AHG Settings

Centralized AHG plugin settings management (section-based admin UI).

ahgSettingsPlugin
Available in: AtoM Heratio Heratio OpenRiC Reference API Records in Contexts (RiC)
All Schemas
302
ahg_settings
28
numbering_scheme
0
numbering_scheme_repository
9
numbering_sequence_used
Entity Relationship Diagram
Open Full Size
AHG Settings ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
ahg_settings_ibfk_1 ahg_settings updated_by user id
numbering_scheme_repository_ibfk_1 numbering_scheme_repository scheme_id numbering_scheme id
numbering_sequence_used_ibfk_1 numbering_sequence_used scheme_id numbering_scheme id
ahg_settings
10 columns 302 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ setting_key varchar(100) NOT NULL -
setting_value text NULL -
setting_type varchar(43) NULL string string, integer, boolean, json, float
FK setting_group varchar(50) NOT NULL general
description varchar(500) NULL -
is_sensitive tinyint(1) NULL 0
FK updated_by int NULL -
updated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
numbering_scheme
16 columns 28 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
name varchar(100) NOT NULL -
FK sector varchar(48) NOT NULL - archive, library, museum, gallery, dam, all
pattern varchar(255) NOT NULL -
description text NULL -
current_sequence bigint NULL 0
sequence_reset varchar(30) NULL never never, yearly, monthly
last_reset_date date NULL -
fill_gaps tinyint(1) NULL 0
validation_regex varchar(255) NULL -
allow_manual_override tinyint(1) NULL 1
auto_generate tinyint(1) NULL 1
FK is_active tinyint(1) NULL 1
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
numbering_scheme_repository
5 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK scheme_id int NOT NULL -
FK repository_id int NOT NULL -
is_active tinyint(1) NULL 1
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
numbering_sequence_used
9 columns 9 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
FK scheme_id int NOT NULL -
sequence_number bigint NOT NULL -
UQ generated_reference varchar(255) NOT NULL -
FK object_id int NULL -
object_type varchar(50) NULL information_object
year_context year NULL -
month_context tinyint NULL -
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.