## 核心关系图

以 `tournaments` 与 `matches` 为枢纽的主要外键路径
枢纽 hub 有 FK 关系 minimal 模式无 FK 边 · 骨架边只画到 row 1（teams · players · tournaments · matches）；row 3 与 honors 的 FK 见下方关系表

## 四个概念组

按业务域聚类的全部 27 个对象类
赛会与赛程
worldcup_competition
8 OTs
赛事、阶段、场次、球场、东道主与小组结构 — 回答「哪一届、哪一场、在哪踢」。

- tournaments
- tournament_stages
- matches
- stadiums
- host_countries
- groups
- group_standings
- tournament_standings

球队与人员
worldcup_participants
13 OTs
国家队、球员、教练、裁判及其任命 / 出场 / 执法记录 — 回答「谁、代表谁、何时上场」。

- teams
- players
- managers
- referees
- confederations
- squads
- qualified_teams
- manager_appointments
- referee_appointments
- team_appearances
- player_appearances
- manager_appearances
- referee_appearances

场上事件
worldcup_events
4 OTs
进球、点球、换人、得牌等可回放事件 — 回答「谁进球、何时换人」。

- goals
- penalty_kicks
- substitutions
- bookings

奖项与荣誉
worldcup_honors
2 OTs
奖项定义与获奖记录 — 回答「金靴 / 金球得主是谁」。

- awards
- award_winners

## 关系类全集（29 条）

命名约定：`rel_<来源表>_<外键列>`

关系 | From | To | 语义
--- | --- | --- | ---
`rel_matches_tournament` | matches | tournaments | 场次所属届次
`rel_matches_home_team` | matches | teams | 主队
`rel_matches_away_team` | matches | teams | 客队
`rel_matches_stadium` | matches | stadiums | 比赛球场
`rel_groups_tournament` | groups | tournaments | 小组归属
`rel_group_standings_team` | group_standings | teams | 积分对应球队
`rel_group_standings_tournament` | group_standings | tournaments | 积分对应届次
`rel_teams_confederation` | teams | confederations | 球队所属足联
`rel_qualified_teams_team` | qualified_teams | teams | 出线球队
`rel_qualified_teams_tournament` | qualified_teams | tournaments | 出线对应届次
`rel_squads_player` | squads | players | 阵容成员
`rel_squads_team` | squads | teams | 阵容归属球队
`rel_squads_tournament` | squads | tournaments | 阵容报名届次
`rel_team_appearances_team` | team_appearances | teams | 球队
`rel_team_appearances_opponent` | team_appearances | teams | 对手
`rel_team_appearances_match` | team_appearances | matches | 对应场次
`rel_player_appearances_player` | player_appearances | players | 出场球员
`rel_player_appearances_team` | player_appearances | teams | 所属球队
`rel_player_appearances_match` | player_appearances | matches | 对应场次
`rel_goals_player` | goals | players | 射手
`rel_goals_team` | goals | teams | 进球方球队
`rel_goals_match` | goals | matches | 所属场次
`rel_bookings_player` | bookings | players | 领牌球员
`rel_bookings_team` | bookings | teams | 球队
`rel_bookings_match` | bookings | matches | 所属场次
`rel_award_winners_award` | award_winners | awards | 奖项
`rel_award_winners_tournament` | award_winners | tournaments | 颁奖届次
`rel_award_winners_player` | award_winners | players | 获奖球员
`rel_award_winners_team` | award_winners | teams | 获奖球队