VVERBATREINA

72 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
GCCUSTO.CODCOLIGADA FKVVERBATREINA_GCCUSTOR
GDEPTO.CODCOLIGADA FKVVERBATREINA_GDEPTOR
VPLANOTREINA.CODCOLIGADA FKVVERBATREINA_VPLANOTREINAR
PSECAO.CODCOLIGADA FKVVERBATREINA_PSECAOR
GFILIAL.CODCOLIGADA FKVVERBATREINA_GFILIALR
CODPLANOTREINA varchar 3 null
VPLANOTREINA.CODPLANOTREINA FKVVERBATREINA_VPLANOTREINAR
SEQUENCIAL smallint 2 null
CODFILIAL smallint 2 √ null
GDEPTO.CODFILIAL FKVVERBATREINA_GDEPTOR
GFILIAL.CODFILIAL FKVVERBATREINA_GFILIALR
CODDEPARTAMENTO varchar 25 √ null
GDEPTO.CODDEPARTAMENTO FKVVERBATREINA_GDEPTOR
CODSECAO varchar 35 √ null
PSECAO.CODIGO FKVVERBATREINA_PSECAOR
CODCCUSTO varchar 25 √ null
GCCUSTO.CODCCUSTO FKVVERBATREINA_GCCUSTOR
VALORESTIMADO RMDVALOR2 17,2 √ null
VALORREALIZADO RMDVALOR2 17,2 √ 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)
PKVVERBATREINA Primary key Asc/Asc/Asc CODCOLIGADA + CODPLANOTREINA + SEQUENCIAL

Relationships

Close relationships within degrees of separation