Tables


SchemaSpy Analysis of milkcrate_prod

Generated on Wed Aug 24 22:45 CEST 2022

XML Representation
Insertion Order Deletion Order
TABLES 115
VIEWS 0
COLUMNS 713
Constraints 210
Anomalies 4
Routines 751

Database Properties

Database Type: PostgreSQL - 11.13

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
bend_sync 1 0 14 Table
template_event_category 0 2 2 Table
conversation_user 0 2 3 Table
user_activity_group 0 2 2 Table
community 42 4 14 Table
screen 1 1 6 Table
node_tag 0 2 2 Table
instance_like 0 4 7 Table
dd_question_type 1 0 2 Table
group_field 0 2 6 Table
response 0 4 8 Table
base_activity_survey 5 2 5 Table
dd_default_avatar 1 0 2 Table
screen_tile 0 2 9 Table
base_activity_event_speaker 0 4 4 Table
dd_file_status 1 0 2 Table
field 4 3 14 Table
node 17 1 2 Table
welcome_screen 0 2 6 Table
user_activity_event 0 3 7 Table
pinned_board 1 3 7 Table
dd_community_status 1 0 2 Table
goal 4 2 11 Table
dd_file_image_type 1 0 4 Table
base_activity_user 0 4 4 Table
user_community 0 3 3 Table
base_activity_place_hour 0 2 4 Table
app_store_ios 0 6 16 Table
users 32 3 9 Table
client_config 0 1 14 Table
push 2 2 10 Table
community_feature_more 0 2 2 Table
dd_city 1 0 3 Table
dd_role 1 0 2 Table
analytics 0 5 18 Table
base_activity_visibility 0 2 6 Table
community_lang 1 1 6 Table
dd_field 0 0 2 Table
base_activity_place 2 2 9 Table
push_result 2 1 4 Table
group 8 3 11 Table
category 6 8 14 Table
group_image 0 2 3 Table
field_visibility 0 1 5 Table
template_event 2 4 23 Table
instance_comment 0 5 10 Table
file 31 3 11 Table
user_subordinate 0 2 2 Table
push_result_error 0 1 3 Table
base_activity_event 6 2 5 Table
screenshot 0 3 4 Table
goal_visibility 0 1 5 Table
dd_field_type 1 0 2 Table
pinned 0 3 6 Table
menu 1 1 10 Table
template_push 0 1 7 Table
tag 2 1 5 Table
file_image 0 2 7 Table
user_role 0 3 3 Table
analytics_device 1 0 7 Table
app_store 2 1 8 Table
post 0 5 8 Table
community_feature 0 2 2 Table
instance_rating 0 4 9 Table
base_activity_survey_activity 0 4 4 Table
base_activity 18 6 17 Table
user_activity_category 0 2 2 Table
dd_node_type 10 0 2 Table
user_activity 3 4 13 Table
task 0 1 8 Table
goal_visibility_group 0 2 2 Table
base_activity_volunteer_opportunity 0 2 6 Table
base_activity_visibility_group 0 3 3 Table
conversation_message 0 3 7 Table
dd_push_status 1 0 2 Table
user_address 0 1 4 Table
pinned_board_user 0 4 4 Table
address 4 2 9 Table
base_activity_action 0 2 5 Table
base_activity_media 0 3 4 Table
dd_repeatable_unit 1 0 2 Table
dd_feature 1 0 4 Table
base_activity_event_instance 1 5 23 Table
conversation 2 1 4 Table
dd_feature_more 1 0 4 Table
goal_status 0 2 7 Table
goal_category 0 2 2 Table
dd_group_type 1 0 2 Table
spatial_ref_sys 0 0 5 Table
bend_migration 0 1 6 Table
user_group 0 2 2 Table
field_visibility_group 0 2 2 Table
user_preference_category 0 3 6 Table
dd_event_type 2 0 2 Table
config_role_community 0 1 2 Table
question 1 3 11 Table
category_group 1 4 13 Table
group_request 0 3 8 Table
push_result_invalid_user 0 1 2 Table
user_profile 0 5 21 Table
push_user 0 2 2 Table
dd_media_type 2 0 2 Table
survey_response 1 2 3 Table
template_event_tag 0 2 2 Table
node_values 0 2 5 Table
dd_screen_tile_type 1 0 2 Table
industry 0 0 4 Table
dd_screenshot_type 1 0 2 Table
base_activity_category 0 3 3 Table
challenge 0 4 10 Table
chat_connections 0 2 9 Table
base_activity_event_recurrent 1 2 11 Table
dd_activity_type 1 0 2 Table
app_store_android 0 4 9 Table
field_option 0 1 4 Table