Schema - mkochalko/musicMD GitHub Wiki

Database Schema

users

column name data type details
id integer primary key
username string unique: true, required: true
email string unique: true, required: true
password string required: true
created_at datetime required: true
updated_at datetime required: true

events

column name data type details
id integer primary key
venue string required: true
artist string required: true
address string required: true
song_ids string default: []
date datetime required: true

library

column name data type details
id integer primary key
user_id integer foreign_key, required: true
event_ids string default: []
song_ids string default: []
created_at datetime required: true
updated_at datetime required: true

songs

column name data type details
id integer primary key
artist string required: true
song_name string required: true
created_at datetime required: true
updated_at datetime required: true