|
tblAuctions |
|
tblAuctionItems |
|
AID |
Unique ID to keep track of records |
Autonumber |
|
IID |
Unique ID to keep track of records |
Autonumber |
|
StartDate |
Date the auction started |
Date/Time |
|
AID |
Which auction does this item belong to?
(Foreign key to Auctions table) |
Integer |
| EndDate |
Date the auction is to end |
Date/Time |
|
Name |
Name of the item being sold |
Text |
|
SellerID |
The ID of the seller. (Foreign key to user table) |
Integer |
|
Description |
Description of the item being sold |
Text |
| |
|
MinPrice |
Minimum price to sell (specified by the seller) |
Money |
|
tblAuctionBids |
|
Increment |
Value to increment proxy bids by (specified by the seller) |
Money |
| BID |
Unique ID to keep track of records |
Autonumber |
|
Available |
Number of items available to sell |
Integer |
| 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 |
|
tblAuctionUsers |
|
WinPrice |
Current price for a user (calculated by application) |
Money |
|
UID |
Unique ID to keep track of records |
Autonumber |
|
MaxBid |
Maximum price for a user |
Money |
|
Name |
Name of user |
Text |
|
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 |
|
|
