community


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
address.id_community community_fkN
analytics.id_community community_fkN
app_store.id_community community_fkR
app_store_android.id_community community_fkR
app_store_ios.id_community community_fkR
base_activity.id_community community_fkR
category.id_community community_fkR
category_group.id_community community_fkR
challenge.id_community community_fkR
chat_connections.id_community chat_connection_community_fkR
client_config.id_community community_fkR
community_feature.id_community community_fkR
community_feature_more.id_community community_feature_more___fk_1R
community_lang.id_community community_lang___fk_communityC
conversation.id_community community_fkR
field.id_community community_fkR
file.id_community community_fkN
goal.id_community community_fkR
group.id_community community_fkR
group_request.id_community group_request_fk3C
instance_comment.id_community community_fkR
instance_like.id_community community_fkR
node_values.id_community community_fkR
pinned.id_community community_fkR
pinned_board.id_community pinned_board___fk_communityR
pinned_board_user.id_community pinned_board_user___fk_communityC
post.id_community community_fkR
push.id_community community_fkR
screen.id_community community_fkR
screenshot.id_community community_fkR
tag.id_community community_fkR
task.id_community community_fkR
template_event.id_community community_fkR
template_push.id_community community_fkR
user_activity.id_community community_fkR
user_activity_event.id_community community_fk_cpR
user_community.id_community community_fkR
user_preference_category.id_community user_preference_community_fkC
user_profile.id_community community_fkR
user_role.id_community user_role_fk1C
users.id_community users_comunity_fkR
welcome_screen.id_community community_fkR
name text 2147483647 √ null
enabled bool 1 √ false
description text 2147483647 √ null
code text 2147483647 √ null
id_address int4 10 √ null
address.id address_fkN
id_dd_community_status int2 5 √ null
dd_community_status.id dd_community_status_fkN
id_logo_file int4 10 √ null
file.id file_fkN
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
user_only_groups bool 1 false

Users see only others users from groups that they belongs
id_qr int4 10 √ null
file.id community_qr_fkN
export_footer text 2147483647 √ null
export_disclaimer text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
community_pk Primary key Asc id
community_code_unique Must be unique Asc code
community_uq Must be unique Asc id_address
community_uq1 Must be unique Asc id_logo_file

Relationships

Close relationships within degrees of separation