-
Notifications
You must be signed in to change notification settings - Fork 1
Doc User
Max Bender edited this page Oct 3, 2016
·
1 revision
For Amable, we have to keep track of our users.
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)