Database Plan
user table:
| Column Name | Variable Type | Attributes |
|---|---|---|
| user_id | INT(10) | UNSIGNED PRIMARY_KEY AUTO_INCREMENT |
| user_name | VARCAHR(50) | NOT_NULL |
| user_password | VARCAHR(20) | NOT_NULL |
| user_fname | VARCAHR(20) | NOT_NULL |
| user_lname | VARCAHR(20) | NOT_NULL |
comment table
| Column Name | Variable Type | Attributes |
|---|---|---|
| comment_id | INT(10) | UNSIGNED PRIMARY_KEY AUTO_INCREMENT |
| comment_text | VARCAHR(20000) | NOT_NULL |
| comment_author | INT(10) | NOT_NULL FOREIGN_KEY |
| comment_date | DATE | NOT_NULL |
| comment_post | INT(10) | NOT_NULL FOREIGN_KEY |
post table
| Column Name | Variable Type | Attributes |
|---|---|---|
| post_id | INT(10) | UNSIGNED PRIMARY_KEY AUTO_INCREMENT |
| post_content | VARCAHR(20000) | NOT_NULL |
| post_category | VARCHAR(20) | NOT_NULL |
| post_date | DATE | NOT_NULL |