Realtime Database Mapping (wb_ast)

To maximize performance, the core routing logic bypasses web REST latency entirely during low-level call execution. Asterisk 2 utilizes a dedicated Entity Framework Core proxy context (AstDbContext) that maps directly to the external Asterisk infrastructure database (wb_ast).

Proxy Entity Framework Mapping Engine

The layout below illustrates how low-latency operational database queries are decoupled from administrative data structures:

graph TD
    %% Query Consumer
    subgraph Consumer["Telephony Routing Engine"]
        SIP_Logic["PJSIP Registration / CDR Handlers"]
    end

    %% Decoupled Proxy Mapping Context
    subgraph ProxyContext["Decoupled EF Core Proxy Layer"]
        AstCtx["AstDbContext Class<br/>(Read-Only Database Proxy)"]
    end

    %% External Schema Targets
    subgraph TargetSchema["External Operational Engine (wb_ast)"]
        Tab_Endpoint[("ps_endpoints Table<br/>(SIP Realtime Auth)")]
        Tab_Servers[("servers Table<br/>(Node Load Stats)")]
        Tab_Cdr[("cdr Table<br/>(Call Records)")]
        Tab_Cel[("cel Table<br/>(Channel Events)")]
        Tab_Queue[("queue_log Table<br/>(Call Center Wait Logic)")]
    end

    %% Data Requests
    Consumer -->|"Direct LINQ Query"| AstCtx
    AstCtx ==>|"Mapped DbSet Connection"| Tab_Endpoint
    AstCtx ==>|"Mapped DbSet Connection"| Tab_Servers
    AstCtx ==>|"Mapped DbSet Connection"| Tab_Cdr
    AstCtx ==>|"Mapped DbSet Connection"| Tab_Cel
    AstCtx ==>|"Mapped DbSet Connection"| Tab_Queue

    %% Premium Palette Tokens
    classDef consumerToken fill:#0f172a,stroke:#38bdf8,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef proxyToken fill:#312e81,stroke:#ec4899,stroke-width:2px,color:#fff,rx:6px,ry:6px;
    classDef schemaToken fill:#1e293b,stroke:#a855f7,stroke-width:2px,color:#fff,rx:6px,ry:6px;

    class Consumer,SIP_Logic consumerToken;
    class ProxyContext,AstCtx proxyToken;
    class TargetSchema,Tab_Endpoint,Tab_Servers,Tab_Cdr,Tab_Cel,Tab_Queue schemaToken;

Mapped Entity Framework DbSet Specifications

| Entity Framework DbSet | External DB Table Name | Query Tracking Setting | Core Functional Telephony Duty | | :--- | :--- | :--- | :--- | | PsEndpoints | ps_endpoints | AsNoTracking | Verifies standard PJSIP client authorization credentials, transport options, and audio codec arrays instantly. | | Servers | servers | Read / Write | Tracks individual active Asterisk cluster instances, CPU stats, and heartbeat timestamps. | | Cdrs | cdr | AsNoTracking | Long-term tracking archive capturing finalized call sessions, duration stats, and answer statuses. | | Cels | cel | AsNoTracking | Captures real-time channel sub-events, state mutations, and call transfer handshakes. | | QueueLogs | queue_log | AsNoTracking | Exposes native call center queue events, agent dropouts, and customer wait metrics cleanly. |

Infrastructure Parity

Because AstDbContext directly queries live operational databases, all migration operations are explicitly disabled for this context. Application updates must never alter native schema structures to avoid breaking internal PBX database drivers.