audit_log

0 rows where operator_id = 1

✎ View and edit SQL

This data as json

0 records

CREATE TABLE audit_log (
	audit_id INTEGER NOT NULL, 
	timestamp DATETIME NOT NULL, 
	operator_id INTEGER NOT NULL, 
	run_id INTEGER, 
	table_name VARCHAR(64) NOT NULL, 
	record_pk VARCHAR(256) NOT NULL, 
	action VARCHAR(6) NOT NULL, 
	column_name VARCHAR(64), 
	old_value TEXT, 
	new_value TEXT, 
	reason TEXT, 
	PRIMARY KEY (audit_id), 
	FOREIGN KEY(operator_id) REFERENCES operator (operator_id), 
	FOREIGN KEY(run_id) REFERENCES ingestion_run (run_id)
);
CREATE INDEX ix_audit_log_timestamp ON audit_log (timestamp);
CREATE INDEX ix_audit_log_record_pk ON audit_log (record_pk);
CREATE INDEX ix_audit_log_run_id ON audit_log (run_id);
CREATE INDEX ix_audit_log_table_name ON audit_log (table_name);
CREATE INDEX ix_audit_log_operator_id ON audit_log (operator_id);