VADVERTENCIA

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVADVERTENCIA_PFUNCR
PSECAO.CODCOLIGADA FKVADVERTENCIA_PSECAOR
VPUNICAO.CODCOLIGADA FVVADVERTENCIA_VPUNICAOR
VMOTADVERT.CODCOLIGADA FKVADVERTENCIA_VMOTADVERTR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKVADVERTENCIA_PFUNCR
CODMOTADVERT varchar 10 null
VMOTADVERT.CODMOTADVERT FKVADVERTENCIA_VMOTADVERTR
DATAHORA datetime 16,3 null
TIPOADVERT smallint 2 √ null
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKVADVERTENCIA_PSECAOR
CODTESTEMUN1 int 4 √ null
PPESSOA.CODIGO FKVADVERTENCIA_PPESSOA1R
CODTESTEMUN2 int 4 √ null
PPESSOA.CODIGO FKVADVERTENCIA_PPESSOA2R
DESCRICAO MEMO 2147483647 √ null
CODPUNICAO varchar 10 √ null
VPUNICAO.CODPUNICAO FVVADVERTENCIA_VPUNICAOR
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)
PKVADVERTENCIA Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CHAPA + CODMOTADVERT + DATAHORA

Relationships

Close relationships within degrees of separation