SQL

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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
package_id TEXT Rename | Drop
child_id TEXT Rename | Drop
day_number INTEGER Rename | Drop
plan_date TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
package_id review_packages.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_rs_day
  • package_id
  • day_number
 SQL 
CREATE INDEX idx_rs_day
ON review_schedules(package_id, day_number)
Drop
sqlite_autoindex_review_schedules_1 id ✓ SQL
-- no sql found --
 Drop