VCOMPETENCIAREQUISITO

160 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VCOMPETENCIA.CODCOLIGADA FKVCOMPETENCIAREQ_VCOMPETENCIAR
VREQUISITOACESSO.CODCOLIGADA FKVCOMPETEREQ_VREQUISITOACESSOR
CODCOMPETENCIA varchar 10 null
VCOMPETENCIA.CODCOMPETENCIA FKVCOMPETENCIAREQ_VCOMPETENCIAR
CODREQUISITO varchar 10 null
VREQUISITOACESSO.CODREQUISITO FKVCOMPETEREQ_VREQUISITOACESSOR
DATAVINCULO datetime 16,3 null
OBRIGATORIO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DATAVALIDADE datetime 16,3 √ null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TEMEXPIRACAO DLOGICO 2 ((0))
DIASEXPIRACAO int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVCOMPETENCIAREQUISITO Primary key Asc/Asc/Asc CODCOLIGADA + CODCOMPETENCIA + CODREQUISITO

Relationships

Close relationships within degrees of separation