Ball:link 초안
테이블 (17)
files
- file_id — CHAR(36) — 기본 키 — NOT NULL
- original_name — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(100) — NOT NULL
- size_bytes — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
game_events
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — NOT NULL
- ts — DATETIME — NOT NULL
- period — INT — NOT NULL
- clock_time — VARCHAR(8)
- team_id — BIGINT
- team_side — ENUM('HOME','AWAY')
- player_id — BIGINT
- type — ENUM( 'SCORE','FOUL','TIMEOUT','SUBSTITUTION', 'ASSIST','STEAL','BLOCK','TURNOVER', 'REBOUND_O','REBOUND_D', 'PERIOD_START','PERIOD_END', 'CLOCK_UPDATE','SHOTCLOCK_RESET', 'NOTE' ) — NOT NULL
- meta — JSON
game_lineup_players
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- team_side — ENUM('HOME','AWAY') — NOT NULL
- player_id — BIGINT
- guest_name — VARCHAR(100)
- guest_number — SMALLINT
- is_starter — TINYINT(1) — NOT NULL
- number — SMALLINT
- position — ENUM('PG','SG','SF','PF','C')
game_player_stats
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- player_id — BIGINT — NOT NULL
- pts — INT — NOT NULL
- reb — INT — NOT NULL
- ast — INT — NOT NULL
- stl — INT — NOT NULL
- blk — INT — NOT NULL
- fg2_made — INT — NOT NULL
- fg2_att — INT — NOT NULL
- fg3_made — INT — NOT NULL
- fg3_att — INT — NOT NULL
- ft_made — INT — NOT NULL
- ft_att — INT — NOT NULL
- tov — INT — NOT NULL
- pf — INT — NOT NULL
- minutes — DECIMAL(5,2) — NOT NULL
game_team_stats
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- pts — INT — NOT NULL
- reb — INT — NOT NULL
- ast — INT — NOT NULL
- stl — INT — NOT NULL
- blk — INT — NOT NULL
- tov — INT — NOT NULL
- pf — INT — NOT NULL
games
- id — BIGINT — 기본 키 — NOT NULL
- tournament_id — BIGINT
- home_team_id — BIGINT — NOT NULL
- away_team_id — BIGINT
- opponent_name — VARCHAR(120)
- round_code — ENUM('GROUP','ROUND_OF_16','QF','SF','FINAL')
- bracket_order — INT
- state — ENUM('SCHEDULED','ONGOING','FINISHED','CANCELED') — NOT NULL
- scheduled_at — DATETIME
- started_at — DATETIME
- finished_at — DATETIME
- canceled_reason — VARCHAR(255)
- venue_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
invites
- code — VARCHAR(32) — 기본 키 — NOT NULL
- team_id — BIGINT — NOT NULL
- status — ENUM('ACTIVE','REVOKED','EXPIRED') — NOT NULL
- expires_at — DATETIME
- max_uses — INT
- used_count — INT — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- revoked_at — DATETIME
join_requests
- id — BIGINT — 기본 키 — NOT NULL
- team_id — BIGINT — NOT NULL
- applicant_user_id — BIGINT — NOT NULL
- position — ENUM('PG','SG','SF','PF','C')
- location — VARCHAR(100)
- bio — TEXT
- invite_code — VARCHAR(32)
- status — ENUM('PENDING','ACCEPTED','REJECTED') — NOT NULL
- applied_at — TIMESTAMP — NOT NULL
- processed_at — DATETIME
- processed_by — BIGINT
- reject_reason — VARCHAR(255)
players
- id — BIGINT — 기본 키 — NOT NULL
- team_id — BIGINT — NOT NULL
- user_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- number — SMALLINT
- position — ENUM('PG','SG','SF','PF','C')
- note — VARCHAR(255)
- active — TINYINT(1) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- is_active — TINYINT(1) — NOT NULL
score_sessions
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — NOT NULL
- session_token — VARCHAR(64) — NOT NULL
- created_by — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- expires_at — DATETIME
- status — ENUM('ACTIVE','EXPIRED','CLOSED') — NOT NULL
team_members
- id — BIGINT — 기본 키 — NOT NULL
- team_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- role — ENUM('LEADER','MANAGER','PLAYER') — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
- left_at — TIMESTAMP
teams
- id — BIGINT — 기본 키 — NOT NULL
- owner_user_id — BIGINT — NOT NULL
- name — VARCHAR(120) — NOT NULL
- short_name — VARCHAR(50)
- founded_year — SMALLINT
- region — VARCHAR(50)
- description — TEXT
- emblem_file_id — CHAR(36)
- color_primary — VARCHAR(9)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
tournament_entries
- id — BIGINT — 기본 키 — NOT NULL
- tournament_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- player_id — BIGINT — NOT NULL
- number — SMALLINT
- position — ENUM('PG','SG','SF','PF','C')
- note — VARCHAR(255)
- locked — TINYINT(1) — NOT NULL
tournament_teams
- id — BIGINT — 기본 키 — NOT NULL
- tournament_id — BIGINT — NOT NULL
- team_id — BIGINT — NOT NULL
- seed — INT
- created_at — TIMESTAMP — NOT NULL
tournaments
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(150) — NOT NULL
- season — VARCHAR(20)
- location — VARCHAR(100)
- status — ENUM('SCHEDULED','ONGOING','FINISHED','CANCELED') — NOT NULL
- start_date — DATE
- end_date — DATE
- venue_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255)
- password_hash — VARCHAR(255)
- name — VARCHAR(100) — NOT NULL
- gender — ENUM('M','F')
- birth_year — SMALLINT
- phone — VARCHAR(30)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
venues
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(150) — NOT NULL
- address — VARCHAR(255)
- phone — VARCHAR(30)
- created_at — TIMESTAMP — NOT NULL