rastreamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idrastreamento int8 19 null
rastreamento_aud.idrastreamento Implied Constraint R
idpedido int8 19 null
pedido.idpedido fk_7duclgxd8jdgqet2kpfkv3uhi R
numeropedido varchar 80 √ null
aprovacaopedido varchar 80 √ null
statuspedido varchar 80 √ null
pedidoreprovado varchar 80 √ null
embarque varchar 80 √ null
transporte varchar 80 √ null
entrega varchar 80 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk9a5fd7f3 Primary key Asc idrastreamento
idx8cd8888c Performance Asc idpedido
idxwsversao_9a5fd7f3 Performance Desc wsversao
uca4585447 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation