localcondicaopagamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalcondicaopagamento int8 19 null
localcondicaopagamento_aud.idlocalcondicaopagamento Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_telhd6evqwjrwoxyffpy44bju R
idcondicaopagamento int8 19 null
condicaopagamento.idcondicaopagamento fk_ialunxlce7i1gdt31hcrag274 R
idusuario int8 19 √ null
usuario.idusuario fk_jja8kkd30gqskdtfiv2uh6kdr R
idlocalfilial int8 19 √ null
local.idlocal fk_t857q2f27e8cp5pi6mrfn02u5 R
idnregraespecial int2 5 √ null
idnpadrao int2 5 null
idsegmento int8 19 √ null
segmento.idsegmento fk_65kbecwlif85rb2g91ci15xvq R
idparceiro int8 19 √ null
parceiro.idparceiro fk_9uv80xit0k46twjtjyv5tobsd R
percentualjuros numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
prazomaximo numeric 18,6 √ null
idgrupocondpagto int8 19 √ null
grupocondpagto.idgrupocondpagto fk_rqa6qdpq8e2ws236q9nnrh74i R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_kko80puejla3dckpubpo3edjv R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_8en5rd90n3ifir40pgj4owndk R
idcultura int8 19 √ null
cultura.idcultura fk_mhmq77v8cjf9498odnjvpbjmd R
idsafra int8 19 √ null
safra.idsafra fk_2q25g1kgg4xlb3nnch7lnyro1 R

Table contained 160 rows

Indexes

Constraint Name Type Sort Column(s)
pk60518151 Primary key Asc idlocalcondicaopagamento
idx1f692441 Performance Asc idlocalfilial
idx440e9ff3 Performance Asc idlocal
idx4a384b3b Performance Asc idsafra
idx79ac3f15 Performance Asc idparceiro
idx9772c07 Performance Asc idtabelapreco
idxca219d18 Performance Asc idgrupocondpagto
idxd2c5226e Performance Asc idtipopedido
idxd56f4188 Performance Asc idcultura
idxdbd06777 Performance Asc idusuario
idxe1b89cd1 Performance Asc idcondicaopagamento
idxef493b0f Performance Asc idsegmento
idxwsversao_60518151 Performance Desc wsversao
ucba4fa0a9 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.