I am designing a CMS, and would like to start with a simple database schema, with the requirements
- Two main types of entity,
Post, it need to support multilingual and versioning
Category, only multilingual support is needed.
- For both type, hierarchical relationship support (see the
parentfield) is needed.
Now, I have prepared a simple design like the following
I want to seek your expert advices if any improvements can be done or corrections are needed.