device


Description

Devices, their characteristics and current status

Columns

Column Type Size Nulls Auto Default Children Parents Comments
iddevice int4 10 null
afcdevice.iddevice fk_afc_device_iddevice R
alert_last.iddevice fk_alert_last_iddevice R
alert_recent.iddevice fk_alert_recent_iddevice R
commandexec.iddevice FK_commandexec_device R
configuration_exec.iddevice fk_configuration_exec_iddevice R
connex_request_log.iddevice connex_request_log_iddevice_fkey R
derate_request_status.iddevice derate_request_status_iddevice_fkey R
device_derate_template.iddevice device_derate_template_iddevice_fkey R
device_deviceconf.iddevice fk_device_deviceconf_iddevice R
device_driverloginconf.iddevice fk_iddevice R
device_peripheral.iddevice FK_device_peripheral_device R
device_security_install.iddevice fk_device_security_install_device R
event.iddevice fk_event_device R
event_arch.iddevice fk_event_arch_iddevice R
event_ecm.iddevice fk_event_ecm_iddevice R
event_temperature.iddevice fk_event_temperature_iddevice R
georeference_device.iddevice fk_iddevice R
incident.iddevice fk_incident_iddevice R
inputoutput.iddevice fk_inputoutput_iddevice R
message.iddevice FK_message_device R
message_acknowledge.iddevice FK_command_acknowledge_device R
message_device_seq.iddevice message_device_seq_iddevice_fkey R
mvw_device_alert.iddevice fk_mvw_device_alert_device R
mvw_mayauser_device.iddevice fk_mvw_mayauser_device_iddevice R
ping_request_audit.iddevice fk_ping_request_audit_device R
port.iddevice fk_port_iddevice R
sensor_preference.iddevice fk_sensor_preference_iddevice R
unit_device.iddevice fk_iddevice R
idunit int4 10 √ null
unit.idunit FK_device_unit R
idtechnicalaccount int4 10 null
technicalaccount.idtechnicalaccount FK_device_technicalaccount R
idmodeldevice int4 10 null
devicemodel.idmodeldevice FK_device_modeldevice R
serialnumber varchar 64 null
device_rnt.serialnumber Implied Constraint R
lastgpsdate timestamptz 35,6 now()
firmware varchar 50 null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
longitude numeric 10,7 null
latitude numeric 10,7 null
enabled bool 1 true
devicetype int4 10 0
security_status int4 10 0
ip inet 2147483647 null
status int4 10 0
last_begin_move timestamptz 35,6 √ null
unit_name varchar 32 √ null
aef_meta hstore 2147483647 √ null
status_age timestamptz 35,6 √ now()
speed float4 8,8 √ null
reason int4 10 √ null
odometer float4 8,8 √ null
others hstore 2147483647 √ null
location hstore 2147483647 √ null
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
ignition_on bool 1 √ null
direction float8 17,17 √ 0.0
idproduct int4 10 √ null
product.idproduct fk_device_idproduct R
script_version varchar 2147483647 √ null

Defines de version of the script of firmware for this device.
driverlogin_pin varchar 2147483647 √ null
port_conf jsonb 2147483647 √ null

To configure alerts or commands depending on the connected peripherals.

Indexes

Constraint Name Type Sort Column(s)
device_pey Primary key Asc iddevice
idx_device_idtechnicalaccount Performance Asc idtechnicalaccount
idx_device_idunit Performance Asc idunit
idx_device_serialnumber_unique Must be unique Asc serialnumber
UQ_device_iddevice Must be unique Asc iddevice

Relationships

Close relationships within degrees of separation