VREQDESLIGAMENTO

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLREQUISICAO DCODCOLIGADA 2 null
VDESLIGAMENTOCOMPL.CODCOLREQUISICAO FKVDESLICOMPL_VREQDESLIGAMENTOR
VREQDESLIGAMENTOPARECER.CODCOLREQUISICAO FKVREQDESLPAR_VREQDESLIGAMENTOR
VPOSICAO.CODCOLIGADA FKVREQDESLIGAMENTO_VPOSICAOR
PFUNC.CODCOLIGADA FKVREQDESLIG_PFUNCREQUISICAOR
HATENDIMENTOBASE.CODCOLIGADA FKVREQDESLIGAM_HATENDIMENTOEXTR
PMOTDEMISSAO.CODCOLIGADA FKVREQDESLIGAMENT_PMOTDEMISSAOR
IDREQ int 4 null
VDESLIGAMENTOCOMPL.IDREQ FKVDESLICOMPL_VREQDESLIGAMENTOR
VREQDESLIGAMENTOPARECER.IDREQ FKVREQDESLPAR_VREQDESLIGAMENTOR
JUSTIFICATIVA MEMO 2147483647 null
DATAABERTURA datetime 16,3 null
CODCOLREQUISITANTE DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKVREQDESLIG_PFUNCREQUISITANTER
CHAPAREQUISITANTE varchar 16 null
PFUNC.CHAPA FKVREQDESLIG_PFUNCREQUISITANTER
CODATENDIMENTO int 4 √ null
HATENDIMENTOBASE.CODATENDIMENTO FKVREQDESLIGAM_HATENDIMENTOEXTR
CODLOCAL int 4 √ null
HATENDIMENTOBASE.CODLOCAL FKVREQDESLIGAM_HATENDIMENTOEXTR
CODSTATUS int 4 null
VREQSTATUS.CODCLIENTE FKVREQDESLIGAMENTO_VREQSTATUSR
DATACANCELAMENTO datetime 16,3 √ null
DATAPREVISTA datetime 16,3 √ null
DATACONCLUSAO datetime 16,3 √ null
CHAPA varchar 16 null
PFUNC.CHAPA FKVREQDESLIG_PFUNCREQUISICAOR
NUMDIASAVISO smallint 2 √ null
CODMOTRESCISAO varchar 5 √ null
PMOTDEMISSAO.CODCLIENTE FKVREQDESLIGAMENT_PMOTDEMISSAOR
CRIASUBSTITUICAO DLOGICO 2 null
EPNE DLOGICO 2 null
CODTIPORESCISAO char 1 √ null
PTPDEMISSAO.CODCLIENTE FKVREQDESLIGAMENTO_PTPDEMISSAOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDPOSICAOORIGEM int 4 √ null
VPOSICAO.IDPOSICAO FKVREQDESLIGAMENTO_VPOSICAOR

Indexes

Constraint Name Type Sort Column(s)
PKVREQDESLIGAMENTO Primary key Asc/Asc CODCOLREQUISICAO + IDREQ

Relationships

Close relationships within degrees of separation