cfoptipopedido


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcfoptipopedido int8 19 null
cfoptipopedido_aud.idcfoptipopedido Implied Constraint R
idcfop int8 19 null
cfop.idcfop fk_cxo2wogov92uf4x8y3spuqxyo R
idtipopedido int8 19 null
tipopedido.idtipopedido fk_nk4wlju1g2uawqd99tim2vtv6 R
idnpadrao int2 5 √ null
descricao varchar 80 null
idlocalfilial int8 19 √ null
local.idlocal fk_s8j46v59is186abj7xvm1emhh R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk24ed6c3d Primary key Asc idcfoptipopedido
idx675bf657 Performance Asc idtipopedido
idx9b9deff5 Performance Asc idcfop
idxb7ca1dd0 Performance Asc idlocalfilial
idxwsversao_24ed6c3d Performance Desc wsversao
uc26d39c9d 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.