operacaorota


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaorota int8 19 null
operacaorota_aud.idoperacaorota Implied Constraint R
descricao varchar 45 null
observacao varchar 4000 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
valor numeric 18,6 null
volume numeric 18,6 null
idoperacao int8 19 null
operacao.idoperacao fk_78fcivjqps5bf1go2w3d1hvjy R
idrota int8 19 √ null
rota.idrota fk_aam2tmf8g0qq55h2b2cacsxbf R
idlocal int8 19 null
local.idlocal fk_4xjm9cdthgwlhh8wyo2uwnt6b R
idparceiro int8 19 null
parceiro.idparceiro fk_o2smjn1en99h5ljc08vhcgexc R
idsegmento int8 19 null
segmento.idsegmento fk_i5nd6f7qh6t5t098ydin816ci R
idusuario int8 19 √ null
usuario.idusuario fk_arscybvolnyn8l617g3wo3b8g R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk687771c8 Primary key Asc idoperacaorota
idx150c1502 Performance Asc idlocal
idx1561b4c3 Performance Asc idsegmento
idx26f8aed9 Performance Asc idparceiro
idx7fb241c1 Performance Asc idrota
idxb6466d16 Performance Asc idusuario
idxc7b34cc9 Performance Asc idoperacao
idxwsversao_687771c8 Performance Desc wsversao
uc43e5dcb2 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation