ASP.NET

By: Xianzhong Zhu	Search For More Articles! Disclaimer Author Terms
Rating: / 3
2007-12-05

Table of Contents:

Tables and Relationships for an ASP.NET AJAX Server-Centric Based Online Shopping Website - Tables continued

(Page 2 of 4 )

Table 4—Structure for table ‘Product’

Field name	Type	Notes
ProductID	int	Primary Key identifying the record
Name	varchar(200)	The product name
CategoryID	int	Foreign Key, referring to the Category ID that the product belongs to
Desn	text	Detailed description for the product
Sell	varchar(200)	The name of the supplier
CreateDate	datetime	Manufacturing datetime
SellInDate	datetime	Stock datetime
Unit	varchar(50)
Quantity	int	Current quantity of this kind of product
Upper	int	The maximum stock quantity of this kind of product
Lower	int	The minimum stock quantity of this kind of product
InPrice	money	Stock price
OutPrice	money	Sale price
PictureID	int	Identifying the related Picture ID of the product. Foreign Key.
Remark	text	Memo info for the product

Table 5—Structure for table ‘Pictures’

Field name	Type	Notes
PictureID	int	Primary Key identifying the record
Desn	varchar(200)	The name of the image/picture
Type	varchar(200)	The type of the image/picture
Data	image	The factual data about the image/picture

Table 6—Structure for table ‘Comment’

Field name	Type	Notes
CommentID	int	Primary Key identifying the record
Desn	varchar(200)	Title of the comment
Body	varchar(200)	The detailed content of the comment
Date	image	The time the comment was created
ProductID	int	Identifying the Product ID that the comment belongs to. Foreign Key.
UserID	int	Identifying the User ID that makes the comment. Foreign Key.

Table 7—Structure for table ‘OrderForm’

Field name	Type	Notes
OrderFormID	int	Primary Key identifying the record
UserID	int	Identifying the UserID that places the order. Foreign Key.
TotalNumber	int	The total number of the product to buy
TotalMoney	money	The total fee of the product to buy
OrderDate	datetime	The datetime when the order is placed
State	int	Identifying the status of the order

Best Practices: Safe and Secure Hardware Asset Recovery
Companies increasingly must meet EPA and local requirements for the disposal of ....

Managing SSL Security in Multi-Server Environments
Read this white paper to learn how to simplify management of your organization's....

Open Source Security Myths
Open Source Software (OSS) is computer software whose source code is available t....

Power and Cooling Capacity Management for Data Centers
This paper describes the principles for achieving power and cooling capacity man....