Digital Asset Management

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

ahgDAMPlugin
Available in: AtoM Heratio Heratio OpenRiC Reference API Records in Contexts (RiC)
All Schemas
1
dam_external_links
3
dam_format_holdings
10
dam_iptc_metadata
0
dam_version_links
3
custom_watermark
0
media_derivatives
85
object_watermark_setting
0
rights_derivative_log
0
rights_derivative_rule
0
security_watermark_log
6
watermark_setting
9
watermark_type
Entity Relationship Diagram
Open Full Size
Digital Asset Management ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
object_watermark_setting_ibfk_2 object_watermark_setting custom_watermark_id custom_watermark id
object_watermark_setting_ibfk_1 object_watermark_setting watermark_type_id watermark_type id
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
custom_watermark
11 columns 3 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK object_id int unsigned NULL - NULL = global watermark
name varchar(100) NOT NULL -
filename varchar(255) NOT NULL -
file_path varchar(500) NOT NULL -
position varchar(50) NULL center
opacity decimal(3,2) NULL 0.40
created_by int unsigned NULL -
FK active tinyint(1) NULL 1
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
media_derivatives
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK derivative_type varchar(43) NOT NULL - thumbnail, poster, preview, waveform
derivative_index int NULL 0
path varchar(500) NOT NULL -
metadata json NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
object_watermark_setting
9 columns 85 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ object_id int unsigned NOT NULL -
watermark_enabled tinyint(1) NULL 1
FK watermark_type_id int unsigned NULL -
FK custom_watermark_id int unsigned NULL -
position varchar(50) NULL center
opacity decimal(3,2) NULL 0.40
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
rights_derivative_log
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK rule_id int NULL -
derivative_type varchar(50) NULL -
original_path varchar(500) NULL -
derivative_path varchar(500) NULL -
requested_by int NULL -
request_purpose varchar(100) NULL -
request_ip varchar(45) NULL -
generated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
rights_derivative_rule
21 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NULL - NULL = applies to collection or global
FK collection_id int NULL - NULL = applies to object or global
is_global tinyint(1) NULL 0
FK rule_type varchar(69) NOT NULL - watermark, redaction, resize, format_conversion, metadata_strip
priority int NULL 0
applies_to_roles json NULL - Array of role IDs, NULL = all
applies_to_clearance_levels json NULL - Array of clearance level codes
applies_to_purposes json NULL - Array of purpose codes
watermark_text varchar(255) NULL -
watermark_image_path varchar(500) NULL -
watermark_position varchar(65) NULL bottom_right center, top_left, top_right, bottom_left, bottom_right, tile
watermark_opacity int NULL 50 0-100
redaction_areas json NULL - Array of {x, y, width, height, page}
redaction_color varchar(7) NULL #000000
max_width int NULL -
max_height int NULL -
is_active tinyint(1) NULL 1
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
security_watermark_log
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK user_id int unsigned NOT NULL -
FK object_id int unsigned NOT NULL -
digital_object_id int unsigned NULL -
watermark_type varchar(32) NOT NULL visible visible, invisible, both
watermark_text varchar(500) NOT NULL -
FK watermark_code varchar(100) NOT NULL -
file_hash varchar(64) NULL -
file_name varchar(255) NULL -
ip_address varchar(45) NULL -
FK created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
watermark_setting
6 columns 6 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ setting_key varchar(100) NOT NULL -
setting_value text NULL -
description varchar(255) NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
watermark_type
9 columns 9 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ code varchar(50) NOT NULL -
name varchar(100) NOT NULL -
image_file varchar(255) NOT NULL -
position varchar(50) NULL repeat
opacity decimal(3,2) NULL 0.30
active tinyint(1) NULL 1
sort_order int NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
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.