SQL

CREATE TABLE bind_codes  (
  code        TEXT PRIMARY KEY,
  parent_id   TEXT NOT NULL REFERENCES parents(id),
  child_id    TEXT,
  -- 绑定后填写
    expires_at  DATETIME NOT NULL,
  used        INTEGER DEFAULT 0,
  created_at  DATETIME DEFAULT (datetime('now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
code TEXT ✓ ✓ Rename | Drop
parent_id TEXT Rename | Drop
child_id TEXT ✓ Rename | Drop
expires_at DATETIME Rename | Drop
used INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop

Foreign Keys

Column Destination
parent_id parents.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_bind_codes_parent parent_id SQL 
CREATE INDEX idx_bind_codes_parent
ON bind_codes(parent_id)
Drop
sqlite_autoindex_bind_codes_1 code ✓ SQL
-- no sql found --
 Drop