campbrinderestricao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcampbrinderestricao int8 19 null
campbrinderestricao_aud.idcampbrinderestricao Implied Constraint R
sgltiporestricao varchar 10 √ null
idcampanhabrinde int8 19 √ null
campanhabrinde.idcampanhabrinde fk_dp4qgkjm3kjomcrjry28yfipo R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_7tb94fmd85d5yvbihbmmara76 R
idregiao int8 19 √ null
regiao.idregiao fk_sq3ltxwfsh5d4vad069qrra9g R
idgrupoparceiro int8 19 √ null
grupoparceiro.idgrupoparceiro fk_odgh4tcwago22vfao8v33igtn R
idparceiro int8 19 √ null
parceiro.idparceiro fk_ljl76tykd1s9hoaf01v6wp7wg R
idlocalprincipal int8 19 √ null
local.idlocal fk_g0tkbq1a05xmyi8eklc1jg73m R
idlocalfilial int8 19 √ null
local.idlocal fk_daukfqnjmboayqxp4pr0muk44 R
idsegmento int8 19 √ null
segmento.idsegmento fk_141qvvb4ayixx7tnecu9coyem R
idsupervisor int8 19 √ null
usuario.idusuario fk_2gm45posiuwwt6whb0dvu7iu3 R
sglclassevenda varchar 10 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
gruporegra int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkcc52f1ef Primary key Asc idcampbrinderestricao
idx13ecead5 Performance Asc idlocalprincipal
idx1da6595e Performance Asc idlocalfilial
idx2b812c39 Performance Asc idgrupoparceiro
idx66aedebb Performance Asc idparceiro
idx6d87494c Performance Asc idtabelapreco
idx7f1adde4 Performance Asc idregiao
idxaddaa7e4 Performance Asc idsegmento
idxae72b8d1 Performance Asc idsupervisor
idxbbe63419 Performance Asc idcampanhabrinde
idxwsversao_cc52f1ef Performance Desc wsversao
ucb010956d 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.