Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
int8
19
null
dataultimopedido
date
13
√
null
dataultimanotafiscal
date
13
√
null
dataultimoatendimento
date
13
√
null
idnpositivado
int2
5
√
null
codigoerp
varchar
80
√
null
wsversao
int8
19
√
null
idparceiro
int8
19
√
null
parceiro .idparceiro
Implied Constraint R
idlocal
int8
19
√
null
local .idlocal
Implied Constraint R
idpedido
int8
19
√
null
pedido .idpedido
Implied Constraint R
idnotafiscal
int8
19
√
null
idatendimento
int8
19
√
null
idusuario
int8
19
√
null
usuario .idusuario
Implied Constraint R
idparceiropositivacao
int8
19
√
null
rev
int8
19
√
null
revtype
int8
19
√
null
Table contained 0 rows
Constraint Name
Type
Sort
Column(s)
pka4ba862a
Primary key
Asc
id
idxwsversao_a4ba862a
Performance
Desc
wsversao
×
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 .