Auction Demo Architecture: SQL Tables

Items Table

IDAutoNumber
TitleText
ArtistText
DimensionsText
MaterialsText
YearNumber
DescriptionMemo
Preview_smallText
Preview_largeText

Bids Table

TimestampNumber
TitleText
PriceCurrency
TimeDate/Time
BidderText

The items table describes all the items being auctioned, and the bids table contains all the bids for those items. Notice the timestamp column, which is used for synchronizing the client with bids made by other users.

HomeBack to the XML Auction Demo overview.

© 1997 Microsoft Corporation. All rights reserved. Terms of use.