FairWay Furniture Resell Application

My peers and I created a furniture reselling application inspired by the website WayFair. First, we produced a logical model for a relational database in MySQL. We then devised and implemented a REST API using Flask to provide access to the data. Following this, we drafted a collection of user interface pages that represented a minimum viable product (MVP) of the application. These pages outlined major features and presented data views tailored to key archetype users, offering a clear vision of the product's functionality and user experience.

Synopsis:
FairWay is North America’s one-stop fix to buying and selling furniture and homegoods in one simple ecommerce website. On the backend, we act as the middleman, building a database of manufacturers and sellers, partnering with both small and large companies who wish to sell their products online and need customers to ship them to. On the frontend, we have customers come to our website, input the type of goods that they need, and connect them to the database we have created. Ideally, this provides a simple way for customers and manufacturers to explore all of their home furnishing options. With an increased focus on online shopping and delivery focused shopping, FairWay makes it easy for home good specific businesses to connect to customers. Focusing entirely on this area of goods, we aim specifically at new home-owners, college students, and anyone looking to decorate their home in a quick and efficient manner.

User Archetype 1 (Customer) -
A customer is a person who purchases products that are marketed at FairWay. The system should allow the user to store the following information: their first and last name, unique ID, phone number, email, address, and an invoice that contains a list of purchased products. The system should also allow the customer to select products that they would like to buy and complete transactions.

User Archetype 2 (Manufacturer) -
A manufacturer is a person who produces goods to be sold by the seller to the customer. The system should allow manufacturers to store the following information: First name, Last name, Manufacturer ID (unique), phone number, email address, products available, and who sells their products. FairWay should also allow the manufacturer to see which products sellers require and volumes of products required to be manufactured.

User Archetype 3 (Seller) -
A seller is a person who purchases goods from manufactures and sells goods to customers. The system should allow the seller to store the following data: First name, Last name, Seller ID(unique), phone number, email address, product purchased from manufacturer, manufacture ID, manufacture name, product available for selling, customer order, customer name, and customer ID. Fairway should allow the seller to see what goods are available from manufacturers and what order the customers made.