campdescrestricao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcampdescrestricao int8 19 null
campdescrestricao_aud.idcampdescrestricao Implied Constraint R
idfilial int8 19 √ null
local.idlocal fk_e6vmb2qrpf82fjhahvcrrrl0c R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_g99jpjas83n3g6w3nd9pl2td3 R
idsegmento int8 19 √ null
segmento.idsegmento fk_nlnc5kqkt3d4ulqdt7tpy9hl5 R
idusuario int8 19 √ null
usuario.idusuario fk_lhvgyoqmol1kttf59oma58tva R
idusuariosuperior int8 19 √ null
usuario.idusuario fk_4g3p5wjvylb7qiywq59wevuwy R
idparceiro int8 19 √ null
parceiro.idparceiro fk_m8ucso4uq4jxxlntd9bsk4m11 R
idgrupousuario int8 19 √ null
grupousuario.idgrupousuario fk_c1wthy65fwh3j1nul2uas86im R
idcondicaopagamento int8 19 √ null
condicaopagamento.idcondicaopagamento fk_rwao9pv8lywxd8ete2223ei8l R
idcampanhadesconto int8 19 √ null
campanhadesconto.idcampanhadesconto fk_137pis0g8g45edctdmtjxerle R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk70ce5e34 Primary key Asc idcampdescrestricao
idx198cfe33 Performance Asc idusuario
idx24183729 Performance Asc idcampanhadesconto
idx6066696e Performance Asc idusuariosuperior
idxaf935583 Performance Asc idparceiro
idxc23ef5e7 Performance Asc idcondicaopagamento
idxd2567b9c Performance Asc idsegmento
idxd7e29424 Performance Asc idgrupousuario
idxdf7d502 Performance Asc idfilial
idxfc5f0b9c Performance Asc idtabelapreco
idxwsversao_70ce5e34 Performance Desc wsversao
uc851a588 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation