pedidolog


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpedidolog int8 19 null
pedidolog_aud.idpedidolog Implied Constraint R
idpedido int8 19 null
pedido.idpedido fk_8itke4e2ges05fl108nm5i4nq R
idobservacaopedido int8 19 √ null
observacaopedido.idobservacaopedido fk_tf713vg5rwgkltpwm7yyha0eq R
idusuario int8 19 √ null
usuario.idusuario fk_rj4ibkbshw8o4uikrprf375k5 R
data date 13 null
hora varchar 10 null
idnexportadoerp int2 5 null
log bytea 2147483647 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idtiposituacaopedido int8 19 √ null
tiposituacaopedido.idtiposituacaopedido fk_il27a6jd5fn3r9airs45uayup R
observacao varchar 4000 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkb40a319f Primary key Asc idpedidolog
idx2dad388d Performance Asc idpedido
idx5cf3def0 Performance Asc idtiposituacaopedido
idx763f46ca Performance Asc idobservacaopedido
idx87583b9f Performance Asc idusuario
idxwsversao_b40a319f Performance Desc wsversao
uc6ff74d1d 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.