reference_node_roles

3383 rows


Description

Roles of nodes in flow datasets paths

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ref_id int4 10 √ null
flows_references.id reference_node_roles_ref_id_fkey C
position int4 10 √ null
node_role_id int4 10 √ null
node_roles.id reference_node_roles_node_role_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
reference_node_roles_ref_id_position_idx Must be unique Asc/Asc ref_id + position

Check Constraints

Constraint Name Constraint
number_roles_less_or_equal_to_path_length ((length_reference_node_roles_acceptable_if_exists((ref_id)::bigint) = true))

Relationships

Close relationships within degrees of separation