필드 하키

테이블 (8)

MATCH

  • id — bigInt — 기본 키 — NOT NULL
  • homeTeamId — bigInt — 외래 키 → TEAM.id — NOT NULL
  • awayTeamId — bigInt — 외래 키 → TEAM.id — NOT NULL
  • season_id — bigInt — NOT NULL
  • stadium_id — bigInt — NOT NULL
  • status — int
  • title — varchar(50)
  • home_score — int
  • away_score — int
  • referee — varchar(50)
  • assistant_referee — varchar(50)
  • third_referee — varchar(50)
  • time_keeper — varchar(50)
  • match_started_at — datetime
  • first_half_started_at — datetime
  • first_half_ended_at — datetime
  • second_half_started_at — datetime
  • second_half_ended_at — datetime
  • created_at — datetime

MATCH_EVENT_LOG

  • id — bigInt — 기본 키 — NOT NULL
  • matchId — bigInt — 외래 키 → MATCH.id — NOT NULL
  • action — varchar(50)
  • matchPeriod (match_period) — varchar(50)
  • after_minutes — int
  • team_id — bigint
  • player_id — bigint
  • out_player_id — bigInt — NOT NULL
  • created_at — datetime

MATCH_PLAYER

  • id — bigInt — 기본 키 — NOT NULL
  • matchId — bigInt — 외래 키 → MATCH.id — NOT NULL
  • type — varchar(50)
  • playerId (player_id) — bigInt
  • name — varchar(50)
  • position — varchar(50)
  • isStartingPlayer (is_starting_player) — boolean

PLAYER

  • id — bigInt — 기본 키 — NOT NULL
  • teamId (id2) — bigInt — 외래 키 → TEAM.id — NOT NULL
  • name — varchar(50)
  • squadNumber (squad_number) — Int
  • postion — varchar(50)
  • createdAt (created_at) — datetime
  • updatedAt (updated_at) — datetime

SEASON

  • id — bigInt — 기본 키 — NOT NULL
  • name — varchar(50)
  • status — varchar(50)
  • started_at — datetime
  • ended_at — datetime
  • created_at — datetime

SEASON_RANKING

  • season_id — bigInt — NOT NULL
  • league_type — VARCHAR(255)
  • team_id — bigInt
  • points — int
  • wins — Int
  • draws — Int
  • losses — Int
  • goals — Int
  • goals_against — Int
  • goals_difference — Int
  • ranking — Int

STADIUM

  • id — bigInt — 기본 키 — NOT NULL
  • name — varchar(50)
  • address — varchar(255)

TEAM

  • id — bigInt — 기본 키 — NOT NULL
  • coach — varchar(50)
  • logo — varchar(255)
  • created_at — datetime