scoremaster

테이블 (6)

경기 (match)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (home_team_id) — int — 외래 키 → 팀.Key — NOT NULL
  • Key (away_team_id) — int — 외래 키 → 팀.Key — NOT NULL
  • Key (league_id) — int — 외래 키 → 리그.Key — NOT NULL
  • Field (start_time) — datetime — NOT NULL
  • Field (home_score) — int — NOT NULL
  • Field2 (away_score) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL

경기예측 (prediction)

  • Key2 (id) — int — 기본 키 — NOT NULL
  • id (user_id) — int — 외래 키 → 회원.id — NOT NULL
  • Key (match_id) — datetime — 외래 키 → 경기.Key — NOT NULL
  • Field2 (home_score) — int — NOT NULL
  • Field2 (away_score) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

리그 (league)

  • Key (id) — int — 기본 키 — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field2 (updated_at) — datetime — NOT NULL

팀 (team)

  • Key (id) — int — 기본 키 — NOT NULL
  • Key (league_id) — int — 외래 키 → 리그.Key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

회원 (user)

  • id — int — 기본 키 — NOT NULL
  • Field2 (username) — varchar(50) — NOT NULL
  • Field3 (password) — varchar(50) — NOT NULL
  • Field (email) — varchar(100) — NOT NULL
  • Field (score) — int — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL

회원-팀 중간테이블 (user_team)

  • Key (id) — int — 기본 키 — NOT NULL
  • id (user_id) — int — 외래 키 → 회원.id — NOT NULL
  • Key (team_id) — int — 외래 키 → 팀.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field (updated_at) — datetime — NOT NULL