뇽
테이블 (13)
comments
- id — BIGINT — 기본 키 — NOT NULL
- created_at — datetime — NOT NULL
- content — VARCHAR(255) — NOT NULL
- is_blocked — BIT(1) — NOT NULL
- game_team_id — BIGINT — 외래 키 → game_teams.id
game_team_players
- id — BIGINT — 기본 키 — NOT NULL
- game_team_id — BIGINT — 외래 키 → game_teams.id
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
game_teams
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — 외래 키 → games.id
- team_id — BIGINT — 외래 키 → teams.id
- cheer_count — INT — NOT NULL
- score — INT — NOT NULL
games
- id — BIGINT — 기본 키 — NOT NULL
- sport_id — BIGINT — 외래 키 → sports.id
- member_id — BIGINT — 외래 키 → members.id
- league_id — BIGINT — 외래 키 → leagues.id
- start_time — datetime — NOT NULL
- video_id — VARCHAR(255)
- quarter_changed_at — datetime
- game_quarter — VARCHAR(255) — NOT NULL
league_sports
- id — BIGINT — 기본 키 — NOT NULL
- sport_id — BIGINT — 외래 키 → sports.id
- league_id — BIGINT — 외래 키 → leagues.id
leagues
- id — BIGINT — 기본 키 — NOT NULL
- administrator_id — BIGINT — 외래 키 → members.id
- organization_id — BIGINT — 외래 키 → organizations.id
- name — VARCHAR(255) — NOT NULL
- start_at — datetime — NOT NULL
- end_at — datetime — NOT NULL
members
- id — BIGINT — 기본 키 — NOT NULL
- organization_id — BIGINT — 외래 키 → organizations.id
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- is_administrator — BIT(1) — NOT NULL
- last_login — datetime
organizations
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
quarters
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- sports_id — BIGINT — 외래 키 → sports.id
records
- id — BIGINT — 기본 키 — NOT NULL
- game_id — BIGINT — 외래 키 → games.id
- game_team_id — BIGINT — 외래 키 → game_teams.id
- game_team_player_id — BIGINT — 외래 키 → game_team_players.id
- score — INT — NOT NULL
- scored_quarter — VARCHAR(255) — NOT NULL
- scored_at — datetime — NOT NULL
sports
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
teams
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- logo_image_url — VARCHAR(255) — NOT NULL
- administrator_id — BIGINT — 외래 키 → members.id
- organization_id — BIGINT — 외래 키 → organizations.id
먀아 (Untitled)
- Field
- Field2
- Field3
- Field4
- Field5
- id — BIGINT — 외래 키 → organizations.id — NOT NULL