sms_scraper_move

191942 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_move_tenants_tenant_id C

Tenant identifier.
scraper_id uuid 2147483647 null
sms_machine.id FK_sms_scraper_move_sms_machine_scraper_id R
day_id int4 10 null
cycle_day_id int4 10 √ null
shift_day_id uuid 2147483647 √ null
sms_shift_day.id FK_sms_scraper_move_sms_shift_day_shift_day_id N
type text 2147483647 √ null
start_date timestamptz 35,6 null
duration int4 10 √ null
distance float8 17,17 √ null
geometry geometry 2147483647 √ null
dozer_id uuid 2147483647 √ null
sms_machine.id FK_sms_scraper_move_sms_machine_dozer_id N
dumpster_loaded_at_the_end bool 1 false
start_daily_zone_id uuid 2147483647 √ null
sms_scraper_daily_zone.id FK_sms_scraper_move_sms_scraper_daily_zone_start_daily_zone_id N
end_daily_zone_id uuid 2147483647 √ null
sms_scraper_daily_zone.id FK_sms_scraper_move_sms_scraper_daily_zone_end_daily_zone_id N
zone_id uuid 2147483647 √ null
sms_zone.id FK_sms_scraper_move_sms_zone_zone_id N
centroid geometry 2147483647 √ null
feature_id uuid 2147483647 √ null
features.id FK_sms_scraper_move_features_feature_id N
created_at timestamptz 35,6 now()

DateTime the record was created.
shift_day_name text 2147483647 √ null
scraper_parameter_id uuid 2147483647 √ null
sms_scraper_parameters.id FK_sms_scraper_move_sms_scraper_parameters_scraper_parameter_id N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_scraper_move Primary key Asc id
IX_sms_scraper_move_centroid Performance Asc centroid
IX_sms_scraper_move_created_at Performance Asc created_at
IX_sms_scraper_move_day_id Performance Asc day_id
IX_sms_scraper_move_dozer_id Performance Asc dozer_id
IX_sms_scraper_move_end_daily_zone_id Performance Asc end_daily_zone_id
IX_sms_scraper_move_feature_id Performance Asc feature_id
IX_sms_scraper_move_geometry Performance Asc geometry
IX_sms_scraper_move_id Must be unique Asc id
IX_sms_scraper_move_scraper_parameter_id Performance Asc scraper_parameter_id
IX_sms_scraper_move_shift_day_id Performance Asc shift_day_id
IX_sms_scraper_move_start_daily_zone_id Performance Asc start_daily_zone_id
IX_sms_scraper_move_tenant_id Performance Asc tenant_id
IX_sms_scraper_move_type Performance Asc type
IX_sms_scraper_move_zone_id Performance Asc zone_id
UQ_sms_scraper_move_scraperid_startdate Must be unique Asc/Asc scraper_id + start_date

Relationships

Close relationships within degrees of separation