discourse.public contains 856 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
api_keys	allowed_ips	_inet	2147483647	√		null
api_keys	created_at	timestamp	29,6
api_keys	created_by_id	int4	10	√		null
api_keys	hidden	bool	1			false
api_keys	id	serial	10		√	nextval('api_keys_id_seq'::regclass)
api_keys	key	varchar	64
api_keys	updated_at	timestamp	29,6
api_keys	user_id	int4	10	√		null
application_requests	count	int4	10			0
application_requests	date	date	13
application_requests	id	serial	10		√	nextval('application_requests_id_seq'::regclass)
application_requests	req_type	int4	10
badge_groupings	created_at	timestamp	29,6
badge_groupings	description	text	2147483647	√		null
badge_groupings	id	serial	10		√	nextval('badge_groupings_id_seq'::regclass)
badge_groupings	name	varchar	255
badge_groupings	position	int4	10
badge_groupings	updated_at	timestamp	29,6
badge_posts	avg_time	int4	10	√		null
badge_posts	baked_at	timestamp	29,6	√		null
badge_posts	baked_version	int4	10	√		null
badge_posts	bookmark_count	int4	10	√		null
badge_posts	cook_method	int4	10	√		null
badge_posts	cooked	text	2147483647	√		null
badge_posts	created_at	timestamp	29,6	√		null
badge_posts	deleted_at	timestamp	29,6	√		null
badge_posts	deleted_by_id	int4	10	√		null
badge_posts	edit_reason	varchar	255	√		null
badge_posts	hidden	bool	1	√		null
badge_posts	hidden_at	timestamp	29,6	√		null
badge_posts	hidden_reason_id	int4	10	√		null
badge_posts	id	int4	10	√		null
badge_posts	illegal_count	int4	10	√		null
badge_posts	inappropriate_count	int4	10	√		null
badge_posts	incoming_link_count	int4	10	√		null
badge_posts	last_editor_id	int4	10	√		null
badge_posts	last_version_at	timestamp	29,6	√		null
badge_posts	like_count	int4	10	√		null
badge_posts	like_score	int4	10	√		null
badge_posts	notify_moderators_count	int4	10	√		null
badge_posts	notify_user_count	int4	10	√		null
badge_posts	off_topic_count	int4	10	√		null
badge_posts	percent_rank	float8	17,17	√		null
badge_posts	post_number	int4	10	√		null
badge_posts	post_type	int4	10	√		null
badge_posts	quote_count	int4	10	√		null
badge_posts	raw	text	2147483647	√		null
badge_posts	reads	int4	10	√		null
badge_posts	reply_count	int4	10	√		null
badge_posts	reply_quoted	bool	1	√		null
badge_posts	reply_to_post_number	int4	10	√		null
badge_posts	reply_to_user_id	int4	10	√		null
badge_posts	score	float8	17,17	√		null
badge_posts	self_edits	int4	10	√		null
badge_posts	sort_order	int4	10	√		null
badge_posts	spam_count	int4	10	√		null
badge_posts	topic_id	int4	10	√		null
badge_posts	updated_at	timestamp	29,6	√		null
badge_posts	user_deleted	bool	1	√		null
badge_posts	user_id	int4	10	√		null
badge_posts	version	int4	10	√		null
badge_posts	vote_count	int4	10	√		null
badge_posts	wiki	bool	1	√		null
badge_posts	word_count	int4	10	√		null
badge_types	created_at	timestamp	29,6
badge_types	id	serial	10		√	nextval('badge_types_id_seq'::regclass)
badge_types	name	varchar	255
badge_types	updated_at	timestamp	29,6
badges	allow_title	bool	1			false
badges	auto_revoke	bool	1			true
badges	badge_grouping_id	int4	10			5
badges	badge_type_id	int4	10
badges	created_at	timestamp	29,6
badges	description	text	2147483647	√		null
badges	enabled	bool	1			true
badges	grant_count	int4	10			0
badges	icon	varchar	255	√		'fa-certificate'::character varying
badges	id	serial	10		√	nextval('badges_id_seq'::regclass)
badges	image	varchar	255	√		null
badges	listable	bool	1	√		true
badges	long_description	text	2147483647	√		null
badges	multiple_grant	bool	1			false
badges	name	varchar	255
badges	query	text	2147483647	√		null
badges	show_posts	bool	1			false
badges	system	bool	1			false
badges	target_posts	bool	1	√		false
badges	trigger	int4	10	√		null
badges	updated_at	timestamp	29,6
categories	allow_badges	bool	1			true
categories	auto_close_based_on_last_post	bool	1	√		false
categories	auto_close_hours	float8	17,17	√		null
categories	background_url	varchar	255	√		null
categories	color	varchar	6			'AB9364'::character varying
categories	created_at	timestamp	29,6
categories	description	text	2147483647	√		null
categories	email_in	varchar	255	√		null
categories	email_in_allow_strangers	bool	1	√		false
categories	id	serial	10		√	nextval('categories_id_seq'::regclass)
categories	latest_post_id	int4	10	√		null
categories	latest_topic_id	int4	10	√		null
categories	logo_url	varchar	255	√		null
categories	name	varchar	50
categories	name_lower	varchar	50
categories	parent_category_id	int4	10	√		null
categories	position	int4	10	√		null
categories	post_count	int4	10			0
categories	posts_day	int4	10	√		0
categories	posts_month	int4	10	√		0
categories	posts_week	int4	10	√		0
categories	posts_year	int4	10	√		0
categories	read_restricted	bool	1			false
categories	slug	varchar	255
categories	text_color	varchar	6			'FFFFFF'::character varying
categories	topic_count	int4	10			0
categories	topic_id	int4	10	√		null
categories	topics_day	int4	10	√		0
categories	topics_month	int4	10	√		0
categories	topics_week	int4	10	√		0
categories	topics_year	int4	10	√		0
categories	updated_at	timestamp	29,6
categories	user_id	int4	10
category_custom_fields	category_id	int4	10
category_custom_fields	created_at	timestamp	29,6
category_custom_fields	id	serial	10		√	nextval('category_custom_fields_id_seq'::regclass)
category_custom_fields	name	varchar	256
category_custom_fields	updated_at	timestamp	29,6
category_custom_fields	value	text	2147483647	√		null
category_featured_topics	category_id	int4	10
category_featured_topics	created_at	timestamp	29,6
category_featured_topics	id	serial	10		√	nextval('category_featured_topics_id_seq'::regclass)
category_featured_topics	rank	int4	10			0
category_featured_topics	topic_id	int4	10
category_featured_topics	updated_at	timestamp	29,6
category_featured_users	category_id	int4	10	√		null
category_featured_users	created_at	timestamp	29,6
category_featured_users	id	serial	10		√	nextval('category_featured_users_id_seq'::regclass)
category_featured_users	updated_at	timestamp	29,6
category_featured_users	user_id	int4	10	√		null
category_groups	category_id	int4	10
category_groups	created_at	timestamp	29,6
category_groups	group_id	int4	10
category_groups	id	serial	10		√	nextval('category_groups_id_seq'::regclass)
category_groups	permission_type	int4	10	√		1
category_groups	updated_at	timestamp	29,6
category_search_data	category_id	int4	10
category_search_data	locale	text	2147483647	√		null
category_search_data	raw_data	text	2147483647	√		null
category_search_data	search_data	tsvector	2147483647	√		null
category_users	category_id	int4	10
category_users	id	serial	10		√	nextval('category_users_id_seq'::regclass)
category_users	notification_level	int4	10
category_users	user_id	int4	10
color_scheme_colors	color_scheme_id	int4	10
color_scheme_colors	created_at	timestamp	29,6
color_scheme_colors	hex	varchar	255
color_scheme_colors	id	serial	10		√	nextval('color_scheme_colors_id_seq'::regclass)
color_scheme_colors	name	varchar	255
color_scheme_colors	updated_at	timestamp	29,6
color_schemes	created_at	timestamp	29,6
color_schemes	enabled	bool	1			false
color_schemes	id	serial	10		√	nextval('color_schemes_id_seq'::regclass)
color_schemes	name	varchar	255
color_schemes	updated_at	timestamp	29,6
color_schemes	version	int4	10			1
color_schemes	versioned_id	int4	10	√		null
digest_unsubscribe_keys	created_at	timestamp	29,6	√		null
digest_unsubscribe_keys	key	varchar	64
digest_unsubscribe_keys	updated_at	timestamp	29,6	√		null
digest_unsubscribe_keys	user_id	int4	10
directory_items	created_at	timestamp	29,6	√		null
directory_items	days_visited	int4	10			0
directory_items	id	serial	10		√	nextval('directory_items_id_seq'::regclass)
directory_items	likes_given	int4	10
directory_items	likes_received	int4	10
directory_items	period_type	int4	10
directory_items	post_count	int4	10
directory_items	posts_read	int4	10			0
directory_items	topic_count	int4	10
directory_items	topics_entered	int4	10
directory_items	updated_at	timestamp	29,6	√		null
directory_items	user_id	int4	10
draft_sequences	draft_key	varchar	255
draft_sequences	id	serial	10		√	nextval('draft_sequences_id_seq'::regclass)
draft_sequences	sequence	int4	10
draft_sequences	user_id	int4	10
drafts	created_at	timestamp	29,6
drafts	data	text	2147483647
drafts	draft_key	varchar	255
drafts	id	serial	10		√	nextval('drafts_id_seq'::regclass)
drafts	sequence	int4	10			0
drafts	updated_at	timestamp	29,6
drafts	user_id	int4	10
email_logs	created_at	timestamp	29,6
email_logs	email_type	varchar	255
email_logs	id	serial	10		√	nextval('email_logs_id_seq'::regclass)
email_logs	post_id	int4	10	√		null
email_logs	reply_key	varchar	32	√		null
email_logs	skipped	bool	1	√		false
email_logs	skipped_reason	varchar	255	√		null
email_logs	to_address	varchar	255
email_logs	topic_id	int4	10	√		null
email_logs	updated_at	timestamp	29,6
email_logs	user_id	int4	10	√		null
email_tokens	confirmed	bool	1			false
email_tokens	created_at	timestamp	29,6
email_tokens	email	varchar	255
email_tokens	expired	bool	1			false
email_tokens	id	serial	10		√	nextval('email_tokens_id_seq'::regclass)
email_tokens	token	varchar	255
email_tokens	updated_at	timestamp	29,6
email_tokens	user_id	int4	10
facebook_user_infos	created_at	timestamp	29,6
facebook_user_infos	email	varchar	255	√		null
facebook_user_infos	facebook_user_id	int8	19
facebook_user_infos	first_name	varchar	255	√		null
facebook_user_infos	gender	varchar	255	√		null
facebook_user_infos	id	serial	10		√	nextval('facebook_user_infos_id_seq'::regclass)
facebook_user_infos	last_name	varchar	255	√		null
facebook_user_infos	link	varchar	255	√		null
facebook_user_infos	name	varchar	255	√		null
facebook_user_infos	updated_at	timestamp	29,6
facebook_user_infos	user_id	int4	10
facebook_user_infos	username	varchar	255	√		null
github_user_infos	created_at	timestamp	29,6
github_user_infos	github_user_id	int4	10
github_user_infos	id	serial	10		√	nextval('github_user_infos_id_seq'::regclass)
github_user_infos	screen_name	varchar	255
github_user_infos	updated_at	timestamp	29,6
github_user_infos	user_id	int4	10
google_user_infos	created_at	timestamp	29,6
google_user_infos	email	varchar	255	√		null
google_user_infos	first_name	varchar	255	√		null
google_user_infos	gender	varchar	255	√		null
google_user_infos	google_user_id	varchar	255
google_user_infos	id	serial	10		√	nextval('google_user_infos_id_seq'::regclass)
google_user_infos	last_name	varchar	255	√		null
google_user_infos	link	varchar	255	√		null
google_user_infos	name	varchar	255	√		null
google_user_infos	picture	varchar	255	√		null
google_user_infos	profile_link	varchar	255	√		null
google_user_infos	updated_at	timestamp	29,6
google_user_infos	user_id	int4	10
group_custom_fields	created_at	timestamp	29,6
group_custom_fields	group_id	int4	10
group_custom_fields	id	serial	10		√	nextval('group_custom_fields_id_seq'::regclass)
group_custom_fields	name	varchar	256
group_custom_fields	updated_at	timestamp	29,6
group_custom_fields	value	text	2147483647	√		null
group_managers	created_at	timestamp	29,6	√		null
group_managers	group_id	int4	10
group_managers	id	serial	10		√	nextval('group_managers_id_seq'::regclass)
group_managers	updated_at	timestamp	29,6	√		null
group_managers	user_id	int4	10
group_users	created_at	timestamp	29,6
group_users	group_id	int4	10
group_users	id	serial	10		√	nextval('group_users_id_seq'::regclass)
group_users	updated_at	timestamp	29,6
group_users	user_id	int4	10
groups	alias_level	int4	10	√		0
groups	automatic	bool	1			false
groups	automatic_membership_email_domains	text	2147483647	√		null
groups	automatic_membership_retroactive	bool	1	√		false
groups	created_at	timestamp	29,6
groups	id	serial	10		√	nextval('groups_id_seq'::regclass)
groups	name	varchar	255
groups	updated_at	timestamp	29,6
groups	user_count	int4	10			0
groups	visible	bool	1			true
incoming_domains	https	bool	1			false
incoming_domains	id	serial	10		√	nextval('incoming_domains_id_seq'::regclass)
incoming_domains	name	varchar	100
incoming_domains	port	int4	10
incoming_links	created_at	timestamp	29,6
incoming_links	current_user_id	int4	10	√		null
incoming_links	id	serial	10		√	nextval('incoming_links_id_seq'::regclass)
incoming_links	incoming_referer_id	int4	10	√		null
incoming_links	ip_address	inet	2147483647	√		null
incoming_links	post_id	int4	10
incoming_links	user_id	int4	10	√		null
incoming_referers	id	serial	10		√	nextval('incoming_referers_id_seq'::regclass)
incoming_referers	incoming_domain_id	int4	10
incoming_referers	path	varchar	1000
invited_groups	created_at	timestamp	29,6
invited_groups	group_id	int4	10	√		null
invited_groups	id	serial	10		√	nextval('invited_groups_id_seq'::regclass)
invited_groups	invite_id	int4	10	√		null
invited_groups	updated_at	timestamp	29,6
invites	created_at	timestamp	29,6
invites	deleted_at	timestamp	29,6	√		null
invites	deleted_by_id	int4	10	√		null
invites	email	varchar	255	√		null
invites	id	serial	10		√	nextval('invites_id_seq'::regclass)
invites	invalidated_at	timestamp	29,6	√		null
invites	invite_key	varchar	32
invites	invited_by_id	int4	10
invites	redeemed_at	timestamp	29,6	√		null
invites	updated_at	timestamp	29,6
invites	user_id	int4	10	√		null
message_bus	context	varchar	255	√		null
message_bus	created_at	timestamp	29,6
message_bus	data	text	2147483647	√		null
message_bus	id	serial	10		√	nextval('message_bus_id_seq'::regclass)
message_bus	name	varchar	255	√		null
muted_users	created_at	timestamp	29,6	√		null
muted_users	id	serial	10		√	nextval('muted_users_id_seq'::regclass)
muted_users	muted_user_id	int4	10
muted_users	updated_at	timestamp	29,6	√		null
muted_users	user_id	int4	10
notifications	created_at	timestamp	29,6
notifications	data	varchar	1000
notifications	id	serial	10		√	nextval('notifications_id_seq'::regclass)
notifications	notification_type	int4	10
notifications	post_action_id	int4	10	√		null
notifications	post_number	int4	10	√		null
notifications	read	bool	1			false
notifications	topic_id	int4	10	√		null
notifications	updated_at	timestamp	29,6
notifications	user_id	int4	10
oauth2_user_infos	created_at	timestamp	29,6
oauth2_user_infos	email	varchar	255	√		null
oauth2_user_infos	id	serial	10		√	nextval('oauth2_user_infos_id_seq'::regclass)
oauth2_user_infos	name	varchar	255	√		null
oauth2_user_infos	provider	varchar	255
oauth2_user_infos	uid	varchar	255
oauth2_user_infos	updated_at	timestamp	29,6
oauth2_user_infos	user_id	int4	10
optimized_images	extension	varchar	10
optimized_images	height	int4	10
optimized_images	id	serial	10		√	nextval('optimized_images_id_seq'::regclass)
optimized_images	sha1	varchar	40
optimized_images	upload_id	int4	10
optimized_images	url	varchar	255
optimized_images	width	int4	10
permalinks	category_id	int4	10	√		null
permalinks	created_at	timestamp	29,6	√		null
permalinks	external_url	varchar	1000	√		null
permalinks	id	serial	10		√	nextval('permalinks_id_seq'::regclass)
permalinks	post_id	int4	10	√		null
permalinks	topic_id	int4	10	√		null
permalinks	updated_at	timestamp	29,6	√		null
permalinks	url	varchar	1000
plugin_store_rows	id	serial	10		√	nextval('plugin_store_rows_id_seq'::regclass)
plugin_store_rows	key	varchar	255
plugin_store_rows	plugin_name	varchar	255
plugin_store_rows	type_name	varchar	255
plugin_store_rows	value	text	2147483647	√		null
post_action_types	created_at	timestamp	29,6
post_action_types	icon	varchar	20	√		null
post_action_types	id	serial	10		√	nextval('post_action_types_id_seq'::regclass)
post_action_types	is_flag	bool	1			false
post_action_types	name_key	varchar	50
post_action_types	position	int4	10			0
post_action_types	updated_at	timestamp	29,6
post_actions	agreed_at	timestamp	29,6	√		null
post_actions	agreed_by_id	int4	10	√		null
post_actions	created_at	timestamp	29,6
post_actions	deferred_at	timestamp	29,6	√		null
post_actions	deferred_by_id	int4	10	√		null
post_actions	deleted_at	timestamp	29,6	√		null
post_actions	deleted_by_id	int4	10	√		null
post_actions	disagreed_at	timestamp	29,6	√		null
post_actions	disagreed_by_id	int4	10	√		null
post_actions	id	serial	10		√	nextval('post_actions_id_seq'::regclass)
post_actions	post_action_type_id	int4	10
post_actions	post_id	int4	10
post_actions	related_post_id	int4	10	√		null
post_actions	staff_took_action	bool	1			false
post_actions	targets_topic	bool	1			false
post_actions	updated_at	timestamp	29,6
post_actions	user_id	int4	10
post_custom_fields	created_at	timestamp	29,6
post_custom_fields	id	serial	10		√	nextval('post_custom_fields_id_seq'::regclass)
post_custom_fields	name	varchar	256
post_custom_fields	post_id	int4	10
post_custom_fields	updated_at	timestamp	29,6
post_custom_fields	value	text	2147483647	√		null
post_details	created_at	timestamp	29,6
post_details	extra	text	2147483647	√		null
post_details	id	serial	10		√	nextval('post_details_id_seq'::regclass)
post_details	key	varchar	255	√		null
post_details	post_id	int4	10	√		null
post_details	updated_at	timestamp	29,6
post_details	value	varchar	255	√		null
post_replies	created_at	timestamp	29,6
post_replies	post_id	int4	10	√		null
post_replies	reply_id	int4	10	√		null
post_replies	updated_at	timestamp	29,6
post_revisions	created_at	timestamp	29,6
post_revisions	hidden	bool	1			false
post_revisions	id	serial	10		√	nextval('post_revisions_id_seq'::regclass)
post_revisions	modifications	text	2147483647	√		null
post_revisions	number	int4	10	√		null
post_revisions	post_id	int4	10	√		null
post_revisions	updated_at	timestamp	29,6
post_revisions	user_id	int4	10	√		null
post_search_data	locale	varchar	255	√		null
post_search_data	post_id	int4	10
post_search_data	raw_data	text	2147483647	√		null
post_search_data	search_data	tsvector	2147483647	√		null
post_timings	msecs	int4	10
post_timings	post_number	int4	10
post_timings	topic_id	int4	10
post_timings	user_id	int4	10
post_uploads	id	serial	10		√	nextval('post_uploads_id_seq'::regclass)
post_uploads	post_id	int4	10
post_uploads	upload_id	int4	10
posts	avg_time	int4	10	√		null
posts	baked_at	timestamp	29,6	√		null
posts	baked_version	int4	10	√		null
posts	bookmark_count	int4	10			0
posts	cook_method	int4	10			1
posts	cooked	text	2147483647
posts	created_at	timestamp	29,6
posts	deleted_at	timestamp	29,6	√		null
posts	deleted_by_id	int4	10	√		null
posts	edit_reason	varchar	255	√		null
posts	hidden	bool	1			false
posts	hidden_at	timestamp	29,6	√		null
posts	hidden_reason_id	int4	10	√		null
posts	id	serial	10		√	nextval('posts_id_seq'::regclass)
posts	illegal_count	int4	10			0
posts	inappropriate_count	int4	10			0
posts	incoming_link_count	int4	10			0
posts	last_editor_id	int4	10	√		null
posts	last_version_at	timestamp	29,6
posts	like_count	int4	10			0
posts	like_score	int4	10			0
posts	notify_moderators_count	int4	10			0
posts	notify_user_count	int4	10			0
posts	off_topic_count	int4	10			0
posts	percent_rank	float8	17,17	√		1.0
posts	post_number	int4	10
posts	post_type	int4	10			1
posts	public_version	int4	10			1
posts	quote_count	int4	10			0
posts	raw	text	2147483647
posts	raw_email	text	2147483647	√		null
posts	reads	int4	10			0
posts	reply_count	int4	10			0
posts	reply_quoted	bool	1			false
posts	reply_to_post_number	int4	10	√		null
posts	reply_to_user_id	int4	10	√		null
posts	score	float8	17,17	√		null
posts	self_edits	int4	10			0
posts	sort_order	int4	10	√		null
posts	spam_count	int4	10			0
posts	topic_id	int4	10
posts	updated_at	timestamp	29,6
posts	user_deleted	bool	1			false
posts	user_id	int4	10	√		null
posts	version	int4	10			1
posts	via_email	bool	1			false
posts	vote_count	int4	10			0
posts	wiki	bool	1			false
posts	word_count	int4	10	√		null
quoted_posts	created_at	timestamp	29,6
quoted_posts	id	serial	10		√	nextval('quoted_posts_id_seq'::regclass)
quoted_posts	post_id	int4	10
quoted_posts	quoted_post_id	int4	10
quoted_posts	updated_at	timestamp	29,6
schema_migrations	version	varchar	255
screened_emails	action_type	int4	10
screened_emails	created_at	timestamp	29,6
screened_emails	email	varchar	255
screened_emails	id	serial	10		√	nextval('screened_emails_id_seq'::regclass)
screened_emails	ip_address	inet	2147483647	√		null
screened_emails	last_match_at	timestamp	29,6	√		null
screened_emails	match_count	int4	10			0
screened_emails	updated_at	timestamp	29,6
screened_ip_addresses	action_type	int4	10
screened_ip_addresses	created_at	timestamp	29,6
screened_ip_addresses	id	serial	10		√	nextval('screened_ip_addresses_id_seq'::regclass)
screened_ip_addresses	ip_address	inet	2147483647
screened_ip_addresses	last_match_at	timestamp	29,6	√		null
screened_ip_addresses	match_count	int4	10			0
screened_ip_addresses	updated_at	timestamp	29,6
screened_urls	action_type	int4	10
screened_urls	created_at	timestamp	29,6
screened_urls	domain	varchar	255
screened_urls	id	serial	10		√	nextval('screened_urls_id_seq'::regclass)
screened_urls	ip_address	inet	2147483647	√		null
screened_urls	last_match_at	timestamp	29,6	√		null
screened_urls	match_count	int4	10			0
screened_urls	updated_at	timestamp	29,6
screened_urls	url	varchar	255
single_sign_on_records	created_at	timestamp	29,6
single_sign_on_records	external_avatar_url	varchar	255	√		null
single_sign_on_records	external_email	varchar	255	√		null
single_sign_on_records	external_id	varchar	255
single_sign_on_records	external_name	varchar	255	√		null
single_sign_on_records	external_username	varchar	255	√		null
single_sign_on_records	id	serial	10		√	nextval('single_sign_on_records_id_seq'::regclass)
single_sign_on_records	last_payload	text	2147483647
single_sign_on_records	updated_at	timestamp	29,6
single_sign_on_records	user_id	int4	10
site_customizations	body_tag	text	2147483647	√		null
site_customizations	created_at	timestamp	29,6
site_customizations	enabled	bool	1
site_customizations	footer	text	2147483647	√		null
site_customizations	head_tag	text	2147483647	√		null
site_customizations	header	text	2147483647	√		null
site_customizations	id	serial	10		√	nextval('site_customizations_id_seq'::regclass)
site_customizations	key	varchar	255
site_customizations	mobile_footer	text	2147483647	√		null
site_customizations	mobile_header	text	2147483647	√		null
site_customizations	mobile_stylesheet	text	2147483647	√		null
site_customizations	mobile_stylesheet_baked	text	2147483647	√		null
site_customizations	mobile_top	text	2147483647	√		null
site_customizations	name	varchar	255
site_customizations	stylesheet	text	2147483647	√		null
site_customizations	stylesheet_baked	text	2147483647			''::text
site_customizations	top	text	2147483647	√		null
site_customizations	updated_at	timestamp	29,6
site_customizations	user_id	int4	10
site_settings	created_at	timestamp	29,6
site_settings	data_type	int4	10
site_settings	id	serial	10		√	nextval('site_settings_id_seq'::regclass)
site_settings	name	varchar	255
site_settings	updated_at	timestamp	29,6
site_settings	value	text	2147483647	√		null
site_texts	created_at	timestamp	29,6
site_texts	text_type	varchar	255
site_texts	updated_at	timestamp	29,6
site_texts	value	text	2147483647
top_topics	all_score	float8	17,17	√		0
top_topics	daily_likes_count	int4	10			0
top_topics	daily_op_likes_count	int4	10			0
top_topics	daily_posts_count	int4	10			0
top_topics	daily_score	float8	17,17	√		0
top_topics	daily_views_count	int4	10			0
top_topics	id	serial	10		√	nextval('top_topics_id_seq'::regclass)
top_topics	monthly_likes_count	int4	10			0
top_topics	monthly_op_likes_count	int4	10			0
top_topics	monthly_posts_count	int4	10			0
top_topics	monthly_score	float8	17,17	√		0
top_topics	monthly_views_count	int4	10			0
top_topics	topic_id	int4	10	√		null
top_topics	weekly_likes_count	int4	10			0
top_topics	weekly_op_likes_count	int4	10			0
top_topics	weekly_posts_count	int4	10			0
top_topics	weekly_score	float8	17,17	√		0
top_topics	weekly_views_count	int4	10			0
top_topics	yearly_likes_count	int4	10			0
top_topics	yearly_op_likes_count	int4	10			0
top_topics	yearly_posts_count	int4	10			0
top_topics	yearly_score	float8	17,17	√		0
top_topics	yearly_views_count	int4	10			0
topic_allowed_groups	group_id	int4	10
topic_allowed_groups	id	serial	10		√	nextval('topic_allowed_groups_id_seq'::regclass)
topic_allowed_groups	topic_id	int4	10
topic_allowed_users	created_at	timestamp	29,6
topic_allowed_users	id	serial	10		√	nextval('topic_allowed_users_id_seq'::regclass)
topic_allowed_users	topic_id	int4	10
topic_allowed_users	updated_at	timestamp	29,6
topic_allowed_users	user_id	int4	10
topic_custom_fields	created_at	timestamp	29,6
topic_custom_fields	id	serial	10		√	nextval('topic_custom_fields_id_seq'::regclass)
topic_custom_fields	name	varchar	256
topic_custom_fields	topic_id	int4	10
topic_custom_fields	updated_at	timestamp	29,6
topic_custom_fields	value	text	2147483647	√		null
topic_embeds	content_sha1	varchar	40	√		null
topic_embeds	created_at	timestamp	29,6
topic_embeds	embed_url	varchar	255
topic_embeds	id	serial	10		√	nextval('topic_embeds_id_seq'::regclass)
topic_embeds	post_id	int4	10
topic_embeds	topic_id	int4	10
topic_embeds	updated_at	timestamp	29,6
topic_invites	created_at	timestamp	29,6
topic_invites	id	serial	10		√	nextval('topic_invites_id_seq'::regclass)
topic_invites	invite_id	int4	10
topic_invites	topic_id	int4	10
topic_invites	updated_at	timestamp	29,6
topic_link_clicks	created_at	timestamp	29,6
topic_link_clicks	id	serial	10		√	nextval('topic_link_clicks_id_seq'::regclass)
topic_link_clicks	ip_address	inet	2147483647
topic_link_clicks	topic_link_id	int4	10
topic_link_clicks	updated_at	timestamp	29,6
topic_link_clicks	user_id	int4	10	√		null
topic_links	clicks	int4	10			0
topic_links	crawled_at	timestamp	29,6	√		null
topic_links	created_at	timestamp	29,6
topic_links	domain	varchar	100
topic_links	id	serial	10		√	nextval('topic_links_id_seq'::regclass)
topic_links	internal	bool	1			false
topic_links	link_post_id	int4	10	√		null
topic_links	link_topic_id	int4	10	√		null
topic_links	post_id	int4	10	√		null
topic_links	quote	bool	1			false
topic_links	reflection	bool	1	√		false
topic_links	title	varchar	255	√		null
topic_links	topic_id	int4	10
topic_links	updated_at	timestamp	29,6
topic_links	url	varchar	500
topic_links	user_id	int4	10
topic_search_data	locale	varchar	255
topic_search_data	raw_data	text	2147483647	√		null
topic_search_data	search_data	tsvector	2147483647	√		null
topic_search_data	topic_id	int4	10
topic_users	bookmarked	bool	1	√		false
topic_users	cleared_pinned_at	timestamp	29,6	√		null
topic_users	first_visited_at	timestamp	29,6	√		null
topic_users	highest_seen_post_number	int4	10	√		null
topic_users	id	serial	10		√	nextval('topic_users_id_seq'::regclass)
topic_users	last_emailed_post_number	int4	10	√		null
topic_users	last_read_post_number	int4	10	√		null
topic_users	last_visited_at	timestamp	29,6	√		null
topic_users	liked	bool	1	√		false
topic_users	notification_level	int4	10			1
topic_users	notifications_changed_at	timestamp	29,6	√		null
topic_users	notifications_reason_id	int4	10	√		null
topic_users	posted	bool	1			false
topic_users	topic_id	int4	10
topic_users	total_msecs_viewed	int4	10			0
topic_users	user_id	int4	10
topic_views	ip_address	inet	2147483647
topic_views	topic_id	int4	10
topic_views	user_id	int4	10	√		null
topic_views	viewed_at	date	13
topics	archetype	varchar	255			'regular'::character varying
topics	archived	bool	1			false
topics	auto_close_at	timestamp	29,6	√		null
topics	auto_close_based_on_last_post	bool	1	√		false
topics	auto_close_hours	float8	17,17	√		null
topics	auto_close_started_at	timestamp	29,6	√		null
topics	auto_close_user_id	int4	10	√		null
topics	avg_time	int4	10	√		null
topics	bookmark_count	int4	10			0
topics	bumped_at	timestamp	29,6
topics	category_id	int4	10	√		null
topics	closed	bool	1			false
topics	created_at	timestamp	29,6
topics	deleted_at	timestamp	29,6	√		null
topics	deleted_by_id	int4	10	√		null
topics	excerpt	varchar	1000	√		null
topics	featured_user1_id	int4	10	√		null
topics	featured_user2_id	int4	10	√		null
topics	featured_user3_id	int4	10	√		null
topics	featured_user4_id	int4	10	√		null
topics	has_summary	bool	1			false
topics	highest_post_number	int4	10			0
topics	id	serial	10		√	nextval('topics_id_seq'::regclass)
topics	illegal_count	int4	10			0
topics	image_url	varchar	255	√		null
topics	inappropriate_count	int4	10			0
topics	incoming_link_count	int4	10			0
topics	last_post_user_id	int4	10
topics	last_posted_at	timestamp	29,6	√		null
topics	like_count	int4	10			0
topics	moderator_posts_count	int4	10			0
topics	notify_moderators_count	int4	10			0
topics	notify_user_count	int4	10			0
topics	off_topic_count	int4	10			0
topics	participant_count	int4	10	√		1
topics	percent_rank	float8	17,17			1.0
topics	pinned_at	timestamp	29,6	√		null
topics	pinned_globally	bool	1			false
topics	posts_count	int4	10			0
topics	reply_count	int4	10			0
topics	score	float8	17,17	√		null
topics	slug	varchar	255	√		null
topics	spam_count	int4	10			0
topics	subtype	varchar	255	√		null
topics	title	varchar	255
topics	updated_at	timestamp	29,6
topics	user_id	int4	10	√		null
topics	views	int4	10			0
topics	visible	bool	1			true
topics	vote_count	int4	10			0
topics	word_count	int4	10	√		null
twitter_user_infos	created_at	timestamp	29,6
twitter_user_infos	id	serial	10		√	nextval('twitter_user_infos_id_seq'::regclass)
twitter_user_infos	screen_name	varchar	255
twitter_user_infos	twitter_user_id	int8	19
twitter_user_infos	updated_at	timestamp	29,6
twitter_user_infos	user_id	int4	10
uploads	created_at	timestamp	29,6
uploads	filesize	int4	10
uploads	height	int4	10	√		null
uploads	id	serial	10		√	nextval('uploads_id_seq'::regclass)
uploads	origin	varchar	1000	√		null
uploads	original_filename	varchar	255
uploads	retain_hours	int4	10	√		null
uploads	sha1	varchar	40	√		null
uploads	updated_at	timestamp	29,6
uploads	url	varchar	255
uploads	user_id	int4	10
uploads	width	int4	10	√		null
user_actions	acting_user_id	int4	10	√		null
user_actions	action_type	int4	10
user_actions	created_at	timestamp	29,6
user_actions	id	serial	10		√	nextval('user_actions_id_seq'::regclass)
user_actions	target_post_id	int4	10	√		null
user_actions	target_topic_id	int4	10	√		null
user_actions	target_user_id	int4	10	√		null
user_actions	updated_at	timestamp	29,6
user_actions	user_id	int4	10
user_avatars	created_at	timestamp	29,6
user_avatars	custom_upload_id	int4	10	√		null
user_avatars	gravatar_upload_id	int4	10	√		null
user_avatars	id	serial	10		√	nextval('user_avatars_id_seq'::regclass)
user_avatars	last_gravatar_download_attempt	timestamp	29,6	√		null
user_avatars	updated_at	timestamp	29,6
user_avatars	user_id	int4	10
user_badges	badge_id	int4	10
user_badges	granted_at	timestamp	29,6
user_badges	granted_by_id	int4	10
user_badges	id	serial	10		√	nextval('user_badges_id_seq'::regclass)
user_badges	notification_id	int4	10	√		null
user_badges	post_id	int4	10	√		null
user_badges	seq	int4	10			0
user_badges	user_id	int4	10
user_custom_fields	created_at	timestamp	29,6
user_custom_fields	id	serial	10		√	nextval('user_custom_fields_id_seq'::regclass)
user_custom_fields	name	varchar	256
user_custom_fields	updated_at	timestamp	29,6
user_custom_fields	user_id	int4	10
user_custom_fields	value	text	2147483647	√		null
user_exports	created_at	timestamp	29,6	√		null
user_exports	file_name	varchar	255
user_exports	id	serial	10		√	nextval('user_exports_id_seq'::regclass)
user_exports	updated_at	timestamp	29,6	√		null
user_exports	user_id	int4	10
user_fields	created_at	timestamp	29,6	√		null
user_fields	description	varchar	255
user_fields	editable	bool	1			false
user_fields	field_type	varchar	255
user_fields	id	serial	10		√	nextval('user_fields_id_seq'::regclass)
user_fields	name	varchar	255
user_fields	required	bool	1			true
user_fields	show_on_profile	bool	1			false
user_fields	updated_at	timestamp	29,6	√		null
user_histories	acting_user_id	int4	10	√		null
user_histories	action	int4	10
user_histories	admin_only	bool	1	√		false
user_histories	context	varchar	255	√		null
user_histories	created_at	timestamp	29,6
user_histories	custom_type	varchar	255	√		null
user_histories	details	text	2147483647	√		null
user_histories	email	varchar	255	√		null
user_histories	id	serial	10		√	nextval('user_histories_id_seq'::regclass)
user_histories	ip_address	varchar	255	√		null
user_histories	new_value	text	2147483647	√		null
user_histories	post_id	int4	10	√		null
user_histories	previous_value	text	2147483647	√		null
user_histories	subject	text	2147483647	√		null
user_histories	target_user_id	int4	10	√		null
user_histories	topic_id	int4	10	√		null
user_histories	updated_at	timestamp	29,6
user_open_ids	active	bool	1
user_open_ids	created_at	timestamp	29,6
user_open_ids	email	varchar	255
user_open_ids	id	serial	10		√	nextval('user_open_ids_id_seq'::regclass)
user_open_ids	updated_at	timestamp	29,6
user_open_ids	url	varchar	255
user_open_ids	user_id	int4	10
user_profiles	badge_granted_title	bool	1	√		false
user_profiles	bio_cooked	text	2147483647	√		null
user_profiles	bio_cooked_version	int4	10	√		null
user_profiles	bio_raw	text	2147483647	√		null
user_profiles	card_background	varchar	255	√		null
user_profiles	card_image_badge_id	int4	10	√		null
user_profiles	dismissed_banner_key	int4	10	√		null
user_profiles	location	varchar	255	√		null
user_profiles	profile_background	varchar	255	√		null
user_profiles	user_id	int4	10
user_profiles	website	varchar	255	√		null
user_search_data	locale	text	2147483647	√		null
user_search_data	raw_data	text	2147483647	√		null
user_search_data	search_data	tsvector	2147483647	√		null
user_search_data	user_id	int4	10
user_stats	days_visited	int4	10			0
user_stats	first_post_created_at	timestamp	29,6	√		null
user_stats	likes_given	int4	10			0
user_stats	likes_received	int4	10			0
user_stats	new_since	timestamp	29,6
user_stats	post_count	int4	10			0
user_stats	posts_read_count	int4	10			0
user_stats	read_faq	timestamp	29,6	√		null
user_stats	time_read	int4	10			0
user_stats	topic_count	int4	10			0
user_stats	topic_reply_count	int4	10			0
user_stats	topics_entered	int4	10			0
user_stats	user_id	int4	10
user_visits	id	serial	10		√	nextval('user_visits_id_seq'::regclass)
user_visits	posts_read	int4	10	√		0
user_visits	user_id	int4	10
user_visits	visited_at	date	13
users	active	bool	1			false
users	admin	bool	1			false
users	approved	bool	1			false
users	approved_at	timestamp	29,6	√		null
users	approved_by_id	int4	10	√		null
users	auth_token	varchar	32	√		null
users	auto_track_topics_after_msecs	int4	10	√		null
users	blocked	bool	1	√		false
users	created_at	timestamp	29,6
users	date_of_birth	date	13	√		null
users	digest_after_days	int4	10	√		null
users	disable_jump_reply	bool	1			false
users	dynamic_favicon	bool	1			false
users	edit_history_public	bool	1			false
users	email	varchar	256
users	email_always	bool	1			false
users	email_digests	bool	1
users	email_direct	bool	1			true
users	email_private_messages	bool	1	√		true
users	enable_quoting	bool	1			true
users	external_links_in_new_tab	bool	1
users	flag_level	int4	10			0
users	id	serial	10		√	nextval('users_id_seq'::regclass)
users	ip_address	inet	2147483647	√		null
users	last_emailed_at	timestamp	29,6	√		null
users	last_posted_at	timestamp	29,6	√		null
users	last_redirected_to_top_at	timestamp	29,6	√		null
users	last_seen_at	timestamp	29,6	√		null
users	locale	varchar	10	√		null
users	mailing_list_mode	bool	1			false
users	moderator	bool	1	√		false
users	name	varchar	255	√		null
users	new_topic_duration_minutes	int4	10	√		null
users	password_hash	varchar	64	√		null
users	previous_visit_at	timestamp	29,6	√		null
users	primary_group_id	int4	10	√		null
users	registration_ip_address	inet	2147483647	√		null
users	salt	varchar	32	√		null
users	seen_notification_id	int4	10			0
users	suspended_at	timestamp	29,6	√		null
users	suspended_till	timestamp	29,6	√		null
users	title	varchar	255	√		null
users	trust_level	int4	10
users	trust_level_locked	bool	1			false
users	updated_at	timestamp	29,6
users	uploaded_avatar_id	int4	10	√		null
users	username	varchar	60
users	username_lower	varchar	60
users	views	int4	10			0
versions	created_at	timestamp	29,6
versions	id	serial	10		√	nextval('versions_id_seq'::regclass)
versions	modifications	text	2147483647	√		null
versions	number	int4	10	√		null
versions	reverted_from	int4	10	√		null
versions	tag	varchar	255	√		null
versions	updated_at	timestamp	29,6
versions	user_id	int4	10	√		null
versions	user_name	varchar	255	√		null
versions	user_type	varchar	255	√		null
versions	versioned_id	int4	10	√		null
versions	versioned_type	varchar	255	√		null
warnings	created_at	timestamp	29,6	√		null
warnings	created_by_id	int4	10
warnings	id	serial	10		√	nextval('warnings_id_seq'::regclass)
warnings	topic_id	int4	10
warnings	updated_at	timestamp	29,6	√		null
warnings	user_id	int4	10