SchemaSpy Analysis of ezp54_community - ConstraintseZ Publish 5.4 Database Schema Diagram Generated by
SchemaSpy
159 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
ezapprove_items_ibfk_1 ezapprove_items.collaboration_id ezcollab_item.id Restrict delete 
ezapprove_items_ibfk_2 ezapprove_items.workflow_process_id ezworkflow_process.id Restrict delete 
ezbasket_ibfk_1 ezbasket.order_id ezorder.id Restrict delete 
ezbasket_ibfk_2 ezbasket.productcollection_id ezproductcollection.id Restrict delete 
ezbasket_ibfk_3 ezbasket.session_id ezsession.session_key Restrict delete 
ezbinaryfile_ibfk_1 ezbinaryfile.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezcobj_state_group_language_ibfk_1 ezcobj_state_group_language.contentobject_state_group_id ezcobj_state_group.id Restrict delete 
ezcobj_state_ibfk_1 ezcobj_state.group_id ezcobj_state_group.id Restrict delete 
ezcobj_state_language_ibfk_1 ezcobj_state_language.contentobject_state_id ezcobj_state.id Restrict delete 
ezcobj_state_link_ibfk_1 ezcobj_state_link.contentobject_id ezcontentobject.id Restrict delete 
ezcobj_state_link_ibfk_2 ezcobj_state_link.contentobject_state_id ezcobj_state.id Restrict delete 
ezcollab_group_ibfk_1 ezcollab_group.parent_group_id ezcollab_group.id Restrict delete 
ezcollab_group_ibfk_2 ezcollab_group.user_id ezuser.contentobject_id Restrict delete 
ezcollab_item_group_link_ibfk_1 ezcollab_item_group_link.collaboration_id ezcollab_item.id Restrict delete 
ezcollab_item_group_link_ibfk_2 ezcollab_item_group_link.group_id ezcollab_group.id Restrict delete 
ezcollab_item_group_link_ibfk_3 ezcollab_item_group_link.user_id ezuser.contentobject_id Restrict delete 
ezcollab_item_ibfk_1 ezcollab_item.creator_id ezuser.contentobject_id Restrict delete 
ezcollab_item_message_link_ibfk_1 ezcollab_item_message_link.collaboration_id ezcollab_item.id Restrict delete 
ezcollab_item_message_link_ibfk_2 ezcollab_item_message_link.message_id ezcollab_simple_message.id Restrict delete 
ezcollab_item_message_link_ibfk_3 ezcollab_item_message_link.participant_id ezuser.contentobject_id Restrict delete 
ezcollab_item_participant_link_ibfk_1 ezcollab_item_participant_link.collaboration_id ezcollab_item.id Restrict delete 
ezcollab_item_participant_link_ibfk_2 ezcollab_item_participant_link.participant_id ezcontentobject.id Restrict delete 
ezcollab_item_status_ibfk_1 ezcollab_item_status.collaboration_id ezcollab_item.id Restrict delete 
ezcollab_item_status_ibfk_2 ezcollab_item_status.user_id ezuser.contentobject_id Restrict delete 
ezcollab_profile_ibfk_1 ezcollab_profile.main_group ezcollab_group.id Restrict delete 
ezcollab_profile_ibfk_2 ezcollab_profile.user_id ezuser.contentobject_id Restrict delete 
ezcollab_simple_message_ibfk_1 ezcollab_simple_message.creator_id ezuser.contentobject_id Restrict delete 
ezcontentbrowsebookmark_ibfk_1 ezcontentbrowsebookmark.node_id ezcontentobject_tree.node_id Restrict delete 
ezcontentbrowsebookmark_ibfk_2 ezcontentbrowsebookmark.user_id ezuser.contentobject_id Restrict delete 
ezcontentbrowserecent_ibfk_1 ezcontentbrowserecent.node_id ezcontentobject_tree.node_id Restrict delete 
ezcontentbrowserecent_ibfk_2 ezcontentbrowserecent.user_id ezuser.contentobject_id Restrict delete 
ezcontentclass_attribute_ibfk_1 ezcontentclass_attribute.contentclass_id ezcontentclass.id Restrict delete 
ezcontentclass_classgroup_ibfk_1 ezcontentclass_classgroup.contentclass_id ezcontentclass.id Restrict delete 
ezcontentclass_ibfk_1 ezcontentclass.creator_id ezuser.contentobject_id Restrict delete 
ezcontentclass_ibfk_2 ezcontentclass.initial_language_id ezcontent_language.id Restrict delete 
ezcontentclass_ibfk_3 ezcontentclass.modifier_id ezuser.contentobject_id Restrict delete 
ezcontentclass_name_ibfk_1 ezcontentclass_name.contentclass_id ezcontentclass.id Restrict delete 
ezcontentclassgroup_ibfk_1 ezcontentclassgroup.creator_id ezuser.contentobject_id Restrict delete 
ezcontentclassgroup_ibfk_2 ezcontentclassgroup.modifier_id ezuser.contentobject_id Restrict delete 
ezcontentobject_attribute_ibfk_1 ezcontentobject_attribute.contentclassattribute_id ezcontentclass_attribute.id Restrict delete 
ezcontentobject_attribute_ibfk_2 ezcontentobject_attribute.contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_ibfk_1 ezcontentobject.contentclass_id ezcontentclass.id Restrict delete 
ezcontentobject_ibfk_2 ezcontentobject.initial_language_id ezcontent_language.id Restrict delete 
ezcontentobject_ibfk_3 ezcontentobject.owner_id ezuser.contentobject_id Restrict delete 
ezcontentobject_ibfk_4 ezcontentobject.section_id ezsection.id Restrict delete 
ezcontentobject_link_ibfk_1 ezcontentobject_link.from_contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_link_ibfk_2 ezcontentobject_link.to_contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_name_ibfk_1 ezcontentobject_name.contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_trash_ibfk_1 ezcontentobject_trash.contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_tree_ibfk_1 ezcontentobject_tree.main_node_id ezcontentobject_tree.node_id Restrict delete 
ezcontentobject_tree_ibfk_2 ezcontentobject_tree.parent_node_id ezcontentobject_tree.node_id Restrict delete 
ezcontentobject_version_ibfk_1 ezcontentobject_version.contentobject_id ezcontentobject.id Restrict delete 
ezcontentobject_version_ibfk_2 ezcontentobject_version.initial_language_id ezcontent_language.id Restrict delete 
ezdiscountsubrule_ibfk_1 ezdiscountsubrule.discountrule_id ezdiscountrule.id Restrict delete 
ezdiscountsubrule_value_ibfk_1 ezdiscountsubrule_value.discountsubrule_id ezdiscountsubrule.id Restrict delete 
ezenumobjectvalue_ibfk_1 ezenumobjectvalue.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezenumvalue_ibfk_1 ezenumvalue.contentclass_attribute_id ezcontentclass_attribute.id Restrict delete 
ezenumvalue_ibfk_2 ezenumvalue.contentclass_attribute_id ezcontentobject_attribute.id Restrict delete 
ezforgot_password_ibfk_1 ezforgot_password.user_id ezuser.contentobject_id Restrict delete 
ezgmaplocation_ibfk_1 ezgmaplocation.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezimagefile_ibfk_1 ezimagefile.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezinfocollection_attribute_ibfk_1 ezinfocollection_attribute.contentclass_attribute_id ezcontentclass_attribute.id Restrict delete 
ezinfocollection_attribute_ibfk_2 ezinfocollection_attribute.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezinfocollection_attribute_ibfk_3 ezinfocollection_attribute.contentobject_id ezcontentobject.id Restrict delete 
ezinfocollection_attribute_ibfk_4 ezinfocollection_attribute.informationcollection_id ezinfocollection.id Restrict delete 
ezinfocollection_ibfk_1 ezinfocollection.contentobject_id ezcontentobject.id Restrict delete 
ezinfocollection_ibfk_2 ezinfocollection.creator_id ezuser.contentobject_id Restrict delete 
ezisbn_registrant_range_ibfk_1 ezisbn_registrant_range.isbn_group_id ezisbn_group.id Restrict delete 
ezkeyword_attribute_link_ibfk_1 ezkeyword_attribute_link.keyword_id ezkeyword.id Restrict delete 
ezkeyword_attribute_link_ibfk_2 ezkeyword_attribute_link.objectattribute_id ezcontentobject_attribute.id Restrict delete 
ezkeyword_ibfk_1 ezkeyword.class_id ezcontentclass.id Restrict delete 
ezm_pool_ibfk_1 ezm_pool.block_id ezm_block.id Restrict delete 
ezm_pool_ibfk_2 ezm_pool.moved_to ezm_block.id Restrict delete 
ezmedia_ibfk_1 ezmedia.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezmultipricedata_ibfk_1 ezmultipricedata.contentobject_attr_id ezcontentobject_attribute.id Restrict delete 
eznode_assignment_ibfk_1 eznode_assignment.parent_node ezcontentobject_tree.node_id Restrict delete 
eznotificationcollection_ibfk_1 eznotificationcollection.event_id eznotificationevent.id Restrict delete 
eznotificationcollection_item_ibfk_1 eznotificationcollection_item.collection_id eznotificationcollection.id Restrict delete 
eznotificationcollection_item_ibfk_2 eznotificationcollection_item.event_id eznotificationevent.id Restrict delete 
ezoperation_memento_ibfk_1 ezoperation_memento.main_key ezoperation_memento.memento_key Restrict delete 
ezorder_ibfk_1 ezorder.productcollection_id ezproductcollection.id Restrict delete 
ezorder_ibfk_2 ezorder.status_id ezorder_status.id Restrict delete 
ezorder_ibfk_3 ezorder.status_modifier_id ezuser.contentobject_id Restrict delete 
ezorder_ibfk_4 ezorder.user_id ezuser.contentobject_id Restrict delete 
ezorder_item_ibfk_1 ezorder_item.order_id ezorder.id Restrict delete 
ezorder_status_history_ibfk_1 ezorder_status_history.modifier_id ezuser.contentobject_id Restrict delete 
ezorder_status_history_ibfk_2 ezorder_status_history.order_id ezorder.id Restrict delete 
ezorder_status_history_ibfk_3 ezorder_status_history.status_id ezorder_status.id Restrict delete 
ezpaymentobject_ibfk_1 ezpaymentobject.order_id ezorder.id Restrict delete 
ezpaymentobject_ibfk_2 ezpaymentobject.workflowprocess_id ezworkflow_process.id Restrict delete 
ezpdf_export_ibfk_1 ezpdf_export.source_node_id ezcontentobject_tree.node_id Restrict delete 
ezpdf_export_ibfk_2 ezpdf_export.modifier_id ezuser.contentobject_id Restrict delete 
ezpdf_export_ibfk_3 ezpdf_export.creator_id ezuser.contentobject_id Restrict delete 
ezpolicy_ibfk_1 ezpolicy.role_id ezrole.id Restrict delete 
ezpolicy_limitation_ibfk_1 ezpolicy_limitation.policy_id ezpolicy.id Restrict delete 
ezpolicy_limitation_value_ibfk_1 ezpolicy_limitation_value.limitation_id ezpolicy_limitation.id Restrict delete 
ezpreferences_ibfk_1 ezpreferences.user_id ezuser.contentobject_id Restrict delete 
ezprest_authcode_ibfk_1 ezprest_authcode.client_id ezprest_clients.client_id Restrict delete 
ezprest_authcode_ibfk_2 ezprest_authcode.user_id ezuser.contentobject_id Restrict delete 
ezprest_authorized_clients_ibfk_1 ezprest_authorized_clients.rest_client_id ezprest_clients.id Restrict delete 
ezprest_authorized_clients_ibfk_2 ezprest_authorized_clients.user_id ezuser.contentobject_id Restrict delete 
ezprest_clients_ibfk_1 ezprest_clients.owner_id ezuser.contentobject_id Restrict delete 
ezprest_token_ibfk_1 ezprest_token.client_id ezprest_clients.client_id Restrict delete 
ezproductcollection_item_ibfk_1 ezproductcollection_item.contentobject_id ezcontentobject.id Restrict delete 
ezproductcollection_item_ibfk_2 ezproductcollection_item.productcollection_id ezproductcollection.id Restrict delete 
ezproductcollection_item_opt_ibfk_1 ezproductcollection_item_opt.item_id ezproductcollection_item.id Restrict delete 
ezproductcollection_item_opt_ibfk_2 ezproductcollection_item_opt.object_attribute_id ezcontentobject_attribute.id Restrict delete 
ezproductcollection_item_opt_ibfk_3 ezproductcollection_item_opt.option_item_id ezproductcollection_item_opt.id Restrict delete 
ezpublishingqueueprocesses_ibfk_1 ezpublishingqueueprocesses.ezcontentobject_version_id ezcontentobject_version.id Restrict delete 
ezrss_export_ibfk_1 ezrss_export.modifier_id ezuser.contentobject_id Restrict delete 
ezrss_export_ibfk_2 ezrss_export.creator_id ezuser.contentobject_id Restrict delete 
ezrss_export_item_ibfk_1 ezrss_export_item.class_id ezcontentclass.id Restrict delete 
ezrss_import_ibfk_1 ezrss_import.class_id ezcontentclass.id Restrict delete 
ezrss_import_ibfk_2 ezrss_import.creator_id ezuser.contentobject_id Restrict delete 
ezrss_import_ibfk_3 ezrss_import.destination_node_id ezcontentobject_tree.node_id Restrict delete 
ezrss_import_ibfk_4 ezrss_import.modifier_id ezuser.contentobject_id Restrict delete 
ezrss_import_ibfk_5 ezrss_import.object_owner_id ezuser.contentobject_id Restrict delete 
ezsearch_object_word_link_ibfk_1 ezsearch_object_word_link.contentobject_id ezcontentobject.id Restrict delete 
ezsearch_object_word_link_ibfk_2 ezsearch_object_word_link.contentclass_id ezcontentclass.id Restrict delete 
ezsearch_object_word_link_ibfk_3 ezsearch_object_word_link.section_id ezsection.id Restrict delete 
ezsession_ibfk_1 ezsession.user_id ezuser.contentobject_id Restrict delete 
ezstarrating_data_ibfk_1 ezstarrating_data.user_id ezuser.contentobject_id Restrict delete 
ezstarrating_data_ibfk_2 ezstarrating_data.contentobject_id ezcontentobject.id Restrict delete 
ezstarrating_data_ibfk_3 ezstarrating_data.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezstarrating_ibfk_1 ezstarrating.contentobject_id ezcontentobject.id Restrict delete 
ezstarrating_ibfk_2 ezstarrating.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezsubtree_notification_rule_ibfk_1 ezsubtree_notification_rule.node_id ezcontentobject_tree.node_id Restrict delete 
ezsubtree_notification_rule_ibfk_2 ezsubtree_notification_rule.user_id ezuser.contentobject_id Restrict delete 
eztipafriend_counter_ibfk_1 eztipafriend_counter.node_id ezcontentobject_tree.node_id Restrict delete 
eztrigger_ibfk_1 eztrigger.workflow_id ezworkflow.id Restrict delete 
ezurl_object_link_ibfk_1 ezurl_object_link.contentobject_attribute_id ezcontentobject_attribute.id Restrict delete 
ezurl_object_link_ibfk_2 ezurl_object_link.url_id ezurl.id Restrict delete 
ezuser_accountkey_ibfk_1 ezuser_accountkey.user_id ezuser.contentobject_id Restrict delete 
ezuser_discountrule_ibfk_1 ezuser_discountrule.contentobject_id ezcontentobject.id Restrict delete 
ezuser_discountrule_ibfk_2 ezuser_discountrule.discountrule_id ezdiscountrule.id Restrict delete 
ezuser_ibfk_1 ezuser.contentobject_id ezcontentobject.id Restrict delete 
ezuser_role_ibfk_1 ezuser_role.role_id ezrole.id Restrict delete 
ezuser_role_ibfk_2 ezuser_role.contentobject_id ezcontentobject_tree.contentobject_id Restrict delete 
ezuser_setting_ibfk_1 ezuser_setting.user_id ezuser.contentobject_id Restrict delete 
ezuservisit_ibfk_1 ezuservisit.user_id ezuser.contentobject_id Restrict delete 
ezvatrule_ibfk_1 ezvatrule.vat_type ezvattype.id Restrict delete 
ezvatrule_product_category_ibfk_1 ezvatrule_product_category.vatrule_id ezvatrule.id Restrict delete 
ezvatrule_product_category_ibfk_2 ezvatrule_product_category.product_category_id ezproductcategory.id Restrict delete 
ezview_counter_ibfk_1 ezview_counter.node_id ezcontentobject_tree.node_id Restrict delete 
ezwaituntildatevalue_ibfk_1 ezwaituntildatevalue.contentclass_attribute_id ezcontentclass_attribute.id Restrict delete 
ezwaituntildatevalue_ibfk_2 ezwaituntildatevalue.contentclass_id ezcontentclass.id Restrict delete 
ezwaituntildatevalue_ibfk_3 ezwaituntildatevalue.workflow_event_id ezworkflow_event.id Restrict delete 
ezwishlist_ibfk_1 ezwishlist.productcollection_id ezproductcollection.id Restrict delete 
ezwishlist_ibfk_2 ezwishlist.user_id ezuser.contentobject_id Restrict delete 
ezworkflow_event_ibfk_1 ezworkflow_event.workflow_id ezworkflow.id Restrict delete 
ezworkflow_group_ibfk_1 ezworkflow_group.creator_id ezuser.contentobject_id Restrict delete 
ezworkflow_group_ibfk_2 ezworkflow_group.modifier_id ezuser.contentobject_id Restrict delete 
ezworkflow_group_link_ibfk_1 ezworkflow_group_link.group_id ezworkflow_group.id Restrict delete 
ezworkflow_group_link_ibfk_2 ezworkflow_group_link.workflow_id ezworkflow.id Restrict delete 
ezworkflow_ibfk_1 ezworkflow.creator_id ezuser.contentobject_id Restrict delete 
ezworkflow_ibfk_2 ezworkflow.modifier_id ezuser.contentobject_id Restrict delete 
ezworkflow_process_ibfk_1 ezworkflow_process.memento_key ezoperation_memento.memento_key Restrict delete 
ezworkflow_process_ibfk_2 ezworkflow_process.user_id ezuser.contentobject_id Restrict delete 
ezworkflow_process_ibfk_3 ezworkflow_process.workflow_id ezworkflow.id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected