잔디밭

테이블 (7)

player_sub_positions

  • id — SERIAL
  • player_id — INTEGER — NOT NULL
  • position — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP

player_tournament_results

  • id — SERIAL
  • player_id — INTEGER — NOT NULL
  • tournament_id — INTEGER — NOT NULL
  • team_id — INTEGER
  • final_result — VARCHAR(50)
  • created_at — TIMESTAMP

players

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • main_position — VARCHAR(10) — NOT NULL
  • soop_id — VARCHAR(100)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

team_coaches

  • id — SERIAL
  • team_id — INTEGER — NOT NULL
  • coach_name — VARCHAR(100) — NOT NULL
  • coach_role — VARCHAR(50)
  • created_at — TIMESTAMP

team_players

  • id — SERIAL
  • team_id — INTEGER — NOT NULL
  • player_id — INTEGER — NOT NULL
  • joined_at — TIMESTAMP

teams

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • tournament_id — INTEGER — NOT NULL
  • manager — VARCHAR(100)
  • logo_url — VARCHAR(255)
  • team_color — VARCHAR(7)
  • final_ranking — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

tournaments

  • id — SERIAL
  • name — VARCHAR(100) — NOT NULL
  • year — INTEGER — NOT NULL
  • logo_url — VARCHAR(255)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP