pedidovinculocomissao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpedidovinculocomissao int8 19 null
pedidovinculocomissao_aud.idpedidovinculocomissao Implied Constraint R
percentualcomissao numeric 18,6 √ null
sglcomissao varchar 10 √ null
idpedido int8 19 null
pedido.idpedido fk_1vq1ghd82nhwrbtx3ct3ypba7 R
idlocal int8 19 √ null
local.idlocal fk_ip42jafleg7fspf6kwwko99ys R
idusuario int8 19 √ null
usuario.idusuario fk_1qhr3v5un2am5tnt3ibi5bc2r R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
datageracao date 13 √ null
datapagamento date 13 √ null
idnpago int2 5 null
valorbase numeric 18,6 √ null
valorcomissao numeric 18,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk283f27a1 Primary key Asc idpedidovinculocomissao
idx263007df Performance Asc idpedido
idx2ed25c7d Performance Asc idusuario
idxd3d55eef Performance Asc idlocal
idxwsversao_283f27a1 Performance Desc wsversao
uc515df0fb Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation