VTABSALARIAIS

9 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNC.CODCOLIGADA FKPFUNC_VTABSALARIAISR
PORCAMENTOLOTACAOCAD.CODCOLIGADA FKPORCAMENTOLOTACAOCAD_VTABSALR
PORCAMENTOLOTACAOCADHST.CODCOLIGADA FKPORCAMENTOLOTACAOCADHST_VTABR
PORCAMENTOLOTACAOFUNC.CODCOLIGADA FKPORCAMENTOLOTACAOFUNC_VTABSAR
VALTDADFUNCPROG.CODCOLIGADA FKVALTDADFUNCPROG_VTABSALARIAIR
VHISTORICOTABELASALARIAL.CODCOLIGADA FKVHISTTABELASAL_VTABSSALR
VHISTTABELASALARIAL.CODCOLIGADA FKVHISTTABELASALARIAL_VTABSALR
VLOTACAO.CODCOLIGADA FKVLOTACAO_VTABSALARIAISR
VMAPACONHECIMENTOCOMPETENCIA.CODCOLIGADA FKVMAPACONHECCOMP_TABSALARIALR
VMAPACONHECIMENTOREQACESSO.CODCOLIGADA FKVMAPACONHECREQ_TABSALARIALR
VNIVEISTABSALARIAIS.CODCOLIGADA FKVNIVEISTABSAL_VTABSALARIAISR
VREQAUMENTOQUADRO.CODCOLREQUISICAO FKVREQAUMENTOQUA_VTABSALARIAISR
VREQAUMENTOQUADROPARECER.CODCOLREQUISICAO FKVREQAUMQUADPAR_VTABSALARIAISR
VREQPROMOCAO.CODCOLREQUISICAO FKVREQPROMOCA_VTABSALARIAISORGR
VREQPROMOCAOPARECER.CODCOLREQUISICAO FKVREQPROPARECER_VTABSALARIAISR
VREQSUBSTITUICAO.CODCOLREQUISICAO FKVREQSUBSTITUI_VTABSALARIAISR
VREQSUBSTITUICAOPARECER.CODCOLREQUISICAO FKVREQSUBSTPAREC_VTABSALARIAISR
VREQTRANSFPROMOCAO.CODCOLORG FKVREQTRANSFPROM_VTABSALORGR
VREQTRANSFPROMOCAO.CODCOLREQUISICAO FKVREQTRANSFPROM_VTABSALARIAISR
VREQTRANSFPROMOCAOPARECER.CODCOLREQUISICAO FKVREQTRANSFPROPARECER_VTABSALR
VTABELACARGO.CODCOLIGADA FKVTABELACARGO_VTABSALARIAISR
VTRANSFALTDADFUNCPROG.CODCOLIGADA FKVTRANSFALTDADFUNCPROG_VTABSAR
GFILIAL.CODCOLIGADA FKVTABSALARIAIS_GFILIALR
CODTABELA varchar 10 null
PFUNC.CODTABELASALARIAL FKPFUNC_VTABSALARIAISR
PORCAMENTOLOTACAOCAD.CODTABELASALARIAL FKPORCAMENTOLOTACAOCAD_VTABSALR
PORCAMENTOLOTACAOCADHST.CODTABELASALARIAL FKPORCAMENTOLOTACAOCADHST_VTABR
PORCAMENTOLOTACAOFUNC.CODTABELASALARIAL FKPORCAMENTOLOTACAOFUNC_VTABSAR
VALTDADFUNCPROG.CODTABSALALT FKVALTDADFUNCPROG_VTABSALARIAIR
VHISTORICOTABELASALARIAL.CODTABELA FKVHISTTABELASAL_VTABSSALR
VHISTTABELASALARIAL.CODTABELA FKVHISTTABELASALARIAL_VTABSALR
VLOTACAO.CODTABELA FKVLOTACAO_VTABSALARIAISR
VMAPACONHECIMENTOCOMPETENCIA.CODTABELASALARIAL FKVMAPACONHECCOMP_TABSALARIALR
VMAPACONHECIMENTOREQACESSO.CODTABELASALARIAL FKVMAPACONHECREQ_TABSALARIALR
VNIVEISTABSALARIAIS.CODTABELA FKVNIVEISTABSAL_VTABSALARIAISR
VREQAUMENTOQUADRO.CODTABELASALARIAL FKVREQAUMENTOQUA_VTABSALARIAISR
VREQAUMENTOQUADROPARECER.CODTABELASALARIAL FKVREQAUMQUADPAR_VTABSALARIAISR
VREQPROMOCAO.CODTABELASALARIAL FKVREQPROMOCAO_VTABSALARIAISR
VREQPROMOCAO.CODTABELASALARIALORG FKVREQPROMOCA_VTABSALARIAISORGR
VREQPROMOCAOPARECER.CODTABELASALARIAL FKVREQPROPARECER_VTABSALARIAISR
VREQSUBSTITUICAO.CODTABELASALARIAL FKVREQSUBSTITUI_VTABSALARIAISR
VREQSUBSTITUICAOPARECER.CODTABELASALARIAL FKVREQSUBSTPAREC_VTABSALARIAISR
VREQTRANSFPROMOCAO.CODTABELASALARIAL FKVREQTRANSFPROM_VTABSALARIAISR
VREQTRANSFPROMOCAO.CODTABELASALARIALORG FKVREQTRANSFPROM_VTABSALORGR
VREQTRANSFPROMOCAOPARECER.CODTABELASALARIAL FKVREQTRANSFPROPARECER_VTABSALR
VTABELACARGO.CODTABELA FKVTABELACARGO_VTABSALARIAISR
VTRANSFALTDADFUNCPROG.CODTABSALALT FKVTRANSFALTDADFUNCPROG_VTABSAR
NOMETABELA varchar 40 √ null
OBSERVACOES MEMO 2147483647 √ null
HORISTA DLOGICO 2 null
CODFILIAL smallint 2 √ null
GFILIAL.CODFILIAL FKVTABSALARIAIS_GFILIALR
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)
PKVTABSALARIAIS Primary key Asc/Asc CODCOLIGADA + CODTABELA

Relationships

Close relationships within degrees of separation