cfoppedido


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcfoppedido int8 19 null
cfoppedido_aud.idcfoppedido Implied Constraint R
idcfop int8 19 null
cfop.idcfop fk_5hpnhnhlixv5o40dr60bl85ly R
idpedido int8 19 null
pedido.idpedido fk_jbf30wooqw5d33air3s5x5px5 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk9ea055e9 Primary key Asc idcfoppedido
idx269d994a Performance Asc idpedido
idx50c5f8e4 Performance Asc idcfop
idxwsversao_9ea055e9 Performance Desc wsversao
ucc788d9d1 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation