sms_machine_teltonika_tracker

52 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
machine_id uuid 2147483647 null
sms_machine.id FK_sms_machine_teltonika_tracker_sms_machine_machine_id C
tracker_serial text 2147483647 null
sms_teltonika_tracker.serial_number FK_sms_machine_teltonika_tracker_sms_teltonika_tracker_tracker~ C
tenant_id uuid 2147483647 null
sms_teltonika_tracker.tenant_id FK_sms_machine_teltonika_tracker_sms_teltonika_tracker_tracker~ C
tenants.id FK_sms_machine_teltonika_tracker_tenants_tenant_id C
sms_state.tenant_id FK_sms_machine_teltonika_tracker_sms_state_state_tenant_id R

Tenant identifier.
valid_from timestamptz 35,6 now()
valid_to timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
state int4 10 √ null
sms_state.id FK_sms_machine_teltonika_tracker_sms_state_state_tenant_id R
created_at timestamptz 35,6 now()

DateTime the record was created.
id uuid 2147483647 gen_random_uuid()

Unique identifier.

Indexes

Constraint Name Type Sort Column(s)
PK_sms_machine_teltonika_tracker Primary key Asc id
IX_sms_machine_teltonika_tracker_created_at Performance Asc created_at
IX_sms_machine_teltonika_tracker_id Must be unique Asc id
IX_sms_machine_teltonika_tracker_machine_id Performance Asc machine_id
IX_sms_machine_teltonika_tracker_state Performance Asc state
IX_sms_machine_teltonika_tracker_state_tenant_id Performance Asc/Asc state + tenant_id
IX_sms_machine_teltonika_tracker_tenant_id Performance Asc tenant_id
IX_sms_machine_teltonika_tracker_tracker_serial Performance Asc tracker_serial
IX_sms_machine_teltonika_tracker_tracker_serial_tenant_id Performance Asc/Asc tracker_serial + tenant_id
IX_sms_machine_teltonika_tracker_valid_from Performance Asc valid_from
IX_sms_machine_teltonika_tracker_valid_to Performance Asc valid_to

Relationships

Close relationships within degrees of separation