Database Schema

users

column name	data type	details
id	int	not null, primary key
user_name	string	not null, unique
hashedPassword	string	not null
session_token	string	not null, indexed, unique
created_at	timestamp	not null
updated_at	timestamp	not null

songs

column name	data type	details
id	int	not null, primary key
name	string	not null
artist	string	not null
upload_id	int	not null, foreign key
image_url	string
audio_url	string	not null
created_at	timestamp	not null
updated_at	timestamp	not null

• upload_id references users table