T_PACIENTE_ENTREGA


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CD_CLIENTE DOUBLE PRECISION 15 null
T_PACIENTE.CD_CLIENTE FK_PAC_ENT_PAC R
CD_PACIENTE DOUBLE PRECISION 15 null
T_PACIENTE.CD_PACIENTE FK_PAC_ENT_PAC R
TP_ENTREGA CHAR 1 null
DS_ENDERECO VARCHAR 200 √ null
NM_BAIRRO VARCHAR 200 √ null
NM_CIDADE VARCHAR 200 √ null
NM_UF VARCHAR 2 √ null
NR_CEP DOUBLE PRECISION 15 √ null
DS_REFERENCIA VARCHAR 200 √ null
DS_OBSERVACAO VARCHAR 2000 √ null
NR_TELEFONE VARCHAR 30 √ null
NR_TELEFONE_CEL VARCHAR 30 √ null
NR_ENDERECO VARCHAR 20 √ null
DS_ENTREGA VARCHAR 100 √ null
ID_ENTREGA INTEGER 10 null
ID_PREFERENCIAL CHAR 1 √ null

Indexes

Constraint Name Type Sort Column(s)
FK_PAC_ENT_PAC Performance Asc/Asc CD_CLIENTE + CD_PACIENTE
PK_T_PACIENTE_ENTREGA Must be unique Desc/Desc/Desc CD_CLIENTE + CD_PACIENTE + ID_ENTREGA

Relationships

Close relationships within degrees of separation