sms_truck_daily_zone

5714 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
sms_truck_cycle.dump_daily_zone_id FK_sms_truck_cycle_sms_truck_daily_zone_dump_daily_zone_id N
sms_truck_cycle.load_daily_zone_id FK_sms_truck_cycle_sms_truck_daily_zone_load_daily_zone_id N
sms_truck_move.end_daily_zone_id FK_sms_truck_move_sms_truck_daily_zone_end_daily_zone_id N
sms_truck_move.start_daily_zone_id FK_sms_truck_move_sms_truck_daily_zone_start_daily_zone_id N

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

Tenant identifier.
day_id int4 10 null
name text 2147483647 null
zone_id uuid 2147483647 √ null
sms_zone.id FK_sms_truck_daily_zone_sms_zone_zone_id N
polygon geometry 2147483647 null
center geometry 2147483647 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
feature_id uuid 2147483647 √ null
features.id FK_sms_truck_daily_zone_features_feature_id N

Indexes

Constraint Name Type Sort Column(s)
PK_sms_truck_daily_zone Primary key Asc id
IX_sms_truck_daily_zone_center Performance Asc center
IX_sms_truck_daily_zone_created_at Performance Asc created_at
IX_sms_truck_daily_zone_day_id Performance Asc day_id
IX_sms_truck_daily_zone_feature_id Performance Asc feature_id
IX_sms_truck_daily_zone_id Must be unique Asc id
IX_sms_truck_daily_zone_name Performance Asc name
IX_sms_truck_daily_zone_polygon Performance Asc polygon
IX_sms_truck_daily_zone_tenant_id Performance Asc tenant_id
IX_sms_truck_daily_zone_zone_id Performance Asc zone_id

Relationships

Close relationships within degrees of separation