Constraints

16 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
admin_fk
administrator.user_id
user.user_id
Cascade on delete
order_store_store_id_fk
order.store_id
store.store_id
Restrict delete
order_fk
order.client_id
client.user_id
Null on delete
store_district_district_id_fk
store.district_id
district.district_id
Restrict delete
store_product_product_product_id_fk
store_product.product_id
product.product_id
Restrict delete
store_product_store_store_id_fk
store_product.store_id
store.store_id
Restrict delete
review_1fk
review.client_id
client.user_id
Cascade on delete
review_2fk
review.product_id
product.product_id
Cascade on delete
request_fk
password_change_request.user_id
user.user_id
Cascade on delete
order_product_product_product_id_fk
order_product.product_id
product.product_id
Restrict delete
order_product_order_order_id_fk
order_product.order_id
order.order_id
Restrict delete
comment_user_user_id_fk
comment.user_id
user.user_id
Restrict delete
comment_review_review_id_fk
comment.review_id
review.review_id
Restrict delete
comment_comment_comment_id_fk
comment.parent_comment_id
comment.comment_id
Cascade on delete
client_fk
client.user_id
user.user_id
Cascade on delete
client_district_district_id_fk
client.district_id
district.district_id
Restrict delete

Check Constraints

Table Constraint Name Constraint