Drop table posts_categories.
Create table post_categories and change M:M association from throw posts_categories to post_categories.
When posts had been destroyed then destroy related comments at the same time.
When users had been destroyed then destroy related posts and comments and the same time.
When posts or categories had been destroyed then destroy job table too.