Alternative Home ButtonCIT 235 logo
School
  • CIT 230
  • CIT 235
Bio
  • Mike and Brit's Blog
  • Our Family
Current Projects
  • Hoggan's Rock Solid Gear
    Test Site
  • PHP Motors
Portfolio
  • BurgWear
  • Nature's Nook
  • The Auto Spa Plus

You Are Here: Home > School's Main Page > CIT 235 Main Page > Database Table Blueprint

Database Table Blueprint

Before we get started structuring our databases, we were told to make a blueprint of how we would classify the structuring for our database, particularly to PHP Motor's contact page and a future register page. This is an idea of how I would set it up.

Contact Information
Communications customer # Primary Key INT unsigned autoincrement
Name VARCHAR (60)
Email VARCHAR (60)
Message VARCHAR (60)
Date TIMESTAMP
IP Address VARCHAR
PRIMARY KEY (message_id)
Registration Information
Registration register_id INT unsigned autoincrement
Address VARCHAR (60)
City VARCHAR
State VARCHAR
Zip Code INT
Phone Number INT
Username VARCHAR (60)
Password VARCHAR (60)
PRIMARY KEY (register_id)
FOREIGN KEY (message_id) REFERENCES (message_id)

Back

Last Updated on April 4, 2009 3:50 PM

© 2008, Mike Hoggan, All rights reserved
Contact Me | Terms | Privacy | Colophon | CIT 230 | CIT 235 | Mike and Brit's Blog
Our Family | Hoggan's Rugged Gear Test Site | BurgWear | Nature's Nook | The Auto Spa Plus

Valid CSS! Valid XHTML 1.0 Strict