Customer:
| CustomerID |
| FirstName |
| LastName |
| BusinessName |
Designation
EmailAddress |
| JoinDateTime |
| AvatarImageURL |
|
|
|
Item:
| ItemID |
| ItemName |
| Manufacturer |
| Unit |
| UnitCost |
| Discount |
| Quantity |
|
|
|
Address:
| AddressID |
| CustomerID |
| AddressType |
| Address1 |
| Address2 |
| City |
| State |
| Zip |
|
|
|
Order:
OrderID
OrderNo |
| CustomerID |
| OrderDateTime |
| ShippingAddressID |
| GrossAmount |
| DiscountCode |
| TotalAmount |
| OrderStatus |
|
|
|
|
|
|
|
Order Details:
| OrderDetailsID |
| OrderID |
| ItemID |
| UnitCost |
| Quantity |
| Amount |
| NetAmount |
| Status |
|
|
|
|
|
Payments:
| PaymentsID |
| CustomerID |
| OrderID |
BillingAddressID
PaymentDateTime |
|
|
|
|
|
|
|
PaymentDetails:
| PaymentDetailsID |
| PaymentsID |
| PaymentMode |
| Name |
| Number |
| Amount |
| ExpiryDate |
| AuthDetails |
| Status |
|
|
|
|