Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| day_id | int4 | 10 | null |
|
|
Day identifier. |
|||||
| tenant_id | uuid | 2147483647 | null |
|
|
Tenant identifier. |
|||||
| site_id | uuid | 2147483647 | √ | null |
|
|
Sms site identifier. |
||||
| site_name | text | 2147483647 | √ | null |
|
|
Sms site name. |
||||
| machine_id | uuid | 2147483647 | null |
|
|
Machine identifier. |
|||||
| machine_type_id | int4 | 10 | null |
|
|
Machine type identifier. |
|||||
| machine_type | text | 2147483647 | null |
|
|
Machine type name. |
|||||
| machine_name | text | 2147483647 | null |
|
|
Machine name. |
|||||
| machine_make | text | 2147483647 | √ | null |
|
|
Machine manufacturer. |
||||
| machine_model | text | 2147483647 | √ | null |
|
|
Machine model. |
||||
| machine_sn | text | 2147483647 | null |
|
|
Machine serial number. |
|||||
| tracker_gps_count_teltonika | int4 | 10 | √ | null |
|
|
Total machine GPS count by Teltonika. |
||||
| tracker_sn_hiboo | text | 2147483647 | √ | null |
|
|
Tracker serial number by Hiboo. |
||||
| tracker_name_hiboo | text | 2147483647 | √ | null |
|
|
Tracker machine name by Hiboo. |
||||
| tracker_sn_teltonika | text | 2147483647 | √ | null |
|
|
Tracker serial number by Teltonika. |
||||
| tracker_id_teltonika | text | 2147483647 | √ | null |
|
|
Tracker machine ID by Teltonika. |
||||
| machine_hours_operating | float8 | 17,17 | √ | null |
|
|
Computed machine operating hours (in h). |
||||
| machine_hours_idle | float8 | 17,17 | √ | null |
|
|
Computed machine idle hours (in h). |
||||
| machine_hours_working | float8 | 17,17 | √ | null |
|
|
Computed machine working hours (in h). |
||||
| machine_fuel_used | float8 | 17,17 | √ | null |
|
|
Computed machine fuel used (in L). |
||||
| machine_distance | float8 | 17,17 | √ | null |
|
|
Computed machine distance travelled (in m). |
||||
| machine_fuel_consumption | float8 | 17,17 | √ | null |
|
|
Computed machine fuel consumption (in L/h). |
||||
| machine_hours_idling_percentage | float8 | 17,17 | √ | null |
|
|
Computed machine idling hours percentage - idling hours/operating hours * 100 (in %). |
||||
| machine_co2_equivalent | float8 | 17,17 | √ | null |
|
|
Computed machine CO2 equivalent (in kg). |
||||
| hiboo_hours_operating | float8 | 17,17 | √ | null |
|
|
Machine operating hours from hiboo source (in h). |
||||
| hiboo_hours_idle | float8 | 17,17 | √ | null |
|
|
Machine idle hours from hiboo source (in h). |
||||
| hiboo_hours_working | float8 | 17,17 | √ | null |
|
|
Machine working hours from hiboo source (in h). |
||||
| hiboo_fuel_used | float8 | 17,17 | √ | null |
|
|
Machine fuel used from hiboo source (in L). |
||||
| hiboo_distance | float8 | 17,17 | √ | null |
|
|
Machine distance travelled from hiboo source (in m). |
||||
| hiboo_fuel_consumption | float8 | 17,17 | √ | null |
|
|
Machine fuel consumption from hiboo source (in L/h). |
||||
| hiboo_hours_idling_percentage | float8 | 17,17 | √ | null |
|
|
Machine idling hours percentage from hiboo source - idling hours/operating hours * 100 (in %). |
||||
| hiboo_co2_equivalent | float8 | 17,17 | √ | null |
|
|
Machine CO2 equivalent from hiboo source (in kg). |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
DateTime the record was created. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_sms_kpi_sites_machines_created_at | Performance | Asc | created_at |
| IX_sms_kpi_sites_machines_day_id | Performance | Asc | day_id |
| IX_sms_kpi_sites_machines_day_id_tenant_id_site_id_machine_id | Must be unique | Asc/Asc/Asc/Asc | day_id + tenant_id + site_id + machine_id |
| IX_sms_kpi_sites_machines_machine_id | Performance | Asc | machine_id |
| IX_sms_kpi_sites_machines_machine_name | Performance | Asc | machine_name |
| IX_sms_kpi_sites_machines_machine_sn | Performance | Asc | machine_sn |
| IX_sms_kpi_sites_machines_machine_type | Performance | Asc | machine_type |
| IX_sms_kpi_sites_machines_machine_type_id | Performance | Asc | machine_type_id |
| IX_sms_kpi_sites_machines_site_id | Performance | Asc | site_id |
| IX_sms_kpi_sites_machines_tenant_id | Performance | Asc | tenant_id |
| IX_sms_kpi_sites_machines_tracker_name_hiboo | Performance | Asc | tracker_name_hiboo |
| IX_sms_kpi_sites_machines_tracker_sn_hiboo | Performance | Asc | tracker_sn_hiboo |
| IX_sms_kpi_sites_machines_tracker_sn_teltonika | Performance | Asc | tracker_sn_teltonika |