PSINDIC

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFHSTCSD.CODCOLIGADA FKPFHSTCSD_PSINDICR
PFHSTMINSINDIC.CODCOLIGADA FKPFHSTMINSINDIC_PSINDICR
PFUNC.CODCOLIGADA FKPFUNC_PSINDICFILIACAOR
PORCAMENTOADMISSAO.CODCOLIGADA FKPORCAMENTOADMISSAO_PSINDICR
PORCAMENTOLOTACAOCAD.CODCOLIGADA FKPORCAMENTOLOTACAOCAD_PSINDICR
PORCAMENTOLOTACAOCADHST.CODCOLIGADA FKPORCAMENTOLOTACAOCADHST_PSINR
PORCAMENTOLOTACAOFUNC.CODCOLIGADA FKPORCAMENTOLOTACAOFUNC_PSINDIR
PSINDEVT.CODCOLIGADA FKPSINDEVT_PSINDICR
PSINDFERIADO.CODCOLIGADA FKPSINDFERIADO_PSINDICR
PSINDHSTSALMIN.CODCOLIGADA FKPSINDHSTSALMIN_PSINDICR
PSINDICPT.CODCOLIGADA FKPSINDICPT_PSINDICR
PSINDMED.CODCOLIGADA FKPSINDMED_PSINDICR
PSINDREMBASE.CODCOLIGADA FKPSINDREMBASE_PSINDICR
PSINDVAL.CODCOLIGADA FKPSINDVAL_PSINDICR
VPOSICAO.CODCOLIGADA FKVPOSICAO_PSINDICR
GCOLIGADA.CODCOLIGADA FKPSINDIC_GCOLIGADAR
GFORMULA.CODCOLIGADA FKPSINDIC_GFORMULAR
CODIGO varchar 10 null
PFHSTCSD.CODSINDICATO FKPFHSTCSD_PSINDICR
PFHSTMINSINDIC.CODSINDICATO FKPFHSTMINSINDIC_PSINDICR
PFUNC.CODSINDICATO FKPFUNC_PSINDICR
PFUNC.CODSINDICATOFILIACAO FKPFUNC_PSINDICFILIACAOR
PORCAMENTOADMISSAO.CODSINDICATO FKPORCAMENTOADMISSAO_PSINDICR
PORCAMENTOLOTACAOCAD.CODSINDICATO FKPORCAMENTOLOTACAOCAD_PSINDICR
PORCAMENTOLOTACAOCADHST.CODSINDICATO FKPORCAMENTOLOTACAOCADHST_PSINR
PORCAMENTOLOTACAOFUNC.CODSINDICATO FKPORCAMENTOLOTACAOFUNC_PSINDIR
PSINDEVT.CODSINDICATO FKPSINDEVT_PSINDICR
PSINDFERIADO.CODSINDICATO FKPSINDFERIADO_PSINDICR
PSINDHSTSALMIN.CODSINDICATO FKPSINDHSTSALMIN_PSINDICR
PSINDICPT.CODIGO FKPSINDICPT_PSINDICR
PSINDMED.CODSINDICATO FKPSINDMED_PSINDICR
PSINDREMBASE.CODSINDICATO FKPSINDREMBASE_PSINDICR
PSINDVAL.CODSINDICATO FKPSINDVAL_PSINDICR
VPOSICAO.CODSINDICATO FKVPOSICAO_PSINDICR
NOME varchar 120 √ null
RUA varchar 100 √ null
NUMERO varchar 8 √ null
COMPLEMENTO DCOMPLEMENTO 60 √ null
BAIRRO DBAIRRO 80 √ null
ESTADO varchar 2 √ null
GETD.CODETD FKPSINDIC_GETDR
CIDADE DCIDADE 32 √ null
CEP DCEP 9 √ null
PAIS varchar 16 √ null
SALARIOMINIMO RMDVALOR2 17,2 √ null
PERCENTVALETR RMDVALOR2 17,2 √ null
DESCUNICOVALETR DLOGICO 2 (0)
USA30DIASVALETR DLOGICO 2 (0)
DESCCONTRIBMESADM DLOGICO 2 (0)
MEDIAMESRESCISAO DLOGICO 2 (0)
PAGAFERIASPROP DLOGICO 2 (0)
MINIMOFERPROPORC smallint 2 √ null
CONSIDANOANTERIOR DLOGICO 2 (0)
PAGAMEDIA1APARC DLOGICO 2 (0)
IGNORAEVTFERMEDIA DLOGICO 2 (0)
MENOR18PARTIDAS DLOGICO 2 (0)
MAIOR50PARTIDAS DLOGICO 2 (0)
LICENCAMENOS1ANO DLOGICO 2 (0)
PROPINTEGRAIS DLOGICO 2 (0)
VENCIDASINTEGRAIS DLOGICO 2 (0)
IGNORAFALTAS DLOGICO 2 (0)
PGFERPERFUTURO DLOGICO 2 (0)
MINIMOGARANTIDO RMDVALOR2 17,2 √ null
FORMTERCOCONSTIT varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORMULATCR
FORMBASEINDENIZ479 varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORMULABIR
FORMESTABILIDADE varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORMULAETR
GRUPOINSALUBRID smallint 2 √ null
APLICACAO varchar 1 √ ('P')
GFORMULA.APLICACAO FKPSINDIC_GFORGARANTIASALR
MESATUALMEDIAFERIAS DLOGICO 2 (0)
COMPARASALCOMISSAO DLOGICO 2 (0)
FORNUMDIASAVISO varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORNUMDIASAVISOR
FORGARANTIASAL varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORGARANTIASALR
MESATUALMEDIA13O smallint 2 √ (0)
CNPJ varchar 20 √ null
CODENTIDADE varchar 20 √ null
MESATUALMENOR15DIAS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIAMESADMMEDIAFERIAS smallint 2 √ (0)
DIAMESADMMEDIA13 smallint 2 √ (0)
DIAMESADMMEDIAAVISO smallint 2 √ (0)
USAMEDIAFERIASRESC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
TELEFONE varchar 15 √ null
NOMECONTATO varchar 45 √ null
TELEFONE1 varchar 15 √ null
USAMEDIA13RESC DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIASDEEXPERIENCIA int 4 √ null
CONSIDERAFORMADIC1APARC DLOGICO 2 (1)
COMPLETAPERFERIAS smallint 2 √ (0)
IGNORAFALTASFERIASNORMAIS smallint 2 √ (0)
PAGADIAFRACIONADOFERIASCOL smallint 2 √ (0)
NUMAGENCIA varchar 6 √ null
DIGAGENCIA varchar 2 √ null
CODCOLFORNEC DCODCOLIGADANULL 2 √ null
FCFO.CODCOLIGADA FKPSINDIC_FCFOR
CODFORNECEDOR varchar 25 √ null
FCFO.CODCFO FKPSINDIC_FCFOR
FORMACALCMEDIA13SAL smallint 2 (1)
FORMACALCMEDIAFERIAS smallint 2 (1)
FORMACALCMEDIAAVPREVIO smallint 2 (1)
CODFORMULADSR varchar 8 √ null
GFORMULA.CODIGO FKPSINDIC_GFORMULAR
DESCUSAMEDIA13RESCPROV DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
ANTECIPAFERIASPROXPER DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
PAGAFERIASPROPJUSTACAUSA DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CALCMEDCOMISSAOMES DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
IGNORAFERIADOSCONTAGEMFERIAS DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIAMESADMMEDIALICENCAMAT smallint 2 √ (0)
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
TPENTIDADESINDICAL smallint 2 √ null
USAPARMEDIACOMISSAO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
CALCMEDIADESCONTOAVISO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
MEDINSALUBCONSSALMINATUAL DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
LANCAINDADIC30DIASDTBASE DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DATABASECORRSALARIAL DDATETIME 16,3 √ null
IGNORAFERIADOCONTAGFERNORMAIS smallint 2 √ null
USAMEDIAREMBASEPROFESSOR DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
INSALUBCONSIDSALMINSIND DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0
DIADATABASE smallint 2 √ null
MESDATABASE smallint 2 √ null
NAOPAGARABONOFRACIONADO DLOGICONULL 2 √ CREATE DEFAULT DEF_DLOGICONULL AS 0

Indexes

Constraint Name Type Sort Column(s)
PKPSINDIC Primary key Asc/Asc CODCOLIGADA + CODIGO

Relationships

Close relationships within degrees of separation