sms_scraper_cycle

25427 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()

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

Tenant identifier.
day_id int4 10 null
cycle_day_id int2 5 null
shift_day_id uuid 2147483647 √ null
sms_shift_day.id FK_sms_scraper_cycle_sms_shift_day_shift_day_id N
scraper_id uuid 2147483647 null
sms_machine.id FK_sms_scraper_cycle_sms_machine_scraper_id R
dozer_id uuid 2147483647 √ null
sms_machine.id FK_sms_scraper_cycle_sms_machine_dozer_id N
load_daily_zone_id uuid 2147483647 √ null
sms_scraper_daily_zone.id FK_sms_scraper_cycle_sms_scraper_daily_zone_load_daily_zone_id N
dump_daily_zone_id uuid 2147483647 √ null
sms_scraper_daily_zone.id FK_sms_scraper_cycle_sms_scraper_daily_zone_dump_daily_zone_id N
load_zone_id uuid 2147483647 √ null
sms_zone.id FK_sms_scraper_cycle_sms_zone_load_zone_id N
dump_zone_id uuid 2147483647 √ null
sms_zone.id FK_sms_scraper_cycle_sms_zone_dump_zone_id N
local_hour int4 10 √ null
start_date timestamptz 35,6 √ null
distance_loaded float8 17,17 √ null
distance_empty float8 17,17 √ null
total_cycle_time int4 10 √ null
travel_time_empty int4 10 √ null
travel_time_loaded int4 10 √ null
waiting_on_track_empty int4 10 √ null
waiting_on_track_loaded int4 10 √ null
stopped_engine_off_time int4 10 √ null
loading_time int4 10 √ null
dumping_time int4 10 √ null
waiting_for_loading_time int4 10 √ null
waiting_for_dumping_time int4 10 √ null
unknown_load bool 1 false
is_approximate bool 1 false
geom_load_dump geometry 2147483647 √ null
feature_id uuid 2147483647 √ null
features.id FK_sms_scraper_cycle_features_feature_id N
created_at timestamptz 35,6 now()

DateTime the record was created.
shift_day_name text 2147483647 √ null
unknown_dump bool 1 false
dozer_parameter_id uuid 2147483647 √ null
sms_dozer_parameters.id FK_sms_scraper_cycle_sms_dozer_parameters_dozer_parameter_id N
scraper_parameter_id uuid 2147483647 √ null
sms_scraper_parameters.id FK_sms_scraper_cycle_sms_scraper_parameters_scraper_parameter_~ N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_scraper_cycle Primary key Asc id
IX_sms_scraper_cycle_created_at Performance Asc created_at
IX_sms_scraper_cycle_day_id Performance Asc day_id
IX_sms_scraper_cycle_dozer_id Performance Asc dozer_id
IX_sms_scraper_cycle_dozer_parameter_id Performance Asc dozer_parameter_id
IX_sms_scraper_cycle_dump_daily_zone_id Performance Asc dump_daily_zone_id
IX_sms_scraper_cycle_dump_zone_id Performance Asc dump_zone_id
IX_sms_scraper_cycle_feature_id Performance Asc feature_id
IX_sms_scraper_cycle_geom_load_dump Performance Asc geom_load_dump
IX_sms_scraper_cycle_id Must be unique Asc id
IX_sms_scraper_cycle_load_daily_zone_id Performance Asc load_daily_zone_id
IX_sms_scraper_cycle_load_zone_id Performance Asc load_zone_id
IX_sms_scraper_cycle_scraper_id Performance Asc scraper_id
IX_sms_scraper_cycle_scraper_parameter_id Performance Asc scraper_parameter_id
IX_sms_scraper_cycle_shift_day_id Performance Asc shift_day_id
IX_sms_scraper_cycle_start_date Performance Asc start_date
IX_sms_scraper_cycle_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation