Case 3 MySQL Database Planning
With the database, I wish to make a comments page that will utilize a MySQL database. I have decided to name my database comments which will consist of five columns. The first would be ID, which will be assigned to each entry. The next will be name. The name will contain whatever name someone writes into the field. The third will be the user’s email address the column will be called email. The fourth will contain a subject, in other words, a short description about what the comment will discuss, it'll be called subject. The last column will be comment, which will contain the comment that the user types.
| Field | Type | Size | Constraint | Extra |
|---|---|---|---|---|
| id | int | 4 | Primary Key | Auto Increment |
| name | varchar | 40 | - | - |
| varchar | 60 | - | - | |
| subject | varchar | 100 | - | - |
| comment | varchar | 400 | - | - |