managed_objects

-1 rows


Description

Table listing all managed objects in the road graph system

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
schema_name text 2147483647 null

The schema name of the managed object table
table_name text 2147483647 null

The table name of the managed object table
geometry_type text 2147483647 null

The geometry type of the managed object table. It can be POINT or LINESTRING or MULTILINESTRING.
update_policy_on_graph_change text 2147483647 'references'::text

The update policy to apply on the managed objects when the road graph changes. It can be “geometry” to update only the geometries based on the references, “references” to update only the references based on the geometries or “none” to not update anything.
last_update timestamp 29,6 √ (now())::timestamp(0) without time zone

The date and time of the last update of table objects based on the road graph.
last_updated_objects_ids _int4 10 √ null

The list of the last updated objects ids based on the road graph.
add_trigger_on_geom_change bool 1 false

If True, the function road_graph.add_managed_objects_triggers will create the trigger trg_calculate_managed_object_references on this table, which calculates the references of the features on insert or on geometry update, and for the line tables the trigger trg_update_managed_object_linked_geometries, which updates the lines connected to an updated line.

Indexes

Constraint Name Type Sort Column(s)
managed_objects_pkey Primary key Asc id
managed_objects_geometry_type_idx Performance Asc geometry_type
unique_managed_object Must be unique Asc/Asc schema_name + table_name

Check Constraints

Constraint Name Constraint
check_geometry_type (lower(geometry_type) = ANY (ARRAY['point'::text, 'linestring'::text, 'multilinestring'::text]))
check_update_policy_on_graph_change (update_policy_on_graph_change = ANY (ARRAY['geometry'::text, 'references'::text]))

Relationships

Close relationships within degrees of separation