论坛交流
首页办公自动化| 网页制作| 平面设计| 动画制作| 数据库开发| 程序设计| 全部视频教程
应用视频: Windows | Word2007 | Excel2007 | PowerPoint2007 | Dreamweaver 8 | Fireworks 8 | Flash 8 | Photoshop cs | CorelDraw 12
编程视频: C语言视频教程 | HTML | Div+Css布局 | Javascript | Access数据库 | Asp | Sql Server数据库Asp.net  | Flash AS
当前位置 > 文字教程 > asp教程
Tag:入门,文摘,实例,技巧,iis,表单,对象,上传,数据库,记录集,session,cookies,存储过程,注入,分页,安全,优化,xmlhttp,fso,jmail,application,防盗链,stream,组件,md5,乱码,缓存,加密,验证码,算法,ubb,正则表达式,水印,,日志,压缩,url重写,控件,函数,破解,触发器,socket,ADO,初学,聊天室,留言本,视频教程

制作我们自己的Ebay(拍卖系统)(3)

文章类别:asp | 发表日期:2008-10-5 20:42:30

Based on the information in the previous section, we have a good understanding of what our database schema should look like. The following tables list our database structure:

tblAuctions
AID:Unique ID to keep track of records Autonumber
StartDate:Date the auction started Date/Time
EndDate:Date the auction is to end Date/Time
SellerID:The ID of the seller. (Foreign key to user table) Integer

tblAuctionItems
IID:Unique ID to keep track of records Autonumber
AID:Which auction does this item belong to? (Foreign key to Auctions table) Integer
Name: Name of the item being sold Text
Description: Description of the item being sold Text
MinPrice: Minimum price to sell (specified by the seller) Money
Increment: Value to increment proxy bids by (specified by the seller) Money
Available: Number of items available to sell Integer

tblAuctionBids
BID: Unique ID to keep track of records Autonumber
IID: Unique ID to keep track of items (foreign key to AuctionItem table) Integer
UID: Unique ID to keep track of bidders (foreign key to AuctionUsers table) Integer
WinPrice :Current price for a user (calculated by application) Money
MaxBid: Maximum price for a user Money
BidItems :The number of items this user bid for Integer
WinItems: The number of items this user would win if the auction ended immediately Integer
Time: The last time this bid was updated Date/Time   

tblAuctionUsers
UID :Unique ID to keep track of records Autonumber
Name :Name of user Text

Note that the above tables are simply used for example. You may decide to store more information for your purposes (i.e., you may store more than just a name in the user table). Already, however, the schema is getting kind of complex - each table has foreign keys to one or more other tables.


NOTE: You can use a pre-existing user table if you wish. We simply provide the tblAuctionUsers table definition for completeness sake.  

视频教程列表
文章教程搜索
 
Asp推荐教程
Asp热门教程
看全部视频教程
购买方式/价格
购买视频教程: 咨询客服
tel:15972130058