SchemaSpy Analysis of postgres.public - Constraints Generated by
SchemaSpy
40 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
address_city_id_fkey address.city_id city.city_id Restrict delete 
city_country_id_fkey city.country_id country.country_id Restrict delete 
customer_address_id_fkey customer.address_id address.address_id Restrict delete 
customer_store_id_fkey customer.store_id store.store_id Restrict delete 
film_actor_actor_id_fkey film_actor.actor_id actor.actor_id Restrict delete 
film_actor_film_id_fkey film_actor.film_id film.film_id Restrict delete 
film_category_category_id_fkey film_category.category_id category.category_id Restrict delete 
film_category_film_id_fkey film_category.film_id film.film_id Restrict delete 
film_language_id_fkey film.language_id language.language_id Restrict delete 
film_original_language_id_fkey film.original_language_id language.language_id Restrict delete 
inventory_film_id_fkey inventory.film_id film.film_id Restrict delete 
inventory_store_id_fkey inventory.store_id store.store_id Restrict delete 
payment_customer_id_fkey payment.customer_id customer.customer_id Restrict delete 
payment_p2007_01_customer_id_fkey payment_p2007_01.customer_id customer.customer_id Restrict delete 
payment_p2007_01_rental_id_fkey payment_p2007_01.rental_id rental.rental_id Restrict delete 
payment_p2007_01_staff_id_fkey payment_p2007_01.staff_id staff.staff_id Restrict delete 
payment_p2007_02_customer_id_fkey payment_p2007_02.customer_id customer.customer_id Restrict delete 
payment_p2007_02_rental_id_fkey payment_p2007_02.rental_id rental.rental_id Restrict delete 
payment_p2007_02_staff_id_fkey payment_p2007_02.staff_id staff.staff_id Restrict delete 
payment_p2007_03_customer_id_fkey payment_p2007_03.customer_id customer.customer_id Restrict delete 
payment_p2007_03_rental_id_fkey payment_p2007_03.rental_id rental.rental_id Restrict delete 
payment_p2007_03_staff_id_fkey payment_p2007_03.staff_id staff.staff_id Restrict delete 
payment_p2007_04_customer_id_fkey payment_p2007_04.customer_id customer.customer_id Restrict delete 
payment_p2007_04_rental_id_fkey payment_p2007_04.rental_id rental.rental_id Restrict delete 
payment_p2007_04_staff_id_fkey payment_p2007_04.staff_id staff.staff_id Restrict delete 
payment_p2007_05_customer_id_fkey payment_p2007_05.customer_id customer.customer_id Restrict delete 
payment_p2007_05_rental_id_fkey payment_p2007_05.rental_id rental.rental_id Restrict delete 
payment_p2007_05_staff_id_fkey payment_p2007_05.staff_id staff.staff_id Restrict delete 
payment_p2007_06_customer_id_fkey payment_p2007_06.customer_id customer.customer_id Restrict delete 
payment_p2007_06_rental_id_fkey payment_p2007_06.rental_id rental.rental_id Restrict delete 
payment_p2007_06_staff_id_fkey payment_p2007_06.staff_id staff.staff_id Restrict delete 
payment_rental_id_fkey payment.rental_id rental.rental_id Null on delete 
payment_staff_id_fkey payment.staff_id staff.staff_id Restrict delete 
rental_customer_id_fkey rental.customer_id customer.customer_id Restrict delete 
rental_inventory_id_fkey rental.inventory_id inventory.inventory_id Restrict delete 
rental_staff_id_fkey rental.staff_id staff.staff_id Restrict delete 
staff_address_id_fkey staff.address_id address.address_id Restrict delete 
staff_store_id_fkey staff.store_id store.store_id Restrict delete 
store_address_id_fkey store.address_id address.address_id Restrict delete 
store_manager_staff_id_fkey store.manager_staff_id staff.staff_id Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected