Query

pilot.db — audit_log

+/- table definition

Query 

CREATE TABLE audit_log  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  ts TEXT NOT NULL DEFAULT (datetime('now')),
  actor_kind TEXT,
  -- 'trainer' | 'student' | 'system'
  actor_id INTEGER,
  action TEXT NOT NULL,
  -- 'booking_created',
  'card_purchased',
  etc.
  entity_type TEXT,
  entity_id INTEGER,
  meta TEXT                               -- JSON-Stringified
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop