rotalocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idrotalocal int8 19 null
pontogps.idrotalocal fk_1hxeydrgvygsqlwrctxly1dtb R
pontogps_aud.idrotalocal Implied Constraint R
rotalocal_aud.idrotalocal Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_q9g3n733n745qh0d1lh6cdvyw R
idrota int8 19 null
rota.idrota fk_otf68xthpb5rxj7rh0rh0pxyp R
idparceiro int8 19 √ null
parceiro.idparceiro fk_suwcl6ibbl3r2e4p8g027348d R
idtipoatendimento int8 19 √ null
tipoatendimento.idtipoatendimento fk_nnr5s4sluwvaci88rf6j8frjc R
dia varchar 45 √ null
semana int8 19 √ null
ordem int8 19 null
datafixa date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_8i72hmmdavmo5s05m90liyl8o R
idpontogps int8 19 √ null
pontogps.idpontogps fk_sdo4kedkxo0jn97l3ktk58nrm R
idusuario int8 19 √ null
usuario.idusuario fk_n1umtcbxkcthjw20pe4jogwx9 R
kmdiretopontoanterior numeric 18,6 √ null
kmsimuladopontoanterior numeric 18,6 √ null
sgltipoponto varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
pk2ac9e001 Primary key Asc idrotalocal
idxaca46a04 Performance Asc idusuario
idxad581415 Performance Asc idpontogps
idxb51ce5fe Performance Asc idlocal
idxb5fcd9f2 Performance Asc idrota
idxbd91296b Performance Asc idtipoatendimento
idxe50d2d6f Performance Asc idlocalfilial
idxed9d2570 Performance Asc idparceiro
idxwsversao_2ac9e001 Performance Desc wsversao
ucbd8a15fb Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation