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 | Consultorio | Cita_ibfk_1 | def | Consultorio | PRIMARY | NONE | NO ACTION | NO ACTION | Cita | paciente | |
def | Consultorio | Cita_ibfk_2 | def | Consultorio | PRIMARY | NONE | NO ACTION | NO ACTION | Cita | Medico | |
def | Consultorio | Diagnóstico_ibfk_1 | def | Consultorio | PRIMARY | NONE | NO ACTION | NO ACTION | Diagnóstico | Cita | |
def | Consultorio | Factura_ibfk_1 | def | Consultorio | PRIMARY | NONE | NO ACTION | NO ACTION | Factura | Cita | |
def | kingkhy | admin_ibfk_1 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | admin | hotel | |
def | kingkhy | reservation_ibfk_1 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | reservation | customer | |
def | kingkhy | reservation_ibfk_2 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | reservation | room | |
def | kingkhy | room_ibfk_1 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | room | hotel | |
def | kingkhy | room_ibfk_2 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | room | room_type | |
def | kingkhy | room_ibfk_3 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | room | facilities | |
def | kingkhy | room_ibfk_4 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | room | room_status | |
def | kingkhy | servents_ibfk_1 | def | kingkhy | PRIMARY | NONE | NO ACTION | CASCADE | servents | hotel |
|