Architecture
Database Schema (CMS)
Database Schema (CMS)
System Models
These core models power the CMS functionality:
Performance Indexes
To ensure fast query times, we apply the following indexes:
BlogPost and DocArticle for fast URL lookups.Recursive Relations
The Header system uses a recursive self-relation:
model HeaderItem {
id String @id @default(uuid())
children HeaderItem[] @relation("ParentChild")
parent HeaderItem? @relation("ParentChild", fields: [parentId], references: [id])
parentId String?
}
Allows: Header -> Dropdown -> Nested Item -> Deep Link.