maya.public

Table / View	Children	Parents	Columns	Type	Comments
path	0	1	3	Table	Geometry representations of trip routes
message_acknowledge	0	1	7	Table	To keep record of whether a message was received by the device
omnitracsuser	0	2	4	Table	A role equivalent to a superuser that can manage several accounts
alertconf_georeference	0	2	2	Table	Links an specific alert configuration to a georeference within which the alert will be issued
inspection_type	0	0	2	Table
mayauser_message	0	1	3	Table	To keep track of messages status
integration_mayauser	0	2	8	Table	To link a mayauser with a kafka topic for integration purposes
inspection	1	2	5	Table
event_ecm	0	1	22	Table
vehicle	0	2	19	Table	Concretization of a particular kind of unit, an automotive vehicle
device_driverloginconf	0	1	13	Table
coverage_usergroup	0	2	2	Table	Defines access granting over the linked objects to a particular usergroup
digital_outputport_cfg_peripheral_template	0	3	11	Table
driverpref	0	1	8	Table
privilegegroup	3	0	3	Table	The group of actions the client is entitled to perform
onewirecfg	0	0	6	Table
device_peripheral	0	1	2	Table
digital_inputport_cfg_peripheral_template	0	2	17	Table
current_ecmevent_parameter_list	0	1	5	Table
serialcfg	0	1	23	Table
trailer	0	1	11	Table	Especializacion de unit, trailer
shipperconf_unitgroup	0	2	2	Table	Which unitgroups the shipper is entitled to view, send commands to
peripheral_template	5	1	8	Table
report_unitgroup	0	3	2	Table	To which unitgroups a report refers to
unit_driverloginconf	0	2	6	Table	To link units and the drivers that can login on those units
geozone	0	1	8	Table
auditentitylog	0	0	4	Table
coverage	5	1	12	Table	Entrance entity for the definition of what kind of tasks over what objects the client wishes to grant access
indicator	0	3	8	Table	Abstract entity for pictoric representations of business metrics such as speed,idling time, etc
externalcontact	0	2	6	Table	Email destinataries due to alerts for users that are not registered on the system
role	3	1	10	Table	They way we group access to tasks whithin the system to users
message	0	4	21	Table	Messages sent to devices
cargo	0	0	4	Table
unit_device	0	2	10	Table
alertconfscalinguser	0	2	7	Table	When an alert is not dealt with, is scalates to another user
command	5	1	7	Table	Catalog of commands that devices accept
coverage_unitgroup	0	2	2	Table	Defines access granting over a unitgroup
alert_recent	0	1	15	Table
t1	0	0	1	Table
bus	1	0	2	Table
connex_request_log	0	2	10	Table	To troubleshoot the sending of connex requests to Irvin’s API
porticon	5	0	2	Table
sharedvehicle_unit	0	2	3	Table
derate_request_status	0	1	6	Table	To keep track of the response from the Derate API
alertconf_toll	0	2	2	Table
route_definition	0	3	10	Table
event0	0	0	21	Table
mvw_mayauser_device	0	2	3	Table
report_georeference	0	2	2	Table	Applies if the report is based on specific georeferences
sharedvehicle	1	2	9	Table
privilege	4	0	5	Table	Task or functions that can be performed on the system by users with the appropriated role
unit_unitgroup	0	2	9	Table	To which unitgroups does a unit belong
driver	7	2	31	Table	Unit drivers, client employees
alert	0	1	18	Table	Generated alerts acording to the customer configuration parameters
mvw_device_alert	0	1	6	Table
vehicle_class	1	0	12	Table
ecmerrorcode_history	0	1	10	Table	When a record is deleted from ecmerrorcode_active, it should be stored here, for reporting purposes
alertconf	10	1	25	Table	General configuration settings for alerts
product	8	0	7	Table
report_georeferencecategory	0	4	2	Table	Applies if the report is based on specific georeference categories
toll_fee	0	1	16	Table
mayauser_report	0	2	2	Table	Destinatary users for a given report
georeference	9	3	15	Table	Abstract representation of a geometry representation of a fence, path, interest point and so on
port	0	3	6	Table
alert_last	0	1	16	Table
driver_alertconf	0	2	4	Table	Alert configurations that applied specifically to a unit driver
macroconf_processor	0	2	12	Table
coverage_command	0	2	2	Table	Defines access granting to send specific commands to vehicles
current_driverlogin	0	2	4	Table
product_feature	0	2	4	Table
feature	1	1	5	Table	Platform available functionalities to be associated to product instances
peripheral	2	2	10	Table
current_ecmevent_parameter	0	1	15	Table
plainmsg	0	1	4	Table
feedback	0	2	8	Table
vir_form_section	1	1	3	Table	Table that stores sections for custom VIR form.
get_location_localremote	0	0	2	Table
inputoutput	0	2	20	Table
customunit	0	2	8	Table	Defines alternative names for units
ping_request_audit	0	2	5	Table
event_restored	0	0	21	Table
integration_topic	1	0	7	Table	Kafka topics for Ternium-like integration
_iddefaultgroup	0	1	1	Table
branch	14	0	2	Table	Catalog for the branch to which a client belongs, such as Mexico, Colombia, etc
digital_inputport_cfg	0	1	16	Table
part_config_sub	0	1	21	Table
indicator_type	1	0	4	Table	What kind of metric does an indicator icon represents
event_temperature	0	1	10	Table
tmp_device	0	5	35	Table
shipperconf	8	3	16	Table	A method with which two or more different client accounts can allow command execution on its own units
toll_history	0	2	4	Table
ternium_mayauser	1	1	3	Table
command_devicemodel	0	2	3	Table	Links a command (instruction) to how does a device implements it (set of subinstructions)
report	7	1	22	Table	Report parameters such as periodicity and type of report
device_deviceconf	0	2	6	Table
inspection_line	0	1	7	Table
mayauser_mayausergroup	0	2	9	Table	To which usergroups belongs a mayauser
configuration_exec	0	3	7	Table
privilege_privilegegroup	0	2	2	Table	To which privilege a privilege group is entitled
featuretype	1	0	2	Table
shipperconf_macros	0	2	3	Table	What macros is the shipper allowed to send
device_security_install	0	1	6	Table
device_buzzerconf	0	0	9	Table
geofence_history_archive	0	0	9	Table	Unit entrance and exit history from geofences
ecmevent_parameter_list	0	0	4	Table
commandexec_port_dynamic	0	1	3	Table
outputport_action	2	1	3	Table
incident	1	1	3	Table
geofence_history	0	1	9	Table
ecmevent_incidence	0	5	16	Table	ECM data depicting acceleration, speed and break pedal pushing depth on the last seconds of harsh break event
device_profile	2	0	8	Table
shipperconf_command	0	2	3	Table	What commands the shipper is allowed to send to a unit within a unitgroup
peripheraltype	2	0	3	Table
driverstatusconf	0	1	10	Table	Driver configuration for Hours of Service
toll	3	0	9	Table
clientgroup	1	0	5	Table	A client can belong to a clientgroup for consolidation purposes
token	0	1	6	Table
part_config	1	0	25	Table
serialcfg_peripheral_template	0	1	24	Table
message_device_seq	0	1	2	Table
device_derate_template	0	2	2	Table	To override the default derate configuration with a given template
porttype	2	0	2	Table
derate_template	1	0	4	Table	Templates for derate devices, as defined by the hardware team
onewire_sensor	0	0	3	Table	Sensor values for each port one-wire
role_privilege	0	2	2	Table	What tasks a role is entitled to perform
ecmevent	0	4	15	Table	Parent table for ECM data,no events should be stored here, children tables should be used instead: ecmevent_parameter,ecmevent_incidence,ecmevent_rpmspeed, ecmevent_errorcode depending on idecmeventtype
mayausergroup	2	2	12	Table	Most permissions a visibility are given to a usergroup
ecmevent_parameter	0	5	15	Table	ECM data related with operative parameters or readings such as Odometer, Total Consumed Fuel, Coolant temperature
unitplate	0	1	9	Table
georeferencecategory	4	2	5	Table	The category in business terms to classify georeferences such as “distrubution center”,“market”,“garage”,etc
tmp_event_code	0	1	4	Table
unitgroup	14	2	13	Table	Traceable units grouped together by name
canacar_geofence	0	0	3	Table
preference	2	1	28	Table	Client preferences regarding, the kind of metric units and timezone to use
georef_georefcat	0	2	3	Table
unit_report	0	2	2	Table	Which units does a report refer to
portcfg	0	0	1	Table
tmp_geofence_history	0	0	9	Table
outage	0	0	4	Table
binarymsg	0	1	3	Table
auditlog	0	0	7	Table
gnx_retried_commands	0	0	12	Table
devicemodel	8	0	8	Table	Device models and their common characteristics
client	27	5	20	Table	Client list
driverlogin_history	0	2	8	Table
landmark	0	1	4	Table	Geometry to represent interest points, in the current implementation these lanmarks where transformed to geofences
client_pos_status_conf	0	2	4	Table
commandexec	3	3	12	Table	Records commands sent to a device and their status
technicalaccount	5	3	14	Table	Provides the posibility to manage different services (at the device level) by using a single customer account
dbversion	0	0	5	Table	Depicts the changes that the database has gone through since released
coverage_macros	0	2	2	Table	Defines access granting over specific commands
alertconf_command	0	2	2	Table	Under wich settings will a command raise an alert
custom_time_partitions	0	0	3	Table
event	0	1	21	Table	Stores positions reported by devices and all the related information to that position
vir_form	1	3	5	Table	Table that stores custom forms for mobile VIR
alertconf_user	0	2	4	Table	Links an specific alert configuration to a specific user
template	0	1	7	Table	User defined message template
device_rnt	20	0	3	Table	Table that stores basic information of RNT devices, such as IP address, last date, serial number, etc.
unit	30	3	16	Table	An abstract representation for an entity carrying a device
drive_workflow	0	2	20	Table
afcdevice	0	2	8	Table
device	28	6	36	Table	Devices, their characteristics and current status
digital_outputport_cfg	0	2	10	Table
indicator_icon	2	0	3	Table	URLs for the pictoric representations of business metrics
event_arch	0	1	15	Table	Events archived by the device and sent on a batch on a single packet
vir_form_line	0	1	3	Table	Table that stores lines for sections in the VIR form.
mayauser	27	4	30	Table	All users of the system
device_profile_client	0	2	2	Table
macroconf_multifield	0	1	6	Table	For macro configurations with multiple fields
macroconf	3	1	10	Table
alert_event	0	0	2	Table	Which event / message generated the alert
sensor_preference	0	1	8	Table
spatial_ref_sys	2	0	5	Table	PostGIS spatial reference system catalog
current_geofence	0	2	4	Table	Lists units and the geofence they are in a particular moment
geofence	0	1	6	Table	Postgis polygons that define entrance and exit events
ecmevent_errorcode	1	5	22	Table	ECM data related to operative error codes
serialcfg_peripheral	0	0	24	Table
tmp_port	0	2	6	Table
note	0	2	5	Table
mntalertcfg	0	1	9	Table
client_deviceconf	0	2	5	Table
ecmerrorcode_active	0	2	10	Table	To store only currently active ecm error codes, for alerts generation purposes
georeference_device	0	2	5	Table
device_profile_peripheral	0	2	21	Table
inspection_section	0	0	2	Table
alertconf_unitgroup	0	3	5	Table	Links an specific alert configuration to the unitgroup that will be subject of alert generation
event_archive	0	0	21	Table
driverloginconf	1	1	5	Table
driver_eventtype	1	0	2	Table
ecmevent_rpmspeed	0	5	16	Table	ECM data depicting how many seconds were spent by the unit at a particular speed / rpm cuadrant (columns: speed 0-100+ 20km ranges, rows: rpm 0-2500+ 500rpm ranges)
driver_unit	0	2	11	Table	Links drivers to the units they drive
macro	2	1	11	Table	Predefined structures for messages
client_extra_privilege	0	2	2	Table
device_updaterequest	0	1	8	Table
deviceconf	2	1	10	Table
unittype	1	0	3	Table	Unit cathegorization
vw_bloat_table	0	0	5	View
vw_position	0	1	31	View
vw_units	0	2	17	View
mvw_shipperconf	0	2	7	View
vw_message_statushistory	0	1	10	View
vw_long_queries	0	0	6	View
vw_alert	0	1	4	View
vw_commandexec	0	2	9	View
vw_shipperconf_extended	0	2	13	View
vw_commandexec_statushistory	0	1	14	View
vw_client	0	0	10	View
v1	0	1	48	View
vw_foreign_units	0	0	3	View
vw_active_no_report	0	2	17	View
vw_shipperconf	0	2	7	View
vw_unit_coverage	0	1	3	View
vw_msgnoack	0	1	5	View
pg_stat_statements	0	0	23	View
vw_mayauser_device	0	1	3	View
vw_shipperconf_all	0	2	7	View
pg_buffercache	0	0	8	View
vw_conciliacion_ns_extended	0	0	20	View
vw_pg_long_running_trans	0	0	7	View
vw_bloat_index	0	0	5	View
vw_calamp_fullevent	0	1	48	View
vw_user	0	2	11	View
vw_ecm_event1	0	2	60	View
geography_columns	0	1	7	View
vw_dw_event	0	2	59	View
vw_serialcfg	0	1	11	View
vw_audit_unit_unitgroup	0	0	6	View
vw_provhub_calls	0	0	9	View
vw_ecm	0	1	20	View
vw_conciliacion_ns	0	0	16	View
vw_coverage_enabled	0	1	10	View
vw_integracion	0	0	6	View
vw_shared_units	0	2	8	View
vw_alert_count	0	0	3	View
vw_privilegroup	0	2	4	View
vw_blocked	0	0	8	View
vw_units_3g	0	0	17	View
table_privs	0	0	5	View
vw_dw_event_ecm	0	2	59	View
geometry_columns	0	1	7	View
public.vw_conciliacion_ns	0	0	16	View
vw_locks	0	0	10	View
vw_locks_blocking	0	0	6	View
vw_su_commands	0	1	9	View
vw_ecm_snapshot	0	1	30	View
vw_dbconnections	0	0	3	View
vw_retry_command	0	0	10	View
pg_stat_activity_dd	0	0	19	View
vw_table_size	0	0	3	View
vw_macro	0	1	6	View
vw_gnx_position_frequency	0	0	5	View	GNX5 devices positioning interval parameters
public.vw_ecm_snapshot	0	1	30	View
vw_pg_stat_statements	0	0	18	View
vw_conciliacion	0	0	5	View
vw_ovmrecon_product	0	0	5	View
vw_shipperconf_extended_all	0	3	15	View
vw_bloat	0	0	8	View
vw_geofence_history	0	0	11	View

path

0

1

3

Table

Geometry representations of trip routes

message_acknowledge

0

1

7

Table

To keep record of whether a message was received by the device

omnitracsuser

0

2

4

Table

A role equivalent to a superuser that can manage several accounts

alertconf_georeference

0

2

Table

Links an specific alert configuration to a georeference within which the alert will be issued

inspection_type

0

2

Table

mayauser_message

0

1

3

Table

To keep track of messages status

integration_mayauser

0

2

8

Table

To link a mayauser with a kafka topic for integration purposes

inspection

1

2

5

Table

event_ecm

0

1

22

Table

vehicle

0

2

19

Table

Concretization of a particular kind of unit, an automotive vehicle

device_driverloginconf

0

1

13

Table

coverage_usergroup

0

2

Table

Defines access granting over the linked objects to a particular usergroup

digital_outputport_cfg_peripheral_template

0

3

11

Table

driverpref

0

1

8

Table

privilegegroup

3

0

3

Table

The group of actions the client is entitled to perform

onewirecfg

0

6

Table

device_peripheral

0

1

2

Table

digital_inputport_cfg_peripheral_template

0

2

17

Table

current_ecmevent_parameter_list

0

1

5

Table

serialcfg

0

1

23

Table

trailer

0

1

11

Table

Especializacion de unit, trailer

shipperconf_unitgroup

0

2

Table

Which unitgroups the shipper is entitled to view, send commands to

peripheral_template

5

1

8

Table

report_unitgroup

0

3

2

Table

To which unitgroups a report refers to

unit_driverloginconf

0

2

6

Table

To link units and the drivers that can login on those units

geozone

0

1

8

Table

auditentitylog

0

4

Table

coverage

5

1

12

Table

Entrance entity for the definition of what kind of tasks over what objects the client wishes to grant access

indicator

0

3

8

Table

Abstract entity for pictoric representations of business metrics such as speed,idling time, etc

externalcontact

0

2

6

Table

Email destinataries due to alerts for users that are not registered on the system

role

3

1

10

Table

They way we group access to tasks whithin the system to users

message

0

4

21

Table

Messages sent to devices

cargo

0

4

Table

unit_device

0

2

10

Table

alertconfscalinguser

0

2

7

Table

When an alert is not dealt with, is scalates to another user

command

5

1

7

Table

Catalog of commands that devices accept

coverage_unitgroup

0

2

Table

Defines access granting over a unitgroup

alert_recent

0

1

15

Table

t1

0

1

Table

bus

1

0

2

Table

connex_request_log

0

2

10

Table

To troubleshoot the sending of connex requests to Irvin’s API

porticon

5

0

2

Table

sharedvehicle_unit

0

2

3

Table

derate_request_status

0

1

6

Table

To keep track of the response from the Derate API

alertconf_toll

0

2

Table

route_definition

0

3

10

Table

event0

0

21

Table

mvw_mayauser_device

0

2

3

Table

report_georeference

0

2

Table

Applies if the report is based on specific georeferences

sharedvehicle

1

2

9

Table

privilege

4

0

5

Table

Task or functions that can be performed on the system by users with the appropriated role

unit_unitgroup

0

2

9

Table

To which unitgroups does a unit belong

driver

7

2

31

Table

Unit drivers, client employees

alert

0

1

18

Table

Generated alerts acording to the customer configuration parameters

mvw_device_alert

0

1

6

Table

vehicle_class

1

0

12

Table

ecmerrorcode_history

0

1

10

Table

When a record is deleted from ecmerrorcode_active, it should be stored here, for reporting purposes

alertconf

10

1

25

Table

General configuration settings for alerts

product

8

0

7

Table

report_georeferencecategory

0

4

2

Table

Applies if the report is based on specific georeference categories

toll_fee

0

1

16

Table

mayauser_report

0

2

Table

Destinatary users for a given report

georeference

9

3

15

Table

Abstract representation of a geometry representation of a fence, path, interest point and so on

