Schema - rfoong8983/sweet_flex_project GitHub Wiki
Database Schema
Users
| column name | data type | details |
|---|---|---|
id |
integer | required: true, primary key |
username |
string | required: true, unique |
password_hash |
string | required: true, |
date |
date | required: true, default: now |
Tweets/Searches
| column name | data type | details |
|---|---|---|
id |
integer | required: true, primary key |
user_id |
string | required: true, unique |
hashtag |
string | required: true, |
date |
date | required: true, default: now |
Sentiments
| column name | data type | details |
|---|---|---|
hashtag |
string | required: true, primary key |
tweet_date |
date | required: true, unique |
user_id |
integer | required: true, |
joy |
float/number | required: true, |
sadness |
number | required: true, |
anger |
number | required: true, |
date |
date | required: true, default: now (not sure if this will be the same as tweet_date) |