Database Schema

Database Schema

Users

Column Name	Data Type	Details
id	INTEGER	primary key, not null
username	VARCHAR(30)	not null, unique
email	VARCHAR(255)	not null, unique
hashedPassword	VARBINARY	not null
profilePictureUrl	VARCHAR(255)
createdAt	TIMESTAMP	not null
updatedAt	TIMESTAMP	not null

Tracks

Column Name	Data Type	Details
id	INTEGER	not null, primary key
userId	INTEGER	not null, foreign key
albumId	INTEGER	not null, foreign key
url	VARCHAR(255)	not null
title	VARCHAR(255)	not null
createdAt	TIMESTAMP	not null
updatedAt	TIMESTMAP	not null

• userId references Users
• albumId references Albums

Comments

Column Name	Data Type	Details
id	INTEGER	not null, primary key
userId	INTEGER	not null, foreign key
trackId	INTEGER	not null, foreign key
body	TEXT	not null
createdAt	TIMESTAMP	not null
updatedAt	TIMESTAMP	not null

• userId references Users
• trackId references Tracks