트센
테이블 (7)
friends
- id — integer — 기본 키 — NOT NULL
- sender_id — integer — 외래 키 — NOT NULL
- receiver_id — integer — 외래 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
match_results
- id — integer — 기본 키 — NOT NULL
- participant_id — integer — 외래 키 — NOT NULL
- match_id — integer — 외래 키 — NOT NULL
- score — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
matches
- id — integer — 기본 키 — NOT NULL
- tournament_id — integer — 외래 키 — NOT NULL
- round — match_round — NOT NULL
- status — match_status — NOT NULL
- scheduled_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
participants
- id — integer — 기본 키 — NOT NULL
- tournament_id — integer — 외래 키 — NOT NULL
- user_id — integer — 외래 키 — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
single_matches
- id — integer — 기본 키 — NOT NULL
- user1_id — integer — 외래 키 — NOT NULL
- user2_id — integer — 외래 키 — NOT NULL
- user1_score — integer — NOT NULL
- user2_score — integer — NOT NULL
- scheduled_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
tournaments
- id — integer — 기본 키 — NOT NULL
- organizer_id — integer — 외래 키 — NOT NULL
- title — varchar(255) — NOT NULL
- start_datetime — timestamp — NOT NULL
- end_datetime — timestamp — NOT NULL
- status — tournament_status — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL
users
- id (Key) — integer — 기본 키 — NOT NULL
- nickname — varchar(255) — NOT NULL
- password — varchar(500) — NOT NULL
- email — varchar(255) — NOT NULL
- profile_image — varchar(500)
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- is_deleted — boolean — NOT NULL