Built on top of the database for a pizza store @thamaranth and I created, all the API routes are located in routes/index.js
- Create several "Business Reporting" functions which return data on various aspects of the business (total sales per year, etc..)
- Basic API provided with ability to CRUD the data in the database.
- STRETCH SPEC Add user authentication and functions that allow a user to alter various aspects of their accounts.
- Create a detailed E-R diagram.
- Perform as much logic as possible in the database.
- Track all of its customers and any relevant customer information, such as customer ID, name, username/login details, delivery address, phone number, payment methods on file.
- Track the ingredients that comprise each of these preferences (e.g., onions, ham, pineapple, anchovies, bacon, etc.)
- Track standard drinks, including a product ID, drink description, manufacturer, supplier, price
- Track its pizza sizes (small, medium, large, extra large), types (thick or thin crust), ingredients (pepperoni, sausage, mushrooms, onions, cheese, etc.), price data for these pizza sizes and ingredients.
- Maintain a history of transactions - all purchases including price, payment method, and delivery date.
The artifact produced is properly licensed, preferably with the MIT license.