Database Schema - lukewhchen/babybook GitHub Wiki
Users
| column |
data type |
detail |
| id |
integer |
not null, primary key |
| first_name |
string |
not null |
| last_name |
string |
not null |
| email |
string |
not null |
| password_digest |
string |
not null |
| session_token |
string |
not null |
| hometown |
string |
optional |
| workplace |
string |
optional |
| school |
string |
optional |
| gender |
string |
optional |
| image_url |
string |
optional |
| timestamps |
datetime |
|
Posts
| column |
data type |
detail |
| id |
integer |
not null, primary key |
| body |
text |
not null |
| author_id |
integer |
not null, foreign key |
| post_image_url |
string |
|
| timestamps |
datetime |
|
Comments
| column |
data type |
detail |
| id |
integer |
not null, primary key |
| body |
string |
not null |
| author_id |
integer |
not null, foreign key |
| timestamps |
datetime |
|
Likes
| column |
data type |
detail |
| id |
integer |
not null, primary key |
| post_id |
integer |
not null, foreign key |
| author_id |
integer |
not null, foreign key |
| timestamps |
datetime |
|
Friendships
| column |
data type |
detail |
| id |
integer |
not null, primary key |
| friend_id |
integer |
not null, foreign key |
| timestamps |
datetime |
|