port

0

3

6

Table

alert_last

0

1

16

Table

driver_alertconf

0

2

4

Table

Alert configurations that applied specifically to a unit driver

macroconf_processor

0

2

12

Table

coverage_command

0

2

Table

Defines access granting to send specific commands to vehicles

current_driverlogin

0

2

4

Table

product_feature

0

2

4

Table

feature

1

5

Table

Platform available functionalities to be associated to product instances

peripheral

2

10

Table

current_ecmevent_parameter

0

1

15

Table

plainmsg

0

1

4

Table

feedback

0

2

8

Table

vir_form_section

1

3

Table

Table that stores sections for custom VIR form.

get_location_localremote

0

2

Table

inputoutput

0

2

20

Table

customunit

0

2

8

Table

Defines alternative names for units

ping_request_audit

0

2

5

Table

event_restored

0

21

Table

integration_topic

1

0

7

Table

Kafka topics for Ternium-like integration

_iddefaultgroup

0

1

Table

branch

14

0

2

Table

Catalog for the branch to which a client belongs, such as Mexico, Colombia, etc

digital_inputport_cfg

0

1

16

Table

part_config_sub

0

1

21

Table

indicator_type

1

0

4

Table

What kind of metric does an indicator icon represents

event_temperature

0

1

10

Table

tmp_device

0

5

35

Table

shipperconf

8

3

16

Table

A method with which two or more different client accounts can allow command execution on its own units

toll_history

0

2

4

Table

ternium_mayauser

1

3

Table

command_devicemodel

0

2

3

Table

Links a command (instruction) to how does a device implements it (set of subinstructions)

report

7

1

22

Table

Report parameters such as periodicity and type of report

device_deviceconf

0

2

6

Table

inspection_line

0

1

7

Table

mayauser_mayausergroup

0

2

9

Table

To which usergroups belongs a mayauser

configuration_exec

0

3

7

Table

privilege_privilegegroup

0

2

Table

To which privilege a privilege group is entitled

featuretype

1

0

2

Table

shipperconf_macros

0

2

3

Table

What macros is the shipper allowed to send

device_security_install

0

1

6

Table

device_buzzerconf

0

9

Table

geofence_history_archive

0

9

Table

Unit entrance and exit history from geofences

ecmevent_parameter_list

0

4

Table

commandexec_port_dynamic

0

1

3

Table

outputport_action

2

1

3

Table

incident

1

3

Table

geofence_history

0

1

9

Table

ecmevent_incidence

0

5

16

Table

ECM data depicting acceleration, speed and break pedal pushing depth on the last seconds of harsh break event

device_profile

2

0

8

Table

shipperconf_command

0

2

3

Table

What commands the shipper is allowed to send to a unit within a unitgroup

peripheraltype

2

0

3

Table

driverstatusconf

0

1

10

Table

Driver configuration for Hours of Service

toll

3

0

9

Table

clientgroup

1

0

5

Table

A client can belong to a clientgroup for consolidation purposes

token

0

1

6

Table

part_config

1

0

25

Table

serialcfg_peripheral_template

0

1

24

Table

message_device_seq

0

1

2

Table

device_derate_template

0

2

Table

To override the default derate configuration with a given template

porttype

2

0

2

Table

derate_template

1

0

4

Table

Templates for derate devices, as defined by the hardware team

onewire_sensor

0

3

Table

Sensor values for each port one-wire

role_privilege

0

2

Table

What tasks a role is entitled to perform

ecmevent

0

4

15

Table

Parent table for ECM data,no events should be stored here, children tables should be used instead: ecmevent_parameter,ecmevent_incidence,ecmevent_rpmspeed, ecmevent_errorcode depending on idecmeventtype

mayausergroup

2

12

Table

Most permissions a visibility are given to a usergroup

ecmevent_parameter

0

5

15

Table

ECM data related with operative parameters or readings such as Odometer, Total Consumed Fuel, Coolant temperature

unitplate

0

1

9

Table

georeferencecategory

4

2

5

Table

The category in business terms to classify georeferences such as “distrubution center”,“market”,“garage”,etc

tmp_event_code

0

1

4

Table

unitgroup

14

2

13

Table

Traceable units grouped together by name

canacar_geofence

0

3

Table

preference

2

1

28

Table

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

georef_georefcat

0

2

3

Table

unit_report

0

2

Table

Which units does a report refer to

portcfg

0

1

Table

tmp_geofence_history

0

9

Table

outage

0

4

Table

binarymsg

0

1

3

Table

auditlog

0

7

Table

gnx_retried_commands

0

12

Table

devicemodel

8

0

8

Table

Device models and their common characteristics

client

27

5

20

Table

Client list

driverlogin_history

0

2

8

Table

landmark

0

1

4

Table

Geometry to represent interest points, in the current implementation these lanmarks where transformed to geofences

client_pos_status_conf

0

2

4

Table

commandexec

3

12

Table

Records commands sent to a device and their status

technicalaccount

5

3

14

Table

Provides the posibility to manage different services (at the device level) by using a single customer account

dbversion

0

5

Table

Depicts the changes that the database has gone through since released

coverage_macros

0

2

Table

Defines access granting over specific commands

alertconf_command

0

2

Table

Under wich settings will a command raise an alert

custom_time_partitions

0

3

Table

event

0

1

21

Table

Stores positions reported by devices and all the related information to that position

vir_form

1

3

5

Table

Table that stores custom forms for mobile VIR

alertconf_user

0

2

4

Table

Links an specific alert configuration to a specific user

template

0

1

7

Table

User defined message template

device_rnt

20

0

3

Table

Table that stores basic information of RNT devices, such as IP address, last date, serial number, etc.

unit

30

3

16

Table

An abstract representation for an entity carrying a device

drive_workflow

0

2

20

Table

afcdevice

0

2

8

Table

device

28

6

36

Table

Devices, their characteristics and current status

digital_outputport_cfg

0

2

10

Table

indicator_icon

2

0

3

Table

URLs for the pictoric representations of business metrics

event_arch

0

1

15

Table

Events archived by the device and sent on a batch on a single packet

vir_form_line

0

1

3

Table

Table that stores lines for sections in the VIR form.

mayauser

27

4

30

Table

All users of the system

device_profile_client

0

2

Table

macroconf_multifield

0

1

6

Table

For macro configurations with multiple fields

macroconf

3

1

10

Table

alert_event

0

2

Table

Which event / message generated the alert

sensor_preference

0

1

8

Table

spatial_ref_sys

2

0

5

Table

PostGIS spatial reference system catalog

current_geofence

0

2

4

Table

Lists units and the geofence they are in a particular moment

geofence

0

1

6

Table

Postgis polygons that define entrance and exit events

ecmevent_errorcode

1

5

22

Table

ECM data related to operative error codes

serialcfg_peripheral

0

24

Table

tmp_port

0

2

6

Table

note

0

2

5

Table

mntalertcfg

0

1

9

Table

client_deviceconf

0

2

5

Table

ecmerrorcode_active

0

2

10

Table

To store only currently active ecm error codes, for alerts generation purposes

georeference_device

0

2

5

Table

device_profile_peripheral

0

2

21

Table

inspection_section

0

2

Table

alertconf_unitgroup

0

3

5

Table

Links an specific alert configuration to the unitgroup that will be subject of alert generation

event_archive

0

21

Table

driverloginconf

1

5

Table

driver_eventtype

1

0

2

Table

ecmevent_rpmspeed

0

5

16

Table

ECM data depicting how many seconds were spent by the unit at a particular speed / rpm cuadrant (columns: speed 0-100+ 20km ranges, rows: rpm 0-2500+ 500rpm ranges)

driver_unit

0

2

11

Table

Links drivers to the units they drive

macro

2

1

11

Table

Predefined structures for messages