Address
Address ID int
Address Li ne nvarc har(50)
AddressLine2 nvarc har(50)
City nvarc har(50)
St at e nvarc har(50)
Pos tal Code nvarc har(50)
Column Name Data Type Allow Nulls
EndUser
EndUser ID int
EndUser TypeID int
FirstName nvarchar(50)
LastName nvarchar(50)
Addres sID int
Cont act Infor mat i onID int
Password nvarchar(50)
IsSubscribed bi t
Column Name Data Type Allow Nulls
FK_EndUser_Address
FK
_
EndUser
_
ContactInformation
EndUserType
EndUs erTypeI D int
TypeName nvarchar(50)
Column Name Data Type Allow Nulls
FK
_
EndUs er
_
EndUs er T
ype
FK_OrderDetails_Orders
FK_Orders_OrderStatus
ProductC ategory
Product Categor yID int
ProductCategoryName text
Column Name Data Type Allow Nulls
ProductImages
Product ImageID int
Product Image image
Column Name Data Type Allow Nulls
Products
Product ID int
ProductCategoryID int
Product Name nvarchar(50)
Product ImageI D int
Des c ri pt i on text
Pri ce smallmoney
Column Name Data Type Allow Nulls
FK_OrderDetails_Products
FK
_
Product s
_
Product Cate
g
or
y
FK
_
Product s
_
ProductIma
g
es
ShoppingCart
Shoppi ngCart ID int
CartGUID nvarchar (50)
Quantity int
ProductID int
DateCreat ed smalldatetime
Column Name Data Type Allow Nulls
Orders
OrderID int
TransactionID nvarc har(50)
EndUs er ID int
OrderStatusID int
OrderDate smalldatetime
Shi pDate smalldatetime
TrackingNumber nvarc har(50)
Column Name Data Type Allow Nulls
OrderDetails
OrderDetailID int
OrderID int
Product ID int
Quantity int
Column Name Data Type Allow Nulls
Order Status
OrderStatusID int
OrderStatusName nvarchar(50)
Column Name Data Type Allow Nulls
ContactInformation
ContactInformationID int
Phone nvarchar(50)
Phone2 nvarchar(50)
Fax nvarchar(50)
Email nvarchar(50)
Column Name Data Type Allow Nulls
FK_ShoppingCart _Produc ts
