localtipodesconto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipodesconto int8 19 null
localtipodesconto_aud.idlocaltipodesconto Implied Constraint R
idtipodesconto int8 19 null
tipodesconto.idtipodesconto fk_71pai68d5mjb8k8fouwc5y6g3 R
idlocal int8 19 √ null
local.idlocal fk_l5qb1jfsbbfiu831e4rgo7hjj R
idlocalfilial int8 19 √ null
local.idlocal fk_oxe9cpn9fstm2vtan3cb3ph55 R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_lqvmt39thmcjd33ga2p0yq9db R
idtipocobranca int8 19 √ null
tipocobranca.idtipocobranca fk_oiskhbo56rlicuggutcojkl24 R
idcondicaopagamento int8 19 √ null
condicaopagamento.idcondicaopagamento fk_eypkjponav8hgv0khusm3i750 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_rsl2kfqccciolvtrwurvojuoy R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_5hfscgidp6s3vhbk3n2ho9sm4 R
idusuario int8 19 √ null
usuario.idusuario fk_s4saeub98mt96b3ayv44jmq0x R
idsegmento int8 19 √ null
segmento.idsegmento fk_m121a3q9n7vkihhf4gwd6x6gu R
idtipologia int8 19 √ null
tipologia.idtipologia fk_34r8u7yfjuqm92idfq8ebarf5 R
idgrupoparceiro int8 19 √ null
grupoparceiro.idgrupoparceiro fk_on0cx2xw3g4ppuapll9dejov2 R
idoperacao int8 19 √ null
operacao.idoperacao fk_nfscj9l91pj69wubtitni225b R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pkb7465cea Primary key Asc idlocaltipodesconto
idx2aa69878 Performance Asc idcondicaopagamento
idx37e72a0f Performance Asc idtabelapreco
idx3c042b6b Performance Asc idtipocobranca
idx62c15161 Performance Asc idlocalfilial
idx742fbdd0 Performance Asc idsegmento
idxae1ffb92 Performance Asc idgrupoparceiro
idxba8273c6 Performance Asc idparceiro
idxbae7c99e Performance Asc idlocal
idxc84fe935 Performance Asc idusuario
idxe4d7ca45 Performance Asc idtipopedido
idxeda4095d Performance Asc idtipodesconto
idxf346efb3 Performance Asc idoperacao
idxfdc25b1f Performance Asc idtipologia
idxwsversao_b7465cea Performance Desc wsversao
ucea3a5712 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.