SELECT * FROM `REFERENTIAL_CONSTRAINTS`
|
CONSTRAINT_CATALOG | CONSTRAINT_SCHEMA | CONSTRAINT_NAME | UNIQUE_CONSTRAINT_CATALOG | UNIQUE_CONSTRAINT_SCHEMA | UNIQUE_CONSTRAINT_NAME | MATCH_OPTION | UPDATE_RULE | DELETE_RULE | TABLE_NAME | REFERENCED_TABLE_NAME | |
---|---|---|---|---|---|---|---|---|---|---|---|
def | sakila | fk_address_city | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | address | city | |
def | sakila | fk_city_country | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | city | country | |
def | sakila | fk_customer_address | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | customer | address | |
def | sakila | fk_customer_store | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | customer | store | |
def | sakila | fk_film_language | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film | language | |
def | sakila | fk_film_language_original | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film | language | |
def | sakila | fk_film_actor_actor | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film_actor | actor | |
def | sakila | fk_film_actor_film | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film_actor | film | |
def | sakila | fk_film_category_film | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film_category | film | |
def | sakila | fk_film_category_category | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | film_category | category | |
def | sakila | fk_inventory_store | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | inventory | store | |
def | sakila | fk_inventory_film | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | inventory | film | |
def | sakila | fk_payment_rental | def | sakila | PRIMARY | NONE | CASCADE | SET NULL | payment | rental | |
def | sakila | fk_payment_customer | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | payment | customer | |
def | sakila | fk_payment_staff | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | payment | staff | |
def | sakila | fk_rental_staff | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | rental | staff | |
def | sakila | fk_rental_inventory | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | rental | inventory | |
def | sakila | fk_rental_customer | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | rental | customer | |
def | sakila | fk_staff_store | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | staff | store | |
def | sakila | fk_staff_address | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | staff | address | |
def | sakila | fk_store_staff | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | store | staff | |
def | sakila | fk_store_address | def | sakila | PRIMARY | NONE | CASCADE | RESTRICT | store | address | |
def | Table_insertion | voiture_ibfk_1 | def | Table_insertion | PRIMARY | NONE | NO ACTION | CASCADE | voiture | ecurie | |
def | Table_insertion | speciale_ibfk_1 | def | Table_insertion | PRIMARY | NONE | NO ACTION | CASCADE | speciale | rallye | |
def | pw | usuario_ibfk_1 | def | pw | PRIMARY | NONE | CASCADE | CASCADE | usuario | credenciales |
|