Back to the assignments page
Case 3 planning MySQL Database Tables Description for Table: content
| Field Name |
Data Type |
Specification |
Description |
| cont_id |
int |
auto Incrament |
primary Key |
| cont_page_id |
varchar |
20 char |
|
| cont_content |
varchar |
5000 char |
|
| cont_advertising |
varchar |
5000 char |
|
Case 3 planning MySQL Database Tables Description for Table: Users
| Field Name |
Data Type |
Specification |
Description |
| user_id |
int |
auto Incrament |
primary Key |
| user_username |
varchar |
30 char |
|
| user_password |
varchar |
30 char |
|
| user_first_name |
varchar |
30 char |
|
| user_last_name |
varchar |
30 char |
|
| user_email |
varchar |
100 char |
|
Case 3 planning MySQL Database Tables Description for Table: Feedback
| Field Name |
Data Type |
Specification |
Description |
| feed_id |
int |
auto Incrament |
primary Key |
| feed_email |
varchar |
100 char |
|
| feed_first_name |
varchar |
30 char |
|
| feed_last_name |
varchar |
30 char |
|
| feed_comment |
varchar |
5000 char |
|
| feed_timestamp |
timestamp |
update |
|
