SQL

CREATE TABLE message  (
  id INTEGER NOT NULL,
  ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  sub_id INTEGER NOT NULL,
  who VARCHAR(80) NOT NULL,
  txt VARCHAR(256),
  PRIMARY KEY (id),
  FOREIGN KEY(sub_id) REFERENCES submission (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
ts DATETIME ✓ Rename | Drop
sub_id INTEGER Rename | Drop
who VARCHAR(80) Rename | Drop
txt VARCHAR(256) ✓ Rename | Drop

Foreign Keys

Column Destination
sub_id submission.id

+ Add index

Indexes

Name Columns Unique SQL Drop?