I am designing a CMS, and would like to start with a simple database schema, with the requirements
- Two main types of entity,
Post
andCategory
- For
Post
, it need to support multilingual and versioning - For
Category
, only multilingual support is needed. - For both type, hierarchical relationship support (see the
parent
field) 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.
Best Answer
A CMS model looks like something complex but lets try to think up something.
Since a PNG is worth 1024 words, here's a conceptual model. I'll be adding edits as you ask questions in the comments section: