T_CLINICA_MEDICO


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CD_CLINICA DOUBLE PRECISION 15 null
T_CLINICA.CD_CLINICA FK_MED_CLI R
CD_MEDICO DOUBLE PRECISION 15 null
T_MEDICO.CD_MEDICO FK_CLI_MED R
CD_EMPRESA DOUBLE PRECISION 15 √ null
T_EMPRESA.CD_EMPRESA Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
PK_CLI_MED Primary key Asc/Asc CD_CLINICA + CD_MEDICO
FK_CLI_MED Performance Asc CD_MEDICO
FK_MED_CLI Performance Asc CD_CLINICA

Relationships

Close relationships within degrees of separation