Database Schema - Lee6413/Flickr-Clone GitHub Wiki
Users
| column name |
data type |
details |
| id |
integer |
not null, primary key |
| userName |
string |
not null, unique |
| email |
string |
not null |
| hashedPassword |
string |
not null |
| createdAt |
datetime |
not null |
| updatedAt |
datetime |
not null |
Albums
| column name |
data type |
details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| title |
string |
not null |
| createdAt |
datetime |
not null |
| updatedAt |
datetime |
not null |
Images
| column name |
data type |
details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| albumId |
integer |
not null |
| imageURL |
string |
not null |
| content |
string |
not null |
| createdAt |
datetime |
not null |
| updatedAt |
datetime |
not null |
Comments
| column name |
data type |
details |
| id |
integer |
not null, primary key |
| userId |
integer |
not null |
| imageId |
integer |
not null |
| comment |
string |
not null |
| createdAt |
datetime |
not null |
| updatedAt |
datetime |
not null |