The Data Model and Stored Procedures
For MyGolfGear.NET, we created several tables to hold orders while they are being created and manipulated by the users. We called these “Basket” tables. For now, we will focus on two of those tables: Basket and BasketItems. The Basket table, described in Table 14.2, contains high-level information about orders, such as order totals and user IDs.
| Field Name | Data Type | Description |
|---|---|---|
| OrderID (PK) | uniqueidentifier | The unique ID of an order. |
| OrderDate | Datetime | The date and time the order is being placed. |
| UserID | uniqueidentifier | The ID of the user who is creating this order. |
| Status | Int | Status of the order; for future growth. Examples are Creation, Product Selection, and Submission. |
| ShippingTotal ... |
Get Building e-Commerce Sites with the .NET Framework now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
