VEXAMESPEND

22 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVEXAMESPEND_PFUNCR
VEXAMES.CODCOLIGADA FKVEXAMESPEND_VEXAMESR
VPERFIL.CODCOLIGADA FKVEXAMESPEND_VPERFILR
CHAPA DCHAPA 16 null
PFUNC.CHAPA FKVEXAMESPEND_PFUNCR
TIPOEXAME varchar 1 √ null
VTIPOEXAME.CODCLIENTE FKVEXAMESPEND_VTIPOEXAMER
CODEXAME varchar 10 null
VEXAMES.CODEXAME FKVEXAMESPEND_VEXAMESR
CODPERFIL varchar 10 √ null
VPERFIL.CODPERFIL FKVEXAMESPEND_VPERFILR
DATAPROXEXAME datetime 16,3 √ null
DATALCTOEXAME datetime 16,3 null
CODPESSOA int 4 null
PPESSOA.CODIGO FKVEXAMESPEND_PPESSOAR
DIASPERIODO int 4 √ null
REALIZADO int 4 √ (0)
CODUSUARIO varchar 20 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
ORIGEM smallint 2 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVEXAMESPEND Primary key Asc/Asc/Asc/Asc CODCOLIGADA + CODEXAME + CHAPA + DATALCTOEXAME

Relationships

Close relationships within degrees of separation