SQL

CREATE TABLE review_schedule_items  (
  id            TEXT PRIMARY KEY,
  schedule_id   TEXT NOT NULL REFERENCES review_schedules(id) ON DELETE CASCADE,
  subject       TEXT NOT NULL,
  topic_name    TEXT NOT NULL,
  item_type     TEXT NOT NULL CHECK(item_type IN ('practice','error_review','mock')),
  estimated_min INTEGER DEFAULT 10,
  status        TEXT DEFAULT 'pending' CHECK(status IN ('pending','completed')),
  created_at    DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
schedule_id TEXT Rename | Drop
subject TEXT Rename | Drop
topic_name TEXT Rename | Drop
item_type TEXT Rename | Drop
estimated_min INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
schedule_id review_schedules.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_review_schedule_items_1 id ✓ SQL
-- no sql found --
 Drop