localtipofrete


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipofrete int8 19 null
localtipofrete_aud.idlocaltipofrete Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_br2rka3d3mqxqnnq20kqlafr7 R
idtipofrete int8 19 null
tipofrete.idtipofrete fk_r35xau4ytxpwt1la63qcopxbk R
idlocalfilial int8 19 √ null
local.idlocal fk_r3vn2tvs5tgn0tele27uvpfdg R
idsegmento int8 19 √ null
segmento.idsegmento fk_g63t1rc9ssgsg2b7msqlwxd3q R
idcidade int8 19 √ null
cidade.idcidade fk_69ev3w102hhho4d6jxs0fp53w R
idnpadrao int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparceiro int8 19 √ null
parceiro.idparceiro fk_irho2iwukm44co5dyrsoscwqb R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_5720ei0ah0od0xn2druk8i4oh R

Indexes

Constraint Name Type Sort Column(s)
pk14018b6b Primary key Asc idlocaltipofrete
idx49f9e213 Performance Asc idsegmento
idx8565f3e6 Performance Asc idcidade
idxa81a553d Performance Asc idtipofrete
idxb48a5d20 Performance Asc idlocal
idxb8bf6087 Performance Asc idparceiro
idxeb4508c0 Performance Asc idtabelapreco
idxffe2f081 Performance Asc idlocalfilial
idxwsversao_14018b6b Performance Desc wsversao
ucef926fcf Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation