edition

1645 rows


Description

This table provides the anchor for a complete scholarly edition of a manuscript. It also maintains the locked and public status of the edition.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
edition_id INT UNSIGNED 10 √ null
artefact_data_owner.edition_id fk_artefact_data_to_editionR
artefact_group_data_owner.edition_id artefact_group_data_owner_to_editionR
artefact_group_member_owner.edition_id artefact_group_member_owner_to_editionR
artefact_position_owner.edition_id fk_artefact_position_to_editionR
artefact_shape_owner.edition_id fk_artefact_shape_to_editionR
artefact_stack_owner.edition_id fk_artefact_stack_to_editionR
artefact_status_owner.edition_id fk_artefact_status_owner_to_edition_idR
attribute_owner.edition_id fk_attribute_to_editionR
attribute_value_css_owner.edition_id fk_attribute_value_css_to_editionR
attribute_value_owner.edition_id fk_attribute_value_to_editionR
edition_editor.edition_id fk_edition_editor_to_editionC
edition_editor_request.edition_id edition_editor_request_to_edition_idR
font_file_owner.edition_id fk_font_file_to_editionR
line_data_owner.edition_id fk_line_data_to_editionR
line_to_sign_owner.edition_id fk_line_to_sign_to_editionR
main_action.edition_id fk_main_action_to_editionR
manuscript_data_owner.edition_id fk_manuscript_data_to_editionR
manuscript_metrics_owner.edition_id manuscript_metrics_owner_to_edition_idR
manuscript_to_text_fragment_owner.edition_id fk_manuscript_to_text_fragment_to_editionR
parallel_group_pair_owner.edition_id fk_parallel_group_pair_to_editionR
parallel_group_pair_to_type_owner.edition_id fk_parallel_group_pair_to_type_to_editionR
parallel_sign_stream_section_owner.edition_id fk_parallel_sss_to_editionR
parallel_type_owner.edition_id fk_parallel_type_to_editionR
position_in_stream_owner.edition_id fk_position_in_stream_owner_to_edition_idR
position_in_text_fragment_stream_owner.edition_id fk_pitfs_owner_to_editionR
scribal_font_glyph_metrics_owner.edition_id fk_sfgm_to_editionR
scribal_font_kerning_owner.edition_id fk_sfk_to_editionR
scribal_font_owner.edition_id fk_scribal_font_type_to_editionR
scribe_owner.edition_id fk_scribe_to_editionR
sign_interpretation_attribute_owner.edition_id fk_sign_interpretation_attribute_to_editionR
sign_interpretation_commentary_owner.edition_id fk_sign_interpretation_commentary_to_editionR
sign_interpretation_roi_owner.edition_id fk_sign_interpretation_roi_to_editionR
sign_stream_section_owner.edition_id fk_sss_owner_to_editionR
text_fragment_data_owner.edition_id fk_text_fragment_data_to_editionR
text_fragment_to_line_owner.edition_id fk_text_fragment_to_line_to_editionR

Unique id of the edition.
manuscript_id INT UNSIGNED 10 null
manuscript.manuscript_id fk_edition_to_manuscriptR

Id of the manuscript treated in this edition.
locked TINYINT UNSIGNED 3 0

A boolean wheather this edition is locked. If an edition is locked, the SQE_API will not allow any changes to be made to it.
copyright_holder TEXT 65535 null

This is the person or institution who holds copyright for the edition.
collaborators TEXT 65535 √ NULL

Each edition may have a set list of collaborators. If NULL, then the API will automatically construct a list of collaborators based on the edition_editors.
public TINYINT UNSIGNED 3 0

A boolean signalling whether this edition has been made publicly viewable or not. Public relates only to viewing rights, not to write or admin. As the system is currently constructed all public editions should also be locked.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc edition_id
fk_edition_to_manuscript Performance Asc manuscript_id

Relationships

Close relationships within degrees of separation