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