SchemaSpy - discourse.public

Generated by
SchemaSpy

Generated by SchemaSpy on Fri Mar 27 12:26 PDT 2015
Database Type: PostgreSQL - 9.4.1
XML Representation Insertion Order Deletion Order (for database loading/purging scripts)

Tables Views Comments

Table / View	Columns	Rows
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