pedidotipodesconto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpedidotipodesconto int8 19 null
pedidotipodesconto_aud.idpedidotipodesconto Implied Constraint R
idtipodesconto int8 19 null
tipodesconto.idtipodesconto fk_21k0qfvalo4rv0254poq67vxt R
idpedido int8 19 null
pedido.idpedido fk_k3nmchh2d3yrhxd4pv19omh1n R
percentual numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
valor numeric 18,6 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pke0761a04 Primary key Asc idpedidotipodesconto
idxb7dd8597 Performance Asc idtipodesconto
idxeaeda2a1 Performance Asc idpedido
idxwsversao_e0761a04 Performance Desc wsversao
uc937c52d6 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.