Audit Trail

Audit logging for all entity changes with field-level detail tracking.

ahgAuditTrailPlugin
All Schemas
0
ahg_audit_access
50
ahg_audit_authentication
199
ahg_audit_log
0
ahg_audit_retention_policy
4
ahg_audit_settings
0
audit_log
Entity Relationship Diagram
Open Full Size
Audit Trail ERD
Foreign Key Relationships
Constraint Table Column References Referenced Column
fk_ahg_audit_access_user ahg_audit_access user_id user id
fk_ahg_audit_auth_user ahg_audit_authentication user_id user id
fk_ahg_audit_log_user ahg_audit_log user_id user id
ahg_audit_access
21 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ uuid char(36) NOT NULL -
FK user_id int NULL -
username varchar(255) NULL -
ip_address varchar(45) NULL -
FK access_type varchar(50) NOT NULL -
FK entity_type varchar(100) NOT NULL -
entity_id int NULL -
entity_slug varchar(255) NULL -
entity_title varchar(500) NULL -
FK security_classification varchar(50) NULL -
security_clearance_level int unsigned NULL -
clearance_verified tinyint(1) NOT NULL 0
file_path varchar(1000) NULL -
file_name varchar(255) NULL -
file_mime_type varchar(100) NULL -
file_size bigint unsigned NULL -
status varchar(20) NOT NULL success
denial_reason varchar(255) NULL -
metadata json NULL -
FK created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
ahg_audit_authentication
13 columns 50 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ uuid char(36) NOT NULL -
FK event_type varchar(50) NOT NULL -
FK user_id int NULL -
username varchar(255) NULL -
FK ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
session_id varchar(128) NULL -
status varchar(20) NOT NULL success
failure_reason varchar(255) NULL -
failed_attempts int unsigned NOT NULL 0
metadata json NULL -
FK created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
ahg_audit_log
26 columns 199 rows
Column Type Nullable Default Extra Comment
PK id bigint unsigned NOT NULL - auto_increment
UQ uuid char(36) NOT NULL -
FK user_id int NULL -
username varchar(255) NULL -
user_email varchar(255) NULL -
FK ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
session_id varchar(128) NULL -
FK action varchar(50) NOT NULL -
FK entity_type varchar(100) NOT NULL -
FK entity_id int NULL -
entity_slug varchar(255) NULL -
entity_title varchar(500) NULL -
module varchar(100) NULL -
action_name varchar(100) NULL -
request_method varchar(10) NULL -
request_uri varchar(2000) NULL -
old_values json NULL -
new_values json NULL -
changed_fields json NULL -
metadata json NULL -
FK security_classification varchar(50) NULL -
FK status varchar(20) NOT NULL success
error_message text NULL -
FK created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
culture_id int NULL -
ahg_audit_retention_policy
8 columns 0 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ log_type varchar(50) NOT NULL -
retention_days int unsigned NOT NULL 2555
archive_before_delete tinyint(1) NOT NULL 1
archive_path varchar(500) NULL -
last_cleanup_at timestamp NULL -
created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
ahg_audit_settings
7 columns 4 rows
Column Type Nullable Default Extra Comment
PK id int unsigned NOT NULL - auto_increment
UQ setting_key varchar(100) NOT NULL -
setting_value text NULL -
setting_type varchar(20) NOT NULL string
description text NULL -
created_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED
updated_at timestamp NOT NULL CURRENT_TIMESTAMP DEFAULT_GENERATED on update CURRENT_TIMESTAMP
audit_log
16 columns 0 rows
Column Type Nullable Default Extra Comment
PK id bigint NOT NULL - auto_increment
FK table_name varchar(100) NOT NULL -
record_id int NOT NULL -
FK action varchar(30) NOT NULL - create, update, delete
field_name varchar(100) NULL -
old_value text NULL -
new_value text NULL -
old_record json NULL -
new_record json NULL -
FK user_id int NULL -
username varchar(255) NULL -
ip_address varchar(45) NULL -
user_agent varchar(500) NULL -
module varchar(100) NULL -
action_description varchar(255) NULL -
FK 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.