sms_tgd_computed_info

12636282 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_teltonika_gps_data.id FK_sms_tgd_computed_info_sms_teltonika_gps_data_id C

Unique identifier.
tenant_id uuid 2147483647 null
tenants.id FK_sms_tgd_computed_info_tenants_tenant_id C

Tenant identifier.
delta_time int4 10 √ null
delta_alt int4 10 √ null
delta_distance int4 10 √ null
computed_speed float8 17,17 √ null
shift_day_name text 2147483647 √ null
day_id int4 10 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
shift_day_id uuid 2147483647 √ null
sms_shift_day.id FK_sms_tgd_computed_info_sms_shift_day_shift_day_id N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_tgd_computed_info Primary key Asc id
IX_sms_tgd_computed_info_created_at Performance Asc created_at
IX_sms_tgd_computed_info_day_id Performance Asc day_id
IX_sms_tgd_computed_info_id Must be unique Asc id
IX_sms_tgd_computed_info_shift_day_id Performance Asc shift_day_id
IX_sms_tgd_computed_info_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation