Gallery Management

Gallery/exhibition management, artist tracking, loans, and provenance.

ahgGalleryPlugin
All Schemas
0
gallery_artist
0
gallery_artist_bibliography
0
gallery_artist_exhibition_history
0
gallery_facility_report
0
gallery_insurance_policy
0
gallery_loan
0
gallery_loan_object
0
gallery_space
0
gallery_valuation
Entity Relationship Diagram
Open Full Size
Gallery Management ERD
gallery_artist
33 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK actor_id int NULL -
FK display_name varchar(255) NOT NULL -
sort_name varchar(255) NULL -
birth_date date NULL -
birth_place varchar(255) NULL -
death_date date NULL -
death_place varchar(255) NULL -
nationality varchar(100) NULL -
artist_type varchar(48) NULL individual individual, collective, studio, anonymous
medium_specialty text NULL -
movement_style text NULL -
active_period varchar(100) NULL -
FK represented tinyint(1) NULL 0
representation_start date NULL -
representation_end date NULL -
representation_terms text NULL -
commission_rate decimal(5,2) NULL -
exclusivity tinyint(1) NULL 0
biography text NULL -
artist_statement text NULL -
cv text NULL -
email varchar(255) NULL -
phone varchar(50) NULL -
website varchar(255) NULL -
studio_address text NULL -
instagram varchar(100) NULL -
twitter varchar(100) NULL -
facebook varchar(255) NULL -
notes text NULL -
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
gallery_artist_bibliography
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK artist_id int NOT NULL -
FK entry_type varchar(74) NULL article book, catalog, article, review, interview, thesis, website, video, other
title varchar(500) NOT NULL -
author varchar(255) NULL -
publication varchar(255) NULL -
publisher varchar(255) NULL -
publication_date date NULL -
volume varchar(50) NULL -
issue varchar(50) NULL -
pages varchar(50) NULL -
url varchar(500) NULL -
isbn varchar(20) NULL -
notes text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_artist_exhibition_history
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK artist_id int NOT NULL -
exhibition_type varchar(45) NULL group solo, group, duo, retrospective, survey
title varchar(255) NOT NULL -
venue varchar(255) NULL -
city varchar(100) NULL -
country varchar(100) NULL -
FK start_date date NULL -
end_date date NULL -
curator varchar(255) NULL -
catalog_published tinyint(1) NULL 0
notes text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_facility_report
29 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK loan_id int NOT NULL -
report_type varchar(27) NOT NULL - incoming, outgoing
institution_name varchar(255) NULL -
building_age int NULL -
construction_type varchar(100) NULL -
fire_detection tinyint(1) NULL 0
fire_suppression tinyint(1) NULL 0
security_24hr tinyint(1) NULL 0
security_guards tinyint(1) NULL 0
cctv tinyint(1) NULL 0
intrusion_detection tinyint(1) NULL 0
climate_controlled tinyint(1) NULL 0
temperature_range varchar(50) NULL -
humidity_range varchar(50) NULL -
light_levels varchar(100) NULL -
uv_filtering tinyint(1) NULL 0
trained_handlers tinyint(1) NULL 0
loading_dock tinyint(1) NULL 0
freight_elevator tinyint(1) NULL 0
storage_available tinyint(1) NULL 0
insurance_coverage varchar(255) NULL -
completed_by varchar(255) NULL -
completed_date date NULL -
approved tinyint(1) NULL 0
approved_by int NULL -
approved_date date NULL -
notes text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_insurance_policy
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
policy_number varchar(100) NOT NULL -
provider varchar(255) NOT NULL -
policy_type varchar(71) NULL all_risk all_risk, named_perils, transit, exhibition, permanent_collection
coverage_amount decimal(14,2) NULL -
deductible decimal(12,2) NULL -
premium decimal(12,2) NULL -
FK start_date date NOT NULL -
end_date date NOT NULL -
contact_name varchar(255) NULL -
contact_email varchar(255) NULL -
contact_phone varchar(50) NULL -
notes text NULL -
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_loan
28 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ loan_number varchar(50) NOT NULL -
FK loan_type varchar(27) NOT NULL - incoming, outgoing
FK status varchar(112) NULL inquiry inquiry, requested, approved, agreed, in_transit_out, on_loan, in_transit_return, returned, cancelled, declined
purpose varchar(255) NULL -
exhibition_id int NULL -
institution_name varchar(255) NOT NULL -
institution_address text NULL -
contact_name varchar(255) NULL -
contact_email varchar(255) NULL -
contact_phone varchar(50) NULL -
request_date date NULL -
approval_date date NULL -
FK loan_start_date date NULL -
loan_end_date date NULL -
actual_return_date date NULL -
loan_fee decimal(12,2) NULL -
insurance_value decimal(12,2) NULL -
insurance_provider varchar(255) NULL -
insurance_policy_number varchar(100) NULL -
special_conditions text NULL -
agreement_signed tinyint(1) NULL 0
agreement_date date NULL -
facility_report_received tinyint(1) NULL 0
notes text NULL -
created_by int NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
gallery_loan_object
14 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK loan_id int NOT NULL -
FK object_id int NOT NULL -
insurance_value decimal(12,2) NULL -
condition_out text NULL -
condition_out_date date NULL -
condition_out_by int NULL -
condition_return text NULL -
condition_return_date date NULL -
condition_return_by int NULL -
packing_instructions text NULL -
display_requirements text NULL -
notes text NULL -
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_space
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK venue_id int NOT NULL - References exhibition_venue.id
name varchar(255) NOT NULL -
description text NULL -
area_sqm decimal(10,2) NULL -
wall_length_m decimal(10,2) NULL -
height_m decimal(10,2) NULL -
lighting_type varchar(100) NULL -
climate_controlled tinyint(1) NULL 0
max_weight_kg decimal(10,2) NULL -
is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
gallery_valuation
17 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK object_id int NOT NULL -
FK valuation_type varchar(72) NULL insurance insurance, market, replacement, auction_estimate, probate, donation
value_amount decimal(14,2) NOT NULL -
currency varchar(3) NULL ZAR
valuation_date date NOT NULL -
valid_until date NULL -
appraiser_name varchar(255) NULL -
appraiser_credentials varchar(255) NULL -
appraiser_organization varchar(255) NULL -
methodology text NULL -
comparables text NULL -
notes text NULL -
document_path varchar(500) NULL -
FK is_current tinyint(1) NULL 1
created_by int NULL -
created_at datetime 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.