Categorizing blog posts

[mactron]

I'm working on a simple CMS system. So my question is how to add categories of blogs inside database correctly. If I understand EAV I need to add two tables; one table for names, descriptions of categories and one table for categories IDs and posts IDs.

I'm correct?

Cheers

blog_tbl

+------+---------+--------+---------------+-------------------+---------+
| b_id | b_title | b_text | b_seo_title   | b_seo_description | slug    |
+------+---------+--------+---------------+-------------------+---------+
|  1   | Title 1 | txt 1  |  70 charsets  | 170 charsets      | title-1 |
|  2   | Title 2 | txt 2  |  70 charsets  | 170 charsets      | title-2 |
+------+---------+--------+---------------+-------------------+---------+

 

Edited February 23, 2020 by mactron

[requinix]

39 minutes ago, mactron said:

If I understand EAV I need to add two tables; one table for names, descriptions of categories and one table for categories IDs and posts IDs.

Sounds good to me. Assuming you want multiple categories applied to each blog post, that is.