0701
Tables (7)
Club (동호회)
- 클럽id (club_id) — int — Primary key — NOT NULL
- 지역id (region_id) — int — Foreign key → Region.id — NOT NULL
- 이름 (name) — varchar — NOT NULL
- 생성날짜 (create_date) — date — NOT NULL
- 총인원 (cnt) — int — NOT NULL
- 랭킹점수 (rp) — int — NOT NULL
- 스포츠 (sports) — enum — NOT NULL
Match (경기)
- 경기id (match_id) — int — Primary key — NOT NULL
- 클럽1id (club1_id) — int — Foreign key → Club.클럽id — NOT NULL
- 클럽2id (club2_id) — int — Foreign key → Club.지역id — NOT NULL
- 지역id (region_id) — int — Foreign key → Region.id — NOT NULL
- 날짜 (match_date) — datetime — NOT NULL
- 장소 (location) — varchar
MatchResult (경기결과)
- 결과id (result_id) — int — Primary key — NOT NULL
- 경기id (match_id) — int — Foreign key → Match.경기id — NOT NULL
- 클럽1점수 (club1_score) — int — NOT NULL
- 클럽2점수 (club2_score) — int — NOT NULL
- 승리클럽 (winclub_id) — int
Region (지역)
- id (region_id) — int — Primary key — NOT NULL
- 이름 (region_name) — varchar — NOT NULL
Review (평가)
- 평가id (review_id) — int — Primary key — NOT NULL
- id (match_id) — int — Foreign key → MatchResult.경기id — NOT NULL
- 평가점수 (rating) — int — NOT NULL
- 코멘트 (comment) — varchar
Users (회원정보)
- id (user_id) — int — Primary key — NOT NULL — 자동삽입
- 이름 (name) — varchar
- 비밀번호 (pw) — varchar
- 전화번호 (phone) — varchar
- 역할 (role) — enum
Users-Club (연관)
- id (user_club_id) — int — Primary key — NOT NULL
- 유저id (user_id) — int — Foreign key → Users.id — NOT NULL — 자동삽입
- 클럽id (club_id) — int — Foreign key → Club.클럽id — NOT NULL
- 가입날짜 (join_date) — date — NOT NULL