mix


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmix int8 19 null
mix_aud.idmix Implied Constraint R
mixlocal.idmix fk_c7psxvg4ix4oqqccgqgw8gs27 R
mixlocal_aud.idmix Implied Constraint R
mixpremiacao.idmix fk_h53vt3e6jk3u4866cbdhpgeqn R
mixpremiacao.idmixpremio fk_gsav1917fartfo5thy1xtvpp2 R
mixpremiacao_aud.idmix Implied Constraint R
mixproduto.idmix fk_na1nol080jwxhro57rks53v2i R
mixproduto_aud.idmix Implied Constraint R
mixtipologia.idmix fk_d92dq80giga2bh21bt0xisrib R
mixtipologia_aud.idmix Implied Constraint R
mixusuario.idmix fk_ahkp7dfpvh2sibmkwksemwusq R
mixusuario_aud.idmix Implied Constraint R
operacaomix.idmix fk_kvgqvro2auc1s5sbyclpwjx88 R
operacaomix_aud.idmix Implied Constraint R
pedidoproduto.idmix fk_8yesdq8qo18t2yhhl3nflnohs R
pedidoproduto_aud.idmix Implied Constraint R
pedidoprodutogradev2.idmix fk_jn9dslcpbo1w3x25u8mjtfjcg R
pedidoprodutogradev2_aud.idmix Implied Constraint R
produto.idmix fk_198muvxdjmrjsybn3amn59fay R
produto_aud.idmix Implied Constraint R
tabelaprecoproduto.idmix fk_2eueoqtbdq7j6vtrint09q530 R
tabelaprecoproduto_aud.idmix Implied Constraint R
datainiciovigencia date 13 null
datafimvigencia date 13 null
descricao varchar 80 null
sigla varchar 20 √ null
codigoerp varchar 80 √ null
idsegmento int8 19 √ null
segmento.idsegmento fk_44j0l6785did7c12lo9jol8h3 R
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk12e3c Primary key Asc idmix
idx192d17f0 Performance Asc idsegmento
idxwsversao_12e3c Performance Desc wsversao
ucc94c6080 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation