SchemaSpy Analysis of discourse.public Generated by
SchemaSpy
Generated by SchemaSpy on Fri Mar 27 12:26 PDT 2015
Database Type: PostgreSQL - 9.4.1 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table / View Children Parents Columns Rows Comments
api_keys 8 0
application_requests 4 145
badge_groupings 6 5
badge_posts 46 view
badge_types 4 3
badges 21 24
categories 33 6
category_custom_fields 6 0
category_featured_topics 6 7
category_featured_users 5 13
category_groups 6 2
category_search_data 4 2
category_users 4 0
color_scheme_colors 6 0
color_schemes 7 0
digest_unsubscribe_keys 4 0
directory_items 12 17
draft_sequences 4 30
drafts 7 10
email_logs 11 58
email_tokens 8 12
facebook_user_infos 12 0
github_user_infos 6 0
google_user_infos 13 0
group_custom_fields 6 0
group_managers 5 0
group_users 5 37
groups 10 10
incoming_domains 4 0
incoming_links 7 0
incoming_referers 3 0
invited_groups 5 0
invites 11 0
message_bus 5 0
muted_users 5 0
notifications 10 25
oauth2_user_infos 8 0
optimized_images 7 10
permalinks 8 0
plugin_store_rows 5 0
post_action_types 7 8
post_actions 17 9
post_custom_fields 6 0
post_details 7 0
post_replies 4 0
post_revisions 8 8
post_search_data 4 29
post_timings 4 46
post_uploads 3 5
posts 49 29
quoted_posts 5 0
schema_migrations 1 536
screened_emails 8 0
screened_ip_addresses 7 5
screened_urls 9 0
single_sign_on_records 10 0
site_customizations 19 1
site_settings 6 36
site_texts 4 1
top_topics 23 9
topic_allowed_groups 3 0
topic_allowed_users 5 16
topic_custom_fields 6 0
topic_embeds 7 0
topic_invites 5 0
topic_link_clicks 6 0
topic_links 16 89
topic_search_data 4 22
topic_users 16 57
topic_views 4 25
topics 51 22
twitter_user_infos 6 0
uploads 12 8
user_actions 9 50
user_avatars 7 8
user_badges 8 17
user_custom_fields 6 0
user_exports 5 0
user_fields 9 2
user_histories 17 54
user_open_ids 7 0
user_profiles 11 8
user_search_data 4 8
user_stats 13 8
user_visits 4 77
users 49 8
versions 12 0
warnings 6 0
           
87 Tables     810 1,617  
1 View     46