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)