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. |
||||
| machines_count | int4 | 10 | √ | null |
|
|
Total machines count. |
||||
| machines_count_active | int4 | 10 | √ | null |
|
|
Total active machines count. |
||||
| machines_volume | float8 | 17,17 | √ | null |
|
|
Sum of all the machines volumes that have been dumped during that day (in m3). |
||||
| machines_fuel_used | float8 | 17,17 | √ | null |
|
|
Sum of all the machines fuel that have been used during that day (in L). |
||||
| machines_co2_equivalent | float8 | 17,17 | √ | null |
|
|
Sum of all the machines fuel that have been used during that day mulitplied by the CO2/L (in Kg). |
||||
| machines_hours_operating | float8 | 17,17 | √ | null |
|
|
Sum of all the machines hours that have been working during that day (in Hours). |
||||
| machines_cost | float8 | 17,17 | √ | null |
|
|
Sum of all the machines hours that have been working during that day mulitplied by the hourly rate. |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
DateTime the record was created. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_sms_kpi_sites_created_at | Performance | Asc | created_at |
| IX_sms_kpi_sites_day_id | Performance | Asc | day_id |
| IX_sms_kpi_sites_day_id_tenant_id_site_id | Must be unique | Asc/Asc/Asc | day_id + tenant_id + site_id |
| IX_sms_kpi_sites_site_id | Performance | Asc | site_id |
| IX_sms_kpi_sites_tenant_id | Performance | Asc | tenant_id |