Integration Project

A pseudo auction website for CS 250. - Kyle Kinkade

Get Started. It's Free
or sign up with your email address
Integration Project by Mind Map: Integration Project

1. PHP

1.1. PDO

1.2. Data Verification

2. JavaScript

2.1. JQuery

2.1.1. Data Verification

2.1.2. Nice Forms

2.2. WYSIWYG Editor

3. Database

3.1. users

3.1.1. userid

3.1.1.1. Primary Key

3.1.1.2. Unique

3.1.1.3. AutoIncrement

3.1.1.4. Integer

3.1.2. username

3.1.2.1. Unique

3.1.2.2. Require

3.1.2.3. Text

3.1.3. password

3.1.3.1. Required

3.1.3.2. Text (MD5)

3.1.4. email

3.1.4.1. Unique

3.1.4.2. Required

3.1.4.3. Text

3.1.5. firstName

3.1.5.1. Required

3.1.5.2. Text

3.1.6. lastName

3.1.6.1. Required

3.1.6.2. Text

3.1.7. dateRegistered

3.1.7.1. Required

3.1.7.2. Date

3.1.7.3. Default

3.1.7.3.1. 00:00:00 01-01-1900

3.1.8. dateLastOnline

3.1.8.1. Required

3.1.8.2. Date

3.1.8.3. Default

3.1.8.3.1. dateRegistered

3.1.9. avgRating

3.1.9.1. Required

3.1.9.2. Real

3.1.9.3. Default

3.1.9.3.1. 0.00

3.1.10. numRatings

3.1.10.1. Required

3.1.10.2. Integer

3.1.10.3. Default

3.1.10.3.1. 0

3.2. auctions

3.2.1. auctionid

3.2.1.1. Primary Key

3.2.1.2. Unique

3.2.1.3. AutoIncrement

3.2.1.4. Integer

3.2.2. sellerid

3.2.2.1. Integer

3.2.2.2. Joined To:

3.2.2.2.1. users.userid

3.2.3. topBidid

3.2.3.1. Unique

3.2.3.2. Integer

3.2.3.3. Joined To:

3.2.3.3.1. bids.bidid

3.2.4. auctionTitle

3.2.4.1. Required

3.2.4.2. Text

3.2.4.3. Default

3.2.4.3.1. ""

3.2.5. auctionDescription

3.2.5.1. Text

3.2.5.2. Default

3.2.5.2.1. "No description has been given to this auction."

3.2.6. dateCreated

3.2.6.1. Date

3.2.7. duration

3.2.7.1. Real

3.2.8. active

3.2.8.1. Boolean

3.2.8.2. Default

3.2.8.2.1. True

3.2.9. tags

3.2.9.1. Text

3.3. bids

3.3.1. bidid

3.3.1.1. Primary Key

3.3.1.2. AutoIncrement

3.3.1.3. Unique

3.3.1.4. Integer

3.3.2. auctionid

3.3.2.1. Integer

3.3.2.2. Joined To: auctions.auctionid

3.3.3. bidderid

3.3.3.1. Integer

3.3.3.2. Joined To:

3.3.3.2.1. users.userid

3.3.4. amount

3.3.4.1. Required

3.3.4.2. Real

3.3.4.3. Default

3.3.4.3.1. 0.00

3.3.5. outbid

3.3.5.1. Boolean

3.3.5.2. Default

3.3.5.2.1. False

3.3.6. won

3.3.6.1. Boolean

3.3.6.2. Default

3.3.6.2.1. False

4. Page Layout

4.1. Register

4.1.1. Functions

4.1.1.1. Verify Data

4.1.1.2. Email Verification Code

4.1.1.2.1. "Verification code sent to $email. If you do not receive the code, click here."

4.1.1.2.2. "To change the email associated with this account, click here."

4.1.2. Content

4.1.2.1. Registration Form

4.1.2.1.1. Username

4.1.2.1.2. Password

4.1.2.1.3. Repeat Password

4.1.2.1.4. Email

4.1.2.1.5. Repeat Email

4.1.2.1.6. Human Check

4.2. Login

4.2.1. Functions

4.2.1.1. Verify Login

4.2.1.2. Create Session

4.2.1.3. Redirect -> My Auctions

4.2.2. Content

4.2.2.1. Login Form

4.2.2.1.1. Username or Email

4.2.2.1.2. Password

4.2.2.2. Recover Account Name

4.2.2.3. Recover Password

4.3. My Auctions

4.3.1. Create an Auction

4.3.1.1. Creation Form

