localtransportador


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltransportador int8 19 null
localtransportador_aud.idlocaltransportador Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_napqvm7lkviy5qdmvfjqlitp3 R
idtransportador int8 19 null
local.idlocal fk_4r8wtihnwttrsevw87da561sw R
idnpadrao int2 5 null
idlocalfilial int8 19 √ null
local.idlocal fk_967h3vv27usudd1cfqv346am4 R
idusuario int8 19 √ null
usuario.idusuario fk_7aj7phqt9ragcsb0v75dr4a0d R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkbe918a64 Primary key Asc idlocaltransportador
idx553a7e38 Performance Asc idtransportador
idx6e4f677a Performance Asc idusuario
idxa8f31e49 Performance Asc idlocal
idxcc551c05 Performance Asc idlocalfilial
idxwsversao_be918a64 Performance Desc wsversao
uc96a49216 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation