sms_zone

48 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_fixed_zone_algo_result.zone_id FK_sms_fixed_zone_algo_result_sms_zone_zone_id N
sms_loader_daily_zone.zone_id FK_sms_loader_daily_zone_sms_zone_zone_id N
sms_loader_move.zone_id FK_sms_loader_move_sms_zone_zone_id N
sms_scraper_cycle.dump_zone_id FK_sms_scraper_cycle_sms_zone_dump_zone_id N
sms_scraper_cycle.load_zone_id FK_sms_scraper_cycle_sms_zone_load_zone_id N
sms_scraper_daily_zone.zone_id FK_sms_scraper_daily_zone_sms_zone_zone_id N
sms_scraper_move.zone_id FK_sms_scraper_move_sms_zone_zone_id N
sms_truck_cycle.dump_zone_id FK_sms_truck_cycle_sms_zone_dump_zone_id N
sms_truck_cycle.load_zone_id FK_sms_truck_cycle_sms_zone_load_zone_id N
sms_truck_daily_zone.zone_id FK_sms_truck_daily_zone_sms_zone_zone_id N
sms_truck_move.zone_id FK_sms_truck_move_sms_zone_zone_id N
sms_zone.parent_id FK_sms_zone_sms_zone_parent_id C
sms_zone_attributes.zone_id FK_sms_zone_attributes_sms_zone_zone_id C

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

Tenant identifier.
name text 2147483647 √ null
parent_id uuid 2147483647 √ null
sms_zone.id FK_sms_zone_sms_zone_parent_id C
accept_load bool 1 false
accept_dump bool 1 false
accept_stop bool 1 false
dump_time_coef int4 10 √ null
load_time_coef int4 10 √ null
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
center geometry 2147483647 √ null
deleted_at timestamptz 35,6 √ null
geometry_3d geometry 2147483647 √ null
polygon geometry 2147483647 null
site_id uuid 2147483647 √ null
sms_site.id FK_sms_zone_sms_site_site_id N
valid_from timestamptz 35,6 now()
valid_to timestamptz 35,6 √ null
feature_id uuid 2147483647 √ null
features.id FK_sms_zone_features_feature_id N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_zone Primary key Asc id
IX_sms_zone_center Performance Asc center
IX_sms_zone_created_at Performance Asc created_at
IX_sms_zone_feature_id Performance Asc feature_id
IX_sms_zone_id Must be unique Asc id
IX_sms_zone_is_system Performance Asc is_system
IX_sms_zone_parent_id Performance Asc parent_id
IX_sms_zone_polygon Performance Asc polygon
IX_sms_zone_site_id Performance Asc site_id
IX_sms_zone_tenant_id Performance Asc tenant_id

Relationships

Close relationships within degrees of separation