Constraints

57 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_results_propagate_to_results
results_propagate.participant_id
results_propagate.attempt_id
results_propagate.item_id
results.participant_id
results.attempt_id
results.item_id
Cascade on delete
fk_groups_root_skill_id_items_id
groups.root_skill_id
items.id
Null on delete
fk_groups_root_activity_id_items_id
groups.root_activity_id
items.id
Null on delete
fk_threads_participant_id_groups_id
threads.participant_id
groups.id
Cascade on delete
fk_threads_helper_group_id_groups_id
threads.helper_group_id
groups.id
Restrict delete
fk_threads_item_id_items_id
threads.item_id
items.id
Cascade on delete
fk_groups_groups_child_group_id_groups_id
groups_groups.child_group_id
groups.id
Cascade on delete
fk_groups_groups_parent_group_id_groups_id
groups_groups.parent_group_id
groups.id
Cascade on delete
fk_filters_user_id_users_group_id
filters.user_id
users.group_id
Cascade on delete
fk_items_strings_item_id_items_id
items_strings.item_id
items.id
Cascade on delete
fk_items_strings_language_tag_languages_tag
items_strings.language_tag
languages.tag
Restrict delete
fk_access_tokens_sessions_session_id
access_tokens.session_id
sessions.session_id
Cascade on delete
fk_items_id_default_language_tag_items_strings_item_language_tag
items.id
items.default_language_tag
items_strings.item_id
items_strings.language_tag
Restrict delete
fk_items_platform_id_platforms_id
items.platform_id
platforms.id
Restrict delete
fk_group_pending_requests_group_id_groups_id
group_pending_requests.group_id
groups.id
Cascade on delete
fk_group_pending_requests_member_id_groups_id
group_pending_requests.member_id
groups.id
Cascade on delete
fk_group_managers_group_id_groups_id
group_managers.group_id
groups.id
Cascade on delete
fk_group_managers_manager_id_groups_id
group_managers.manager_id
groups.id
Cascade on delete
fk_permissions_propagate_item_id_items_id
permissions_propagate.item_id
items.id
Cascade on delete
fk_permissions_propagate_group_id_groups_id
permissions_propagate.group_id
groups.id
Cascade on delete
fk_answers_author_id_users_group_id
answers.author_id
users.group_id
Cascade on delete
fk_answers_participant_id_attempt_id_item_id_results
answers.participant_id
answers.attempt_id
answers.item_id
results.participant_id
results.attempt_id
results.item_id
Cascade on delete
fk_results_item_id_items_id
results.item_id
items.id
Cascade on delete
fk_results_participant_id_attempt_id_attempts_participant_id_id
results.participant_id
results.attempt_id
attempts.participant_id
attempts.id
Cascade on delete
fk_submissions_answer_id_answers_id
gradings.answer_id
answers.id
Cascade on delete
fk_badges_user_id_users_group_id
badges.user_id
users.group_id
Cascade on delete
fk_results_propagate_items_to_items
results_recompute_for_items.item_id
items.id
Cascade on delete
fk_permissions_granted_source_group_id_groups_id
permissions_granted.source_group_id
groups.id
Cascade on delete
fk_permissions_granted_item_id_items_id
permissions_granted.item_id
items.id
Cascade on delete
fk_can_request_help_to_groups_id
permissions_granted.can_request_help_to
groups.id
Null on delete
fk_permissions_granted_group_id_groups_id
permissions_granted.group_id
groups.id
Cascade on delete
fk_items_items_child_item_id_items_id
items_items.child_item_id
items.id
Cascade on delete
fk_items_items_parent_item_id_items_id
items_items.parent_item_id
items.id
Restrict delete
fk_id
items_propagate.id
items.id
Cascade on delete
fk_group_item_additional_times_item_id_items_id
group_item_additional_times.item_id
items.id
Cascade on delete
fk_group_item_additional_times_group_id_groups_id
group_item_additional_times.group_id
groups.id
Cascade on delete
fk_permissions_generated_item_id_items_id
permissions_generated.item_id
items.id
Cascade on delete
fk_permissions_generated_group_id_groups_id
permissions_generated.group_id
groups.id
Cascade on delete
fk_items_ancestors_ancestor_item_id_items_id
items_ancestors.ancestor_item_id
items.id
Restrict delete
fk_items_ancestors_child_item_id_items_id
items_ancestors.child_item_id
items.id
Cascade on delete
fk_user_batch_prefixes_group_id_groups_id
user_batch_prefixes.group_id
groups.id
Null on delete
fk_group_membership_changes_initiator_id_users_group_id
group_membership_changes.initiator_id
users.group_id
Null on delete
fk_group_membership_changes_group_id_groups_id
group_membership_changes.group_id
groups.id
Cascade on delete
fk_group_membership_changes_member_id_groups_id
group_membership_changes.member_id
groups.id
Cascade on delete
fk_sessions_users_user_id_group_id
sessions.user_id
users.group_id
Cascade on delete
fk_attempts_root_item_id_items_id
attempts.root_item_id
items.id
Null on delete
fk_attempts_participant_id_groups_id
attempts.participant_id
groups.id
Cascade on delete
fk_attempts_creator_id_users_group_id
attempts.creator_id
users.group_id
Null on delete
fk_groups_ancestors_ancestor_group_id_groups_id
groups_ancestors.ancestor_group_id
groups.id
Cascade on delete
fk_groups_ancestors_child_group_id_groups_id
groups_ancestors.child_group_id
groups.id
Cascade on delete
fk_user_batches_v2_group_prefix_user_batch_prefixes_group_pref
user_batches_v2.group_prefix
user_batch_prefixes.group_prefix
Restrict delete
fk_user_batches_v2_creator_id_users_group_id
user_batches_v2.creator_id
users.group_id
Null on delete
fk_users_creator_id_users_group_id
users.creator_id
users.group_id
Null on delete
fk_users_group_id_groups_id
users.group_id
groups.id
Cascade on delete
fk_item_dependencies_item_id_items_id
item_dependencies.item_id
items.id
Cascade on delete
fk_item_dependencies_dependent_item_id_items_id
item_dependencies.dependent_item_id
items.id
Cascade on delete
fk_groups_propagate_id_groups_id
groups_propagate.id
groups.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected