preference


Description

Client preferences regarding, the kind of metric units and timezone to use

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idpreference int4 10 null
client.idpreference FK_client_preference R
mayauser.idpreference FK_mayauser_preference R
createbyuser int4 10 null
creationdate timestamp 29,6 √ now()
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 √ null
originatingsystem varchar 50 √ null
enabled bool 1 true
metrics int4 10 0
timezone int4 10 √ 0
metrictemperature int4 10 0

Unidades de Temperatura
metricpressure int4 10 0

Unidades de Presión
metricdistance int4 10 0

Unidades de Distancia
metricconsumption int4 10 0

Unidades de Rendimiento de Combustible
metricvolume int4 10 0

Unidades de Volumen
metricweight int4 10 0

Unidades de Peso
metricothers hstore 2147483647 √ null

Otras unidades de Medida
ui_setup_dashboards varchar 2147483647 √ null
ui_setup_monitor varchar 2147483647 √ null
idui_setup_map int2 5 √ null
preferences_ui_setup_map.idui_setup_map fk_preference_ui_setup_map R
ui_setup varchar 2147483647 √ null
monitor_refresh_interval int4 10 √ 300
police_tracking bool 1 √ false
risky_zone_enabled bool 1 √ null
status_config hstore 2147483647 √ null
concentrator_evaluation int4 10 √ 1
mobile_preferences hstore 2147483647 √ null

The preferences for the mobile app
licence_driver_app int4 10 √ null
soft_move int4 10 0

Indexes

Constraint Name Type Sort Column(s)
PK_preference Primary key Asc idpreference
UQ_preference_idpreference Must be unique Asc idpreference

Relationships

Close relationships within degrees of separation