Table cxgn.sgn_people.sp_login_old

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column	Type	Size	Nulls	Auto	Default
sp_login_id	serial	10		√	nextval('sp_login_old_sp_login_id_seq'::regclass)
username	varchar	255	√		null
private_email	varchar	255	√		null
pending_email	varchar	255	√		null
password	varchar	255	√		null
confirm_code	varchar	20	√		null
disabled	int8	19	√		null
user_type	varchar	9	√		'user'::character varying

Table contained 393 rows at Wed May 20 02:02 EDT 2009

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
sp_login_id	Primary key	Asc	sp_login_pkey
private_email	Performance	Asc	private_email_idx
username	Must be unique	Asc	username_unique	This unique column is also nullable