sms_teltonika_tracker

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
serial_number text 2147483647 null
sms_machine_teltonika_tracker.tracker_serial FK_sms_machine_teltonika_tracker_sms_teltonika_tracker_tracker~ C
sms_teltonika_gps_data.serial_number FK_sms_teltonika_gps_data_sms_teltonika_tracker_serial_number_~ C
tenant_id uuid 2147483647 null
sms_machine_teltonika_tracker.tenant_id FK_sms_machine_teltonika_tracker_sms_teltonika_tracker_tracker~ C
sms_teltonika_gps_data.tenant_id FK_sms_teltonika_gps_data_sms_teltonika_tracker_serial_number_~ C
tenants.id FK_sms_teltonika_tracker_tenants_tenant_id C
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_sms_teltonika_tracker Primary key Asc/Asc serial_number + tenant_id
IX_sms_teltonika_tracker_created_at Performance Asc created_at
IX_sms_teltonika_tracker_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation