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