sms_truck_parameters

13 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_truck_cycle.truck_parameter_id FK_sms_truck_cycle_sms_truck_parameters_truck_parameter_id N
sms_truck_move.truck_parameter_id FK_sms_truck_move_sms_truck_parameters_truck_parameter_id N

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

Tenant identifier.
machine_id uuid 2147483647 null
sms_machine.id FK_sms_truck_parameters_sms_machine_machine_id C
valid_from timestamptz 35,6 now()
valid_to timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
cost_per_hour int2 5 null
theoretical_consumption float8 17,17 null
kg_co2_per_liter float8 17,17 null
target_dump_time int2 5 null
tonne float8 17,17 null
volume float8 17,17 null
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null

User who create the record. Null if System.
updated_at timestamptz 35,6 √ null

DateTime the record was last updated.
updated_by uuid 2147483647 √ null

User who last updated the record.
is_system bool 1 false

A system-generated record. Default = false

Indexes

Constraint Name Type Sort Column(s)
PK_sms_truck_parameters Primary key Asc id
IX_sms_truck_parameters_created_at Performance Asc created_at
IX_sms_truck_parameters_id Must be unique Asc id
IX_sms_truck_parameters_is_system Performance Asc is_system
IX_sms_truck_parameters_machine_id Performance Asc machine_id
IX_sms_truck_parameters_tenant_id Performance Asc tenant_id
IX_sms_truck_parameters_valid_from Performance Asc valid_from
IX_sms_truck_parameters_valid_to Performance Asc valid_to

Relationships

Close relationships within degrees of separation