Constraints

91 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
matchmaker_queue_ibfk_2
matchmaker_queue.leaderboard_id
leaderboard.id
Restrict delete
matchmaker_queue_ibfk_1
matchmaker_queue.featured_mod_id
game_featuredMods.id
Restrict delete
coop_map_coop_scenario_id_fk
coop_map.scenario_id
coop_scenario.id
Restrict delete
login_terms_of_service_version_fk
login.accepted_tos
terms_of_service.version
Restrict delete
FK_unique_id_users_user_id_to_login
unique_id_users.user_id
login.id
Restrict delete
FK_user_hash_to_uid
unique_id_users.uniqueid_hash
uniqueid.hash
Restrict delete
featured_mods_owners_ibfk_1
featured_mods_owners.moduid
game_featuredMods.id
Cascade on delete
featured_mods_owners_ibfk_2
featured_mods_owners.uid
login.id
Cascade on delete
reporter_id_of_moderation_report
moderation_report.reporter_id
login.id
Restrict delete
moderation_report_ibfk_1
moderation_report.last_moderator
login.id
Restrict delete
game_id_of_moderation_report
moderation_report.game_id
game_stats.id
Restrict delete
table_map_comments_ibfk_2
table_map_comments.user_id
login.id
Cascade on delete
table_map_comments_ibfk_1
table_map_comments.map_id
map_version.id
Cascade on delete
victim_fk
teamkills.victim
login.id
Restrict delete
teamkiller_fk
teamkills.teamkiller
login.id
Restrict delete
teamkills_game_stats_id_fk
teamkills.game_id
game_stats.id
Restrict delete
vote_of_voting_answer
voting_answer.vote_id
vote.id
Restrict delete
voting_choice_of_voting_answer
voting_answer.voting_choice_id
voting_choice.id
Restrict delete
map_license_id_fk
map.license
license.id
Restrict delete
author
map.author
login.id
Cascade on delete
voting_question_of_voting_choice
voting_choice.voting_question_id
voting_question.id
Restrict delete
clan_ibfk_1
clan.founder_id
login.id
Restrict delete
clan_ibfk_2
clan.leader_id
login.id
Restrict delete
mod_reviews_summary_ibfk_1
mod_reviews_summary.mod_id
mod.id
Restrict delete
user_ibfk_1
service_links.user_id
login.id
Restrict delete
fk_game_player_stats_player
game_player_stats.playerId
login.id
Restrict delete
game_id_fk
game_player_stats.gameId
game_stats.id
Restrict delete
leaderboard_rating_journal_ibfk_2
leaderboard_rating_journal.leaderboard_id
leaderboard.id
Restrict delete
leaderboard_rating_journal_ibfk_1
leaderboard_rating_journal.game_player_stats_id
game_player_stats.id
Restrict delete
tutorial_map_version
tutorial.map_version_id
map_version.id
Restrict delete
tutorial_category
tutorial.category
tutorial_category.id
Restrict delete
group_permission_assignment_ibfk_1
group_permission_assignment.group_id
user_group.id
Restrict delete
group_permission_assignment_ibfk_2
group_permission_assignment.permission_id
group_permission.id
Restrict delete
tutorials_ibfk_1
tutorials.section
tutorial_sections.id
Restrict delete
name_history_ibfk_1
name_history.user_id
login.id
Cascade on delete
map
map_version.map_id
map.id
Cascade on delete
map_reviews_summary_ibfk_1
map_reviews_summary.map_id
map.id
Restrict delete
voting_subject_of_voting_question
voting_question.voting_subject_id
voting_subject.id
Restrict delete
login_log_login_id_fk
login_log.login_id
login.id
Cascade on delete
user_notes_user_login_id_fk
user_notes.user_id
login.id
Restrict delete
user_notes_author_login_id_fk
user_notes.author
login.id
Restrict delete
mod_version_ibfk_1
mod_version.mod_id
mod.id
Cascade on delete
mapid_fkey
game_stats.mapId
map_version.id
Restrict delete
game_stats_game_featuredMods_id_fk
game_stats.gameMod
game_featuredMods.id
Restrict delete
game_stats_game_validity_id_fk
game_stats.validity
game_validity.id
Restrict delete
fk_game_stats_host
game_stats.host
login.id
Restrict delete
map_version_reviews_summary_map_version
map_version_reviews_summary.map_version_id
map_version.id
Restrict delete
voting_choice_of_winner
winner_for_voting_question.voting_choice_id
voting_choice.id
Restrict delete
voting_question_of_winner
winner_for_voting_question.voting_question_id
voting_question.id
Restrict delete
user_group_assignment_ibfk_1
user_group_assignment.user_id
login.id
Restrict delete
user_group_assignment_ibfk_2
user_group_assignment.group_id
user_group.id
Restrict delete
fk_achievement
player_achievements.achievement_id
achievement_definitions.id
Restrict delete
fk_login
player_achievements.player_id
login.id
Cascade on delete
leaderboard_rating_ibfk_1
leaderboard_rating.login_id
login.id
Restrict delete
leaderboard_rating_ibfk_2
leaderboard_rating.leaderboard_id
leaderboard.id
Restrict delete
coop_leaderboard_ibfk_1
coop_leaderboard.gameuid
game_stats.id
Restrict delete
map_version_review_ibfk_1
map_version_review.user_id
login.id
Restrict delete
map_version_review_ibfk_2
map_version_review.map_version_id
map_version.id
Restrict delete
voting_subject_of_vote
vote.voting_subject_id
voting_subject.id
Restrict delete
player_of_vote
vote.player_id
login.id
Restrict delete
user_group_ibfk_1
user_group.parent_group_id
user_group.id
Restrict delete
friends_and_foes_subject_login_id_fk
friends_and_foes.subject_id
login.id
Restrict delete
friends_and_foes_user_login_id_fk
friends_and_foes.user_id
login.id
Restrict delete
clan_membership_ibfk_1
clan_membership.clan_id
clan.id
Restrict delete
clan_membership_ibfk_2
clan_membership.player_id
login.id
Restrict delete
player_events_login_id_fk
player_events.player_id
login.id
Restrict delete
game_reviews_summary_game
game_reviews_summary.game_id
game_stats.id
Restrict delete
mod_ibfk_1
mod.uploader
login.id
Cascade on delete
mod_license_id_fk
mod.license
license.id
Restrict delete
FK_uniqueid_exempt_user_id_to_login
uniqueid_exempt.user_id
login.id
Restrict delete
mod_version_review_ibfk_2
mod_version_review.mod_version_id
mod_version.id
Restrict delete
mod_version_review_ibfk_1
mod_version_review.user_id
login.id
Restrict delete
avatars_ibfk_1
avatars.idUser
login.id
Restrict delete
avatars_ibfk_2
avatars.idAvatar
avatars_list.id
Restrict delete
mod_stats_ibfk_1
mod_stats.mod_id
mod.id
Cascade on delete
game_review_ibfk_1
game_review.user_id
login.id
Restrict delete
game_review_ibfk_2
game_review.game_id
game_stats.id
Restrict delete
matchmaker_queue_game_ibfk_1
matchmaker_queue_game.matchmaker_queue_id
matchmaker_queue.id
Restrict delete
matchmaker_queue_game_ibfk_2
matchmaker_queue_game.game_stats_id
game_stats.id
Restrict delete
ban_revoke_author
ban.author_id
login.id
Restrict delete
ban_ibfk_3
ban.report_id
moderation_report.id
Restrict delete
ban_ibfk_2
ban.author_id
login.id
Restrict delete
ban_ibfk_1
ban.player_id
login.id
Restrict delete
map_pool_map_version_ibfk_2
map_pool_map_version.map_version_id
map_version.id
Restrict delete
map_pool_map_version_ibfk_1
map_pool_map_version.map_version_id
map_version.id
Restrict delete
player_id_of_reported_user
reported_user.player_id
login.id
Restrict delete
report_id_of_reported_user
reported_user.report_id
moderation_report.id
Restrict delete
mod_version_reviews_summary_mod_version
mod_version_reviews_summary.mod_version_id
mod_version.id
Restrict delete
matchmaker_queue_map_pool_map_pool_id_fk
matchmaker_queue_map_pool.map_pool_id
map_pool.id
Restrict delete
matchmaker_queue_map_pool_matchmaker_queue_id_fk
matchmaker_queue_map_pool.matchmaker_queue_id
matchmaker_queue.id
Restrict delete
leaderboard_ibfk_1
leaderboard.initializer_id
leaderboard.id
Restrict delete

Check Constraints

Table Constraint Name Constraint