- Constraints
214 Foreign Key Constraints:

Constraint Name Child Column Parent Column Delete Rule
fk1253a8933b9a12bc bookmark_keywords.bookmark_id bookmark.id Restrict delete 
fk12786185c5b5c794 portlet_recent_contrib_collect.portlet_recent_contrib_id portlet_recent_contrib.id Restrict delete 
fk12786185e81286d9 portlet_recent_contrib_collect.collections_id item_definition.id Restrict delete 
fk12ba86a51152333c hierarchy_topic.parent_id hierarchy_topic.id Restrict delete 
fk12ba86a5282920d0 hierarchy_topic.advanced_search_id power_search.id Restrict delete 
fk12ba86a54ac8a50d hierarchy_topic.long_description_id language_bundle.id Restrict delete 
fk12ba86a54f36f5c6 hierarchy_topic.subtopics_section_name_id language_bundle.id Restrict delete 
fk12ba86a5b14de658 hierarchy_topic.results_section_name_id language_bundle.id Restrict delete 
fk12ba86a5bc711081 hierarchy_topic.institution_id institution.id Restrict delete 
fk12ba86a5d4838ffb hierarchy_topic.name_id language_bundle.id Restrict delete 
fk12ba86a5d8e2270d hierarchy_topic.short_description_id language_bundle.id Restrict delete 
fk1563c1b29965196c tlegroup.parent_id tlegroup.id Restrict delete 
fk1563c1b2bc711081 tlegroup.institution_id institution.id Restrict delete 
fk193e9a73aa97c6e1 oauth_client.id base_entity.id Restrict delete 
fk1a879e51bc711081 oauth_token.institution_id institution.id Restrict delete 
fk1a879e51f5ba4eba oauth_token.client_id oauth_client.id Restrict delete 
fk1b3a4635aa97c6e1 dyna_collection.id base_entity.id Restrict delete 
fk1e51e5be6f7f1a9c item_referenced_urls.item_id item.id Restrict delete 
fk1e51e5bed6221acd item_referenced_urls.referenced_urls_id referencedurl.id Restrict delete 
fk1f3e7981edfda12 qti_item_variable_value.qti_item_variable_id qti_item_variable.id Restrict delete 
fk1f54941e1dc2c1f3 power_search_itemdefs.power_search_id power_search.id Restrict delete 
fk1f54941eae8bca4d power_search_itemdefs.itemdefs_id item_definition.id Restrict delete 
fk20214f31e27af61 hierarchy_topic_attributes.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fk21bd7bfaa97c6e1 workflow.id base_entity.id Restrict delete 
fk237a88ebbc711081 notification.institution_id institution.id Restrict delete 
fk26541c764d844e25 cal_portion.holding_id cal_holding.id Restrict delete 
fk26541c766f7f1a9c cal_portion.item_id item.id Restrict delete 
fk2c83e4a3c5665a18 order_history.order_id order.id Restrict delete 
fk2d110d6430fc83c0 order_item.order_store_part_id order_store_part.id Restrict delete 
fk2dc27197c9e397e9 workflow_node_status_accepted.workflow_node_status_id workflow_node_status.id Restrict delete 
fk317b13172b24e item.moderation_id moderation_status.id Restrict delete 
fk317b135e8657f1 item.item_xml_id item_xml.id Restrict delete 
fk317b13888c44ea item.description_id language_bundle.id Restrict delete 
fk317b13bc711081 item.institution_id institution.id Restrict delete 
fk317b13d0a6662f item.item_definition_id item_definition.id Restrict delete 
fk317b13d4838ffb item.name_id language_bundle.id Restrict delete 
fk317b13eddc9ef7 item.drm_settings_id drm_settings.id Restrict delete 
fk35c047b1d1b0a8 sale.storefront_id store_front.id Restrict delete 
fk35c047bc711081 sale.institution_id institution.id Restrict delete 
fk36446c4849bf4b term.parent_id term.id Restrict delete 
fk36446c97aac22 term.taxonomy_id taxonomy.id Restrict delete 
fk3a7f3ffc7ab3c14a hierarchy_topic_inh_schemas.entity_id tleschemas.id Restrict delete 
fk3a7f3ffce27af61 hierarchy_topic_inh_schemas.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fk3fa356bbaa97c6e1 pricing_tier.id base_entity.id Restrict delete 
fk40704c53bc711081 audit_log_entry.institution_id institution.id Restrict delete 
fk4182d8b823714712 oauth_client_permissions.oauth_client_id oauth_client.id Restrict delete 
fk418d9e9544010798 cla_holding_ids.cla_holding_id cla_holding.id Restrict delete 
fk42a7253b41c96364 tlegroup_users.tlegroup_id tlegroup.id Restrict delete 
fk440e8e826d1a7dc3 workflow_node.parent_id workflow_node.id Restrict delete 
fk440e8e82888c44ea workflow_node.description_id language_bundle.id Restrict delete 
fk440e8e82cbffa4b4 workflow_node.workflow_id workflow.id Restrict delete 
fk440e8e82d4838ffb workflow_node.name_id language_bundle.id Restrict delete 
fk44e89c40aa97c6e1 harvester_profile.id base_entity.id Restrict delete 
fk46014edbc711081 hierarchy_topic_dynamic_key_re.institution_id institution.id Restrict delete 
fk468b33c020c75211 cla_portion.holding_id cla_holding.id Restrict delete 
fk468b33c06f7f1a9c cla_portion.item_id item.id Restrict delete 
fk474eb8746cc83be5 lti_consumer_unknown_groups.lti_consumer_id lti_consumer.id Restrict delete 
fk4969939a4643267c portlet_recent_contrib.portlet_id portlet.id Restrict delete 
fk4a063c4fe946f1b4 qti_item_variable.result_id qti_abstract_result.id Restrict delete 
fk4c6190077e7398bd entity_lock.entity_id base_entity.id Restrict delete 
fk4c619007bc711081 entity_lock.institution_id institution.id Restrict delete 
fk4daeb90baa97c6e1 payment_gateway.id base_entity.id Restrict delete 
fk56c7cc69aa97c6e1 catalogue.id base_entity.id Restrict delete 
fk56c7cc69d6cc32d4 catalogue.dynamic_collection_id dyna_collection.id Restrict delete 
fk590bcb436f7f1a9c activate_request.item_id item.id Restrict delete 
fk590bcb43a37d7db2 activate_request.course_info_id course_info.id Restrict delete 
fk5a1b2b596cc83be5 lti_consumer_custom_role.lti_consumer_id lti_consumer.id Restrict delete 
fk5a4911d13b841bdb hierarchy_topic_all_parents.all_parents_id hierarchy_topic.id Restrict delete 
fk5a4911d1e27af61 hierarchy_topic_all_parents.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fk5b4901016f7f1a9c item_collaborators.item_id item.id Restrict delete 
fk5e8df130a9577dcb dyna_collection_item_defs.entity_id item_definition.id Restrict delete 
fk5e8df130da2687dd dyna_collection_item_defs.dyna_collection_id dyna_collection.id Restrict delete 
fk5ee11c81a9577dcb hierarchy_topic_inh_idefs.entity_id item_definition.id Restrict delete 
fk5ee11c81e27af61 hierarchy_topic_inh_idefs.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fk6022dccb4306333b payment_gateway_regions.payment_gateway_id payment_gateway.id Restrict delete 
fk6022dccbf9e5fb5d payment_gateway_regions.regions_id region.id Restrict delete 
fk608e6bda6f7f1a9c task_history.item_id item.id Restrict delete 
fk608e6bda96112c19 task_history.task_id workflow_node.id Restrict delete 
fk651874ebc711081 order.institution_id institution.id Restrict delete 
fk65fb1494fe11b4c price.catalogue_id catalogue.id Restrict delete 
fk65fb14974eb2c48 price.region_id region.id Restrict delete 
fk65fb1498353f912 price.tier_id pricing_tier.id Restrict delete 
fk65fb149ea92b3a5 price.period_id subscription_period.id Restrict delete 
fk671d5414bc711081 cached_value.institution_id institution.id Restrict delete 
fk67e90501bc711081 purchase.institution_id institution.id Restrict delete 
fk67e90501e2678d38 purchase.store_id store.id Restrict delete 
fk68af8e1aa97c6e1 store.id base_entity.id Restrict delete 
fk7340e3a36cc83be5 lti_consumer_other_roles.lti_consumer_id lti_consumer.id Restrict delete 
fk76d892d11deee77 pricing_tier_assignment.subscription_pricing_tier_id pricing_tier.id Restrict delete 
fk76d892d14005525b pricing_tier_assignment.purchase_pricing_tier_id pricing_tier.id Restrict delete 
fk76d892d16f7f1a9c pricing_tier_assignment.item_id item.id Restrict delete 
fk7787a5366f7f1a9c bookmark.item_id item.id Restrict delete 
fk7787a536bc711081 bookmark.institution_id institution.id Restrict delete 
fk7a02bd11888c44ea base_entity.description_id language_bundle.id Restrict delete 
fk7a02bd11bc711081 base_entity.institution_id institution.id Restrict delete 
fk7a02bd11d4838ffb base_entity.name_id language_bundle.id Restrict delete 
fk7cfe56e66cc83be5 lti_consumer_instructor_roles.lti_consumer_id lti_consumer.id Restrict delete 
fk7ec66f526f7f1a9c cal_holding.item_id item.id Restrict delete 
fk805cf6d76f7f1a9c item_lock.item_id item.id Restrict delete 
fk805cf6d7bc711081 item_lock.institution_id institution.id Restrict delete 
fk8149b26295d2b2e8 store_harvest_info.sale_id sale.id Restrict delete 
fk81b843bdbc711081 purchased_content.institution_id institution.id Restrict delete 
fk81b843bde2678d38 purchased_content.store_id store.id Restrict delete 
fk854811596f7f1a9c pss_callback_log.item_id item.id Restrict delete 
fk85481159bc711081 pss_callback_log.institution_id institution.id Restrict delete 
fk8999ea834b964518 cla_portion_topics.cla_portion_id cla_portion.id Restrict delete 
fk8aeb84bc6f7f1a9c item_notifications.item_id item.id Restrict delete 
fk8af759236f7f1a9c attachment.item_id item.id Restrict delete 
fk8b9a85d7817719f3 access_entry.expression_id access_expression.id Restrict delete 
fk8b9a85d7bc711081 access_entry.institution_id institution.id Restrict delete 
fk925447ef1fa00fb0 mime_entry_attributes.mime_entry_id mime_entry.id Restrict delete 
fk93ad1d452f4908cf base_entity_attributes.base_entity_id base_entity.id Restrict delete 
fk94de4f876b3d7505 workflow_message.node_id workflow_node_status.id Restrict delete 
fk94eb98a7bc711081 mime_entry.institution_id institution.id Restrict delete 
fk956be0716f7f1a9c share_pass.item_id item.id Restrict delete 
fk956be071bc711081 share_pass.institution_id institution.id Restrict delete 
fk96095c08aa97c6e1 custom_link.id base_entity.id Restrict delete 
fk97b58ab055bb2652 qti_item_result.id qti_abstract_result.id Restrict delete 
fk97b58ab0a934b117 qti_item_result.assessment_result_id qti_assessment_result.id Restrict delete 
fk97b58ab0d4a8d8f9 qti_item_result.item_ref_id qti_assessment_item_ref.id Restrict delete 
fk983a75ff25b0392b item_definition.slow_id itemdef_blobs.id Restrict delete 
fk983a75ff9db92ecc item_definition.schema_id tleschemas.id Restrict delete 
fk983a75ffaa97c6e1 item_definition.id base_entity.id Restrict delete 
fk983a75ffcbffa4b4 item_definition.workflow_id workflow.id Restrict delete 
fk98d3e6d7bc711081 qti_assessment_item.institution_id institution.id Restrict delete 
fk98d8b0566f7f1a9c qti_assessment_test.item_id item.id Restrict delete 
fk98d8b056bc711081 qti_assessment_test.institution_id institution.id Restrict delete 
fk9efd869c6f7f1a9c cla_holding.item_id item.id Restrict delete 
fk9fd29358bc711081 language.institution_id institution.id Restrict delete 
fka1a86c479db92ecc schema_exp_transforms.schema_id tleschemas.id Restrict delete 
fka57d4216f7f1a9c item_navigation_node.item_id item.id Restrict delete 
fka57d421f11e6b39 item_navigation_node.parent_id item_navigation_node.id Restrict delete 
fka591802b8e3f7fd1 hierarchy_topic_key_resources.element item.id Restrict delete 
fka591802be27af61 hierarchy_topic_key_resources.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fka6ba4d4baa97c6e1 store_front.id base_entity.id Restrict delete 
fka6ba4d4be438b3e3 store_front.tax_type_id tax_type.id Restrict delete 
fka6ba4d4bf5ba4eba store_front.client_id oauth_client.id Restrict delete 
fka7b59a229db92ecc power_search.schema_id tleschemas.id Restrict delete 
fka7b59a22aa97c6e1 power_search.id base_entity.id Restrict delete 
fka89466e87ab3c14a dyna_collection_schemas.entity_id tleschemas.id Restrict delete 
fka89466e8da2687dd dyna_collection_schemas.dyna_collection_id dyna_collection.id Restrict delete 
fka9f4ff0a7808d449 term_attributes.term_id term.id Restrict delete 
fkac424965aa97c6e1 tleschemas.id base_entity.id Restrict delete 
fkac738b2b33716f61 qti_assessment_item_ref.question_id qti_assessment_item.id Restrict delete 
fkac738b2ba53360b4 qti_assessment_item_ref.test_id qti_assessment_test.id Restrict delete 
fkac8764634fe11b4c catalogue_assignment.catalogue_id catalogue.id Restrict delete 
fkac8764636f7f1a9c catalogue_assignment.item_id item.id Restrict delete 
fkadc0d996a772c91a item_navigation_tab.attachment_id attachment.id Restrict delete 
fkadc0d996f3bfa6e1 item_navigation_tab.node_id item_navigation_node.id Restrict delete 
fkae9cf4f529816258 access_expression_expression_p.access_expression_id access_expression.id Restrict delete 
fkaf1c5231cbacd5fc workflow_node_groups.workflow_node_id workflow_node.id Restrict delete 
fkaf6118f76f7f1a9c drm_acceptance.item_id item.id Restrict delete 
fkaf6dfc43aa97c6e1 federated_search.id base_entity.id Restrict delete 
fkb113279170ddb63c purchase_item.purchase_id purchase.id Restrict delete 
fkb322f77455198ba5 cal_section.portion_id cal_portion.id Restrict delete 
fkb345a22c5665a18 order_store_part.order_id order.id Restrict delete 
fkb345a22e2678d38 order_store_part.store_id store.id Restrict delete 
fkb6646e38bc711081 tleuser.institution_id institution.id Restrict delete 
fkb76982ba7ab3c14a hierarchy_topic_add_schemas.entity_id tleschemas.id Restrict delete 
fkb76982bae27af61 hierarchy_topic_add_schemas.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fkbbed16c0cbacd5fc workflow_node_roles.workflow_node_id workflow_node.id Restrict delete 
fkbc19160bcbacd5fc workflow_node_users.workflow_node_id workflow_node.id Restrict delete 
fkbe5ed6d815b002a4 language_string.bundle_id language_bundle.id Restrict delete 
fkc20452e155bb2652 qti_assessment_result.id qti_abstract_result.id Restrict delete 
fkc20452e1a53360b4 qti_assessment_result.test_id qti_assessment_test.id Restrict delete 
fkc391e90d8d5414b6 cal_portion_topics.cal_portion_id cal_portion.id Restrict delete 
fkc3ac484fb7ba8b05 workflow_node_status.mod_status_id moderation_status.id Restrict delete 
fkc3ac484fb9679514 workflow_node_status.wnode_id workflow_node.id Restrict delete 
fkc3ac484ff2b1413e workflow_node_status.cause_id workflow_node_status.id Restrict delete 
fkc599b2294fe11b4c catalogue_regions.catalogue_id catalogue.id Restrict delete 
fkc599b229f9e5fb5d catalogue_regions.regions_id region.id Restrict delete 
fkc5e4d90da2687dd dyna_collection_usage_ids.dyna_collection_id dyna_collection.id Restrict delete 
fkc7022ac94b964518 cla_portion_authors.cla_portion_id cla_portion.id Restrict delete 
fkc84826f4aa97c6e1 region.id base_entity.id Restrict delete 
fkc84c5534aa97c6e1 report.id base_entity.id Restrict delete 
fkcc09fd7f8d5414b6 cal_portion_authors.cal_portion_id cal_portion.id Restrict delete 
fkcc3fde94aa97c6e1 lti_consumer.id base_entity.id Restrict delete 
fkcca73c4b85bed736 cal_holding_ids.cal_holding_id cal_holding.id Restrict delete 
fkd2200171cbacd5fc workflow_node_auto_assigns.workflow_node_id workflow_node.id Restrict delete 
fkd35a0ebe285c8f91 cla_section.portion_id cla_portion.id Restrict delete 
fkda58f6bfa9577dcb hierarchy_topic_add_idefs.entity_id item_definition.id Restrict delete 
fkda58f6bfe27af61 hierarchy_topic_add_idefs.hierarchy_topic_id hierarchy_topic.id Restrict delete 
fkdb761febc711081 favourite_search.institution_id institution.id Restrict delete 
fkdc17ddf46f7f1a9c comments.item_id item.id Restrict delete 
fkdd79f44daa97c6e1 connector.id base_entity.id Restrict delete 
fkdef3f9fc65f7e40d relation.first_item_id item.id Restrict delete 
fkdef3f9fcf78851d1 relation.second_item_id item.id Restrict delete 
fkdef7ad4e9db92ecc schema_citations.schema_id tleschemas.id Restrict delete 
fke2ab9b2974eb2c48 region_countries.region_id region.id Restrict delete 
fke3d1e1a544010798 cla_holding_authors.cla_holding_id cla_holding.id Restrict delete 
fke4d0aac1fa00fb0 mime_entry_extensions.mime_entry_id mime_entry.id Restrict delete 
fke56a43686f7f1a9c item_history.item_id item.id Restrict delete 
fke56a4368b83bb2ce item_history.history_id history_event.id Restrict delete 
fke882fe9daa97c6e1 echo_server.id base_entity.id Restrict delete 
fke8a0adfaaa97c6e1 portlet.id base_entity.id Restrict delete 
fke8d9b45b85bed736 cal_holding_authors.cal_holding_id cal_holding.id Restrict delete 
fke97e4b389db92ecc schema_imp_transforms.schema_id tleschemas.id Restrict delete 
fked77c4404643267c portlet_preference.portlet_id portlet.id Restrict delete 
fkef7b9b4eaa97c6e1 tax_type.id base_entity.id Restrict delete 
fkf05a3351aa97c6e1 taxonomy.id base_entity.id Restrict delete 
fkf1b9ce5caa97c6e1 kaltura_server.id base_entity.id Restrict delete 
fkf2590f23bc711081 subscription_period.institution_id institution.id Restrict delete 
fkf2590f23d4838ffb subscription_period.name_id language_bundle.id Restrict delete 
fkf33e3cbc711081 thumbnail_request.institution_id institution.id Restrict delete 
fkf406b33bc711081 audit_log_lms.institution_id institution.id Restrict delete 
fkf61f17bfaa97c6e1 user_script.id base_entity.id Restrict delete 
fkf699215e41c96364 tlegroup_all_parents.tlegroup_id tlegroup.id Restrict delete 
fkf699215ec397020b tlegroup_all_parents.all_parents_id tlegroup.id Restrict delete 
fkf9f6880b95d2b2e8 sale_item.sale_id sale.id Restrict delete 
fkf9f6880bea92b3a5 sale_item.period_id subscription_period.id Restrict delete 
fkfb081652aa97c6e1 course_info.id base_entity.id Restrict delete 
fkfbfeff9637910ee2 oauth_token_permissions.oauth_token_id oauth_token.id Restrict delete 
fkfe0ad8b1aa97c6e1 html_editor_plugin.id base_entity.id Restrict delete 
fkffc5658caa97c6e1 external_tool.id base_entity.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected