SQL

CREATE TABLE submission  (
  id INTEGER NOT NULL,
  ts DATETIME DEFAULT CURRENT_TIMESTAMP,
  user_id INTEGER NOT NULL,
  taskid VARCHAR(34),
  category VARCHAR(50),
  task VARCHAR(200),
  active BOOLEAN,
  points INTEGER,
  filename VARCHAR(200),
  is_graded BOOLEAN,
  PRIMARY KEY (id),
  FOREIGN KEY(user_id) REFERENCES user (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
ts DATETIME ✓ Rename | Drop
user_id INTEGER Rename | Drop
taskid VARCHAR(34) ✓ Rename | Drop
category VARCHAR(50) ✓ Rename | Drop
task VARCHAR(200) ✓ Rename | Drop
active BOOLEAN ✓ Rename | Drop
points INTEGER ✓ Rename | Drop
filename VARCHAR(200) ✓ Rename | Drop
is_graded BOOLEAN ✓ Rename | Drop

Foreign Keys

Column Destination
user_id user.id

+ Add index

Indexes

Name Columns Unique SQL Drop?