/SQL/Creating a comment and reply system PHP and MySQL

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  title         | VARCHAR(255) |            |
|  slug          | VARCHAR(255) | UNIQUE     |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  user_id       | INT(11)      |            |
|  post_id       | INT(11)      |            |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+------------------------+------------+
|     field      |     type               | specs      |
+----+-----------+------------------------+------------+
|  id            | INT(11)                |            |
|  username      | VARCHAR(255)           | UNIQUE     |
|  email         | VARCHAR(255)           | UNIQUE     |
|  password      | VARCHAR(255)           |            |
|  created_at    | TIMESTAMP              |            |
+----------------+--------------+---------+------------+

Source: codewithawa.com

Creating a comment and reply system PHP and MySQL

+----+-----------+--------------+------------+
|     field      |     type     | specs      |
+----+-----------+--------------+------------+
|  id            | INT(11)      |            |
|  user_id       | INT(11)      |            |
|  comment_id    | INT(11)      |            |
|  body          | TEXT         |            |
|  created_at    | TIMESTAMP    |            |
|  updated_at    | TIMESTAMP    |            |
+----------------+--------------+------------+

Source: codewithawa.com

Similar codes

1 vote130 views1 answer
How to get mysql db size
SQL
4 votes145 views1 answer
Oracle user tables
SQL
0 vote139 views1 answer
Table values functions in SQL
SQL
1 vote129 views1 answer
Sql server 2012 query history
SQL
17 votes142 views3 answers
Cast in sql server
SQL
0 vote276 views1 answer
Multiple row join
SQL
0 vote130 views2 answers
Show slave status mysql
SQL
3 votes99 views4 answers
Mysql delete duplicate rows
SQL
11 votes145 views2 answers
Turn off safe mode mysql
SQL
7 votes134 views3 answers
Sql update where id
SQL