operacaouf


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaouf int8 19 null
operacaouf_aud.idoperacaouf Implied Constraint R
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
percentualbasecalculo numeric 18,6 √ null
valorminimo numeric 18,6 √ null
valormaximo numeric 18,6 √ null
valor numeric 18,6 √ null
codigo varchar 20 √ null
descricao varchar 80 √ null
quantidademinima numeric 18,6 √ null
quantidademaxima numeric 18,6 √ null
idunidadefederativa int8 19 null
unidadefederativa.idunidadefederativa fk_ay3b02l9j9ul8ck31p9ss0d58 R
idsegmento int8 19 √ null
segmento.idsegmento fk_3keq7s2ypac2e80xk5jayhi6u R
idoperacao int8 19 null
operacao.idoperacao fk_sep0j1x3jwge6ntbpuel2iyrk R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk761e7e4f Primary key Asc idoperacaouf
idx5d17c1c8 Performance Asc idunidadefederativa
idx5ec2e0fc Performance Asc idsegmento
idxff7165f0 Performance Asc idoperacao
idxwsversao_761e7e4f Performance Desc wsversao
uc9c737b2b Must be unique Asc codigoerp

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.