Schema

Postgres Database Schema

Users

column name	data type	details
id	bigint	not null, primary key
username	string	not null, indexed, unique
password_digest	string	not null
email	string	not null, indexed, unique
name	string	not null
birth_date	string	not null
session_token	string	not null, indexed, unique
created_at	datetime	not null
updated_at	datetime	not null

Songs

Playlists

Likes

Artists

Albums