SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
nickname TEXT Rename | Drop
grade INTEGER ✓ Rename | Drop
avatar TEXT ✓ Rename | Drop
tags TEXT ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
updated_at DATETIME ✓ Rename | Drop
device_id TEXT ✓ Rename | Drop
phone TEXT ✓ Rename | Drop
institution_id TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_children_device_id device_id SQL 
CREATE INDEX idx_children_device_id
ON children(device_id)
Drop
sqlite_autoindex_children_1 id ✓ SQL
-- no sql found --
 Drop