We sell furniture of all kinds which are grouped into 9 basic categories:

1. Chairs
2. Beds
3. Couches
4. Dressers
5. Shelves
6. Tables
7. Cabinets
8. Desks
9. Other

Other is used for any furniture that does not fit the previous 8 categories.

When someone registers onto our site, we capture 3 claims:

1. Name
   a. We have a claim for your name in order to personalize the site to you
2. Email
   a. We have a claim for your email to store it in an easy to access location
3. Location
   a. We have a claim for your location to give promotions for specific locations where we are located

We are enforcing 2 policies:

1. Admin Only
   a. We are enforcing this policy because we need the ability to edit our inventory but not give access to a regular member
   (This way a random person can't "delete" all of our stock)
2. Location a. We are enforcing this policy so we can give promotions to specific locations as we our promotions only apply to certain locations
3. Member Only
   a. We are enforcing this policy so that only members can purchase our products.

Microsoft
Google

We have a products table to store all the products.
This stores:

• Product ID
• Product Sku
• Product Name
• Product Price
• Product Image
• Product Description
• Product Category

We have a basket table to store every basket made by every user in our user database.
This stores:

• Basket ID
• User Id
• List of Basket Items
• If it is Processed

We have a basket item table to store the references to the products and the baskets as well as hold the quantity of the product that the user wishes to buy.
This stores:

• Basket Item ID
• Basket ID
• Product
• Product ID
• Quantity

We have an Order table to store the orders that have come in.
This holds a reference to the Basket it is related to and the basket items that are being purchased.
This stores:

• Order ID
• List of Basket Items
• User Id
• Basket ID
• Total Price
• Date of Order
• If it is Processed

Please click here to access our site.
If that doesn't work, go to: https://jjcommerce.azurewebsites.net/
and you will be brought to the same place.

Our vulnerability report can be found here

Jimmy Chang
Judah Hunger