operacaopedidoentrega


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaopedidoentrega int8 19 null
operacaopedidoentrega_aud.idoperacaopedidoentrega Implied Constraint R
sgltipotransporte varchar 10 √ null
valor numeric 18,6 √ null
pesomin numeric 18,6 √ null
pesomax numeric 18,6 √ null
idncargafechada int2 5 null
idoperacao int8 19 null
operacao.idoperacao fk_3rfg0rpaeh0st9fm1ncngnfw1 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk957ac815 Primary key Asc idoperacaopedidoentrega
idxaad5ba12 Performance Asc idoperacao
idxwsversao_957ac815 Performance Desc wsversao
ucf4ab40c7 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation