Constraints

Restrict delete

template_event_fk

template_event_category.id_template_event

template_event.id

Restrict delete

conversation_fk

conversation_user.id_conversation

conversation.id

Restrict delete

conversation_user_fk

conversation_user.id_user

users.id_node

Cascade on delete

activity_group_activity_fk

user_activity_group.id_activity

user_activity.id

Cascade on delete

activity_group_group_fk

user_activity_group.id_group

group.id

Cascade on delete

community_qr_fk

community.id_qr

file.id

Null on delete

address_fk

community.id_address

Null on delete

dd_community_status_fk

community.id_dd_community_status

dd_community_status.id

Null on delete

file_fk

community.id_logo_file

file.id

Null on delete

community_fk

screen.id_community

Restrict delete

node_tag_node_fk

node_tag.id_node

node.id

Cascade on delete

node_tag_tag_fk

node_tag.id_tag

tag.id

Restrict delete

node_fk

instance_like.id_node

instance_like.id_dd_node_type

node.id

node.id_dd_node_type

Restrict delete

community_fk

instance_like.id_community

Restrict delete

users_fk

instance_like.id_user

users.id_node

Restrict delete

group_fk

group_field.id_group

group.id

Cascade on delete

field_fk

group_field.id_field

field.id

Cascade on delete

question_fk

response.id_question

question.id

Restrict delete

response_survey_response_id_fk

response.id_survey_response

survey_response.id

Cascade on delete

users_fk

response.id_dd_node_type

response.id_node

users.id_dd_node_type

users.id_node

Restrict delete

dd_node_type_fk

base_activity_survey.id_dd_node_type

Restrict delete

base_activity_survey_fk_node

node.id

Cascade on delete

screen_fk

screen_tile.id_screen

screen.id

Restrict delete

dd_screen_tile_type_fk

screen_tile.id_dd_screen_tile_type

dd_screen_tile_type.id

Restrict delete

base_activity_event_fk

base_activity_event_speaker.id_node_base_activity_event

base_activity_event_speaker.id_dd_node_type_base_activity_event

base_activity_event.id_dd_node_type

Cascade on delete

users_fk

base_activity_event_speaker.id_dd_node_type_users

base_activity_event_speaker.id_node_users

users.id_dd_node_type

users.id_node

Cascade on delete

dd_field_type_fk

field.id_dd_field_type

dd_field_type.id

Restrict delete

dd_node_type_fk

field.id_dd_node_type

Restrict delete

community_fk

field.id_community

Restrict delete

dd_node_type_fk

node.id_dd_node_type

Restrict delete

community_fk

welcome_screen.id_community

Restrict delete

file_fk

welcome_screen.id_file

file.id

Restrict delete

community_fk_cp

user_activity_event.id_community

base_activity_event_instance.id

Restrict delete

user_activity_fk

user_activity_event.id_user_activity

user_activity.id

Cascade on delete

activity_instance_fk_cp

user_activity_event.id_instance

Restrict delete

pinned_board___fk_file

pinned_board.id_cover

file.id

Null on delete

pinned_board___fk_user

pinned_board.id_user

users.id_node

Cascade on delete

pinned_board___fk_community

pinned_board.id_community

Restrict delete

goal_icon_fk

goal.id_icon

file.id

Restrict delete

community_fk

goal.id_community

Restrict delete

base_activity_fk

base_activity_user.id_node_base_activity

base_activity_user.id_dd_node_type_base_activity

base_activity.id_node

base_activity.id_dd_node_type

Restrict delete

users_fk

base_activity_user.id_node_user

base_activity_user.id_dd_node_type_users

users.id_node

users.id_dd_node_type

Restrict delete

community_fk

user_community.id_community

Restrict delete

users_fk

user_community.id_dd_node_type

user_community.id_node

users.id_dd_node_type

users.id_node

Restrict delete

base_activity_place_fk

base_activity_place_hour.id_node

base_activity_place_hour.id_dd_node_type

base_activity_place.id_node

base_activity_place.id_dd_node_type

Cascade on delete

app_store_ios_push_certificat_fk

app_store_ios.id_push_certificate

file.id

Restrict delete

app_store_ios_developer_certificate_fk

app_store_ios.id_developer_certificate

file.id

Restrict delete

community_fk

app_store_ios.id_community

Restrict delete

app_store_fk

app_store_ios.id_app_store

app_store.id

Restrict delete

app_store_ios_fk6

app_store_ios.id_mobile_provision

file.id

Restrict delete

app_store_ios_fk5

app_store_ios.id_icon

file.id

Restrict delete

node_fk

users.id_node

node.id

Restrict delete

dd_node_type_fk

users.id_dd_node_type

Restrict delete

users_comunity_fk

users.id_community

Restrict delete

community_fk

client_config.id_community

Restrict delete

dd_push_status_fk

push.id_dd_push_status

dd_push_status.id

Restrict delete

community_fk

push.id_community

Restrict delete

community_feature_more___fk_1

community_feature_more.id_community

Restrict delete

community_feature_more___fk_2

community_feature_more.id_dd_feature_more

dd_feature_more.id

Restrict delete

node_fk

analytics.id_node

analytics.id_dd_node_type

node.id

node.id_dd_node_type

Restrict delete

community_fk

analytics.id_community

Null on delete

analytics_device_fk

analytics.id_device

analytics_device.unique_id

Restrict delete

users_fk

analytics.id_user

users.id_node

Null on delete

base_activity_fk

base_activity_visibility.id_node_base_activity

base_activity_visibility.id_dd_node_type_base_activity

base_activity.id_node

base_activity.id_dd_node_type

Cascade on delete

community_lang___fk_community

community_lang.id_community

Cascade on delete

node_fk

base_activity_place.id_node

node.id

Cascade on delete

dd_node_type_fk

base_activity_place.id_dd_node_type

Restrict delete

push_fk

push_result.id_push

push.id

Cascade on delete

dd_group_type_fk

group.id_dd_group_type

dd_group_type.id

Restrict delete

community_fk

group.id_community

Restrict delete

group_fk1

group.id_icon

file.id

Restrict delete

group_fk

category.id_group

category_group.id

Null on delete

category_fk4

category.cover_image

file.id

Restrict delete

category_fk5

category.icon

file.id

Restrict delete

category_fk2

category.button_image

file.id

Restrict delete

category_fk3

category.button_image_selected

file.id

Restrict delete

community_fk

category.id_community

Restrict delete

category_fk6

category.icon_sticker

file.id

Restrict delete

category_fk7

category.id_parent

Restrict delete

group_fk

group_image.id_group

group.id

Cascade on delete

group_image_fk1

group_image.id_file

file.id

Restrict delete

field_visibility_fk

field_visibility.id_field

field.id

Restrict delete

community_fk

template_event.id_community

Restrict delete

dd_event_type_fk

template_event.id_dd_event_type

dd_event_type.id

Restrict delete

address_fk

template_event.id_address

Null on delete

template_event_fk0

template_event.id_cover_image

file.id

Restrict delete

community_fk

instance_comment.id_community

Restrict delete

activity_comment_fk3

instance_comment.id_photo

file.id

Restrict delete

base_activity_fk

instance_comment.id_node

instance_comment.id_dd_node_type

node.id

node.id_dd_node_type

Cascade on delete

base_activity_comment_user_fk

instance_comment.id_user

users.id_node

Cascade on delete

dd_media_type_fk

file.id_dd_media_type

dd_media_type.id

Restrict delete

community_fk

file.id_community

Null on delete

dd_file_status_fk

file.id_dd_file_status

dd_file_status.id

Null on delete

user_subordinate_fk2

user_subordinate.id_user_subordinate

users.id_node

Cascade on delete

user_subordinte_fk1

user_subordinate.id_user_supervisor

users.id_node

Cascade on delete

push_result_fk

push_result_error.id_push_result

push_result.id

Cascade on delete

node_fk

node.id

Cascade on delete

dd_node_type_fk

base_activity_event.id_dd_node_type

Restrict delete

dd_screenshot_type_fk

screenshot.id_dd_screenshot_type

dd_screenshot_type.id

Restrict delete

community_fk

screenshot.id_community

Restrict delete

file_fk

screenshot.id_file

file.id

Restrict delete

goal_fk

goal_visibility.id_goal

goal.id

Cascade on delete

community_fk

pinned.id_community

Restrict delete

pinned_user_fk

pinned.id_user

users.id_node

Restrict delete

pinned_node_fk

pinned.id_node

base_activity.id_node

Restrict delete

menu_fk0

menu.parent_menu_id

menu.id

Restrict delete

community_fk

template_push.id_community

Restrict delete

community_fk

tag.id_community

Restrict delete

dd_file_image_type_fk

file_image.id_dd_file_image_type

dd_file_image_type.id

Restrict delete

file_fk

file_image.id_file

file.id

Cascade on delete

user_role_fk2

user_role.id_role

dd_role.id

Restrict delete

user_role_fk0

user_role.id_user

users.id_node

Cascade on delete

user_role_fk1

user_role.id_community

Cascade on delete

community_fk

app_store.id_community

Restrict delete

community_fk

post.id_community

Restrict delete

base_activity_post_node_fk

post.id_node

node.id

Cascade on delete

file_fk

post.id_file

file.id

Null on delete

users_fk

post.id_dd_node_type_users

post.id_node_users

users.id_dd_node_type

users.id_node

Restrict delete

dd_feature_fk

community_feature.id_dd_feature

dd_feature.id

Restrict delete

community_fk

community_feature.id_community

Restrict delete

base_activity_fk

instance_rating.id_node

instance_rating.id_dd_node_type

base_activity.id_node

base_activity.id_dd_node_type

Restrict delete

file_fk

instance_rating.id_file

file.id

Null on delete

users_fk

instance_rating.id_user

users.id_node

Restrict delete

base_activity_fk

base_activity_survey_activity.id_node_base_activity

base_activity_survey_activity.id_dd_node_type_base_activity

base_activity.id_node

base_activity.id_dd_node_type

Cascade on delete

base_activity_survey_fk

base_activity_survey_activity.id_dd_node_type_base_activity_survey

base_activity_survey_activity.id_node_base_activity_survey

base_activity_survey.id_dd_node_type

Restrict delete

node_fk

base_activity.id_node

node.id

Cascade on delete

dd_node_type_fk

base_activity.id_dd_node_type

Restrict delete

community_fk

base_activity.id_community

Restrict delete

address_fk

base_activity.id_address

Null on delete

file_fk

base_activity.id_cover_image_file

file.id

Null on delete

dd_repeatable_unit_fk

base_activity.id_dd_repeatable_unit

dd_repeatable_unit.id

Restrict delete

activity_fk

user_activity_category.id_activity

user_activity.id

Cascade on delete

category_fk

user_activity_category.id_category

Cascade on delete

dd_activity_type_fk

user_activity.id_dd_activity_type

dd_activity_type.id

Restrict delete

community_fk

user_activity.id_community

Restrict delete

base_activity_fk

user_activity.id_node_base_activity

node.id

Cascade on delete

activity_user_fk

user_activity.id_user

users.id_node

Restrict delete

community_fk

task.id_community

Restrict delete

goal_fk

goal_visibility_group.id_goal

goal.id

Cascade on delete

group_fk

goal_visibility_group.id_group

group.id

Cascade on delete

node_fk

base_activity_volunteer_opportunity.id_node

node.id

Cascade on delete

dd_node_type_fk

base_activity_volunteer_opportunity.id_dd_node_type

Restrict delete

group_fk

base_activity_visibility_group.id_group

group.id

Restrict delete

base_activity_fk

base_activity_visibility_group.id_node_base_activity

base_activity_visibility_group.id_dd_node_type_base_activity

base_activity.id_node

base_activity.id_dd_node_type

Cascade on delete

conversation_message_user_fk

conversation_message.id_user

users.id_node

Cascade on delete

conversation_fk

conversation_message.id_conversation

conversation.id

Restrict delete

file_fk

conversation_message.id_file

file.id

Null on delete

address_fk

user_address.id_address

Cascade on delete

pinned_board_user___fk_base_activity

pinned_board_user.id_node

base_activity.id_node

Restrict delete

pinned_board_user___fk_community

pinned_board_user.id_community

Cascade on delete

pinned_board_user___fk_board

pinned_board_user.id_pinned_board

pinned_board.id

Cascade on delete

pinned_board_user___fk_user

pinned_board_user.id_user

users.id_node

Cascade on delete

dd_city_fk

address.id_dd_city

dd_city.id

Null on delete

community_fk

address.id_community

Null on delete

node_fk

base_activity_action.id_node

node.id

Cascade on delete

dd_node_type_fk

base_activity_action.id_dd_node_type

Restrict delete

dd_media_type_fk

base_activity_media.id_dd_media_type

