node


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
analytics.id_node node_fkR
base_activity.id_node node_fkC
base_activity_action.id_node node_fkC
base_activity_event.id_node node_fkC
base_activity_place.id_node node_fkC
base_activity_survey.id_node base_activity_survey_fk_nodeC
base_activity_volunteer_opportunity.id_node node_fkC
instance_comment.id_node base_activity_fkC
instance_like.id_node node_fkR
node_tag.id_node node_tag_node_fkC
node_values.id_node node_fkR
post.id_node base_activity_post_node_fkC
user_activity.id_node_base_activity base_activity_fkC
users.id_node node_fkR
id_dd_node_type int2 5 null
analytics.id_dd_node_type node_fkR
instance_comment.id_dd_node_type base_activity_fkC
instance_like.id_dd_node_type node_fkR
dd_node_type.id dd_node_type_fkR

Indexes

Constraint Name Type Sort Column(s)
node_pk Primary key Asc id
node_unique Must be unique Asc/Asc id + id_dd_node_type

Relationships

Close relationships within degrees of separation