pedidopagamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpedidopagamento int8 19 null
observacaopagamento.idpedidopagamento fk_sx4xih67iyknbk770ah3ru0hv R
observacaopagamento_aud.idpedidopagamento Implied Constraint R
pedidopagamento_aud.idpedidopagamento Implied Constraint R
datahoracriacao timestamp 29,6 null
datahoraatualizacao timestamp 29,6 √ null
tokentransacao varchar 200 null
idtiposituacaopagamento int8 19 null
tiposituacaopagamento.idtiposituacaopagamento fk_ly3ewn4iv1pu2s748c09s6770 R
valor numeric 18,6 null
imagem bytea 2147483647 √ null
link varchar 200 √ null
codigopagamento varchar 400 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idpedido int8 19 null
pedido.idpedido fk_jn5o5j7dtgmm8n1m3anp5rlnx R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk3f573141 Primary key Asc idpedidopagamento
idx52541076 Performance Asc idtiposituacaopagamento
idxa36d186a Performance Asc idpedido
idxwsversao_3f573141 Performance Desc wsversao
uca8aac7fb 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.