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) |
|
|
|
|