Constraints

9 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
game_participants.killed_by_leader_id
game_participants.leader_id
game_participants.died_on_turn
leaders.leader_id
leaders.leader_id
turn_years.turn
Restrict delete
game_participants_game_fk
game_participants.season_id
game_participants.game_season_id
game.season_id
game.game_season_id
Restrict delete
leader_pools.leader_id
leader_pools.season_id
leaders.leader_id
seasons.season_id
Restrict delete
leader_traits.leader_id
leader_traits.trait_id
leaders.leader_id
traits.trait_id
Restrict delete
game_wars.target_leader_id
game_wars.declared_by_leader_id
game_wars.ending_turn
game_wars.declaring_turn
leaders.leader_id
leaders.leader_id
turn_years.turn
turn_years.turn
Restrict delete
game_wars_game_fk
game_wars.season_id
game_wars.game_season_id
game.season_id
game.game_season_id
Restrict delete
starting_technologies.civilization_id
starting_technologies.technology_id
civilizations.civilization_id
technologies.technology_id
Restrict delete
game.game_type_id
game.victory_type
game.died_first_leader_id
game.second_leader_id
game.winner_leader_id
game.season_id
game.victory_turn
game_type.game_type_id
game_victory_type.game_victory_type_id
leaders.leader_id
leaders.leader_id
leaders.leader_id
seasons.season_id
turn_years.turn
Restrict delete
civilization_leaders.civilization_id
civilization_leaders.leader_id
civilizations.civilization_id
leaders.leader_id
Restrict delete

Check Constraints

Table Constraint Name Constraint