VREQUISICAOBASE_TEMP70

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
IDREQUISICAO int 4 null
DESCRICAO varchar 200 null
DATABERTURA datetime 16,3 √ null
IDMOTIVOREQUISICAO int 4 √ null
IDTIPOREQUISICAO int 4 √ null
VTIPOREQUISICAO.IDTIPOREQUISICAO Implied ConstraintR
CODREQUISITANTE int 4 √ null
CODATENDIMENTO int 4 √ null
ECNTATENDIM.CODATENDIMENTO Implied ConstraintR
CODLOCAL int 4 √ null
HLOCALIDADE.CODLOCAL Implied ConstraintR
FLGATIVA DLOGICO 2 null
CODREQUISICAO varchar 10 √ null
CODFUNCAO varchar 10 √ null
CODSECAO varchar 35 √ null
CODVAGA varchar 16 √ null
TIPO smallint 2 √ null
TCODIGO.TIPO Implied ConstraintR
SALARIO RMDVALOR2 17,2 √ null
CODFAIXA varchar 10 √ null
CODNIVEL varchar 10 √ null
NUMVAGASREQUISITADAS smallint 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)
PKVREQUISICAOBASE_TEMP70 Primary key Asc/Asc CODCOLIGADA + IDREQUISICAO

Relationships

Close relationships within degrees of separation