users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
email text 2147483647 √ null
birthdate date 13 √ null
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
id_dd_node_type int2 5 null
base_activity_event_speaker.id_dd_node_type_users users_fkC
base_activity_user.id_dd_node_type_users users_fkR
post.id_dd_node_type_users users_fkR
response.id_dd_node_type users_fkR
user_community.id_dd_node_type users_fkR
user_profile.id_dd_node_type users_fkR
dd_node_type.id dd_node_type_fkR
id_node int8 19 null
analytics.id_user users_fkN
base_activity_event_speaker.id_node_users users_fkC
base_activity_user.id_node_user users_fkR
chat_connections.id_user chat_connection_user_fkC
conversation_message.id_user conversation_message_user_fkC
conversation_user.id_user conversation_user_fkC
goal_status.id_user goal_status_users_id_node_fkC
group_request.id_user group_request_fk2C
instance_comment.id_user base_activity_comment_user_fkC
instance_like.id_user users_fkR
instance_rating.id_user users_fkR
pinned.id_user pinned_user_fkR
pinned_board.id_user pinned_board___fk_userC
pinned_board_user.id_user pinned_board_user___fk_userC
post.id_node_users users_fkR
push_user.id_user user_fkC
response.id_node users_fkR
survey_response.id_user survey_response_users_id_node_fkC
user_activity.id_user activity_user_fkR
user_community.id_node users_fkR
user_group.id_user user_group_user_fkC
user_preference_category.id_user user_preference_user_fkC
user_profile.id_node users_fkR
user_role.id_user user_role_fk0C
user_subordinate.id_user_subordinate user_subordinate_fk2C
user_subordinate.id_user_supervisor user_subordinte_fk1C
node.id node_fkR
communities _int4 10 √ null
id_community int4 10 √ null
community.id users_comunity_fkR
username text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
user_pk Primary key Asc/Asc id_dd_node_type + id_node
user_uq Must be unique Asc id_node
users_uq_username Must be unique Asc/Asc id_community + username

Relationships

Close relationships within degrees of separation