XPESSOAENDERECO

7 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
COD_PESS int 4 null
XPESSOA.COD_PESS FKPESSOAENDERECO_XPESSOAR
NUM_SEQ_END int 4 null
SIG_UF varchar 2 null
COD_TIPO_END char 1 √ null
XTIPOENDERECO.COD_TIPO_END FKPESSOAENDERECO_XTIPOENDERECOR
DSC_END varchar 45 √ null
DSC_NUM varchar 6 √ null
DSC_COMPL varchar 15 √ null
NOM_BAIR varchar 25 √ null
NOM_CID varchar 30 √ null
NUM_CEP varchar 8 √ null
NUM_TEL varchar 14 √ null
NUM_RAM varchar 4 √ null
NUM_FAX varchar 14 √ null
NUM_CEL varchar 14 √ null
COD_SIT_OPRL char 1 √ null
COD_PESS_ULT_MNT varchar 20 √ null
DAT_ULT_MNT datetime 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKXPESSOAENDERECO Primary key Asc/Asc COD_PESS + NUM_SEQ_END

Relationships

Close relationships within degrees of separation