dd_media_type.id

Restrict delete

base_activity_fk

base_activity_media.id_node_base_activity

base_activity_media.id_dd_node_type_base_activity

base_activity.id_node

base_activity.id_dd_node_type

Cascade on delete

dd_node_type_fk_cp

base_activity_event_instance.id_dd_node_type

base_activity_event_recurrent.id

Restrict delete

base_activity_event_recurrent_fk

base_activity_event_instance.id_base_activity_event_recurrent

Cascade on delete

node_fk_cp

base_activity_event_instance.id_node

base_activity_event_instance.id_dd_node_type

base_activity_event.id_dd_node_type

Cascade on delete

base_activity_event_type_fk_cp

base_activity_event_instance.id_type

dd_event_type.id

Restrict delete

community_fk

conversation.id_community

Restrict delete

goal_fk

goal_status.id_goal

goal.id

Cascade on delete

goal_status_users_id_node_fk

goal_status.id_user

users.id_node

Cascade on delete

goal_fk

goal_category.id_goal

goal.id

Cascade on delete

category_fk

goal_category.id_category

Restrict delete

group_fk

user_group.id_group

group.id

Restrict delete

user_group_user_fk

user_group.id_user

users.id_node

Cascade on delete

group_fk

field_visibility_group.id_group

group.id

Restrict delete

field_fk

field_visibility_group.id_field

field.id

Restrict delete

user_preference_category_fk

user_preference_category.id_category

Restrict delete

user_preference_community_fk

user_preference_category.id_community

Cascade on delete

user_preference_user_fk

user_preference_category.id_user

users.id_node

Cascade on delete

dd_question_type_fk

question.id_dd_question_type

dd_question_type.id

Restrict delete

question_base_activity_fk

question.id_dd_node_type

question.id_node

base_activity_survey.id_dd_node_type

Cascade on delete

community_fk

category_group.id_community

Restrict delete

category_group_fk1

category_group.icon

file.id

Restrict delete

category_group_fk2

category_group.inner_icon

file.id

Restrict delete

category_group_fk3

category_group.outer_icon

file.id

Restrict delete

group_request_fk2

group_request.id_user

users.id_node

Cascade on delete

group_request_fk1

group_request.id_group

group.id

Restrict delete

group_request_fk3

group_request.id_community

Cascade on delete

push_result_fk

push_result_invalid_user.id_push_result

push_result.id

Cascade on delete

community_fk

user_profile.id_community

Restrict delete

dd_default_avatar_fk

user_profile.id_dd_default_avatar

dd_default_avatar.id

Restrict delete

file_fk

user_profile.id_avatar_file

file.id

Null on delete

users_fk

user_profile.id_dd_node_type

user_profile.id_node

users.id_dd_node_type

users.id_node

Restrict delete

push_fk

push_user.id_push

push.id

Cascade on delete

user_fk

push_user.id_user

users.id_node

Cascade on delete

survey_response_users_id_node_fk

survey_response.id_user

users.id_node

Cascade on delete

survey_response_base_activity_survey_id_node_fk

survey_response.id_node

Cascade on delete

tag_fk

template_event_tag.id_tag

tag.id

Restrict delete

template_event_fk

template_event_tag.id_template_event

template_event.id

Restrict delete

node_fk

node_values.id_node

node.id

Restrict delete

community_fk

node_values.id_community

Restrict delete

base_activity_fk

base_activity_category.id_node

base_activity_category.id_dd_node_type

base_activity.id_node

base_activity.id_dd_node_type

Cascade on delete

category_fk

base_activity_category.id_category

Restrict delete

community_fk

challenge.id_community

Restrict delete

base_activity_fk

challenge.id_node_base_activity

challenge.id_dd_node_type

base_activity.id_node

base_activity.id_dd_node_type

Restrict delete

file_fk

challenge.id_cover_image_file

file.id

Restrict delete

chat_connection_community_fk

chat_connections.id_community

Restrict delete

chat_connection_user_fk

chat_connections.id_user

users.id_node

Cascade on delete

base_activity_event_fk

base_activity_event_recurrent.id_node_base_activity_event

base_activity_event_recurrent.id_dd_node_type_base_activity_event

base_activity_event.id_dd_node_type

Cascade on delete

app_store_android_fk1

app_store_android.id_icon

file.id

Restrict delete

community_fk

app_store_android.id_community