Provenance Tracking

Chain of custody and provenance event tracking for archival records.

ahgProvenancePlugin
All Schemas
0
object_provenance
23
provenance_agent
0
provenance_agent_i18n
1
provenance_document
42
provenance_entry
11
provenance_event
0
provenance_event_i18n
10
provenance_record
10
provenance_record_i18n
Entity Relationship Diagram
Open Full Size
Provenance Tracking ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
provenance_agent_i18n_ibfk_1 provenance_agent_i18n id provenance_agent id
provenance_document_ibfk_2 provenance_document provenance_event_id provenance_event id
provenance_document_ibfk_1 provenance_document provenance_record_id provenance_record id
provenance_event_ibfk_2 provenance_event from_agent_id provenance_agent id
provenance_event_ibfk_1 provenance_event provenance_record_id provenance_record id
provenance_event_ibfk_3 provenance_event to_agent_id provenance_agent id
provenance_event_i18n_ibfk_1 provenance_event_i18n id provenance_event id
fk_provenance_record_info_object provenance_record information_object_id information_object id
provenance_record_ibfk_1 provenance_record provenance_agent_id provenance_agent id
provenance_record_i18n_ibfk_1 provenance_record_i18n id provenance_record id
object_provenance
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
FK donor_id int NULL -
acquisition_type varchar(50) NULL -
acquisition_date date NULL -
provenance_notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL - on update CURRENT_TIMESTAMP
provenance_agent
14 columns 23 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK actor_id int NULL - Link to AtoM actor if exists
FK agent_type varchar(44) NULL person person, organization, family, unknown
FK name varchar(500) NOT NULL -
contact_info text NULL -
location varchar(500) NULL -
country_code varchar(3) NULL -
verified tinyint(1) NULL 0
verified_by int NULL -
verified_at timestamp NULL -
notes text NULL -
created_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
provenance_agent_i18n
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
name varchar(500) NULL -
biographical_note text NULL -
notes text NULL -
provenance_document
19 columns 1 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK provenance_record_id int NULL -
FK provenance_event_id int NULL -
FK document_type varchar(299) NOT NULL other deed_of_gift, bill_of_sale, invoice, receipt, auction_catalog, exhibition_catalog, inventory, insurance_record, photograph, correspondence, certificate, customs_document, export_license, import_permit, appraisal, condition_report, newspaper_clipping, publication, oral_history, affidavit, legal_document, other
title varchar(500) NULL -
description text NULL -
document_date date NULL -
document_date_text varchar(255) NULL -
filename varchar(500) NULL -
original_filename varchar(500) NULL -
file_path varchar(1000) NULL -
mime_type varchar(100) NULL -
file_size int NULL -
external_url varchar(1000) NULL -
archive_reference varchar(500) NULL - Reference in external archive
is_public tinyint(1) NULL 0
created_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
provenance_entry
25 columns 42 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK information_object_id int unsigned NOT NULL -
sequence smallint unsigned NOT NULL 1
FK owner_name varchar(500) NOT NULL -
owner_type varchar(97) NOT NULL unknown person, family, dealer, auction_house, museum, corporate, government, religious, artist, unknown
owner_actor_id int unsigned NULL -
owner_location varchar(255) NULL -
owner_location_tgn varchar(100) NULL -
start_date varchar(50) NULL -
start_date_qualifier varchar(31) NULL - circa, before, after, by
end_date varchar(50) NULL -
end_date_qualifier varchar(31) NULL - circa, before, after, by
FK transfer_type varchar(123) NOT NULL unknown sale, auction, gift, bequest, inheritance, commission, exchange, seizure, restitution, transfer, loan, found, created, unknown
transfer_details text NULL -
sale_price decimal(15,2) NULL -
sale_currency varchar(10) NULL -
auction_house varchar(255) NULL -
auction_lot varchar(50) NULL -
FK certainty varchar(53) NOT NULL unknown certain, probable, possible, uncertain, unknown
sources text NULL -
notes text NULL -
is_gap tinyint(1) NOT NULL 0
gap_explanation text NULL -
created_at timestamp NULL -
updated_at timestamp NULL -
provenance_event
27 columns 11 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK provenance_record_id int NOT NULL -
FK from_agent_id int NULL - Previous owner/holder
FK to_agent_id int NULL - New owner/holder
FK event_type varchar(331) NOT NULL unknown creation, commission, sale, purchase, auction, gift, donation, bequest, inheritance, descent, loan_out, loan_return, deposit, withdrawal, transfer, exchange, theft, recovery, confiscation, restitution, repatriation, discovery, excavation, import, export, authentication, appraisal, conservation, restoration, accessioning, deaccessioning, unknown, other
FK event_date date NULL -
event_date_start date NULL -
event_date_end date NULL -
event_date_text varchar(255) NULL - For display like "circa 1920" or "before 1945"
date_certainty varchar(45) NULL unknown exact, approximate, estimated, unknown
event_location varchar(500) NULL -
event_city varchar(255) NULL -
event_country varchar(3) NULL -
price decimal(15,2) NULL -
currency varchar(3) NULL -
sale_reference varchar(255) NULL - Auction lot number, invoice, etc.
evidence_type varchar(55) NULL none documentary, physical, oral, circumstantial, none
evidence_description text NULL -
source_reference text NULL - Bibliography, archive reference, etc.
certainty varchar(45) NULL uncertain certain, probable, possible, uncertain
sequence_number int NULL 0 Order in provenance chain
notes text NULL -
is_public tinyint(1) NULL 1
created_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
sort_order int NULL 1
provenance_event_i18n
6 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
event_description text NULL -
evidence_description text NULL -
source_reference text NULL -
notes text NULL -
provenance_record
28 columns 10 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK information_object_id int NOT NULL -
FK provenance_agent_id int NULL - Current/last known owner
FK donor_id int NULL - Link to donor if applicable
donor_agreement_id int NULL - Link to donor agreement if applicable
FK current_status varchar(50) NULL owned owned, on_loan, deposited, unknown, disputed
custody_type varchar(42) NULL permanent permanent, temporary, loan, deposit
FK acquisition_type varchar(91) NULL unknown donation, purchase, bequest, transfer, loan, deposit, exchange, field_collection, unknown
acquisition_date date NULL -
acquisition_date_text varchar(255) NULL - For imprecise dates like "circa 1950"
acquisition_price decimal(15,2) NULL -
acquisition_currency varchar(3) NULL -
FK certainty_level varchar(53) NULL unknown certain, probable, possible, uncertain, unknown
has_gaps tinyint(1) NULL 0 Are there gaps in provenance chain?
gap_description text NULL -
research_status varchar(55) NULL not_started not_started, in_progress, complete, inconclusive
research_notes text NULL -
FK nazi_era_provenance_checked tinyint(1) NULL 0
nazi_era_provenance_clear tinyint(1) NULL -
nazi_era_notes text NULL -
cultural_property_status varchar(51) NULL none none, claimed, disputed, repatriated, cleared
cultural_property_notes text NULL -
provenance_summary text NULL - Human-readable provenance statement
is_complete tinyint(1) NULL 0
is_public tinyint(1) NULL 1
created_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
provenance_record_i18n
8 columns 10 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
PK culture varchar(16) NOT NULL en
provenance_summary text NULL -
acquisition_notes text NULL -
gap_description text NULL -
research_notes text NULL -
nazi_era_notes text NULL -
cultural_property_notes text 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.