12th
Tables (8)
tbl_club (구단)
- club_id (아이디) — BIGINT — Primary key — NOT NULL
- club_name (이름) — VARCHAR(30)
- club_stadium (구단구장) — VARCHAR(30)
- club_score (클럽점수) — INT
- club_win (승수) — INT
- club_lose (패배수) — INT
- club_draw (무승부수) — INT
tbl_favorite_club (구단 즐겨찾기)
- club_favorite_id (아이디) — BIGINT — Primary key — NOT NULL
- club_id (구단아이디) — BIGINT — Foreign key → tbl_club.club_id — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
tbl_favorite_player (선수 즐겨찾기)
- id (아이디) — BIGINT — Primary key — NOT NULL
- player_id (선수아이디) — BIGINT — Foreign key → tbl_player.player_id — NOT NULL
- user_id (유저아이디) — BIGINT — Foreign key → tbl_user.user_id — NOT NULL
tbl_goal (골)
- goal_id (아이디) — BIGINT — Primary key — NOT NULL
- player_id (아이디2) — BIGINT — Foreign key → tbl_player.player_id — NOT NULL
- match_id (아이디3) — BIGINT — Foreign key → tbl_match.match_id — NOT NULL
- goal_time (골시간) — INT
tbl_match (경기)
- match_id (아이디) — BIGINT — Primary key — NOT NULL
- home_club_id (홈팀아이디) — BIGINT — Foreign key → tbl_club.club_id — NOT NULL
- away_club_id (어웨이팀 아이디) — BIGINT — Foreign key → tbl_club.club_id — NOT NULL
- home_score (홈팀점수) — INT
- away_score (어웨이점수) — INT
- match_date (매치날짜) — DATE
tbl_match_event (경기 이벤트)
- event_id (아이디) — BIGINT — Primary key — NOT NULL
- player_id (아이디2) — BIGINT — Foreign key → tbl_player.player_id — NOT NULL
- match_id (아이디3) — BIGINT — Foreign key → tbl_match.match_id — NOT NULL
tbl_player (선수)
- player_id (아이디) — BIGINT — Primary key — NOT NULL
- club_id (아이디2) — BIGINT — Foreign key → tbl_club.club_id — NOT NULL
- player_name (이름) — VARCHAR(30)
- player_age (나이) — INT
- player_position (포지션) — ENUM
- player_number (번호) — INT
tbl_user (유저)
- user_id (아이디) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR(30)
- password (비밀번호) — VARCHAR(30)