SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
key TEXT Rename | Drop
label TEXT Rename | Drop
sort_order INTEGER ✓ Rename | Drop
created_at TEXT Rename | Drop
department_id INTEGER ✓ Rename | Drop
visible_to_client INTEGER Rename | Drop

Foreign Keys

Column Destination
department_id departments.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_package_checklist_items_1 key ✓ SQL
-- no sql found --
 Drop