operacaolocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaolocal int8 19 null
operacaolocal_aud.idoperacaolocal Implied Constraint R
idoperacao int8 19 null
operacao.idoperacao fk_fcfg1664wctlt4menmpmrwe0i R
idlocal int8 19 √ null
local.idlocal fk_kek2alv34pu26e9d1dcb50sp2 R
idusuario int8 19 √ null
usuario.idusuario fk_2ehtyao2iqe3cewhdycwptbjh R
valor numeric 18,6 null
percentualbasecalculo numeric 18,6 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
observacao varchar 4000 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_n9v6rq4fx6dqvpl2abrjdir8u R
idsegmento int8 19 √ null
segmento.idsegmento fk_k4ufaw0eeex3ovdr6mqum5suw R
idunidadefedorigem int8 19 √ null
unidadefederativa.idunidadefederativa fk_qvy1l1etvg2p8imqevln04flq R
idunidadefeddestino int8 19 √ null
unidadefederativa.idunidadefederativa fk_e61cs2wi25bw18b85ocxpfq4p R
codigo varchar 20 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparceiro int8 19 √ null
parceiro.idparceiro fk_cvn8qmtl1coh82nvvkto9ybm4 R
idtipologia int8 19 √ null
tipologia.idtipologia fk_8v6y187d1vbvx9qt064jxsb15 R

Indexes

Constraint Name Type Sort Column(s)
pka621facd Primary key Asc idoperacaolocal
idx12af61a6 Performance Asc idusuario
idx42fba30 Performance Asc idlocalfilial
idx56b97323 Performance Asc idsegmento
idx5915c701 Performance Asc idparceiro
idx9f7ca465 Performance Asc idunidadefeddestino
idxb29f1e26 Performance Asc idoperacao
idxbabe6263 Performance Asc idtipologia
idxd0056785 Performance Asc idunidadefedorigem
idxfe9f2452 Performance Asc idlocal
idxwsversao_a621facd Performance Desc wsversao
uc79ba1e2f Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation