Application requirements, defined in Chapter 4, Requirement Specification for Modular Web Shop App, give us some wireframes relating to the cart and checkout. Based on these wireframes, we can speculate about what type of entities we need to create in order to deliver on functionality.
The following is a list of required module entities:
Cart
Cart Item
Order
Order Item
The Cart
entity includes the following properties and their data types:
id
: integer, auto-incrementcustomer_id
: stringcreated_at
: datetimemodified_at
: datetime
The Cart Item
entity includes the following properties:
id
: integer, auto-incrementcart_id
: integer, foreign key that references the categorytable id
columnproduct_id
: integer, foreign key that references producttable id
columnqty
: stringunit_price
: decimalcreated_at
: datetimemodified_at
: datetime
The Order
entity includes the following properties:
id
: integer, auto-incrementcustomer_id
: integer, foreign key that references the customertable id
column...