Database Schema

Database Schema

Users

column name	data type	details
id	integer	primary key/ not null
username	varchar	not null
email	varchar	not null
hashedPassword	varchar	not null
createdAt	timestamp	not null
updatetAt	timestamp	not null

Tracks

column name	data type	details
id	integer	primary key/ not null
userId	integer	foreign key/ not null
title	varchar	not null
imageUrl	varchar	nullable
createdAt	timestamp	not null
updatetAt	timestamp	not null

Songs

column name	data type	details
id	integer	primary key/ not null
userId	integer	foreign key/ not null
title	varchar	not null
imageUrl	varchar	not null
createdAt	timestamp	not null
updatetAt	timestamp	not null

Comments

column name	data type	details
id	integer	primary key/ not null
userId	integer	foreign key/ not null
trackId	integer	foreign key/ not null
songId	integer	foreign key/ not null
body	varchar	not null
createdAt	timestamp	not null
updatetAt	timestamp	not null