|
马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。
您需要 登录 才可以下载或查看,没有帐号?立即注册
x
使用cdonts,可以发送、查看邮件,实现webmail的功能。结合wsh,可以实现对nt主机的管理,如nt用户管理、iis虚拟主机设置、exchange邮箱设置等等,就像管理本地机一样方便。Basedontheinformationintheprevioussection,wehaveagoodunderstandingofwhatourdatabaseschemashouldlooklike.Thefollowingtableslistourdatabasestructure:
tblAuctions
AID:UniqueIDtokeeptrackofrecordsAutonumber
StartDate:DatetheauctionstartedDate/Time
EndDate:DatetheauctionistoendDate/Time
SellerID:TheIDoftheseller.(Foreignkeytousertable)Integer
tblAuctionItems
IID:UniqueIDtokeeptrackofrecordsAutonumber
AID:Whichauctiondoesthisitembelongto?(ForeignkeytoAuctionstable)Integer
Name:NameoftheitembeingsoldText
Description:DescriptionoftheitembeingsoldText
MinPrice:Minimumpricetosell(specifiedbytheseller)Money
Increment:Valuetoincrementproxybidsby(specifiedbytheseller)Money
Available:NumberofitemsavailabletosellInteger
tblAuctionBids
BID:UniqueIDtokeeptrackofrecordsAutonumber
IID:UniqueIDtokeeptrackofitems(foreignkeytoAuctionItemtable)Integer
UID:UniqueIDtokeeptrackofbidders(foreignkeytoAuctionUserstable)Integer
WinPrice:Currentpriceforauser(calculatedbyapplication)Money
MaxBid:MaximumpriceforauserMoney
BidItems:ThenumberofitemsthisuserbidforInteger
WinItems:ThenumberofitemsthisuserwouldwiniftheauctionendedimmediatelyInteger
Time:ThelasttimethisbidwasupdatedDate/Time
tblAuctionUsers
UID:UniqueIDtokeeptrackofrecordsAutonumber
Name:NameofuserText
Notethattheabovetablesaresimplyusedforexample.Youmaydecidetostoremoreinformationforyourpurposes(i.e.,youmaystoremorethanjustanameintheusertable).Already,however,theschemaisgettingkindofcomplex-eachtablehasforeignkeystooneormoreothertables.
NOTE:Youcanuseapre-existingusertableifyouwish.WesimplyprovidethetblAuctionUserstabledefinitionforcompletenesssake.
缺乏可以共同遵循的行业标准,ASP还处在发展初期,大家对它的理解不同,如产品和服务标准,收费标准等,不利于行业的健康发展。 |
|