SchemaSpy Analysis of sakila - Constraints | Generated by SchemaSpy |
22 Foreign Key Constraints: |
|
Constraint Name | Child Column | Parent Column | Delete Rule |
---|---|---|---|
fk_address_city | address.city_id | city.city_id | Restrict delete |
fk_city_country | city.country_id | country.country_id | Restrict delete |
fk_customer_address | customer.address_id | address.address_id | Restrict delete |
fk_customer_store | customer.store_id | store.store_id | Restrict delete |
fk_film_actor_actor | film_actor.actor_id | actor.actor_id | Restrict delete |
fk_film_actor_film | film_actor.film_id | film.film_id | Restrict delete |
fk_film_category_category | film_category.category_id | category.category_id | Restrict delete |
fk_film_category_film | film_category.film_id | film.film_id | Restrict delete |
fk_film_language | film.language_id | language.language_id | Restrict delete |
fk_film_language_original | film.original_language_id | language.language_id | Restrict delete |
fk_inventory_film | inventory.film_id | film.film_id | Restrict delete |
fk_inventory_store | inventory.store_id | store.store_id | Restrict delete |
fk_payment_customer | payment.customer_id | customer.customer_id | Restrict delete |
fk_payment_rental | payment.rental_id | rental.rental_id | Null on delete |
fk_payment_staff | payment.staff_id | staff.staff_id | Restrict delete |
fk_rental_customer | rental.customer_id | customer.customer_id | Restrict delete |
fk_rental_inventory | rental.inventory_id | inventory.inventory_id | Restrict delete |
fk_rental_staff | rental.staff_id | staff.staff_id | Restrict delete |
fk_staff_address | staff.address_id | address.address_id | Restrict delete |
fk_staff_store | staff.store_id | store.store_id | Restrict delete |
fk_store_address | store.address_id | address.address_id | Restrict delete |
fk_store_staff | store.manager_staff_id | staff.staff_id | Restrict delete |
Check Constraints:
Table | Constraint Name | Constraint |
---|---|---|
None detected |