뇽

테이블 (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