Knowledge Network · BKN Structure

Fjelstul 世界杯 · BKN 知识网络

worldcup_vega_catalog_bkn — 基于 Joshua C. Fjelstul 世界杯开放数据库的领域模型

ObjectTypes 对象类

RelationTypes 关系类

ConceptGroups 概念组

核心关系图

以 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	获奖球队

骨架模式（minimal · 默认） · 不含 substitutions.* RelationType 与 goals.player_team_id；换人分析需经 substitutions 表本体属性串联 matches / player_appearances。数据来自 Joshua C. Fjelstul, The Fjelstul World Cup Database，许可 CC-BY-SA 4.0。