campanhadescontorestricao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcampanhadescontorestricao int8 19 null
campanhadescontorestricao_aud.idcampanhadescontorestricao Implied Constraint R
idfilial int8 19 √ null
local.idlocal fk_306qta48x8ii6gqrg89txgjp2 R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_630jkldxbr3pwh6cp59lct7j6 R
idsegmento int8 19 √ null
segmento.idsegmento fk_5ow5xmlrfh2fr9bp8xar8tc4c R
idusuario int8 19 √ null
usuario.idusuario fk_aexygvyx009l17gma9ef1fy2i R
idparceiro int8 19 √ null
parceiro.idparceiro fk_edpmmtxqcwfrfnqd50317ys1i R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_b15m9trewb31g07rjle7p5213 R
idcampanhadesconto int8 19 √ null
campanhadesconto.idcampanhadesconto fk_dpmor10tv83uj250tr5jof9vb R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk25109334 Primary key Asc idcampanhadescontorestricao
idx1e8e0b1f Performance Asc idparceiro
idx31bfb80d Performance Asc idsegmento
idx31f95a36 Performance Asc idusuario
idx4e16a5a9 Performance Asc idtabelapreco
idx577a8f9f Performance Asc idgrupousuario
idx61d1c189 Performance Asc idcampanhadesconto
idxb62ab9fc Performance Asc idfilial
idxwsversao_25109334 Performance Desc wsversao
uc8a944f88 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.