Ball:Link
Tables (19)
files
- created_at — datetime(6)
- size_bytes — bigint
- file_id — varchar(36) — NOT NULL
- content_type — varchar(255)
- original_name — varchar(255)
- category — enum
- owner_id — bigint
- owner_type — enum
- relative_path — varchar(255)
game_events
- period — int — NOT NULL
- game_id — bigint
- id — bigint
- player_id — bigint
- team_id — bigint
- ts — datetime(6)
- clock_time — varchar(255)
- meta — longtext
- team_side — enum
- type — varchar(32) — NOT NULL
game_lineup_players
- guest_number — smallint
- is_starter — bit — NOT NULL
- number — smallint
- game_id — bigint
- id — bigint
- player_id — bigint
- team_id — bigint
- guest_name — varchar(255)
- position — enum
- team_side — enum
game_player_stats
- ast — int — NOT NULL
- blk — int — NOT NULL
- fg2att — int — NOT NULL
- fg2made — int — NOT NULL
- fg3att — int — NOT NULL
- fg3made — int — NOT NULL
- ft_att — int — NOT NULL
- ft_made — int — NOT NULL
- minutes — decimal(38, 2)
- pf — int — NOT NULL
- pts — int — NOT NULL
- reb — int — NOT NULL
- stl — int — NOT NULL
- tov — int — NOT NULL
- game_id — bigint
- id — bigint
- player_id — bigint
- team_id — bigint
game_team_stats
- ast — int — NOT NULL
- blk — int — NOT NULL
- pf — int — NOT NULL
- pts — int — NOT NULL
- reb — int — NOT NULL
- stl — int — NOT NULL
- tov — int — NOT NULL
- game_id — bigint
- id — bigint
- team_id — bigint
- fg2 — int
- fg3 — int
- ft — int
games
- bracket_order — int
- away_team_id — bigint
- created_at — datetime(6)
- finished_at — datetime(6)
- home_team_id — bigint
- id — bigint
- scheduled_at — datetime(6)
- started_at — datetime(6)
- tournament_id — bigint
- venue_id — bigint
- canceled_reason — varchar(255)
- opponent_name — varchar(255)
- round_code — enum
- state — enum
- deleted_at — datetime(6)
- is_scrimmage — bit — NOT NULL
- away_team_name — varchar(255)
- home_team_name — varchar(255)
invites
- max_uses — int
- used_count — int
- created_at — datetime(6)
- created_by — bigint
- expires_at — datetime(6)
- revoked_at — datetime(6)
- team_id — bigint
- code — varchar(32) — NOT NULL
- status — enum
join_requests
- applicant_user_id — bigint
- applied_at — datetime(6)
- id — bigint
- processed_at — datetime(6)
- processed_by — bigint
- team_id — bigint
- invite_code — varchar(32)
- bio — varchar(255)
- location — varchar(255)
- reject_reason — varchar(255)
- position — enum
- status — enum
password_reset_token
- used — bit — NOT NULL
- expires_at — datetime(6) — NOT NULL
- id — bigint
- email — varchar(255) — NOT NULL
- token — varchar(255) — NOT NULL
players
- is_active — bit — NOT NULL
- number — smallint
- created_at — datetime(6)
- deleted_at — datetime(6)
- id — bigint
- team_id — bigint
- updated_at — datetime(6)
- user_id — bigint
- name — varchar(100) — NOT NULL
- note — varchar(255)
- position — enum
score_sessions
- created_at — datetime(6)
- ended_at — datetime(6)
- created_by — bigint
- expires_at — datetime(6)
- game_id — bigint
- id — bigint
- status — enum
- tournament_id — bigint
- session_token — varchar(128) — NOT NULL
team_members
- id — bigint
- joined_at — datetime(6)
- left_at — datetime(6)
- team_id — bigint
- user_id — bigint
- role — enum
- back_number — int
- location — varchar(100)
- position — varchar(10)
teams
- founded_at — date
- is_public — bit — NOT NULL
- created_at — datetime(6)
- deleted_at — datetime(6)
- id — bigint
- owner_user_id — bigint
- updated_at — datetime(6)
- name — varchar(120) — NOT NULL
- emblem_url — varchar(500)
- description — longtext
- region — varchar(255)
- short_name — varchar(255)
- team_tag — varchar(4) — NOT NULL
tournament_entries
- locked — bit — NOT NULL
- number — smallint
- id — bigint
- player_id — bigint
- team_id — bigint
- tournament_id — bigint
- note — varchar(255)
- position — enum
tournament_teams
- seed — int
- created_at — datetime(6)
- id — bigint
- team_id — bigint
- tournament_id — bigint
tournaments
- end_date — date
- start_date — date
- created_at — datetime(6)
- id — bigint
- venue_id — bigint
- name — varchar(150) — NOT NULL
- location — varchar(255)
- season — varchar(255)
- status — enum
user_providers
- created_at — datetime(6)
- id — bigint
- user_id — bigint
- provider_user_id — varchar(191) — NOT NULL
- email — varchar(255)
- provider — enum
users
- birth_year — smallint
- created_at — datetime(6)
- id — bigint
- updated_at — datetime(6)
- name — varchar(100) — NOT NULL
- email — varchar(255)
- password_hash — varchar(255)
- phone — varchar(255)
- gender — enum
- profile_image_path — varchar(255)
- is_admin — bit — NOT NULL
venues
- created_at — datetime(6)
- id — bigint
- name — varchar(150) — NOT NULL
- address — varchar(255)
- phone — varchar(255)