PMOTDEMISSAO

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFUNC_PMOTDEMISSAOR
PMOTIVDEMISSAOCLI.CODCOLIGADA FKPMOTIVDEMISSAOCLI_PMOTDEMISSR
PORCAMENTODEMISSAO.CODCOLIGADA FKPORCAMENTODEMISSAO_PMOTDEMISR
PORCAMENTOLOTACAOCAD.CODCOLIGADA FKPORCAMENTOLOTACAOCAD_PMOTDEMR
PORCAMENTOLOTACAOFUNC.CODCOLIGADA FKPORCAMENTOLOTACAOFUNC_PMOTDER
PORCAMENTOTRANSFERENCIA.CODCOLIGADA FKPORCAMENTOTRANSFERENCIA_PMOTR
VREQDESLIGAMENTO.CODCOLREQUISICAO FKVREQDESLIGAMENT_PMOTDEMISSAOR
VREQDESLIGAMENTOPARECER.CODCOLREQUISICAO FKVREQDESLPARECER_PMOTDEMISSAOR
GCOLIGADA.CODCOLIGADA FKPMOTDEMISSAO_GCOLIGADAR
CODCLIENTE varchar 5 null
PFUNC.MOTIVODEMISSAO FKPFUNC_PMOTDEMISSAOR
PMOTIVDEMISSAOCLI.CODTOTVS FKPMOTIVDEMISSAOCLI_PMOTDEMISSR
PORCAMENTODEMISSAO.CODMOTIVO FKPORCAMENTODEMISSAO_PMOTDEMISR
PORCAMENTOLOTACAOCAD.MOTIVODEMISSAO FKPORCAMENTOLOTACAOCAD_PMOTDEMR
PORCAMENTOLOTACAOFUNC.MOTIVODEMISSAO FKPORCAMENTOLOTACAOFUNC_PMOTDER
PORCAMENTOTRANSFERENCIA.CODMOTIVO FKPORCAMENTOTRANSFERENCIA_PMOTR
VREQDESLIGAMENTO.CODMOTRESCISAO FKVREQDESLIGAMENT_PMOTDEMISSAOR
VREQDESLIGAMENTOPARECER.CODMOTRESCISAO FKVREQDESLPARECER_PMOTDEMISSAOR
CODINTERNO varchar 5 null
DESCRICAO varchar 50 √ null
PODEALTERAR 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)
PKPMOTDEMISSAO Primary key Asc/Asc CODCOLIGADA + CODCLIENTE
PXMOTDEMISSAO Performance Asc CODCLIENTE

Relationships

Close relationships within degrees of separation