operacaomix


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaomix int8 19 null
operacaomix_aud.idoperacaomix Implied Constraint R
valor numeric 18,6 null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
percentual numeric 18,6 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
observacao varchar 4000 √ null
idoperacao int8 19 null
operacao.idoperacao fk_8nsqu4m81cejqqw214vsjuyvc R
idmix int8 19 √ null
mix.idmix fk_kvgqvro2auc1s5sbyclpwjx88 R
idsegmento int8 19 √ null
segmento.idsegmento fk_phx71qfxhqi4h4f8ft8flogpk R
idlocalfilial int8 19 √ null
local.idlocal fk_5s2c0px1vts1dib2t0g75a0bq R
idregiao int8 19 √ null
regiao.idregiao fk_g97o22jrdlp1800j1illi4whr R
idunidadefederativa int8 19 √ null
unidadefederativa.idunidadefederativa fk_4hjsnu9bwv484in7g2lybdexx R
idcondicaopagamento int8 19 √ null
condicaopagamento.idcondicaopagamento fk_hl4rparjed8m3qo8em2mpx8ag R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk4db1323e Primary key Asc idoperacaomix
idx3b53b0f7 Performance Asc idregiao
idx4e95c103 Performance Asc idunidadefederativa
idx7e15ccf4 Performance Asc idlocalfilial
idx82cf8ad1 Performance Asc idoperacao
idx9ba07896 Performance Asc idmix
idxac169f2e Performance Asc idsegmento
idxe5fa653 Performance Asc idcondicaopagamento
idxwsversao_4db1323e Performance Desc wsversao
uc60641a9e Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation