sms_machine

57 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_dozer_parameters.machine_id FK_sms_dozer_parameters_sms_machine_machine_id C
sms_fixed_zone_algo_machine_parameters.machine_id FK_sms_fixed_zone_algo_machine_parameters_sms_machine_machine_~ C
sms_fixed_zone_algo_result.machine_id FK_sms_fixed_zone_algo_result_sms_machine_machine_id R
sms_loader_move.loader_id FK_sms_loader_move_sms_machine_loader_id R
sms_loader_parameters.machine_id FK_sms_loader_parameters_sms_machine_machine_id C
sms_machine_site_association.machine_id FK_sms_machine_site_association_sms_machine_machine_id C
sms_machine_teltonika_tracker.machine_id FK_sms_machine_teltonika_tracker_sms_machine_machine_id C
sms_other_parameters.machine_id FK_sms_other_parameters_sms_machine_machine_id C
sms_scraper_cycle.dozer_id FK_sms_scraper_cycle_sms_machine_dozer_id N
sms_scraper_cycle.scraper_id FK_sms_scraper_cycle_sms_machine_scraper_id R
sms_scraper_move.dozer_id FK_sms_scraper_move_sms_machine_dozer_id N
sms_scraper_move.scraper_id FK_sms_scraper_move_sms_machine_scraper_id R
sms_scraper_parameters.machine_id FK_sms_scraper_parameters_sms_machine_machine_id C
sms_teltonika_scraper_gps_data.dozer_id FK_sms_teltonika_scraper_gps_data_sms_machine_dozer_id N
sms_teltonika_scraper_gps_data.scraper_id FK_sms_teltonika_scraper_gps_data_sms_machine_scraper_id C
sms_truck_cycle.loader_id FK_sms_truck_cycle_sms_machine_loader_id N
sms_truck_cycle.truck_id FK_sms_truck_cycle_sms_machine_truck_id R
sms_truck_move.loader_id FK_sms_truck_move_sms_machine_loader_id N
sms_truck_move.truck_id FK_sms_truck_move_sms_machine_truck_id R
sms_truck_parameters.machine_id FK_sms_truck_parameters_sms_machine_machine_id C

Unique identifier.
tenant_id uuid 2147483647 null
sms_category.tenant_id FK_sms_machine_sms_category_category_tenant_id R
sms_machine_type.tenant_id FK_sms_machine_sms_machine_type_type_tenant_id R
tenants.id FK_sms_machine_tenants_tenant_id C

Tenant identifier.
name varchar 256 null
serial_number varchar 256 null
model varchar 256 √ null
make varchar 256 √ null
category int4 10 √ null
sms_category.id FK_sms_machine_sms_category_category_tenant_id R
type int4 10 √ null
sms_machine_type.id FK_sms_machine_sms_machine_type_type_tenant_id R
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null
updated_at timestamptz 35,6 √ null
updated_by uuid 2147483647 √ null
is_system bool 1 false
description text 2147483647 √ null
deleted_at timestamptz 35,6 √ null
feature_id uuid 2147483647 √ null
features.id FK_sms_machine_features_feature_id N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_machine Primary key Asc id
IX_sms_machine_category_tenant_id Performance Asc/Asc category + tenant_id
IX_sms_machine_created_at Performance Asc created_at
IX_sms_machine_feature_id Performance Asc feature_id
IX_sms_machine_id Must be unique Asc id
IX_sms_machine_is_system Performance Asc is_system
IX_sms_machine_name Performance Asc name
IX_sms_machine_tenant_id Performance Asc tenant_id
IX_sms_machine_type_tenant_id Performance Asc/Asc type + tenant_id

Relationships

Close relationships within degrees of separation