edition_editor

1645 rows


Description

Each edition has one or more edition editors, which are the individual users working on that edition. Each edition editor has individual access rights that are specified here.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
edition_editor_id INT UNSIGNED 10 √ null
artefact_data_owner.edition_editor_id fk_artefact_data_to_edition_editorR
artefact_group_data_owner.edition_editor_id artefact_group_data_owner_to_edition_editorR
artefact_group_member_owner.edition_editor_id artefact_group_member_owner_to_edition_editorR
artefact_position_owner.edition_editor_id fk_artefact_position_to_edition_editorR
artefact_shape_owner.edition_editor_id fk_artefact_shape_to_edition_editorR
artefact_stack_owner.edition_editor_id fk_artefact_stack_to_edition_editorR
artefact_status_owner.edition_editor_id fk_artefact_status_owner_to_edition_editor_idR
attribute_owner.edition_editor_id fk_attribute_to_edition_editorR
attribute_value_css_owner.edition_editor_id fk_attribute_value_css_to_edition_editorR
attribute_value_owner.edition_editor_id fk_attribute_value_to_edition_editorR
font_file_owner.edition_editor_id fk_font_file_to_edition_editorR
line_data_owner.edition_editor_id fk_line_data_to_edition_editorR
line_to_sign_owner.edition_editor_id fk_line_to_sign_to_edition_editorR
main_action.edition_editor_id fk_main_action_to_edition_editorR
manuscript_data_owner.edition_editor_id fk_manuscript_data_to_edition_editorR
manuscript_metrics_owner.edition_editor_id manuscript_metrics_owner_to_edition_editorR
manuscript_to_text_fragment_owner.edition_editor_id fk_manuscript_to_text_fragment_to_edition_editorR
parallel_group_pair_owner.edition_editor_id fk_parallel_group_pair_to_edition_editorR
parallel_group_pair_to_type_owner.edition_editor_id fk_parallel_group_pair_to_type_to_edition_editorR
parallel_sign_stream_section_owner.edition_editor_id fk_parallel_sss_to_edition_editorR
parallel_type_owner.edition_editor_id fk_parallel_type_to_edition_editorR
position_in_stream_owner.edition_editor_id fk_position_in_stream_owner_to_edition_editor_idR
position_in_text_fragment_stream_owner.edition_editor_id fk_pitfs_owner_to_editorR
scribal_font_glyph_metrics_owner.edition_editor_id fk_sfgm_to_edition_editorR
scribal_font_kerning_owner.edition_editor_id fk_sfk_to_edition_editorR
scribal_font_owner.edition_editor_id fk_scribal_font_type_to_edition_editorR
scribe_owner.edition_editor_id fk_scribe_to_edition_editorR
sign_interpretation_attribute_owner.edition_editor_id fk_sign_interpretation_to_edition_editorR
sign_interpretation_commentary_owner.edition_editor_id fk_sign_interpretation_commentary_to_edition_editorR
sign_interpretation_roi_owner.edition_editor_id fk_sign_interpretation_roi_to_edition_editorR
sign_stream_section_owner.edition_editor_id fk_sss_owner_to_edition_editorR
text_fragment_data_owner.edition_editor_id fk_text_fragment_data_to_edition_editorR
text_fragment_to_line_owner.edition_editor_id fk_text_fragment_to_line_to_edition_editorR

Id of the editor, who is working on a particular edition.
user_id INT UNSIGNED 10 0
user.user_id fk_edition_editor_to_userR

Link to the editor’s user account.
edition_id INT UNSIGNED 10 0
edition.edition_id fk_edition_editor_to_editionC

This is the id of the edition on which this editor is working.
may_write TINYINT UNSIGNED 3 0

Boolean whether this editor has permission to write to the edition. An editor must have read permissions to have write permissions.
may_lock TINYINT UNSIGNED 3 0

Boolean whether the editor is allowed to lock the edition.
may_read TINYINT UNSIGNED 3 1

Boolean whether the editor is allowed to read the edition. No editors may ever be deleted from an edition, but revoking read access to an editor is the SQE equivalent to fully removing the editor from work on an edition.
is_admin TINYINT UNSIGNED 3 0

Boolean whether an editor is an admin. An admin must have read permission. Only an admin may change the permissions of other editors, including revoking admin status (including for herself). Each edition must have at least one admin. Only an admin may publish or delete an edition.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc edition_editor_id
edition_user_idx Must be unique Asc/Asc edition_id + user_id
fk_edition_editor_to_user Performance Asc user_id

Relationships

Close relationships within degrees of separation