Dj Duggy Record Pool - Terlam/DWT Wiki

ERD

Here's a lite version of the ERD for the DJ Duggy app

User

       - UserID (PK)

     - DJname/UserName

     - first name - string 

 - last name - string

 - email - email

 - password - string

 - IG -string unique

 - Twitter - string unique

 - city - string

 - dj - boolean

 - artist - boolean

 - title - string 

     - photo - string 

table version in progress...

column type
user_id varchar
user_name varchar
first_name varchar
lastame varchar
email varchar

Position

- UserID (FK)
- UserTitle - string

Song

- SongID (PK)
- audiofile
- release Date
- genre
- author
- title
- userID (FK)

Genre

- songID (FK)
- genre
- (together are primary keys)

App Pages

name assignee link
landing page DeAndre https://xd.adobe.com/view/10681fa4-d585-48bc-b8cc-d28130d5c316-453b/screen/7a3f0fa8-dbb9-4d6a-b275-2fc3cc904fb3
register Will
login Will
profile Terrell
upload Terrell
music feed Will
song page Terrell

Figma Link: https://www.figma.com/file/lqQQFMKX0WUWvNbqPOa6h7/dj_duggy_mockup

Other Record pools

https://www.djcity.com/

Software Stack

We are planning to use the MERN stack to build this project. This includes Mongo DB, Express.js, React, and Node.js.