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 |
|