-
Notifications
You must be signed in to change notification settings - Fork 0
Schema
dannyjyan edited this page Mar 12, 2019
·
1 revision
| 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 |
| 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 |
| 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) |