Digital Asset Management

Digital Asset Management with IPTC metadata, watermarks, and asset workflows.

ahgDAMPlugin
All Schemas
1
dam_external_links
3
dam_format_holdings
10
dam_iptc_metadata
0
dam_version_links
Entity Relationship Diagram
Open Full Size
Digital Asset Management ERD
dam_external_links
12 columns 1 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL - information_object.id
FK link_type varchar(146) NOT NULL - ESAT, IMDb, SAFILM, NFVSA, Wikipedia, Wikidata, VIAF, YouTube, Vimeo, Archive_org, BFI, AFI, Letterboxd, MUBI, Filmography, Review, Academic, Press, Other
url varchar(500) NOT NULL -
title varchar(255) NULL - Link display text
description text NULL - What this link provides
FK person_name varchar(255) NULL - For person-specific links: Donald Swanson
person_role varchar(100) NULL - Role in production: Director, Actor, etc.
verified_date date NULL - Last verified link is working
is_primary tinyint(1) NULL 0 Primary reference link flag
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
dam_format_holdings
16 columns 3 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL - information_object.id
FK format_type varchar(165) NOT NULL - 35mm, 16mm, 8mm, Super8, VHS, Betacam, U-matic, DV, DVD, Blu-ray, LaserDisc, Digital_File, DCP, ProRes, Nitrate, Safety, Polyester, Audio_Reel, Audio_Cassette, Vinyl, CD, Other
format_details varchar(255) NULL - Additional info: color, sound type, aspect ratio
FK holding_institution varchar(255) NOT NULL - e.g., NFVSA, Western Cape Provincial Library
holding_location varchar(255) NULL - Specific location/department within institution
accession_number varchar(100) NULL - Institution catalog/reference number
condition_status varchar(56) NULL unknown excellent, good, fair, poor, deteriorating, unknown
FK access_status varchar(98) NULL unknown available, restricted, preservation_only, digitized_available, on_request, staff_only, unknown
access_url varchar(500) NULL - URL for digitized/streaming versions
access_notes text NULL - How to request access, viewing conditions
is_primary tinyint(1) NULL 0 Primary viewing copy flag
verified_date date NULL - Date holding was last verified
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
dam_iptc_metadata
81 columns 10 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ object_id int NOT NULL -
FK creator varchar(255) NULL -
creator_job_title varchar(255) NULL -
creator_address text NULL -
creator_city varchar(255) NULL -
creator_state varchar(255) NULL -
creator_postal_code varchar(50) NULL -
creator_country varchar(255) NULL -
creator_phone varchar(100) NULL -
creator_email varchar(255) NULL -
creator_website varchar(500) NULL -
headline varchar(500) NULL -
duration_minutes int unsigned NULL - Running time in minutes (rounded)
caption text NULL -
FK keywords text NULL -
iptc_subject_code varchar(255) NULL -
intellectual_genre varchar(255) NULL -
FK asset_type varchar(100) NULL - PBCore: Documentary, Feature, Short, News, etc.
FK genre varchar(255) NULL - Film genre: Documentary, Drama, etc.
contributors_json json NULL - Structured credits: [{role, name}]
color_type varchar(47) NULL - color, black_and_white, mixed, colorized
audio_language varchar(255) NULL - Audio language(s) - ISO codes
subtitle_language varchar(255) NULL - Subtitle language(s)
FK production_company varchar(500) NULL - Production company/studio
distributor varchar(500) NULL - Distributor/Broadcaster
FK broadcast_date varchar(100) NULL -
awards text NULL - Awards and nominations
series_title varchar(500) NULL - If part of a series
episode_number varchar(50) NULL - Episode number if applicable
season_number varchar(50) NULL - Season number if applicable
iptc_scene varchar(255) NULL -
FK date_created date NULL -
city varchar(255) NULL -
state_province varchar(255) NULL -
country varchar(255) NULL -
country_code varchar(10) NULL -
production_country varchar(100) NULL - Country where film/video was produced
production_country_code char(3) NULL - ISO 3166-1 alpha-3 production country code
sublocation varchar(500) NULL -
title varchar(500) NULL -
job_id varchar(255) NULL -
instructions text NULL -
credit_line varchar(500) NULL -
source varchar(500) NULL -
copyright_notice text NULL -
rights_usage_terms text NULL -
license_type varchar(84) NULL - rights_managed, royalty_free, creative_commons, public_domain, editorial, other
license_url varchar(500) NULL -
license_expiry date NULL -
model_release_status varchar(47) NULL none none, not_applicable, unlimited, limited
model_release_id varchar(255) NULL -
property_release_status varchar(47) NULL none none, not_applicable, unlimited, limited
property_release_id varchar(255) NULL -
artwork_title varchar(500) NULL -
artwork_creator varchar(255) NULL -
artwork_date varchar(100) NULL -
artwork_source varchar(500) NULL -
artwork_copyright text NULL -
persons_shown text NULL -
camera_make varchar(100) NULL -
camera_model varchar(100) NULL -
lens varchar(255) NULL -
focal_length varchar(50) NULL -
aperture varchar(20) NULL -
shutter_speed varchar(50) NULL -
iso_speed int NULL -
flash_used tinyint(1) NULL -
gps_latitude decimal(10,8) NULL -
gps_longitude decimal(11,8) NULL -
gps_altitude decimal(10,2) NULL -
image_width int NULL -
image_height int NULL -
resolution_x int NULL -
resolution_y int NULL -
resolution_unit varchar(20) NULL -
color_space varchar(50) NULL -
bit_depth int NULL -
orientation varchar(50) NULL -
created_at datetime NULL -
updated_at datetime NULL -
dam_version_links
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK object_id int NOT NULL - Main asset information_object.id
FK related_object_id int NULL - Related AtoM object if catalogued separately
FK version_type varchar(66) NOT NULL language language, format, restoration, directors_cut, censored, other
title varchar(255) NOT NULL - Title of this version, e.g., Kuddes van die veld
language_code char(3) NULL - ISO 639-2 code (afr, eng, nld)
language_name varchar(50) NULL - Human readable: Afrikaans, English, Dutch
year varchar(10) NULL - Release year of this version
notes text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
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.