features

3887 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
attachments.feature_id FK_attachments_features_feature_id C
features.parent_id FK_features_features_parent_id C
features_locks.feature_id FK_features_locks_features_feature_id C
features_versions.feature_id FK_features_versions_features_feature_id C
sms_hiboo_equipment.feature_id FK_sms_hiboo_equipment_features_feature_id N
sms_loader_daily_zone.feature_id FK_sms_loader_daily_zone_features_feature_id N
sms_loader_move.feature_id FK_sms_loader_move_features_feature_id N
sms_machine.feature_id FK_sms_machine_features_feature_id N
sms_scraper_cycle.feature_id FK_sms_scraper_cycle_features_feature_id N
sms_scraper_daily_zone.feature_id FK_sms_scraper_daily_zone_features_feature_id N
sms_scraper_move.feature_id FK_sms_scraper_move_features_feature_id N
sms_truck_cycle.feature_id FK_sms_truck_cycle_features_feature_id N
sms_truck_daily_zone.feature_id FK_sms_truck_daily_zone_features_feature_id N
sms_truck_move.feature_id FK_sms_truck_move_features_feature_id N
sms_zone.feature_id FK_sms_zone_features_feature_id N

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

Tenant identifier.
parent_id uuid 2147483647 √ null
features.id FK_features_features_parent_id C
element_id uuid 2147483647 null
elements.id FK_features_elements_element_id C
geometry geometry 2147483647 √ null
properties jsonb 2147483647 √ null
valid_from timestamptz 35,6 now()
valid_to timestamptz 35,6 √ null
deleted_at timestamptz 35,6 √ null
deleted_by uuid 2147483647 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null

User who create the record. Null if System.
updated_at timestamptz 35,6 √ null

DateTime the record was last updated.
updated_by uuid 2147483647 √ null

User who last updated the record.
is_system bool 1 false

A system-generated record. Default = false

Indexes

Constraint Name Type Sort Column(s)
PK_features Primary key Asc id
IX_features_created_at Performance Asc created_at
IX_features_element_id Performance Asc element_id
IX_features_geometry Performance Asc geometry
IX_features_id Must be unique Asc id
IX_features_is_system Performance Asc is_system
IX_features_parent_id Performance Asc parent_id
IX_features_properties Performance Asc properties
IX_features_tenant_id Performance Asc tenant_id
IX_features_valid_from Performance Asc valid_from
IX_features_valid_to Performance Asc valid_to

Relationships

Close relationships within degrees of separation