필드 하키
테이블 (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