route_decisions


Description

{“what”:“Historical log of routing decisions, each with rule version and reason.”,“why”:“Without it, past routing decisions and their rationale are lost, making debugging and compliance impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.269824194+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('route_decisions_id_seq'::regclass)

{“what”:“Auto-incrementing integer that uniquely identifies each decision row.”,“why”:“Without it, there is no stable key to reference a specific decision, so audit trails and updates become ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.305074780+00:00”}

target text 2147483647 null

{“what”:“The routing target (e.g., URL, service name) that the decision applies to.”,“why”:“Without it, it is unknown which target the decision was made for, so the log cannot be filtered by target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.327106540+00:00”}

intent text 2147483647 √ null

{“what”:“Optional description of the request’s intent, e.g., ‘read’ or ‘write’.”,“why”:“Without it, the reason for the decision may be unclear when multiple intents share the same target.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.436252606+00:00”}

decision text 2147483647 null

{“what”:“The outcome of the routing decision, e.g., ‘allow’, ‘deny’, or a route name.”,“why”:“Without it, the actual action taken is unknown, so the log cannot be used to verify policy enforcement.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.447399023+00:00”}

rule int4 10 null

{“what”:“Version or ID of the routing rule that produced this decision.”,“why”:“Without it, it is impossible to know which rule version was applied, so changes in behavior cannot be traced to rule updates.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.458915014+00:00”}

reason text 2147483647 null

{“what”:“Human-readable explanation of why the decision was made, e.g., ‘target matches rule 5’.”,“why”:“Without it, the rationale behind a decision is lost, making debugging and compliance audits impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.479539003+00:00”}

deterministic bool 1 true

{“what”:“Flag indicating whether the decision is deterministic (same inputs always yield same output).”,“why”:“Without it, non-deterministic decisions cannot be identified, so replaying the log may not reproduce the same outcomes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.501142819+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp (with time zone) when the decision was recorded.”,“why”:“Without it, the order and timing of decisions are unknown, so time-based analysis and correlation with other events are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:22:52.514037552+00:00”}

Indexes

Constraint Name Type Sort Column(s)
route_decisions_pkey Primary key Asc id

Relationships