-
Notifications
You must be signed in to change notification settings - Fork 1
Postgres Database Schema
jas-singh-code edited this page Mar 17, 2021
·
26 revisions
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
lastname | string | not null, indexed, unique |
firstname | string | not null |
age | integer | not null |
gender | string | not null |
location | string | not null |
occupation | string | not null |
string | not null, indexed, unique | |
password_digest | string | not null, indexed |
session_token | string | not null, indexed, unique |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
message | text | not null |
poster_id | integer | not null, indexed, foreign key |
wall_id | integer | not null, indexed, foreign key |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
body | text | not null |
author_id | integer | not null, foreign key |
post_id | integer | not null, foreign key |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
liker_id | integer | not null, indexed, foreign key |
comment_id | integer | not null ,indexed, foreign key |
post_id | integer | not null, indexed, foreign key |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
sender_id | integer | not null, indexed, foreign key |
receiver_id | integer | not null, indexed, foreign key |
created_at | datetime | not null |
updated_at | datetime | not null |
column name | data type | details |
---|---|---|
id | integer | not null, primary key |
friend1_id | integer | not null, indexed, foreign key |
friend2_id | integer | not null, indexed, foreign key |
created_at | datetime | not null |
updated_at | datetime | not null |