Add Column

Cancel

Current Schema

CREATE TABLE phone_institution_map  (
  id              INTEGER PRIMARY KEY AUTOINCREMENT,
  phone           TEXT NOT NULL,
  institution_id  TEXT NOT NULL,
  role            TEXT DEFAULT 'student' CHECK(role IN ('student','parent','teacher','admin')),
  note            TEXT,
  created_at      DATETIME DEFAULT (datetime('now')),
  UNIQUE(phone, institution_id)
)