Digital Preservation

PREMIS events, checksums, fixity verification, format registry, PRONOM sync, replication.

ahgPreservationPlugin
All Schemas
0
ahg_file_checksum
1
oais_fixity_check
4
oais_information_package
3
oais_package_content
6
oais_premis_event
0
oais_preservation_policy
0
oais_pronom_format
0
premis_object
0
preservation_backup_verification
10
preservation_checksum
195
preservation_event
2
preservation_fixity_check
60
preservation_format
6
preservation_format_conversion
9
preservation_format_obsolescence
28
preservation_migration_pathway
0
preservation_migration_plan
0
preservation_migration_plan_object
144
preservation_object_format
3
preservation_package
15
preservation_package_event
6
preservation_package_object
16
preservation_policy
2
preservation_replication_log
1
preservation_replication_target
0
preservation_stats
8
preservation_virus_scan
0
preservation_workflow_run
12
preservation_workflow_schedule
Entity Relationship Diagram
Open Full Size
Digital Preservation ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
oais_fixity_check_ibfk_1 oais_fixity_check package_id oais_information_package id
oais_information_package_ibfk_1 oais_information_package object_id information_object id
oais_information_package_ibfk_2 oais_information_package parent_package_id oais_information_package id
oais_package_content_ibfk_2 oais_package_content digital_object_id digital_object id
oais_package_content_ibfk_1 oais_package_content package_id oais_information_package id
oais_premis_event_ibfk_2 oais_premis_event content_id oais_package_content id
oais_premis_event_ibfk_1 oais_premis_event package_id oais_information_package id
premis_object_FK_1 premis_object id object id
premis_object_FK_2 premis_object information_object_id information_object id
preservation_checksum_ibfk_1 preservation_checksum digital_object_id digital_object id
preservation_event_ibfk_1 preservation_event digital_object_id digital_object id
preservation_event_ibfk_2 preservation_event information_object_id information_object id
preservation_fixity_check_ibfk_2 preservation_fixity_check checksum_id preservation_checksum id
preservation_fixity_check_ibfk_1 preservation_fixity_check digital_object_id digital_object id
preservation_format_conversion_ibfk_1 preservation_format_conversion digital_object_id digital_object id
preservation_format_obsolescence_ibfk_1 preservation_format_obsolescence format_id preservation_format id
preservation_format_obsolescence_ibfk_2 preservation_format_obsolescence recommended_pathway_id preservation_migration_pathway id
preservation_migration_plan_ibfk_1 preservation_migration_plan pathway_id preservation_migration_pathway id
preservation_migration_plan_object_ibfk_2 preservation_migration_plan_object digital_object_id digital_object id
preservation_migration_plan_object_ibfk_1 preservation_migration_plan_object plan_id preservation_migration_plan id
preservation_object_format_ibfk_1 preservation_object_format digital_object_id digital_object id
preservation_object_format_ibfk_2 preservation_object_format format_id preservation_format id
preservation_package_ibfk_1 preservation_package parent_package_id preservation_package id
preservation_package_event_ibfk_1 preservation_package_event package_id preservation_package id
preservation_package_object_ibfk_1 preservation_package_object package_id preservation_package id
preservation_replication_log_ibfk_1 preservation_replication_log target_id preservation_replication_target id
preservation_virus_scan_ibfk_1 preservation_virus_scan digital_object_id digital_object id
preservation_workflow_run_ibfk_1 preservation_workflow_run schedule_id preservation_workflow_schedule id
ahg_file_checksum
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ digital_object_id int NOT NULL -
FK information_object_id int NOT NULL -
FK checksum_md5 char(32) NULL -
FK checksum_sha256 char(64) NULL -
FK file_size bigint unsigned NULL -
file_name varchar(500) NULL -
mime_type varchar(100) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
oais_fixity_check
9 columns 1 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK package_id int NOT NULL -
content_id int NULL -
check_type varchar(27) NOT NULL - md5, sha256, sha512
expected_value varchar(128) NOT NULL -
actual_value varchar(128) NOT NULL -
FK is_valid tinyint(1) NOT NULL -
checked_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
checked_by varchar(100) NULL -
oais_information_package
18 columns 4 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK package_type varchar(21) NOT NULL - SIP, AIP, DIP
UQ package_id varchar(255) NOT NULL -
FK object_id int NULL - Link to information_object
FK parent_package_id int NULL - For DIP->AIP relationship
FK status varchar(63) NULL pending pending, ingesting, stored, preserved, disseminated, error
checksum_md5 varchar(32) NULL -
checksum_sha256 varchar(64) NULL -
checksum_sha512 varchar(128) NULL -
total_size bigint NULL 0
file_count int NULL 0
storage_location varchar(500) NULL -
preservation_level varchar(30) NULL bit bit, logical, semantic
retention_period int NULL - Years to retain
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
ingested_at datetime NULL -
oais_package_content
15 columns 3 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK package_id int NOT NULL -
FK digital_object_id int NULL -
file_path varchar(500) NOT NULL -
file_name varchar(255) NOT NULL -
file_size bigint NULL 0
mime_type varchar(100) NULL -
checksum_md5 varchar(32) NULL -
checksum_sha256 varchar(64) NULL -
FK pronom_puid varchar(50) NULL - PRONOM format ID
format_name varchar(255) NULL -
format_version varchar(50) NULL -
content_type varchar(45) NULL content content, metadata, manifest, signature
is_original tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
oais_premis_event
12 columns 6 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK package_id int NOT NULL -
FK content_id int NULL -
event_identifier varchar(255) NOT NULL -
FK event_type varchar(269) NOT NULL - capture, compression, creation, deaccession, decompression, decryption, deletion, digital_signature_validation, dissemination, encryption, fixity_check, format_identification, ingestion, message_digest_calculation, migration, normalization, replication, validation, virus_check
FK event_date_time datetime NOT NULL -
event_detail text NULL -
event_outcome varchar(33) NOT NULL - success, failure, warning
event_outcome_detail text NULL -
linking_agent_identifier varchar(255) NULL -
linking_agent_role varchar(100) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
oais_preservation_policy
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
source_format_puid varchar(50) NULL -
target_format_puid varchar(50) NULL -
action_type varchar(44) NOT NULL - migrate, normalize, emulate, preserve
priority int NULL 5
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
oais_pronom_format
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ puid varchar(50) NOT NULL - e.g., fmt/18 for PDF 1.4
format_name varchar(255) NOT NULL -
format_version varchar(50) NULL -
mime_type varchar(100) NULL -
extensions text NULL - JSON array of extensions
FK risk_level varchar(34) NULL low low, medium, high, critical
preservation_action_required tinyint(1) NULL 0
last_updated datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
premis_object
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL -
FK information_object_id int NULL -
puid varchar(255) NULL -
filename varchar(1024) NULL -
last_modified datetime NULL -
date_ingested date NULL -
size bigint NULL -
mime_type varchar(255) NULL -
preservation_backup_verification
19 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK backup_id bigint unsigned NULL - Reference to atom_backup if exists
FK backup_type varchar(41) NOT NULL - database, files, full, incremental
backup_path varchar(1024) NOT NULL -
backup_size bigint unsigned NULL -
original_checksum varchar(128) NULL -
verified_checksum varchar(128) NULL -
FK status varchar(47) NOT NULL - valid, invalid, missing, error, corrupted
verification_method varchar(50) NULL sha256
files_checked int unsigned NULL 0
files_valid int unsigned NULL 0
files_invalid int unsigned NULL 0
files_missing int unsigned NULL 0
FK verified_at datetime NOT NULL -
verified_by varchar(100) NULL -
duration_ms int unsigned NULL -
error_message text NULL -
details json NULL - Detailed verification results
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_checksum
10 columns 10 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK algorithm varchar(32) NOT NULL sha256 md5, sha1, sha256, sha512
checksum_value varchar(128) NOT NULL -
file_size bigint unsigned NULL -
generated_at datetime NOT NULL -
FK verified_at datetime NULL -
FK verification_status varchar(37) NULL pending pending, valid, invalid, error
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_event
13 columns 195 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NULL -
FK information_object_id int NULL -
FK event_type varchar(207) NOT NULL - creation, capture, ingestion, validation, fixity_check, virus_check, format_identification, normalization, migration, replication, deletion, deaccession, modification, metadata_modification, access, dissemination
FK event_datetime datetime NOT NULL -
event_detail text NULL -
FK event_outcome varchar(41) NULL unknown success, failure, warning, unknown
event_outcome_detail text NULL -
linking_agent_type varchar(43) NULL system user, system, software, organization
linking_agent_value varchar(255) NULL -
linking_object_type varchar(100) NULL -
linking_object_value varchar(255) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_fixity_check
12 columns 2 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK checksum_id bigint unsigned NULL -
algorithm varchar(32) NOT NULL - md5, sha1, sha256, sha512
expected_value varchar(128) NOT NULL -
actual_value varchar(128) NULL -
FK status varchar(33) NOT NULL - pass, fail, error, missing
error_message text NULL -
FK checked_at datetime NOT NULL -
checked_by varchar(100) NULL - user or system/cron
duration_ms int unsigned NULL - Check duration in milliseconds
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_format
13 columns 60 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK puid varchar(50) NULL - PRONOM Unique Identifier
FK mime_type varchar(255) NULL -
format_name varchar(255) NOT NULL -
format_version varchar(50) NULL -
extension varchar(20) NULL -
FK risk_level varchar(34) NULL medium low, medium, high, critical
risk_notes text NULL -
preservation_action varchar(40) NULL monitor none, monitor, migrate, normalize
migration_target_id bigint unsigned NULL - Target format for migration
is_preservation_format tinyint(1) NULL 0
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_format_conversion
24 columns 6 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK source_format varchar(100) NULL -
source_mime_type varchar(100) NULL -
FK target_format varchar(100) NULL -
target_mime_type varchar(100) NULL -
conversion_tool varchar(100) NOT NULL - imagemagick, ffmpeg, ghostscript, etc.
tool_version varchar(50) NULL -
FK status varchar(45) NOT NULL pending pending, processing, completed, failed
source_path varchar(1024) NULL -
source_size bigint unsigned NULL -
source_checksum varchar(128) NULL -
output_path varchar(1024) NULL -
output_size bigint unsigned NULL -
output_checksum varchar(128) NULL -
conversion_options json NULL - Tool-specific options used
quality_score decimal(5,2) NULL - Quality assessment score if applicable
started_at datetime NULL -
completed_at datetime NULL -
duration_ms int unsigned NULL -
error_message text NULL -
created_by varchar(100) NULL -
FK created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_format_obsolescence
13 columns 9 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK format_id bigint unsigned NOT NULL - Reference to preservation_format
FK puid varchar(50) NOT NULL - PRONOM identifier
FK current_risk_level varchar(34) NOT NULL - low, medium, high, critical
FK migration_urgency varchar(39) NULL none none, low, medium, high, critical
affected_object_count int unsigned NULL 0
storage_size_bytes bigint unsigned NULL 0 Total storage for affected objects
recommended_action text NULL -
FK recommended_pathway_id bigint unsigned NULL - Suggested migration pathway
last_assessed_at datetime NULL -
next_assessment_at datetime NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_migration_pathway
13 columns 28 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK source_puid varchar(50) NOT NULL - PRONOM identifier of source format
FK target_puid varchar(50) NOT NULL - PRONOM identifier of target format
FK migration_tool varchar(100) NOT NULL - Tool to perform migration (imagemagick, ffmpeg, etc.)
migration_command text NULL - Command template with placeholders {input} {output}
quality_impact varchar(47) NULL minimal lossless, minimal, moderate, significant
fidelity_score decimal(5,2) NULL - Quality fidelity score 0-100
FK is_recommended tinyint(1) NULL 0 Recommended pathway for this source format
is_automated tinyint(1) NULL 1 Can be run automatically without review
priority int NULL 100 Priority order when multiple pathways exist
notes text NULL - Additional notes about this pathway
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_migration_plan
29 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
FK source_puid varchar(50) NOT NULL -
FK target_puid varchar(50) NOT NULL -
FK pathway_id bigint unsigned NULL - Selected migration pathway
FK status varchar(63) NULL draft draft, approved, in_progress, completed, cancelled, failed
scope_type varchar(42) NULL all all, repository, collection, custom
scope_criteria json NULL - Criteria for object selection
total_objects int unsigned NULL 0
objects_queued int unsigned NULL 0
objects_processed int unsigned NULL 0
objects_succeeded int unsigned NULL 0
objects_failed int unsigned NULL 0
objects_skipped int unsigned NULL 0
original_size_bytes bigint unsigned NULL 0
converted_size_bytes bigint unsigned NULL 0
FK created_by int NULL - User who created the plan
approved_by int NULL - User who approved the plan
approved_at datetime NULL -
started_at datetime NULL -
completed_at datetime NULL -
keep_originals tinyint(1) NULL 1 Keep original files after migration
create_preservation_copies tinyint(1) NULL 1 Store as preservation copies
run_fixity_after tinyint(1) NULL 1 Run fixity check after conversion
scheduled_start datetime NULL - When to start if scheduled
max_concurrent int unsigned NULL 5 Max concurrent conversions
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_migration_plan_object
18 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK plan_id bigint unsigned NOT NULL -
FK digital_object_id int NOT NULL -
FK status varchar(60) NULL pending pending, queued, processing, completed, failed, skipped
source_path varchar(1024) NULL -
source_size bigint unsigned NULL -
source_checksum varchar(128) NULL -
output_path varchar(1024) NULL -
output_size bigint unsigned NULL -
output_checksum varchar(128) NULL -
queued_at datetime NULL -
started_at datetime NULL -
completed_at datetime NULL -
duration_ms int unsigned NULL -
error_message text NULL -
retry_count int unsigned NULL 0
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_object_format
13 columns 144 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
FK format_id bigint unsigned NULL -
FK puid varchar(50) NULL -
FK mime_type varchar(255) NULL -
format_name varchar(255) NULL -
format_version varchar(50) NULL -
identification_tool varchar(100) NULL - e.g., DROID, file, finfo
identification_date datetime NOT NULL -
confidence varchar(33) NULL medium low, medium, high, certain
basis varchar(500) NULL -
warning text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_package
26 columns 3 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ uuid char(36) NOT NULL -
name varchar(255) NOT NULL -
description text NULL -
FK package_type varchar(21) NOT NULL - sip, aip, dip
FK status varchar(58) NOT NULL draft draft, building, complete, validated, exported, error
FK package_format varchar(33) NOT NULL bagit bagit, zip, tar, directory
bagit_version varchar(10) NULL 1.0
object_count int unsigned NULL 0
total_size bigint unsigned NULL 0
manifest_algorithm varchar(20) NULL sha256
package_checksum varchar(128) NULL -
source_path varchar(1024) NULL -
export_path varchar(1024) NULL -
originator varchar(255) NULL -
submission_agreement varchar(255) NULL -
retention_period varchar(100) NULL -
FK parent_package_id bigint unsigned NULL -
FK information_object_id int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
created_by varchar(100) NULL -
built_at datetime NULL -
validated_at datetime NULL -
exported_at datetime NULL -
updated_at datetime NULL - on update CURRENT_TIMESTAMP
metadata json NULL -
preservation_package_event
10 columns 15 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK package_id bigint unsigned NOT NULL -
FK event_type varchar(89) NOT NULL - creation, modification, building, validation, export, import, transfer, deletion, error
FK event_datetime datetime NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
event_detail text NULL -
event_outcome varchar(33) NULL success success, failure, warning
event_outcome_detail text NULL -
agent_type varchar(50) NULL -
agent_value varchar(255) NULL -
created_by varchar(100) NULL -
preservation_package_object
13 columns 6 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK package_id bigint unsigned NOT NULL -
FK digital_object_id int NOT NULL -
relative_path varchar(1024) NOT NULL -
file_name varchar(255) NOT NULL -
file_size bigint unsigned NULL -
checksum_algorithm varchar(20) NULL sha256
checksum_value varchar(128) NULL -
mime_type varchar(100) NULL -
puid varchar(50) NULL -
FK object_role varchar(43) NULL payload payload, metadata, manifest, tagfile
sequence int unsigned NULL 0
added_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_policy
11 columns 16 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
FK policy_type varchar(45) NOT NULL - fixity, format, retention, replication
FK is_active tinyint(1) NULL 1
schedule_cron varchar(100) NULL - Cron expression for scheduled runs
last_run_at datetime NULL -
FK next_run_at datetime NULL -
config json NULL - Policy-specific configuration
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_replication_log
14 columns 2 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK target_id bigint unsigned NOT NULL -
operation varchar(29) NOT NULL - sync, verify, restore
FK status varchar(42) NOT NULL - started, completed, failed, partial
files_total int unsigned NULL 0
files_synced int unsigned NULL 0
files_failed int unsigned NULL 0
bytes_transferred bigint unsigned NULL 0
FK started_at datetime NOT NULL -
completed_at datetime NULL -
duration_ms int unsigned NULL -
error_message text NULL -
details json NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_replication_target
13 columns 1 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
FK target_type varchar(39) NOT NULL - local, sftp, s3, azure, gcs, rsync
connection_config json NOT NULL - Encrypted connection details
FK is_active tinyint(1) NULL 1
sync_schedule varchar(100) NULL - Cron expression
last_sync_at datetime NULL -
last_sync_status varchar(32) NULL - success, partial, failed
last_sync_files int unsigned NULL 0
last_sync_bytes bigint unsigned NULL 0
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
preservation_stats
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ stat_date date NOT NULL -
total_objects int unsigned NULL 0
total_size_bytes bigint unsigned NULL 0
objects_with_checksum int unsigned NULL 0
fixity_checks_run int unsigned NULL 0
fixity_failures int unsigned NULL 0
formats_at_risk int unsigned NULL 0
events_logged int unsigned NULL 0
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_virus_scan
16 columns 8 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK digital_object_id int NOT NULL -
scan_engine varchar(50) NOT NULL clamav
engine_version varchar(50) NULL -
signature_version varchar(100) NULL -
FK status varchar(38) NOT NULL - clean, infected, error, skipped
FK threat_name varchar(255) NULL - Name of detected threat if infected
file_path varchar(1024) NULL -
file_size bigint unsigned NULL -
FK scanned_at datetime NOT NULL -
scanned_by varchar(100) NULL - user or system/cron
duration_ms int unsigned NULL -
error_message text NULL -
quarantined tinyint(1) NULL 0
quarantine_path varchar(1024) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_workflow_run
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK schedule_id bigint unsigned NOT NULL -
FK workflow_type varchar(50) NOT NULL -
FK status varchar(52) NOT NULL running running, completed, failed, timeout, cancelled
FK started_at datetime NOT NULL -
completed_at datetime NULL -
duration_ms int unsigned NULL -
objects_processed int unsigned NULL 0
objects_succeeded int unsigned NULL 0
objects_failed int unsigned NULL 0
objects_skipped int unsigned NULL 0
error_message text NULL -
summary json NULL - Detailed run summary
triggered_by varchar(30) NULL scheduler scheduler, manual, api
triggered_by_user varchar(100) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
preservation_workflow_schedule
23 columns 12 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
FK workflow_type varchar(105) NOT NULL - format_identification, fixity_check, virus_scan, format_conversion, backup_verification, replication
FK is_enabled tinyint(1) NULL 1
FK schedule_type varchar(30) NOT NULL cron cron, interval, manual
cron_expression varchar(100) NULL - Cron expression (e.g., 0 2 * * *)
interval_hours int unsigned NULL - Hours between runs for interval type
batch_limit int unsigned NULL 100 Max objects per run
timeout_minutes int unsigned NULL 60 Max runtime in minutes
options json NULL - Workflow-specific options
last_run_at datetime NULL -
last_run_status varchar(40) NULL - success, partial, failed, timeout
last_run_processed int unsigned NULL 0
last_run_duration_ms int unsigned NULL -
FK next_run_at datetime NULL -
total_runs int unsigned NULL 0
total_processed int unsigned NULL 0
notify_on_failure tinyint(1) NULL 1
notify_email varchar(255) NULL -
created_by varchar(100) NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - 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.