Sample Data Model

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