schema - Rmark92/Soundstorm GitHub Wiki
Users
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | primary key |
| username | string | not null, unique, indexed |
| password | string | not null |
| session_token | string | not null |
| profile_image_url | string | |
| background_image_url | string |
Tracks
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | primary key |
| title | string | not null |
| artist_id | integer | not null, foreign key on users(id) |
| track_image_url | string | |
| track_url | string | not null |
Comments
| Column Name | Data Type | Details |
|---|---|---|
| id | integer | primary key |
| body | text | not null |
| track_id | integer | not null, foreign key on tracks(id) |
| author_id | integer | not null, foreign key on users(id) |