Constraints

65 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_product_download_customer_id_customer_id
product_download.customer_id
customer.id
Restrict delete
fk_product_download_product_id_product_id
product_download.product_id
product.id
Restrict delete
fk_attribute_combination_product_id_product_id
attribute_combination.product_id
product.id
Restrict delete
fk_order_impersonating_customer_id_customer_id
order.impersonating_customer_id
customer.id
Restrict delete
fk_order_discount_id_order_discount_id
order.discount_id
order_discount.id
Restrict delete
fk_order_shipping_address_id_address_id
order.shipping_address_id
address.id
Restrict delete
fk_order_department_id_department_id
order.department_id
department.id
Restrict delete
fk_order_billing_address_id_address_id
order.billing_address_id
address.id
Restrict delete
fk_order_customer_id_customer_id
order.customer_id
customer.id
Restrict delete
fk_order_storefront_id_storefront_id
order.storefront_id
storefront.id
Cascade on delete
fk_order_delivery_method_id_delivery_method_id
order.delivery_method_id
delivery_method.id
Restrict delete
fk_customer_customer_role_mapping_customer_id_customer_id
customer_customer_role_mapping.customer_id
customer.id
Cascade on delete
fk_customer_customer_role_mapping_role_id_customer_role_id
customer_customer_role_mapping.role_id
customer_role.id
Restrict delete
fk_department_shipping_method_mapping_department_id_department_
department_shipping_method_mapping.department_id
department.id
Cascade on delete
fk_mis_plugin_mapping_mis_plugin_id_mis_plugin_id
mis_plugin_mapping.mis_plugin_id
mis_plugin.id
Restrict delete
fk_category_parent_category_id_category_id
category.parent_category_id
category.id
Restrict delete
fk_category_storefront_id_storefront_id
category.storefront_id
storefront.id
Cascade on delete
fk_product_storefront_id_storefront_id
product.storefront_id
storefront.id
Cascade on delete
fk_customer_shipping_address_id_address_id
customer.shipping_address_id
address.id
Restrict delete
fk_customer_department_id_department_id
customer.department_id
department.id
Restrict delete
fk_customer_billing_address_id_address_id
customer.billing_address_id
address.id
Restrict delete
fk_customer_storefront_id_storefront_id
customer.storefront_id
storefront.id
Cascade on delete
fk_customer_address_mapping_address_id_address_id
customer_address_mapping.address_id
address.id
Restrict delete
fk_customer_address_mapping_customer_id_customer_id
customer_address_mapping.customer_id
customer.id
Cascade on delete
fk_mis_plugin_storefront_id_storefront_id
mis_plugin.storefront_id
storefront.id
Cascade on delete
fk_customer_attributes_mapping_attribute_name_id_attribute_name
customer_attributes_mapping.attribute_name_id
attribute_name.id
Cascade on delete
fk_customer_attributes_mapping_customer_id_customer_id
customer_attributes_mapping.customer_id
customer.id
Cascade on delete
fk_customer_attributes_mapping_attribute_value_id_attribute_val
customer_attributes_mapping.attribute_value_id
attribute_value.id
Null on delete
fk_budget_usage_history_budget_id_budget_id
budget_usage_history.budget_id
budget.id
Cascade on delete
fk_budget_usage_history_used_with_order_id_order_id
budget_usage_history.used_with_order_id
order.id
Restrict delete
fk_product_specification_attribute_mapping_attribute_name_id_at
product_specification_attribute_mapping.attribute_name_id
attribute_name.id
Cascade on delete
fk_product_specification_attribute_mapping_attribute_value_id_a
product_specification_attribute_mapping.attribute_value_id
attribute_value.id
Cascade on delete
fk_product_specification_attribute_mapping_product_id_product_i
product_specification_attribute_mapping.product_id
product.id
Cascade on delete
fk_orderline_approver_history_customer_id_customer_id
orderline_approver_history.customer_id
customer.id
Null on delete
fk_orderline_approver_history_orderline_id_orderline_id
orderline_approver_history.orderline_id
orderline.id
Restrict delete
fk_attribute_attributecombination_mapping_AttributeNameId_attri
attribute_attributecombination_mapping.AttributeNameId
attribute_name.id
Cascade on delete
fk_attribute_attributecombination_mapping_AttributeCombinationI
attribute_attributecombination_mapping.AttributeCombinationId
attribute_combination.id
Cascade on delete
fk_attribute_attributecombination_mapping_AttributeValueId_attr
attribute_attributecombination_mapping.AttributeValueId
attribute_value.id
Null on delete
fk_customer_login_history_customer_id_customer_id
customer_login_history.customer_id
customer.id
Cascade on delete
fk_order_discount_storefront_id_storefront_id
order_discount.storefront_id
storefront.id
Cascade on delete
fk_budget_storefront_id_storefront_id
budget.storefront_id
storefront.id
Cascade on delete
fk_budget_customer_id_customer_id
budget.customer_id
customer.id
Restrict delete
fk_orderline_attribute_mapping_orderline_id_orderline_id
orderline_attribute_mapping.orderline_id
orderline.id
Cascade on delete
fk_orderline_attribute_mapping_attribute_name_id_attribute_name
orderline_attribute_mapping.attribute_name_id
attribute_name.id
Cascade on delete
fk_orderline_attribute_mapping_attribute_value_id_attribute_val
orderline_attribute_mapping.attribute_value_id
attribute_value.id
Cascade on delete
fk_orderline_attribute_combination_id_attribute_combination_id
orderline.attribute_combination_id
attribute_combination.id
Null on delete
fk_orderline_storefront_id_storefront_id
orderline.storefront_id
storefront.id
Cascade on delete
fk_orderline_order_id_order_id
orderline.order_id
order.id
Restrict delete
fk_orderline_product_id_product_id
orderline.product_id
product.id
Restrict delete
fk_department_storefront_id_storefront_id
department.storefront_id
storefront.id
Cascade on delete
fk_customer_relationship_mapping_customer_child_id_customer_id
customer_relationship_mapping.customer_child_id
customer.id
Restrict delete
fk_customer_relationship_mapping_customer_master_id_customer_id
customer_relationship_mapping.customer_master_id
customer.id
Cascade on delete
fk_reward_points_history_used_with_order_id_order_id
reward_points_history.used_with_order_id
order.id
Restrict delete
fk_reward_points_history_customer_id_customer_id
reward_points_history.customer_id
customer.id
Cascade on delete
fk_product_attribute_mapping_attribute_name_id_attribute_name_i
product_attribute_mapping.attribute_name_id
attribute_name.id
Cascade on delete
fk_product_attribute_mapping_attribute_value_id_attribute_value
product_attribute_mapping.attribute_value_id
attribute_value.id
Cascade on delete
fk_product_attribute_mapping_product_id_product_id
product_attribute_mapping.product_id
product.id
Cascade on delete
fk_address_storefront_id_storefront_id
address.storefront_id
storefront.id
Cascade on delete
fk_product_category_mapping_category_id_category_id
product_category_mapping.category_id
category.id
Cascade on delete
fk_product_category_mapping_product_id_product_id
product_category_mapping.product_id
product.id
Restrict delete
fk_department_payment_method_mapping_department_id_department_i
department_payment_method_mapping.department_id
department.id
Cascade on delete
fk_order_checkout_attribute_mapping_order_id_order_id
order_checkout_attribute_mapping.order_id
order.id
Cascade on delete
fk_order_checkout_attribute_mapping_attribute_value_id_attribut
order_checkout_attribute_mapping.attribute_value_id
attribute_value.id
Cascade on delete
fk_order_checkout_attribute_mapping_attribute_name_id_attribute
order_checkout_attribute_mapping.attribute_name_id
attribute_name.id
Cascade on delete
fk_orderline_status_history_orderline_id_orderline_id
orderline_status_history.orderline_id
orderline.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint