node_roles

54 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('node_roles_id_seq'::regclass)
links_reference_node_roles.node_role_id links_reference_node_roles_node_role_id_fkey R
reference_node_roles.node_role_id reference_node_roles_node_role_id_fkey R
node_type_id int4 10 √ null
node_types.id node_roles_node_type_id_fkey R
role text 2147483647 √ null
level int2 5 √ null
sub_type_id int4 10 √ null
node_sub_types.id node_roles_sub_type_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
node_roles_pkey Primary key Asc id
node_roles_node_type_id_role_idx Must be unique Asc/Asc node_type_id + role

Check Constraints

Constraint Name Constraint
role_must_be_uppercase ((upper(role) = role))

Relationships

Close relationships within degrees of separation