SQL

CREATE TABLE classes  (
  id             TEXT PRIMARY KEY,
  institution_id TEXT NOT NULL,
  name           TEXT NOT NULL,
  grade          INTEGER,
  head_teacher_id TEXT,
  student_count  INTEGER DEFAULT 0,
  status         TEXT DEFAULT 'active' CHECK(status IN ('active','archived')),
  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
institution_id TEXT Rename | Drop
name TEXT Rename | Drop
grade INTEGER ✓ Rename | Drop
head_teacher_id TEXT ✓ Rename | Drop
student_count INTEGER ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_classes_inst institution_id SQL 
CREATE INDEX idx_classes_inst
ON classes(institution_id)
Drop
sqlite_autoindex_classes_1 id ✓ SQL
-- no sql found --
 Drop