SQL

CREATE TABLE teachers  (
  id            TEXT PRIMARY KEY,
  institution_id TEXT NOT NULL,
  name          TEXT NOT NULL,
  phone         TEXT,
  email         TEXT,
  title         TEXT DEFAULT '',
  status        TEXT DEFAULT 'active' CHECK(status IN ('active','inactive','resigned')),
  created_at    DATETIME DEFAULT (datetime('now')),
  updated_at    DATETIME DEFAULT (datetime('now')),
  password_hash TEXT DEFAULT '',
  login_enabled INTEGER DEFAULT 1
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
institution_id TEXT Rename | Drop
name TEXT Rename | Drop
phone TEXT ✓ Rename | Drop
email TEXT ✓ Rename | Drop
title TEXT ✓ Rename | Drop
status TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop
password_hash TEXT ✓ Rename | Drop
login_enabled INTEGER ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_teachers_inst institution_id SQL 
CREATE INDEX idx_teachers_inst
ON teachers(institution_id)
Drop
sqlite_autoindex_teachers_1 id ✓ SQL
-- no sql found --
 Drop