User Documentation

For Amable, we have to keep track of our users.

User DDL

Table "public.users"
    Column     |            Type             |                     Modifiers                      
---------------+-----------------------------+----------------------------------------------------
 id            | integer                     | not null default nextval('users_id_seq'::regclass)
 username      | character varying(80)       | 
 email         | character varying(120)      | 
 password      | character varying(128)      | not null
 salt          | character varying(128)      | not null
 name          | character varying(128)      | 
 role          | character varying(10)       | 
 bio           | text                        | 
 website       | character varying(128)      | 
 location      | character varying(128)      | 
 phone         | character varying(10)       | 
 dob           | timestamp without time zone | 
 profile_image | character varying(128)      | 
 date_created  | timestamp without time zone | not null
 date_modified | timestamp without time zone | not null
Indexes:
    "users_pkey" PRIMARY KEY, btree (id)
    "users_email_key" UNIQUE CONSTRAINT, btree (email)
    "users_username_key" UNIQUE CONSTRAINT, btree (username)
Referenced by:
    TABLE "comments" CONSTRAINT "comments_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "community_users" CONSTRAINT "community_users_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "post_reports" CONSTRAINT "post_reports_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "post_upvotes" CONSTRAINT "post_upvotes_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "posts" CONSTRAINT "posts_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)
    TABLE "reports" CONSTRAINT "reports_user_id_fkey" FOREIGN KEY (user_id) REFERENCES users(id)