+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop