# Telephony Session Engine (TelephonyDbContext)

The **TelephonyDbContext** data layer is decoupled from standard administrative workflows to serve high-frequency hardware integration loops. This schema tracks live **Dinstar SIM Banks**, multi-port GSM routing gateways, and persistent voice session state matrices.

---

## Session Persistence Engine Map

The flowchart below maps out the continuous operational loop syncing hardware state arrays into relational storage tables:

```mermaid
graph TD
    %% Source Racks
    subgraph RackTier["Physical Telecom Infrastructure"]
        Rack_Sim["Dinstar Hardware SIM Array"]
        Rack_Gsm["Multi-Port Outbound Gateway"]
    end

    %% Sync Services
    subgraph ServiceTier["Background Operational Services"]
        Worker_Sync["GatewayStatusBackgroundService.cs<br/>(Hardware Heartbeat Engine)"]
    end

    %% Storage Ledgers
    subgraph StorageTier["Telephony Storage Ledgers"]
        T_Pool[("GatewayPools Table<br/>(Weighted Outbound Lists)")]
        T_Sim[("SimProfiles Table<br/>(Port Status & Identity Ledgers)")]
        T_Event[("SessionEvents Table<br/>(Raw Streaming JSON Payloads)")]
    end

    %% Flow links
    Rack_Sim <-->|"Continuous Heartbeats"| Worker_Sync
    Rack_Gsm <-->|"Continuous Heartbeats"| Worker_Sync
    
    Worker_Sync ==>|"Update Load Weights"| T_Pool
    Worker_Sync ==>|"Update Port Conditions"| T_Sim
    Worker_Sync ==>|"Flush Session Buffers"| T_Event

    %% Premium Aesthetics
    classDef rackToken fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef svcToken fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef dbToken fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;

    class RackTier,Rack_Sim,Rack_Gsm rackToken;
    class ServiceTier,Worker_Sync svcToken;
    class StorageTier,T_Pool,T_Sim,T_Event dbToken;
```

---

## Structural Engine Properties

### 1. Optimized Lock Management
Because operational telemetry writes to `TelephonyDbContext` every second, entity models configure specific index structures to prevent long-term table locking. 

### 2. Live Session Contexting
Voice handlers querying active line records execute transactions over read-only scopes (`AsNoTracking`), avoiding Entity Framework change-tracker memory bloat.