Worklog for task "Design the data structure in haih-cms"
Progress: Target model conceptually defined
The legacy database analysis confirmed heavy duplication of the content infrastructure: different types of materials are distributed across specialized tables while repeating the same features—text, URL, SEO, publication, sorting, etc.
A target decision has been made: content entities of the new site are, wherever possible, reduced to a universal Concept. Differences between a case study, service, FAQ, page, news article, and other materials are expressed through content, type, URI, hierarchy, and relationships, rather than the mandatory creation of a new table and CRUD.
This decision is viewed as the foundation for AI-driven content: the fewer special schemas an agent has to understand, the easier mass automated editing and further project development will be.
Design the target data model for haih-cms based on the needs of the new website, using the legacy database solely as a data source rather than an architectural template.