4.3.1.1.1. Item Name

4.3.1.1.2. Auction Title

4.3.1.1.3. Auction Description

4.3.1.1.4. Tags

4.3.1.1.5. Starting Price

4.3.1.1.6. Buyout Price

4.3.1.1.7. Quantity

4.3.1.1.8. Duration

4.3.1.2. Auction Guidelines

4.3.2. Table of Current Auctions

4.3.2.1. Auction Title

4.3.2.2. Auction Description

4.3.2.3. Current Top Bid

4.3.2.4. Time Remaining

4.3.3. Table of Completed Auctions

4.3.3.1. Auction Title

4.3.3.2. Auction Description

4.3.3.3. End Date

4.3.3.4. Final Price

4.4. My Bids

4.4.1. Table of Auctions Bid On

4.4.1.1. Auction Title

4.4.1.2. Auction Description

4.4.1.3. Current Top Bid

4.4.1.4. Your Last Bid

4.4.1.5. Time Remaining

4.4.1.6. Quick Bid

4.4.2. Table of Recent Auctions

4.4.2.1. Auction Title

4.4.2.2. Auction Description

4.4.2.3. End Date

4.4.2.4. Final Price

4.5. Auction Page

4.5.1. Your Auction

4.5.1.1. Modify an Auction

4.5.1.2. Cancel Auction

4.5.2. Other's Auction

4.5.2.1. Place Bid

4.5.2.2. Seller's Rating

4.5.2.3. View User's Profile

4.6. User Profile

4.6.1. User's Public Information

4.6.1.1. User Name

4.6.1.2. Seller Rating

4.6.1.3. Number of Ratings

4.6.1.4. Table of Current Auctions

4.6.1.4.1. Auction Title

4.6.1.4.2. Auction Description

4.6.1.4.3. Current Top Bid

4.6.1.4.4. Time Remaining

4.6.1.5. Table of Completed Auctions

4.6.1.5.1. Auction Title

4.6.1.5.2. Auction Description

4.6.1.5.3. End Date

4.6.1.5.4. Final Price

4.6.1.6. Last Online

4.7. Search Auctions

4.7.1. By Keyword

4.7.2. Advanced Search

4.7.2.1. By Auction Name

4.7.2.2. By Seller Name

4.7.2.3. By Tags

4.7.2.4. By Price Range

4.7.2.4.1. Min | Max

4.7.2.5. By Remaining Time

4.8. Search Users

4.9. Includes

4.9.1. Header

4.9.1.1. Non-Member

4.9.1.1.1. Logo

4.9.1.1.2. Search Bar

4.9.1.1.3. Would you like to register? Sign up now!

4.9.1.1.4. Already a member? Sign in!

4.9.1.2. Member

4.9.1.2.1. Logo

4.9.1.2.2. Search Bar

4.9.1.2.3. Welcome, $username | Logout

4.9.1.2.4. Your Account

4.9.1.2.5. Your Auctions

4.9.1.2.6. Your Bids

4.9.1.2.7. Create Auction

4.9.2. Footer

4.9.2.1. Copyright | Kyle Kinkade

4.9.2.2. Contact

4.9.2.3. About

4.9.2.4. Site Map

4.9.2.5. FAQ

4.9.2.6. Project Documents

5. Future Features

5.1. Comment on Auctions

5.2. Leave Feedback for Sellers

5.3. Private Messaging

5.4. Report User

5.5. User Profiles

5.5.1. About Section

5.5.2. Data Protection

5.5.3. New node

5.6. More Auction Features

5.6.1. Payment Method

5.6.2. Shipping Method

5.6.3. Tax

5.6.4. Return Policy

5.6.5. Fixed Price (Only Buyout)

5.7. Product Suggestions

5.8. More Search Functions

6. Questions

6.1. How do I handle Verification Codes? Verification table? If entry exists for user, not verified? Verification Code and Verified in users table?

6.2. Verification Code Handling?

6.2.1. A verification table?

6.2.1.1. verifyid

6.2.1.1.1. Primary Key

6.2.1.1.2. AutoIncrement

6.2.1.1.3. Unique

6.2.1.1.4. Integer

6.2.1.2. userid

6.2.1.2.1. Integer

6.2.1.2.2. Joined To:

6.2.1.3. code

6.2.1.3.1. Text

6.2.2. Add to users table?

6.2.2.1. + verifyCode

6.2.2.1.1. Text

6.2.2.2. + verified

6.2.2.2.1. Boolean

6.2.2.2.2. Default