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