pedidocomplementocampo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpedidocomplementocampo int8 19 null
pedidocomplementocampo_aud.idpedidocomplementocampo Implied Constraint R
idpedido int8 19 null
pedido.idpedido fk_5upp1st3t6a9bw4an8rcgaxus R
idwsconfigcampo int8 19 null
wsconfigcampo.idwsconfigcampo fk_fid3jb4h1f46bujj0pdhd75u7 R
valor varchar 5000 null
idnobrigatorio int2 5 null
ordem int8 19 null
codigoerp varchar 80 null
wsversao int8 19 null

Table contained 17 rows

Indexes

Constraint Name Type Sort Column(s)
pkfabfa20a Primary key Asc idpedidocomplementocampo
idx1e6811be Performance Asc idwsconfigcampo
idxd3f774ca Performance Asc idpedido
idxwsversao_fabfa20a Performance Desc wsversao
uccb0840d0 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.