+/- table definition

Query 

CREATE TABLE review_schedules  (
  id            TEXT PRIMARY KEY,
  package_id    TEXT NOT NULL REFERENCES review_packages(id) ON DELETE CASCADE,
  child_id      TEXT NOT NULL,
  day_number    INTEGER NOT NULL CHECK(day_number BETWEEN 1 AND 7),
  plan_date     TEXT,
  status        TEXT DEFAULT 'pending' CHECK(status IN ('pending','in_progress','completed')),
  created_at    DATETIME DEFAULT (datetime('now'))
)
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