audit_id bigint(20) auto_increment not_null
agent_id varchar(100) not_null
action_type varchar(100) not_null
outcome varchar(50) not_null
details longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin default null CHECK (json_valid(details))
timestamp timestamp NULL default(current_timestamp)

--
primary audit_id
idx_agent_id agent_id
idx_action_type action_type
idx_outcome outcome
idx_timestamp timestamp

##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci
