1. users
1.1. userid
1.1.1. Primary Key
1.1.2. Unique
1.1.3. AutoIncrement
1.1.4. Integer
1.2. username
1.2.1. Unique
1.2.2. Require
1.2.3. Text
1.3. password
1.3.1. Required
1.3.2. Text (MD5)
1.4. email
1.4.1. Unique
1.4.2. Required
1.4.3. Text
1.5. firstName
1.5.1. Required
1.5.2. Text
1.6. lastName
1.6.1. Required
1.6.2. Text
1.7. dateRegistered
1.7.1. Required
1.7.2. Date
1.7.3. Default
1.7.3.1. 00:00:00 01-01-1900
1.8. dateLastOnline
1.8.1. Required
1.8.2. Date
1.8.3. Default
1.8.3.1. dateRegistered
1.9. avgRating
1.9.1. Required
1.9.2. Real
1.9.3. Default
1.9.3.1. 0.00
1.10. numRatings
1.10.1. Required
1.10.2. Integer
1.10.3. Default
1.10.3.1. 0
2. auctions
2.1. auctionid
2.1.1. Primary Key
2.1.2. Unique
2.1.3. AutoIncrement
2.1.4. Integer
2.2. sellerid
2.2.1. Integer
2.2.2. Joined To:
2.2.2.1. users.userid
2.3. topBidid
2.3.1. Unique
2.3.2. Integer
2.3.3. Joined To:
2.3.3.1. bids.bidid
2.4. auctionTitle
2.4.1. Required
2.4.2. Text
2.4.3. Default
2.4.3.1. ""
2.5. auctionDescription
2.5.1. Text
2.5.2. Default
2.5.2.1. "No description has been given to this auction."
2.6. dateCreated
2.6.1. Date
2.7. duration
2.7.1. Real
2.8. active
2.8.1. Boolean
2.8.2. Default
2.8.2.1. True
2.9. tags
2.9.1. Text
3. bids
3.1. bidid
3.1.1. Primary Key
3.1.2. AutoIncrement
3.1.3. Unique
3.1.4. Integer
3.2. auctionid
3.2.1. Integer
3.2.2. Joined To: auctions.auctionid
3.3. bidderid
3.3.1. Integer
3.3.2. Joined To:
3.3.2.1. users.userid
3.4. amount
3.4.1. Required
3.4.2. Real
3.4.3. Default
3.4.3.1. 0.00
3.5. outbid
3.5.1. Boolean
3.5.2. Default
3.5.2.1. False
3.6. won
3.6.1. Boolean
3.6.2. Default
3.6.2.1. False