links_reference_node_roles

93 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ref_id int4 10 √ null
links_references.id links_reference_node_roles_ref_id_fkey R
position int4 10 √ null
node_role_id int4 10 √ null
node_roles.id links_reference_node_roles_node_role_id_fkey R

Check Constraints

Constraint Name Constraint
node_role_matches_level ( CASE WHEN (get_node_role_level(node_role_id) IS NOT NULL) THEN (get_node_role_level(node_role_id) = get_link_ref_position_level(ref_id, "position")) ELSE true END)
node_role_matches_node_type_id ( CASE WHEN (get_node_role_node_type_id(node_role_id) IS NOT NULL) THEN (get_link_ref_position_node_type_id(ref_id, "position") = get_node_role_node_type_id(node_role_id)) ELSE true END)
node_role_matches_sub_type_id ( CASE WHEN (get_node_role_sub_type_id(node_role_id) IS NOT NULL) THEN (get_link_ref_position_sub_type_id(ref_id, "position") = get_node_role_sub_type_id(node_role_id)) ELSE true END)
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