Cps Platform ERD

테이블 (8)

Certificates

  • id — BIGINT — 기본 키
  • member_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • contest_id — BIGINT
  • issued_at — TIMESTAMP

Contests

  • id — INT — 기본 키
  • title — VARCHAR(255) — NOT NULL
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP
  • created_at — TIMESTAMP

Problems

  • id — INT — 기본 키
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT
  • visibility — ENUM('public', 'private')
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • created_at — TIMESTAMP

TeamSolve

  • id — INT — 기본 키
  • team_id — INT
  • problem_id — INT
  • answer — TEXT
  • solved — BOOLEAN
  • solved_at — TIMESTAMP

Teams

  • id — INT — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • is_winner — BOOLEAN

Users

  • id — INT — 기본 키
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • created_at — TIMESTAMP

member_team

  • id — BIGINT — 기본 키
  • team_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • created_at — TIMESTAMP

답안 파일 (file)