manuscript

1645 rows


Description

The manuscript is an abstract placeholder that is given metadata via the manuscript_data table. This allows multiple editions of the same manuscript to be created, regardless of the naming scheme used. A manuscript will contain one or more text fragments (manuscript_to_text_fragment)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
manuscript_id INT UNSIGNED 10 √ null
edition.manuscript_id fk_edition_to_manuscriptR
iaa_edition_catalog.manuscript_id fk_edition_catalog_to_manuscript_idR
manuscript_data.manuscript_id fk_manuscript_to_master_manuscriptR
manuscript_metrics.manuscript_id manuscript_metrics_to_manuscriptR
manuscript_to_text_fragment.manuscript_id fk_manuscript_to_text_fragment_to_scrollR

Indexes

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

Relationships

Close relationships within degrees of separation