create.sql

CREATE TABLE submissions (
  id            BIGINT NOT NULL,
  epoch_second  BIGINT NOT NULL,
  problem_id    VARCHAR(255) NOT NULL,
  contest_id    VARCHAR(255) NOT NULL,
  user_id       BIGINT NOT NULL, -- 数値化
  language      VARCHAR(255) NOT NULL,
  point         DOUBLE PRECISION NOT NULL,
  length        INT NOT NULL,
  result        VARCHAR(255) NOT NULL,
  execution_time  INT,
  PRIMARY KEY (id)
);

CREATE INDEX user_id on submissions(user_id);