Why would you add category_id in the table post ? We want to make things organised and logical.

We have the table post (id,title, text, date)
and category (id, name)

Then the goal is to create a table with name, say post_category linking id in post and id in category.

What do you have to say about the above?