schema

Jump to bottom

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"