Table topp.atn.users Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('atn.users_id_seq'::regclass)
firstname varchar 255  √  null
lastname varchar 255  √  null
email text 2147483647  √  null
password text 2147483647  √  null
userdir text 2147483647  √  null
date text 2147483647  √  null
organization text 2147483647  √  null
authcode text 2147483647  √  null
authorized int4 10  √  null
defperm int4 10  √  null
username text 2147483647  √  null
regcite text 2147483647  √  null

Table contained 28 rows at Wed Dec 27 13:21 PST 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc users_pkey  
username Must be unique Asc users_username_key This unique column is also nullable