wagrpedido


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idwagrpedido int8 19 null
wagrpedido_aud.idwagrpedido Implied Constraint R
pedido.idpedido fk_q4g9s0j95p0bw4wtfvj1q5dng R
datadeterminada date 13 √ null
datacotacao date 13 √ null
idnliberacd int2 5 null
idnicmsembutido int2 5 null
quantidade numeric 18,6 √ null
idcultura int8 19 √ null
cultura.idcultura fk_sanjiq0fptuo4wrqcau5uql8j R
idindexador int8 19 √ null
indexador.idindexador fk_88tgnani4u6swa5j59cvtnsgt R
idcfop int8 19 √ null
cfop.idcfop fk_nkmlde93koykjajcef1jxpaud R
idsafra int8 19 √ null
safra.idsafra fk_n6vb75qxwl38h3r09cyteums4 R
idparceirobanco int8 19 √ null
parceiro.idparceiro fk_89anacucu84v3wcsbk89u4l73 R
idcondicaopagtooriginal int8 19 √ null
condicaopagamento.idcondicaopagamento fk_8rcjmoi0nxas2sr5mqn3dupw R
percrefugioatendido numeric 18,6 √ null
idprojetoagricolaarea int8 19 √ null
projetoagricolaarea.idprojetoagricolaarea fk_gqjouaye5g2cp2a8g9bnwdkqv R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk92b714da Primary key Asc idwagrpedido
idx2fa286a5 Performance Asc idcondicaopagtooriginal
idxa2cffb7 Performance Asc idindexador
idxc47cc98e Performance Asc idparceirobanco
idxd7728a3 Performance Asc idsafra
idxeffb0848 Performance Asc idprojetoagricolaarea
idxfc2d5042 Performance Asc idcultura
idxfee29047 Performance Asc idcfop
idxwsversao_92b714da Performance Desc wsversao
uc5d482e80 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.