SchemaSpy Analysis of sakila - Constraints Generated by
SchemaSpy
22 Foreign Key Constraints:
SourceForge.net

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