faixastipodesconto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idfaixastipodesconto int8 19 null
faixastipodesconto_aud.idfaixastipodesconto Implied Constraint R
idtipodesconto int8 19 null
tipodesconto.idtipodesconto fk_i92mghcjxjxjhlp9k65kegpwr R
sgltipovalidacao varchar 30 null
minimo numeric 18,6 null
sgllogicaexcederminimo varchar 10 √ null
idtipoaprovacaominimo int8 19 √ null
tipoaprovacao.idtipoaprovacao fk_i03x7ikt9cfc84lu42tbbn33i R
maximo numeric 18,6 null
sgllogicaexcedermaximo varchar 10 √ null
idtipoaprovacaomaximo int8 19 √ null
tipoaprovacao.idtipoaprovacao fk_tkkx047n4iur58hlwrbsj8nb2 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkb043191b Primary key Asc idfaixastipodesconto
idx11016112 Performance Asc idtipoaprovacaomaximo
idx9e50572a Performance Asc idtipodesconto
idxf806aa64 Performance Asc idtipoaprovacaominimo
idxwsversao_b043191b Performance Desc wsversao
uc5f2d11f 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.