search

cedricparages / projectTwo

0 stars 0 forks source link

DB Schema #10

Open nkeyes94 opened 4 years ago

nkeyes94 commented 4 years ago

Create a DB schema to house our data.

Thus far the data we will need:

-Email -Password

nkeyes94 commented 4 years ago

We need to figure out the parameters for our database and then finalize a schema for development.

With my experience working on the login functionality thus far, what I've found is that we'll need some of these fields: -Email address (For logging in, doesn't need to be encrypted, STRING) -Password (Encrypted STRING) -Bonus: Add additional user information (F-Name, L-Name, Sign-up date, etc.)

I think we'll also need to add the following fields to our database: -Favorites: For this, the names of our users' favorite artists/bands should be saved as a string. This way, upon logging in we can pull their favorites data and then dynamically generate pages for their favorites.

If you have any other ideas, please post a comment regarding them. Thanks!