Database Schema

The repository includes migrations under database/migrations/ and a full SQL dump at database/db/database.sql. The schema is large; this document focuses on the CMS-relevant tables.

Core Tables (Observed) - websites, websites_pages - CategoriesCities - MGPages, PPages - Locations - Dictionary - content_version - Files - Slideshows, SlideshowsItems, SlideshowsKind - Forms, Fields, Choices, FormsSent, FormsSentFields - investor_relation_reports, reports_downloadable, reports_hardcoded

Schema Note - Many tables use legacy naming conventions (capitalized table names, custom primary keys). Models reflect these mappings.

Simplified Entity Diagram

erDiagram
    WEBSITES ||--o{ WEBSITES_PAGES : has
    CATEGORIESCITIES ||--o{ MGPAGES : has
    CATEGORIESCITIES ||--o{ NEWSPAGES : has
    CATEGORIESCITIES ||--o{ LOCATIONS : has
    LOCATIONS ||--o{ PPAGES : has
    MGPAGES ||--o{ CONTENT_VERSION : versions
    PPAGES ||--o{ CONTENT_VERSION : versions
    DICTIONARY ||--o{ MGPAGES : content
    DICTIONARY ||--o{ PPAGES : content
    FILES ||--o{ SLIDESHOWS_ITEMS : media
    FORMS ||--o{ FIELDS : has
    FORMS ||--o{ FORMS_SENT : submissions