Database Schema - Hieu-Ma/Journey GitHub Wiki
Users
| Column Name |
Data Type |
Details |
| id |
Integer |
not null, primary key |
| email |
String |
not null |
| user_name |
String(15) |
not null |
| hashed_password |
String(15) |
not null, unique |
| created_at |
dateTime |
not null |
| updated_at |
dateTime |
not null |
Journals
| column name |
data type |
details |
| id |
integer |
not null |
| user_id |
integer |
not null, unique |
| title |
string |
not null |
| created_at |
timestamp |
not null |
| updated_at |
timestamp |
not null |
Entries
| column name |
data type |
details |
| id |
integer |
not null |
| journal_id |
integer |
not null, unique |
| title |
string |
not null |
| description |
string |
not null |
| created_at |
timestamp |
not null |
| updated_at |
timestamp |
not null |