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