This repository was archived by the owner on Nov 27, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Database Schema
B Salinas edited this page Apr 26, 2021
·
12 revisions
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
| username | string(50) | not null, unique |
| hashedPassword | string.binary | not null |
| profilePic | string(255) | not null |
| session_token | string | not null, unique |
| created_at | datetime | not null |
| updated_at | datetime | not null |
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
title |
string(150) | not null |
user_id |
integer | not null, foreignKey |
album_id |
integer | not null, foreignKey |
| created_at | datetime | not null |
| updated_at | datetime | not null |
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
| title | string(150) | not null |
user_id |
integer | not null, foreignKey |
| created_at | datetime | not null |
| updated_at | datetime | not null |
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
user_id |
integer | not null |
song_id |
integer | not null |
| created_at | datetime | not null |
| updated_at | datetime | not null |
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
user_id |
integer | not null, foreignKey |
song_id |
integer | not null, foreignKey |
| content | string(250) | not null |
| created_at | datetime | not null |
| updated_at | datetime | not null |
| Column Name | Data Type | Details |
|---|---|---|
id |
integer | serial, not null, primary key |
user_id |
integer | not null, foreignKey |
followed_user_id |
integer | not null, foreignKey |
| created_at | datetime | not null |
| updated_at | datetime | not null |