L2 — Universal repository

L2 is the only layer that opens Timescale for plant truth. L1 posts envelopes; L3–L6 read through HTTP with service keys. L4 may hold derived operational data (PSMPlant Situation Model, traces) in its own store — never a second plant system of record.

Repo#

Typical ports (local compose): ingest :8090 · query :8091 · console :8092 · admin :8093 · Timescale :5433.

Seven schemas (as-built)#

Detail and retention: consumer docs/EXTENSIVE.md. Configure meters and context into these stores via L1-L2-DATA-PLANE.md.

How facts land#

flowchart TB
    %% house-style: l2-ingest-seven-schemas
    l1["L1 POST /v1/ingest/records<br/>StampedRecordEnvelope"]
    gate{{"contracts plus bill_line validated"}}
    subgraph ingestPath["Ingest path"]
        direction LR
        inbox["ingest.l1_processed_inbox<br/>dedupe_key"] --> demux["route_record to schema tables"]
    end
    subgraph seven["Seven schemas"]
        direction LR
        s1["ingest"]
        s2["telemetry"]
        s3["graph"]
        s4["commercial"]
        s5["features"]
        s6["baselines"]
        s7["ledger"]
    end
    dup(["↩ 200 duplicate inserted false"])
    l1 --> gate --> inbox --> demux --> seven
    gate -.-> dup

    classDef govc fill:#fff4d6,stroke:#c99a2e,color:#000
    classDef agentc fill:#e8f0ff,stroke:#5b7bd5,color:#000
    classDef loopc fill:#eef7ee,stroke:#4f9a4f,color:#000
    class gate govc
    class dup loopc

Fast-loop tables and the Plant Box bundle (direction)#

Nothing here is as-built. Sixteen new tables land in the existing schemas; rows arrive as upserts through records/{type} and the normal L1 cloud path, each stamped with episode_id where one applies and the Plant BoxPlant-side computer for the fast loop (direction; D4) lockfile id. Producer, consumers and proposed contracts per table: ../fast-loop/07-interfaces-and-ownership.md section 3. Keys: ../fast-loop/05-records-deployment-operations.md.

Plant Box config read. GET /v1/plants/{plant_id}/plant-box-config?since= (plant-box credential) returns the signed plant_box_config bundle that L2 assembles from parts written by L5 (procedures, switches, roster, budgets) and the L3 tuning job (parameter rows, aliases). The Plant Box pulls; the cloud never connects in. The bundle never carries the writer allow-list or limits; those live in the site packVersioned, owner-reviewed plant configuration including topology. See 07 section 4.

What L3–L6 may ask#

L3 engines KeyError or empty when required tags are missing — that is fail-closed, not invent.

Hard rules#

Related#

• Data plane (configure + prove): L1-L2-DATA-PLANE.md
• Handoffs: ../../handoff/l2/ — prefer this page for architecture