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 ...[ 查看全文 ]