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