40 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| payment_rental_id_fkey |
|
|
Null on delete | ||
| payment_staff_id_fkey |
|
|
Restrict delete | ||
| payment_customer_id_fkey |
|
|
Restrict delete | ||
| film_language_id_fkey |
|
|
Restrict delete | ||
| film_original_language_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_05_rental_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_05_customer_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_05_staff_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_06_rental_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_06_customer_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_06_staff_id_fkey |
|
|
Restrict delete | ||
| inventory_film_id_fkey |
|
|
Restrict delete | ||
| inventory_store_id_fkey |
|
|
Restrict delete | ||
| city_country_id_fkey |
|
|
Restrict delete | ||
| address_city_id_fkey |
|
|
Restrict delete | ||
| store_manager_staff_id_fkey |
|
|
Restrict delete | ||
| store_address_id_fkey |
|
|
Restrict delete | ||
| staff_address_id_fkey |
|
|
Restrict delete | ||
| staff_store_id_fkey |
|
|
Restrict delete | ||
| customer_store_id_fkey |
|
|
Restrict delete | ||
| customer_address_id_fkey |
|
|
Restrict delete | ||
| rental_staff_id_fkey |
|
|
Restrict delete | ||
| rental_customer_id_fkey |
|
|
Restrict delete | ||
| rental_inventory_id_fkey |
|
|
Restrict delete | ||
| film_actor_film_id_fkey |
|
|
Restrict delete | ||
| film_actor_actor_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_03_rental_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_03_staff_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_03_customer_id_fkey |
|
|
Restrict delete | ||
| film_category_film_id_fkey |
|
|
Restrict delete | ||
| film_category_category_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_04_rental_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_04_staff_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_04_customer_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_01_customer_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_01_rental_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_01_staff_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_02_customer_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_02_staff_id_fkey |
|
|
Restrict delete | ||
| payment_p2007_02_rental_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| payment_p2007_05 | payment_p2007_05_payment_date_check | (((payment_date >= '2007-05-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-06-01 00:00:00'::timestamp without time zone))) |
| payment_p2007_06 | payment_p2007_06_payment_date_check | (((payment_date >= '2007-06-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-07-01 00:00:00'::timestamp without time zone))) |
| payment_p2007_03 | payment_p2007_03_payment_date_check | (((payment_date >= '2007-03-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-04-01 00:00:00'::timestamp without time zone))) |
| payment_p2007_04 | payment_p2007_04_payment_date_check | (((payment_date >= '2007-04-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-05-01 00:00:00'::timestamp without time zone))) |
| payment_p2007_01 | payment_p2007_01_payment_date_check | (((payment_date >= '2007-01-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-02-01 00:00:00'::timestamp without time zone))) |
| payment_p2007_02 | payment_p2007_02_payment_date_check | (((payment_date >= '2007-02-01 00:00:00'::timestamp without time zone) AND (payment_date < '2007-03-01 00:00:00'::timestamp without time zone))) |