Exhibition Management

Exhibition planning, object loans, venue management for GLAM/DAM institutions.

ahgExhibitionPlugin
All Schemas
2
exhibition
8
exhibition_checklist
58
exhibition_checklist_item
3
exhibition_checklist_template
7
exhibition_event
0
exhibition_gallery
0
exhibition_media
12
exhibition_object
5
exhibition_section
2
exhibition_status_history
5
exhibition_storyline
8
exhibition_storyline_stop
0
exhibition_venue
Entity Relationship Diagram
Open Full Size
Exhibition Management ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
exhibition_checklist_ibfk_1 exhibition_checklist exhibition_id exhibition id
exhibition_checklist_item_ibfk_1 exhibition_checklist_item checklist_id exhibition_checklist id
exhibition_event_ibfk_1 exhibition_event exhibition_id exhibition id
exhibition_gallery_ibfk_1 exhibition_gallery venue_id exhibition_venue id
exhibition_media_ibfk_1 exhibition_media exhibition_id exhibition id
exhibition_object_ibfk_1 exhibition_object exhibition_id exhibition id
exhibition_object_ibfk_2 exhibition_object section_id exhibition_section id
exhibition_section_ibfk_1 exhibition_section exhibition_id exhibition id
exhibition_status_history_ibfk_1 exhibition_status_history exhibition_id exhibition id
exhibition_storyline_ibfk_1 exhibition_storyline exhibition_id exhibition id
exhibition_storyline_stop_ibfk_2 exhibition_storyline_stop exhibition_object_id exhibition_object id
exhibition_storyline_stop_ibfk_1 exhibition_storyline_stop storyline_id exhibition_storyline id
exhibition
55 columns 2 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
title varchar(500) NOT NULL -
subtitle varchar(500) NULL -
UQ slug varchar(255) NULL -
description text NULL -
theme text NULL -
FK exhibition_type varchar(53) NULL temporary permanent, temporary, traveling, online, pop_up
FK status varchar(89) NULL concept concept, planning, preparation, installation, open, closing, closed, archived, canceled
planning_start_date date NULL -
preparation_start_date date NULL -
installation_start_date date NULL -
FK opening_date date NULL -
closing_date date NULL -
actual_closing_date date NULL -
FK venue_id bigint unsigned NULL -
venue_name varchar(255) NULL -
venue_address text NULL -
venue_city varchar(100) NULL -
venue_country varchar(100) NULL -
is_external_venue tinyint(1) NULL 0
gallery_ids json NULL -
total_square_meters decimal(10,2) NULL -
admission_fee decimal(10,2) NULL -
admission_currency varchar(3) NULL ZAR
is_free_admission tinyint(1) NULL 0
expected_visitors int NULL -
actual_visitors int NULL -
wheelchair_accessible tinyint(1) NULL 1
audio_guide_available tinyint(1) NULL 0
braille_available tinyint(1) NULL 0
sign_language_tours tinyint(1) NULL 0
budget_amount decimal(12,2) NULL -
budget_currency varchar(3) NULL ZAR
actual_cost decimal(12,2) NULL -
total_insurance_value decimal(15,2) NULL -
insurance_policy_number varchar(100) NULL -
insurance_provider varchar(255) NULL -
has_catalog tinyint(1) NULL 0
catalog_isbn varchar(20) NULL -
catalog_publication_date date NULL -
has_virtual_tour tinyint(1) NULL 0
virtual_tour_url varchar(500) NULL -
online_exhibition_url varchar(500) NULL -
curator_id int NULL -
curator_name varchar(255) NULL -
designer_name varchar(255) NULL -
organized_by varchar(255) NULL -
sponsored_by text NULL -
project_code varchar(50) NULL -
notes text NULL -
internal_notes text NULL -
created_by int NULL -
updated_by int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_checklist
11 columns 8 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
template_id bigint unsigned NULL -
name varchar(255) NOT NULL -
checklist_type varchar(81) NOT NULL - planning, preparation, installation, opening, during, closing, deinstallation
due_date date NULL -
completed_date date NULL -
status varchar(51) NULL not_started not_started, in_progress, completed, overdue
assigned_to int NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_checklist_item
11 columns 58 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK checklist_id bigint unsigned NOT NULL -
name varchar(255) NOT NULL -
description text NULL -
category varchar(100) NULL -
is_required tinyint(1) NULL 0
is_completed tinyint(1) NULL 0
completed_at timestamp NULL -
completed_by int NULL -
notes text NULL -
sequence_order int NULL 0
exhibition_checklist_template
8 columns 3 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
checklist_type varchar(81) NOT NULL - planning, preparation, installation, opening, during, closing, deinstallation
items json NULL -
is_default tinyint(1) NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_event
29 columns 7 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
title varchar(255) NOT NULL -
event_type varchar(89) NOT NULL - opening, closing, tour, lecture, workshop, performance, family, school, vip, press, other
description text NULL -
FK event_date date NOT NULL -
start_time time NULL -
end_time time NULL -
is_recurring tinyint(1) NULL 0
recurrence_pattern varchar(100) NULL -
venue_id bigint unsigned NULL -
gallery_id bigint unsigned NULL -
location_notes varchar(255) NULL -
max_attendees int NULL -
registered_attendees int NULL 0
actual_attendees int NULL -
requires_registration tinyint(1) NULL 0
registration_url varchar(500) NULL -
registration_deadline datetime NULL -
is_free tinyint(1) NULL 1
ticket_price decimal(10,2) NULL -
ticket_currency varchar(3) NULL ZAR
presenter_name varchar(255) NULL -
presenter_bio text NULL -
status varchar(48) NULL scheduled scheduled, confirmed, canceled, completed
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
exhibition_gallery
24 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK venue_id bigint unsigned NOT NULL -
name varchar(255) NOT NULL -
code varchar(50) NULL -
gallery_type varchar(60) NULL gallery gallery, hall, room, corridor, outdoor, foyer, stairwell
floor_level varchar(20) NULL -
square_meters decimal(8,2) NULL -
ceiling_height_meters decimal(4,2) NULL -
wall_linear_meters decimal(8,2) NULL -
has_climate_control tinyint(1) NULL 0
target_temperature decimal(4,1) NULL -
target_humidity decimal(4,1) NULL -
natural_light tinyint(1) NULL 0
max_lux_level int NULL -
max_visitors int NULL -
max_objects int NULL -
has_display_cases tinyint(1) NULL 0
number_of_cases int NULL 0
has_pedestals tinyint(1) NULL 0
number_of_pedestals int NULL 0
has_track_lighting tinyint(1) NULL 0
has_av_equipment tinyint(1) NULL 0
notes text NULL -
is_active tinyint(1) NULL 1
exhibition_media
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
section_id bigint unsigned NULL -
media_type varchar(59) NOT NULL - image, video, audio, document, floorplan, poster, press
usage_type varchar(71) NULL documentation promotional, installation, documentation, press, catalog, internal
file_path varchar(500) NULL -
file_name varchar(255) NULL -
mime_type varchar(100) NULL -
file_size bigint NULL -
title varchar(255) NULL -
caption text NULL -
credits varchar(500) NULL -
is_primary tinyint(1) NULL 0
is_public tinyint(1) NULL 1
sequence_order int NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
exhibition_object
38 columns 12 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
FK section_id bigint unsigned NULL -
FK information_object_id int NOT NULL -
sequence_order int NULL 0
display_position varchar(100) NULL -
FK status varchar(71) NULL proposed proposed, confirmed, on_loan_request, installed, removed, returned
requires_loan tinyint(1) NULL 0
loan_id bigint unsigned NULL -
lender_institution varchar(255) NULL -
display_case_required tinyint(1) NULL 0
mount_required tinyint(1) NULL 0
mount_description text NULL -
special_lighting tinyint(1) NULL 0
lighting_notes text NULL -
security_level varchar(35) NULL standard standard, enhanced, maximum
climate_controlled tinyint(1) NULL 0
max_lux_level int NULL -
uv_filtering_required tinyint(1) NULL 0
rotation_required tinyint(1) NULL 0
max_display_days int NULL -
display_start_date date NULL -
display_end_date date NULL -
pre_installation_condition_report_id bigint unsigned NULL -
post_exhibition_condition_report_id bigint unsigned NULL -
insurance_value decimal(15,2) NULL -
label_text text NULL -
label_credits text NULL -
extended_label text NULL -
audio_stop_number varchar(20) NULL -
installation_notes text NULL -
handling_notes text NULL -
installed_by int NULL -
installed_at timestamp NULL -
removed_by int NULL -
removed_at timestamp NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_section
24 columns 5 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
title varchar(255) NOT NULL -
subtitle varchar(255) NULL -
description text NULL -
narrative text NULL -
section_type varchar(54) NULL gallery gallery, room, alcove, corridor, outdoor, virtual
sequence_order int NULL 0
gallery_name varchar(100) NULL -
floor_level varchar(20) NULL -
square_meters decimal(8,2) NULL -
target_temperature_min decimal(4,1) NULL -
target_temperature_max decimal(4,1) NULL -
target_humidity_min decimal(4,1) NULL -
target_humidity_max decimal(4,1) NULL -
max_lux_level int NULL -
theme varchar(255) NULL -
color_scheme varchar(100) NULL -
has_audio_guide tinyint(1) NULL 0
audio_guide_number varchar(20) NULL -
has_video tinyint(1) NULL 0
has_interactive tinyint(1) NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_status_history
7 columns 2 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
from_status varchar(50) NULL -
to_status varchar(50) NOT NULL -
changed_by int NULL -
change_reason text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
exhibition_storyline
21 columns 5 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK exhibition_id bigint unsigned NOT NULL -
title varchar(255) NOT NULL -
slug varchar(255) NULL -
description text NULL -
narrative_type varchar(141) NULL general thematic, chronological, biographical, geographical, technique, custom, general, guided_tour, self_guided, educational, accessible, highlights
introduction text NULL -
body_text text NULL -
conclusion text NULL -
sequence_order int NULL 0
is_primary tinyint(1) NULL 0
target_audience varchar(51) NULL all general, children, students, specialists, all
reading_level varchar(37) NULL intermediate basic, intermediate, advanced
estimated_duration_minutes int NULL -
has_audio tinyint(1) NULL 0
audio_file_path varchar(500) NULL -
has_video tinyint(1) NULL 0
video_url varchar(500) 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
exhibition_storyline_stop
16 columns 8 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK storyline_id bigint unsigned NOT NULL -
FK exhibition_object_id bigint unsigned NOT NULL -
sequence_order int NULL 0
stop_number varchar(10) NULL -
title varchar(255) NULL -
narrative_text text NULL -
key_points text NULL -
discussion_questions text NULL -
connection_to_next text NULL -
connection_to_theme text NULL -
audio_transcript text NULL -
audio_duration_seconds int NULL -
suggested_viewing_minutes int NULL 2
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
exhibition_venue
25 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
code varchar(50) NULL -
venue_type varchar(42) NULL internal internal, partner, external, online
address_line1 varchar(255) NULL -
address_line2 varchar(255) NULL -
city varchar(100) NULL -
province_state varchar(100) NULL -
postal_code varchar(20) NULL -
country varchar(100) NULL South Africa
contact_name varchar(255) NULL -
contact_email varchar(255) NULL -
contact_phone varchar(50) NULL -
website varchar(500) NULL -
total_square_meters decimal(10,2) NULL -
has_climate_control tinyint(1) NULL 0
has_security_system tinyint(1) NULL 0
has_loading_dock tinyint(1) NULL 0
accessibility_rating varchar(27) NULL partial none, partial, full
has_facility_insurance tinyint(1) NULL 0
insurance_policy_number varchar(100) NULL -
notes text NULL -
is_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
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.