Database Schema (CMS)

System Models

These core models power the CMS functionality:

`User`: Admin and editor accounts. Linked to Account and Session for auth.

`Role`: Defines permissions (e.g., ADMIN, EDITOR, VIEWER).

`DocArticle`: Polymorphic model for Documentation and SOPs.

`BlogPost`: public articles with slug, excerpt, coverImage, and publishedAt.

`MediaItem`: Stores metadata for uploaded assets (url, type, size).

`VendorProfile`: Core vendor record with scores and contact info.

`ComplianceRecord`: Tracks individual document uploads and expiry dates.

`FooterSetting`: Global footer configuration (tagline, copyright).

`FooterSection`: Configurable column in the footer.

`FooterLink`: Individual links within a section.