unit


Description

An abstract representation for an entity carrying a device

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idunit int4 10 null
fs_unit.idunit fk_fs_unit_unit R
current_driverlogin.idunit fk_idunit_current_driverlogin R
current_ecmevent_parameter.idunit fk_idunit_current_ecmevent_parameter R
current_ecmevent_parameter_list.idunit fk_idunit_current_ecmevent_parameter_list R
current_geofence.idunit FK_current_geofence_unit R
customunit.idunit FK_customunit_unit R
device.idunit FK_device_unit R
driver_unit.idunit FK_driver_unit_unit R
driverlogin_history.idunit fk_idunit_driverlogin_history R
ecmerrorcode_active.idunit fk_ecmerrorcode_active_idunit R
ecmerrorcode_history.idunit fk_ecmerrorcode_history_idunit R
ecmevent.idunit fk_ecmevent_idunit R
ecmevent_errorcode.idunit fk_ecmevent_errorcode_idunit R
ecmevent_incidence.idunit fk_ecmevent_incidence_idunit R
ecmevent_parameter.idunit fk_ecmevent_parameter_idunit R
ecmevent_rpmspeed.idunit fk_ecmevent_rpmspeed_idunit R
geofence_history.idunit fk_geofence_history_unit R
inspection.idunit idunit_inspection_fk R
note.idunit fk_maya_device_note R
sharedvehicle_unit.idunit fk_idunit R
toll_history.idunit fk_toll_unit R
trailer.idunit fk_trailer_unit R
unit_device.idunit fk_idunit R
unit_driverloginconf.idunit fk_idunit_unit_driverloginconf R
unit_report.idunit FK_unit_report_unit R
unit_unitgroup.idunit FK_unit_unitgroup_unit R
unitplate.idunit fk_unitplate_unit R
vehicle.idunit FK_Vehicle_unit R
vir_form.idproduct vir_form_product_fk_idproduct R
vir_form.idunit vir_form_unit_fk_idunit R
idunittype int4 10 null
unittype.idunittype FK_unit_unittype R
idclient int4 10 null
client.idclient FK_unit_client R
alias varchar 128 null
createbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
status int4 10 0
aef_id int4 10 √ null
idbranch int4 10 √ null
branch.idbranch Implied Constraint R
alias_shipper varchar 128 √ null
enable_checks bool 1 √ true
over_rpms int4 10 √ 1

Indexes

Constraint Name Type Sort Column(s)
PK_unit Primary key Asc idunit
id_unit_idunittype Performance Asc idunittype
idx_unit_alias Performance Asc alias
idx_unit_enabled Performance Asc enabled
idx_unit_idclient Performance Asc idclient
idx_unit_lower_alias Performance
UQ_unit_idunit Must be unique Asc idunit

Relationships

Close relationships within degrees of separation