Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| tenant_id | uuid | 2147483647 | null |
|
|
|||||||||
| serial_number | text | 2147483647 | null |
|
|
|||||||||
| time | timestamptz | 35,6 | null |
|
|
|||||||||
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
|||||||||
| coord | geometry | 2147483647 | √ | null |
|
|
||||||||
| speed | float8 | 17,17 | √ | null |
|
|
||||||||
| extv | float8 | 17,17 | √ | null |
|
|
||||||||
| ign | bool | 1 | √ | null |
|
|
||||||||
| dumpster_proximity | int4 | 10 | √ | null |
|
|
||||||||
| created_at | timestamptz | 35,6 | now() |
|
|
|||||||||
| alt | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_sms_teltonika_gps_data | Primary key | Asc/Asc/Asc | serial_number + time + tenant_id |
| AK_sms_teltonika_gps_data_id | Must be unique | Asc | id |
| IX_sms_teltonika_gps_data_id | Must be unique | Asc | id |
| IX_sms_teltonika_gps_data_serial_number_tenant_id | Performance | Asc/Asc | serial_number + tenant_id |
| IX_sms_teltonika_gps_data_tenant_id | Performance | Asc | tenant_id |