SchemaSpy - Table discourse.public.users

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default
id	serial	10		√	nextval('users_id_seq'::regclass)
username	varchar	60
created_at	timestamp	29,6
updated_at	timestamp	29,6
name	varchar	255	√		null
seen_notification_id	int4	10			0
last_posted_at	timestamp	29,6	√		null
email	varchar	256
password_hash	varchar	64	√		null
salt	varchar	32	√		null
active	bool	1			false
username_lower	varchar	60
auth_token	varchar	32	√		null
last_seen_at	timestamp	29,6	√		null
admin	bool	1			false
last_emailed_at	timestamp	29,6	√		null
email_digests	bool	1
trust_level	int4	10
email_private_messages	bool	1	√		true
email_direct	bool	1			true
approved	bool	1			false
approved_by_id	int4	10	√		null
approved_at	timestamp	29,6	√		null
digest_after_days	int4	10	√		null
previous_visit_at	timestamp	29,6	√		null
suspended_at	timestamp	29,6	√		null
suspended_till	timestamp	29,6	√		null
date_of_birth	date	13	√		null
auto_track_topics_after_msecs	int4	10	√		null
views	int4	10			0
flag_level	int4	10			0
ip_address	inet	2147483647	√		null
new_topic_duration_minutes	int4	10	√		null
external_links_in_new_tab	bool	1
enable_quoting	bool	1			true
moderator	bool	1	√		false
blocked	bool	1	√		false
dynamic_favicon	bool	1			false
title	varchar	255	√		null
uploaded_avatar_id	int4	10	√		null
email_always	bool	1			false
mailing_list_mode	bool	1			false
locale	varchar	10	√		null
primary_group_id	int4	10	√		null
registration_ip_address	inet	2147483647	√		null
last_redirected_to_top_at	timestamp	29,6	√		null
disable_jump_reply	bool	1			false
edit_history_public	bool	1			false
trust_level_locked	bool	1			false

Table contained 8 rows at Fri Mar 27 12:26 PDT 2015

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	users_pkey
auth_token	Performance	Asc	index_users_on_auth_token
	Must be unique		index_users_on_email	These unique columns are also nullable
last_posted_at	Performance	Asc	index_users_on_last_posted_at
last_seen_at	Performance	Asc	index_users_on_last_seen_at
username	Must be unique	Asc	index_users_on_username
username_lower	Must be unique	Asc	index_users_on_username_lower