+/- table definition

Query 

CREATE TABLE package_checklist_items  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  key TEXT UNIQUE NOT NULL,
  label TEXT NOT NULL,
  sort_order INTEGER DEFAULT 0,
  created_at TEXT NOT NULL DEFAULT (datetime('now','localtime')),
  department_id INTEGER REFERENCES departments(id) ON DELETE SET NULL,
  visible_to_client INTEGER NOT NULL DEFAULT 1
)
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 view : create view : drop