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 |