Is it ok to use this Database Integrity, Table relations and Database design pattern

Vote count:

1

I try to create a database design to suit my needs.

I would really appreciate any of your recommendation for my following table design:

I have two components: Categories and Content.

Whenever I create a new item for any of those two components, a new route item should be created also, with relations like shown on visual diagram.

Is it good practice to have the following columns in those tables like ci_routes.refid, ci_categories.slug and ci_content.slug ?

asked 1 min ago

aspirinemaga

1,100