SQL

CREATE TABLE mock_exams  (
  id            TEXT PRIMARY KEY,
  child_id      TEXT NOT NULL,
  package_id    TEXT REFERENCES review_packages(id),
  subject       TEXT NOT NULL,
  questions     TEXT DEFAULT '[]',
  answers       TEXT DEFAULT '[]',
  total_score   INTEGER DEFAULT 100,
  user_score    INTEGER DEFAULT 0,
  time_limit_min INTEGER DEFAULT 15,
  used_seconds  INTEGER DEFAULT 0,
  status        TEXT DEFAULT 'pending' CHECK(status IN ('pending','in_progress','completed')),
  created_at    DATETIME DEFAULT (datetime('now')),
  updated_at    DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
child_id TEXT Rename | Drop
package_id TEXT ✓ Rename | Drop
subject TEXT Rename | Drop
questions TEXT ✓ Rename | Drop
answers TEXT ✓ Rename | Drop
total_score INTEGER ✓ Rename | Drop
user_score INTEGER ✓ Rename | Drop
time_limit_min INTEGER ✓ Rename | Drop
used_seconds INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
package_id review_packages.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_me_child child_id SQL 
CREATE INDEX idx_me_child
ON mock_exams(child_id)
Drop
sqlite_autoindex_mock_exams_1 id ✓ SQL
-- no sql found --
 Drop