Add Column

Cancel

Current Schema

CREATE TABLE children  (
  id          TEXT PRIMARY KEY,
  nickname    TEXT NOT NULL,
  grade       INTEGER,
  -- 年级 1-12
    avatar      TEXT,
  tags        TEXT,
  -- 性格标签 JSON
    created_at  DATETIME DEFAULT (datetime('now')),
  updated_at  DATETIME DEFAULT (datetime('now')),
  device_id TEXT,
  phone TEXT,
  institution_id TEXT
)