Skip to content
Kieran Scannell edited this page Feb 28, 2020 · 2 revisions

Database Schema

users

column name data type details
username string required, unique
email string required, unique
password string required
token string
dateOfBirth date required
gender string required, enum: ["Male", "Female", "Non-binary"]
followedPlaylists array of ids ref "playlists"

songs

column name data type details
title string required
album id required, ref "albums"
artist id required, ref "artists"

artists

column name data type details
name string required
albums array of ids ref "albums"

albums

column name data type details
name string required
artist id ref "artists"
songs array of ids ref "songs"
genre string required

playlists

column name data type details
name string required
creator id ref "users"
songs array of ids ref "songs"

genres

column name data type details
name string required
albums array of ids ref "albums"

Clone this wiki locally