202117761DB_football

Tables (6)

Matches (HOME)

  • 경기ID (match_id) — INT — Primary key — NOT NULL
  • 경기일시 (match_date) — DATETIME
  • 경기장명 (stadium_name) — VARCHAR(100)
  • 홈팀점수 (home_score) — INT
  • 어웨이팀점수 (away_score) — INT
  • 홈팀ID (home_team_id) — INT — NOT NULL
  • 어웨이팀ID (away_team_id) — INT — NOT NULL
  • 구단ID (team_id2) — INT — Foreign key → Teams.구단ID — NOT NULL

Matches (CopyOfUntitled2)

  • 경기ID (match_id) — INT — Primary key — NOT NULL
  • 경기일시 (match_date) — DATETIME
  • 경기장명 (stadium_name) — VARCHAR(100)
  • 홈팀점수 (home_score) — INT
  • 어웨이팀점수 (away_score) — INT
  • 홈팀ID (home_team_id) — INT — NOT NULL
  • 어웨이팀ID (away_team_id) — INT — NOT NULL
  • 구단ID (away_team_id) — INT — Foreign key → Teams.구단ID — NOT NULL

Player_Reviews (Untitled3)

  • 리뷰ID (review_id) — BIGINT — Primary key — NOT NULL
  • 유저ID (user_id) — INT
  • 선수ID (player_id) — INT
  • 경기ID (match_id) — INT
  • 평점 (rating) — DECIMAL(3,1)
  • 한줄평 (comment) — TEXT
  • 유저ID (user_id2) — INT — Foreign key → Users.유저ID — NOT NULL
  • 선수ID (player_id2) — INT — Foreign key → Players.선수ID — NOT NULL
  • 구단ID (team_id2) — INT — Foreign key → Players.구단ID — NOT NULL
  • 경기ID (match_id2) — INT — Foreign key → Matches.경기ID — NOT NULL
  • 경기ID (match_id3) — INT — Foreign key → Matches.경기ID — NOT NULL

Players (Untitled5)

  • 선수ID (player_id) — INT — Primary key — NOT NULL
  • 구단ID (team_id2) — INT — Foreign key → Teams.구단ID — NOT NULL
  • 선수이름 (player_name) — VARCHAR(100)
  • 등번호 (back_number) — INT
  • 포지션 (position) — VARCHAR(30)
  • 국적 (nationality) — VARCHAR(50)
  • 구단ID (team_id) — INT — NOT NULL

Teams (Untitled)

  • 구단ID (team_id) — INT — Primary key — NOT NULL
  • 구단이름 (team_name) — VARCHAR(100)
  • 창단연도 (foundation_year) — INT
  • 연고지 (home_town) — VARCHAR(50)
  • 감독이름 (manager_name) — VARCHAR(50)

Users (Untitled4)

  • 유저ID (user_id) — INT — Primary key — NOT NULL
  • 이메일 (email) — VARCHAR(100)
  • 비밀번호 (password) — VARCHAR(50)
  • 닉네임 (nickname) — VARCHAR(20)
  • 멤버십등급 (membership_level) — VARCHAR(20)
  • 가입일시 (joined_date) — DATETIME