T_CLINICA


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CD_CLINICA DOUBLE PRECISION 15 null
T_CLINICA_MEDICO.CD_CLINICA FK_MED_CLI R
NM_CLINICA VARCHAR 200 null
DS_ENDERECO VARCHAR 400 √ null
DS_BAIRRO VARCHAR 100 √ null
DS_CIDADE VARCHAR 80 √ null
DS_UF CHAR 2 √ null
DS_CEP CHAR 9 √ null
ID_SITUACAO CHAR 1 √ null
DS_OBSERVACAO VARCHAR 2000 √ null
NM_UF CHAR 2 √ null
CD_EMPRESA DOUBLE PRECISION 15 √ null
T_EMPRESA.CD_EMPRESA Implied Constraint R
NR_TELEFONE VARCHAR 50 √ null
NR_TELEFONE01 VARCHAR 50 √ null
NR_TELEFONE0101 VARCHAR 50 √ null
NR_TELEFONE01010101 VARCHAR 50 √ null
NR_TELEFONE010101 VARCHAR 50 √ null
NR_TELEFONE_FAX VARCHAR 50 √ null
NR_TELEFONE_FAX01 VARCHAR 50 √ null
NR_TELEFONE_FAX0101 VARCHAR 50 √ null
NR_TELEFONE_FAX01010101 VARCHAR 50 √ null
NR_TELEFONE_FAX010101 VARCHAR 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_CLINICA Primary key Asc CD_CLINICA

Relationships

Close relationships within degrees of separation