# Entity DbSet Relationships

The **Asterisk 2** documentation tree relies on strict Entity Framework Core foreign key mapping schemas to track project networks. The architecture implements strong parent-child associations ensuring clear document rendering across client interfaces.

---

## Content Navigation Storage Matrix

The flow chart below illustrates how relational document nodes map downward from global projects into single page contents:

```mermaid
graph LR
    %% Master Node
    subgraph LevelRoot["Project Root Definition"]
        E_Proj["Project Entity Class<br/>(List&lt;Section&gt; Sections)"]
    end

    %% Intermediate Node
    subgraph LevelSection["Categorized Module Scope"]
        E_Sec["Section Entity Class<br/>(List&lt;Page&gt; Pages)"]
    end

    %% Leaf Contents
    subgraph LevelPage["Content Leaf Nodes"]
        E_Page["Page Entity Class<br/>(Content string, Order index)"]
        E_Sub["Recursive SubPage Arrays<br/>(List&lt;Page&gt; SubPages)"]
    end

    %% Links
    E_Proj ==>|"Navigation Includes"| E_Sec
    E_Sec ==>|"Eager Loaded Leaves"| E_Page
    E_Page ==>|"Lazy / Explicit Resolvers"| E_Sub

    %% Color Mapping
    classDef rootToken fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef secToken fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef pageToken fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;

    class LevelRoot,E_Proj rootToken;
    class LevelSection,E_Sec secToken;
    class LevelPage,E_Page,E_Sub pageToken;
```

---

## Detailed Model Field Specifications

### 1. `Project` Entity Mappings
- **`Id`** (`int`): Primary automatic auto-increment identity integer.
- **`Slug`** (`string`): Unique URL-friendly string identifier enforced by database indices.
- **`Sections`**: Virtual navigational collection representing associated documentation categories.

### 2. `Section` Entity Mappings
- **`ProjectId`** (`int`): Mandatory foreign key associating the category to its top-level owner.
- **`Pages`**: Navigational tracking lists sorting top-level document documents.

### 3. `Page` Entity Mappings
- **`SectionId`** (`int`): Foreign key anchoring leaf records to their parent module.
- **`ParentPageId`** (`int?`): Nullable hierarchical self-reference foreign key supporting multi-level document trees.
- **`Content`** (`string`): Unrestricted storage text columns retaining compiled Markdown instructions.