/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

2 votes296 views1 answer
Coalesce sql
SQL
0 vote261 views3 answers
Sql all columns
SQL
-2 votes258 views3 answers
Oracle tablespace usage
SQL
0 vote333 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote263 views1 answer
Groupby error in mysql
SQL
4 votes298 views2 answers
Sqlalchemy_database_uri for mysql
SQL
0 vote272 views1 answer
Alter check command
SQL
1 vote283 views1 answer
Customer using hdfc bank sql query
SQL
0 vote259 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote262 views1 answer
Mostrar datos de tablas relacionadas mysql kjava
SQL