Report Builder

Enterprise report builder with templates, sections, SQL queries, scheduling.

ahgReportBuilderPlugin
All Schemas
0
report_archive
0
report_attachment
0
report_comment
32
report_definition
0
report_link
0
report_query
0
report_schedule
3
report_section
0
report_share
8
report_template
0
report_version
Entity Relationship Diagram
Open Full Size
Report Builder ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
report_archive_ibfk_1 report_archive custom_report_id custom_report id
report_archive_ibfk_2 report_archive schedule_id report_schedule id
report_schedule_ibfk_1 report_schedule custom_report_id custom_report id
report_archive
11 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK custom_report_id bigint unsigned NULL -
FK schedule_id bigint unsigned NULL -
file_path varchar(500) NOT NULL -
file_format varchar(10) NOT NULL -
file_size int unsigned NULL -
FK generated_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
generated_by int NULL -
parameters json NULL -
download_token varchar(64) NULL -
download_count int NULL 0
report_attachment
12 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
FK section_id bigint unsigned NULL -
file_name varchar(255) NOT NULL -
file_path varchar(1024) NOT NULL -
file_type varchar(100) NULL -
file_size bigint unsigned NULL 0
thumbnail_path varchar(1024) NULL -
digital_object_id int NULL -
caption text NULL -
position int NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
report_comment
10 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
FK section_id bigint unsigned NULL -
user_id int NOT NULL -
content text NOT NULL -
is_resolved tinyint(1) NULL 0
resolved_by int NULL -
resolved_at datetime NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
report_definition
13 columns 32 rows
Column Type Nullable Default Extra Comment
PK id int NOT NULL - auto_increment
UQ code varchar(100) NOT NULL -
name varchar(255) NOT NULL -
description text NULL -
FK category varchar(92) NOT NULL - collection, acquisition, access, preservation, researcher, compliance, statistics, custom
sector set('archive','library','museum','dam','researcher') NOT NULL archive
report_class varchar(255) NOT NULL - PHP class name for report generator
parameters json NULL - Available filter parameters
output_formats set('html','pdf','csv','xlsx','json') NOT NULL html,csv
FK is_active tinyint(1) NOT NULL 1
sort_order int NOT NULL 0
created_at datetime NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
report_link
13 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
FK section_id bigint unsigned NULL -
FK link_type varchar(79) NOT NULL - external, information_object, actor, repository, accession, digital_object
url varchar(2048) NULL -
title varchar(500) NULL -
description text NULL -
target_id int NULL -
target_slug varchar(255) NULL -
link_category varchar(100) NULL reference
og_image varchar(2048) NULL -
position int NULL 0
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
report_query
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NULL -
section_id bigint unsigned NULL -
name varchar(255) NOT NULL -
query_text text NOT NULL -
query_type varchar(24) NULL visual visual, raw_sql
visual_config json NULL -
parameters json NULL -
row_limit int NULL 1000
timeout_seconds int NULL 30
FK created_by int NOT NULL -
is_shared tinyint(1) NULL 0
last_executed_at datetime NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
report_schedule
15 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK custom_report_id bigint unsigned NOT NULL -
frequency varchar(40) NOT NULL - daily, weekly, monthly, quarterly
day_of_week tinyint NULL -
day_of_month tinyint NULL -
time_of_day time NULL 08:00:00
output_format varchar(22) NULL pdf pdf, xlsx, csv
email_recipients text NULL -
last_run datetime NULL -
FK next_run datetime NULL -
FK is_active tinyint(1) NULL 1
created_at datetime NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at datetime NULL - on update CURRENT_TIMESTAMP
schedule_type varchar(27) NULL recurring recurring, trigger
trigger_config json NULL -
report_section
11 columns 3 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
section_type varchar(74) NOT NULL - narrative, table, chart, summary_card, image_gallery, links, sql_query
title varchar(255) NULL -
content longtext NULL -
position int NULL 0
config json NULL -
clearance_level int NULL 0
is_visible tinyint(1) NULL 1
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
report_share
9 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
UQ share_token varchar(64) NOT NULL -
shared_by int NOT NULL -
expires_at datetime NULL -
access_count int NULL 0
is_active tinyint(1) NULL 1
email_recipients text NULL -
created_at timestamp NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
report_template
11 columns 8 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
name varchar(255) NOT NULL -
description text NULL -
FK category varchar(100) NULL custom
FK scope varchar(33) NULL user system, institution, user
structure json NOT NULL -
created_by int NULL -
repository_id int 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
report_version
7 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
FK report_id bigint unsigned NOT NULL -
version_number int NOT NULL -
snapshot json NOT NULL -
change_summary varchar(500) NULL -
created_by int 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.