Condition Assessment

Spectrum 5.1-aligned condition assessment with treatment proposals and photo documentation.

ahgConditionPlugin
All Schemas
0
condition_assessment_schedule
0
condition_conservation_link
0
condition_damage
0
condition_event
0
condition_image
0
condition_report
43
condition_vocabulary
0
condition_vocabulary_term
Entity Relationship Diagram
Open Full Size
Condition Assessment ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
condition_damage_condition_report_id_foreign condition_damage condition_report_id condition_report id
condition_image_condition_report_id_foreign condition_image condition_report_id condition_report id
condition_assessment_schedule
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
frequency_months int NULL 12
last_assessment_date date NULL -
FK next_due_date date NULL -
priority varchar(20) NULL normal
notes text NULL -
is_active tinyint(1) NULL 1
condition_conservation_link
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK condition_event_id int unsigned NOT NULL -
FK treatment_id int unsigned NOT NULL -
link_type varchar(50) NULL treatment
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
condition_damage
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK condition_report_id bigint unsigned NOT NULL -
FK damage_type varchar(50) NOT NULL -
location varchar(50) NOT NULL overall
FK severity varchar(31) NOT NULL minor minor, moderate, severe
description text NULL -
dimensions varchar(100) NULL -
is_active tinyint(1) NOT NULL 1
treatment_required tinyint(1) NOT NULL 0
treatment_notes text NULL -
created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
condition_event
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK object_id int NOT NULL -
event_type varchar(50) NOT NULL assessment
FK event_date date NOT NULL -
assessor varchar(255) NULL -
FK condition_status varchar(50) NULL -
damage_types json NULL -
severity varchar(50) NULL -
notes text NULL -
risk_score decimal(5,2) NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL -
condition_image
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK condition_report_id bigint unsigned NOT NULL -
digital_object_id int unsigned NULL -
file_path varchar(500) NULL -
caption varchar(500) NULL -
image_type varchar(54) NOT NULL general general, detail, damage, before, after, raking, uv
annotations json NULL -
created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
condition_report
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK information_object_id int unsigned NOT NULL -
assessor_user_id int unsigned NULL -
FK assessment_date date NOT NULL -
context varchar(121) NOT NULL routine acquisition, loan_out, loan_in, loan_return, exhibition, storage, conservation, routine, incident, insurance, deaccession
FK overall_rating varchar(47) NOT NULL good excellent, good, fair, poor, unacceptable
summary text NULL -
recommendations text NULL -
priority varchar(32) NOT NULL normal low, normal, high, urgent
FK next_check_date date NULL -
environmental_notes text NULL -
handling_notes text NULL -
display_notes text NULL -
storage_notes text NULL -
created_at timestamp NULL -
updated_at timestamp NULL -
condition_vocabulary
11 columns 43 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK vocabulary_type varchar(72) NOT NULL - damage_type, severity, condition, priority, material, location_zone
code varchar(100) NOT NULL -
display_name varchar(255) NOT NULL -
description text NULL -
color varchar(20) NULL - For UI display
icon varchar(50) NULL - FontAwesome icon class
sort_order int NOT NULL 0
is_active tinyint(1) NOT NULL 1
created_at datetime NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
condition_vocabulary_term
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
FK vocabulary_type varchar(50) NOT NULL -
term_code varchar(50) NOT NULL -
term_label varchar(255) NOT NULL -
term_description text NULL -
sort_order int NULL 0
is_active tinyint(1) NULL 1
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.