Constraints

11 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

order_items_product_id_fkey

order_items.product_id

products.product_id

Restrict delete

order_items_order_id_fkey

order_items.order_id

orders.order_id

Restrict delete

reviews_product_id_fkey

reviews.product_id

products.product_id

Restrict delete

reviews_user_id_fkey

reviews.user_id

users.user_id

Restrict delete

orders_user_id_fkey

orders.user_id

users.user_id

Restrict delete

addresses_user_id_fkey

addresses.user_id

users.user_id

Restrict delete

payment_methods_user_id_fkey

payment_methods.user_id

users.user_id

Restrict delete

wishlist_product_id_fkey

wishlist.product_id

products.product_id

Restrict delete

wishlist_user_id_fkey

wishlist.user_id

users.user_id

Restrict delete

product_categories_product_id_fkey

product_categories.product_id

products.product_id

Restrict delete

product_categories_category_id_fkey

product_categories.category_id

categories.category_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint