-
Notifications
You must be signed in to change notification settings - Fork 0
Database Schema
Tommy Pham edited this page Apr 3, 2018
·
22 revisions
| Column Name | Data Type | Details |
|---|---|---|
| ID | Integer | Not Null, Primary Key |
username |
String | Not Null, Indexed, Unique |
password_digest |
String | Not Null |
session_token |
String | Not Null, Indexed, Unique |
email |
String | Not Null, Indexed, Unique |
profile_picture_url |
String | |
created_at |
Date Time | Not Null |
updated_at |
Date Time | Not Null |
- Destroying a user will remove all blogs and follows associated with that user
- Will transitively remove all likes associated with blogs as well
| Column Name | Data Type | Details |
|---|---|---|
| ID | Integer | Not Null, Primary Key |
author_id |
Integer | Not Null, Foreign Key(refers to a User), Indexed |
content_type |
String | Not Null, Options(text, quote, image, audio, video) |
title |
String | |
description |
Text | |
quote |
String | |
has_attached_file |
String | |
created_at |
Date Time | Not Null |
updated_at |
Date Time | Not Null |
-
has_attached_filecontent type will be validated viavalidates_attachment_content_type - Destroying a blog will remove all likes associated with that blog
| Column Name | Data Type | Details |
|---|---|---|
| ID | Integer | Not Null, Primary Key |
follower_id |
Integer | Not Null, Foreign Key(refers to a User), Indexed |
followee_id |
Integer | Not Null, Foreign Key(refers to a user), Indexed |
created_at |
Date Time | Not Null |
updated_at |
Date Time | Not Null |
| Column Name | Data Type | Details |
|---|---|---|
| ID | Integer | Not Null, Primary Key |
liker_id |
Integer | Not Null, Foreign Key(refers to a User), Indexed |
liked_blog_id |
Integer | Not Null, Foreign Key(refers to a Blog), Indexed |
created_at |
Date Time | Not Null |
updated_at |
Date Time | Not Null |