SchemaSpy Analysis of xonstatdb.xonstat - Constraints Generated by
SchemaSpy
26 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
achievements_fk001 achievements.achievement_cd cd_achievement.achievement_cd Restrict delete 
achievements_fk002 achievements.player_id players.player_id Restrict delete 
game_mutators_fk001 game_mutators.game_id games.game_id Restrict delete 
game_mutators_fk002 game_mutators.mutator_cd cd_mutator.mutator_cd Restrict delete 
games_fk001 games.game_type_cd cd_game_type.game_type_cd Restrict delete 
games_fk002 games.server_id servers.server_id Restrict delete 
games_fk003 games.map_id maps.map_id Restrict delete 
hashkeys_fk001 hashkeys.player_id players.player_id Restrict delete 
map_game_types_fk001 map_game_types.map_id maps.map_id Restrict delete 
map_game_types_fk002 map_game_types.game_type_cd cd_game_type.game_type_cd Restrict delete 
player_elos_fk01 player_elos.player_id players.player_id Restrict delete 
player_elos_fk02 player_elos.game_type_cd cd_game_type.game_type_cd Restrict delete 
player_game_anticheats_fk01 player_game_anticheats.player_id players.player_id Restrict delete 
player_game_stats_fk001 player_game_stats.player_id players.player_id Restrict delete 
player_game_stats_fk002 player_game_stats.game_id games.game_id Restrict delete 
player_groups_fk001 player_groups.player_id players.player_id Restrict delete 
player_map_captimes_fk01 player_map_captimes.player_id players.player_id Restrict delete 
player_map_captimes_fk02 player_map_captimes.map_id maps.map_id Restrict delete 
player_nicks_fk01 player_nicks.player_id players.player_id Restrict delete 
player_ranks_fk01 player_ranks.player_id players.player_id Restrict delete 
player_ranks_fk02 player_ranks.game_type_cd cd_game_type.game_type_cd Restrict delete 
player_weapon_stats_fk001 player_weapon_stats.player_id players.player_id Restrict delete 
player_weapon_stats_fk002 player_weapon_stats.game_id games.game_id Restrict delete 
player_weapon_stats_fk003 player_weapon_stats.weapon_cd cd_weapon.weapon_cd Restrict delete 
player_weapon_stats_fk004 player_weapon_stats.player_game_stat_id player_game_stats.player_game_stat_id Restrict delete 
team_game_stats_fk001 team_game_stats.game_id games.game_id Cascade on delete 

Check Constraints:

Table Constraint Name Constraint
None detected