Database Schema - euniceparkk/TravelScape-Copy GitHub Wiki
Users
| column |
data type |
details |
| id |
integer |
not null, primary key |
| pen_name |
varchar(20) |
not null, unique |
| email |
varchar(50) |
not null, unique |
| bio |
text |
|
| profile_pic |
text |
|
| hashedPW |
varchar(255) |
not null |
| createdAt |
timestampz |
not null |
| updatedAt |
timestampz |
not null |
Articles
| column |
data type |
details |
| id |
integer |
not null, primary key |
| title |
varchar(100) |
not null |
| content |
text |
not null |
| imageSrc |
text |
|
| userId |
integer |
not null, foreign key |
| createdAt |
timestampz |
not null |
| updatedAt |
timestampz |
not null |
Comments
| column |
data type |
details |
| id |
integer |
not null, primary key |
| content |
varchar(255) |
not null |
| articleId |
integer |
not null, onDelete |
| userId |
integer |
not null |
| createdAt |
timestampz |
not null |
| updatedAt |
timestampz |
not null |
PenPals
| column |
data type |
details |
| id |
integer |
not null, primary key |
| followerId |
integer |
not null |
| followingId |
integer |
not null |
| createdAt |
timestampz |
not null |
| updatedAt |
timestampz |
not null |
Stamps
| column |
data type |
details |
| id |
integer |
not null, primary key |
| articleId |
integer |
not null, onDelete |
| userId |
integer |
not null |
| createdAt |
timestampz |
not null |
| updatedAt |
timestampz |
not null |