VBATERIAEXAMES

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VEXAMES.CODCOLIGADA FKVBATERIAEXAMES_VEXAMESR
VPERFIL.CODCOLIGADA FKVBATERIAEXAMES_VPERFILR
GFORMULA.CODCOLIGADA FKVBATERIAEXAMES_GFORMULAR
CODPERFIL varchar 10 null
VPERFIL.CODPERFIL FKVBATERIAEXAMES_VPERFILR
CODEXAME varchar 10 null
VEXAMES.CODEXAME FKVBATERIAEXAMES_VEXAMESR
DATAINICIOVALID datetime 16,3 √ null
DIASPERIODO smallint 2 √ null
CODFORMULAAPLICACAO varchar 1 √ null
GFORMULA.APLICACAO FKVBATERIAEXAMES_GFORMULAR
CODFORMULAPERIODO varchar 8 √ null
GFORMULA.CODIGO FKVBATERIAEXAMES_GFORMULAR
TIPOEXAME varchar 1 ('I')
VTIPOEXAME.CODCLIENTE FKVBATERIAEXAMES_VTIPOEXAMER
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)
PKVBATERIAEXAMES Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODPERFIL + CODEXAME + TIPOEXAME

Relationships

Close relationships within degrees of separation