Museum Cataloging

Museum cataloging with CCO, CIDOC-CRM, Spectrum 5.1, Getty vocabulary linking.

ahgMuseumPlugin
All Schemas
22
museum_metadata
Entity Relationship Diagram
Open Full Size
Museum Cataloging ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
museum_metadata_ibfk_1 museum_metadata object_id information_object id
museum_metadata
95 columns 22 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ object_id int NOT NULL -
work_type varchar(50) NULL -
object_type varchar(255) NULL -
classification varchar(255) NULL -
materials text NULL -
techniques text NULL -
measurements varchar(255) NULL -
dimensions varchar(255) NULL -
creation_date_earliest date NULL -
creation_date_latest date NULL -
inscription text NULL -
inscriptions text NULL -
condition_notes text NULL -
provenance text NULL -
style_period varchar(255) NULL -
cultural_context varchar(255) NULL -
current_location text NULL -
edition_description text NULL -
state_description varchar(512) NULL -
state_identification varchar(100) NULL -
facture_description text NULL -
technique_cco varchar(512) NULL -
technique_qualifier varchar(255) NULL -
orientation varchar(100) NULL -
physical_appearance text NULL -
color varchar(255) NULL -
shape varchar(255) NULL -
condition_term varchar(100) NULL -
condition_date date NULL -
condition_description text NULL -
condition_agent varchar(255) NULL -
treatment_type varchar(255) NULL -
treatment_date date NULL -
treatment_agent varchar(255) NULL -
treatment_description text NULL -
inscription_transcription text NULL -
inscription_type varchar(100) NULL -
inscription_location varchar(255) NULL -
inscription_language varchar(100) NULL -
inscription_translation text NULL -
mark_type varchar(100) NULL -
mark_description text NULL -
mark_location varchar(255) NULL -
related_work_type varchar(100) NULL -
related_work_relationship varchar(255) NULL -
related_work_label varchar(512) NULL -
related_work_id varchar(255) NULL -
current_location_repository varchar(512) NULL -
current_location_geography varchar(512) NULL -
current_location_coordinates varchar(100) NULL -
current_location_ref_number varchar(255) NULL -
creation_place varchar(512) NULL -
creation_place_type varchar(100) NULL -
discovery_place varchar(512) NULL -
discovery_place_type varchar(100) NULL -
provenance_text text NULL -
ownership_history text NULL -
legal_status varchar(255) NULL -
rights_type varchar(100) NULL -
rights_holder varchar(512) NULL -
rights_date varchar(100) NULL -
rights_remarks text NULL -
cataloger_name varchar(255) NULL -
cataloging_date date NULL -
cataloging_institution varchar(512) NULL -
cataloging_remarks text NULL -
record_type varchar(100) NULL -
record_level varchar(100) NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
creator_identity varchar(512) NULL -
creator_role varchar(255) NULL -
creator_extent varchar(255) NULL -
creator_qualifier varchar(255) NULL -
creator_attribution varchar(255) NULL -
creation_date_display varchar(255) NULL -
creation_date_qualifier varchar(100) NULL -
style varchar(255) NULL -
period varchar(255) NULL -
cultural_group varchar(255) NULL -
movement varchar(255) NULL -
school varchar(255) NULL -
dynasty varchar(255) NULL -
subject_indexing_type varchar(100) NULL -
subject_display text NULL -
subject_extent varchar(255) NULL -
historical_context text NULL -
architectural_context text NULL -
archaeological_context text NULL -
object_class varchar(255) NULL -
object_category varchar(255) NULL -
object_sub_category varchar(255) NULL -
edition_number varchar(100) NULL -
edition_size varchar(100) NULL -
Notes

Log in to add notes.

Legend
PK Primary Key FK Foreign Key / Index UQ Unique Constraint
Table structures are read live from the database. Row counts reflect current data.