localsegmento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalsegmento int8 19 null
localsegmento_aud.idlocalsegmento Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_4kjph4nlu8ur1x5iw3kvxw1ah R
idsegmento int8 19 √ null
segmento.idsegmento fk_7tdkkbmps8f9prgrr4oi6abkv R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnpadrao int2 5 null
idparceiro int8 19 √ null
parceiro.idparceiro fk_tcmuihj0aud0skkkw8vggrcv5 R
idusuario int8 19 √ null
usuario.idusuario fk_n2b7sufvl7ytboc8saqn5aan2 R

Indexes

Constraint Name Type Sort Column(s)
pk18da2007 Primary key Asc idlocalsegmento
idx3a507356 Performance Asc idlocal
idx8ab30b89 Performance Asc idsegmento
idx9336a697 Performance Asc idparceiro
idxc0867801 Performance Asc idusuario
idxwsversao_18da2007 Performance Desc wsversao
uc6d483375 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation