Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | gen_random_uuid() |
|
|
{“what”:“Unique identifier for a schedule; generated UUID.”,“why”:“Without it, schedules cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.563437040+00:00”} |
||
| url | text | 2147483647 | null |
|
|
{“what”:“Target URL to be scanned or processed by the schedule.”,“why”:“Without it, the schedule has no endpoint to act on.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.638396258+00:00”} |
||
| interval_hours | int4 | 10 | 24 |
|
|
{“what”:“Number of hours between scheduled runs; default 24.”,“why”:“Without it, run frequency is undefined and next_run_at cannot be computed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.745110984+00:00”} |
||
| phases | _text | 2147483647 | '{waf,headers,fingerprint,discover,ramp}'::text[] |
|
|
{“what”:“Ordered list of phase names to execute, e.g., waf, headers, fingerprint, discover, ramp.”,“why”:“Without it, the sequence of operations for a run is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.793925063+00:00”} |
||
| ramp_max_step | int4 | 10 | 5 |
|
|
{“what”:“Maximum step number for the ramp phase; default 5.”,“why”:“Without it, the ramp phase has no upper bound to stop increasing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.904976769+00:00”} |
||
| enabled | bool | 1 | true |
|
|
{“what”:“Whether the schedule is active; true means it will run.”,“why”:“Without it, disabled schedules would still execute, causing unwanted scans.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:53.008178757+00:00”} |
||
| last_run_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp of the most recent run; null if never run.”,“why”:“Without it, you cannot know if a schedule is overdue or has ever executed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:53.328683480+00:00”} |
|
| next_run_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the next run is due; defaults to creation time.”,“why”:“Without it, the scheduler has no trigger time to fire the next run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:54.323525770+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the schedule was created.”,“why”:“Without it, audit and ordering of schedules by creation time is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:54.544814354+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| schedules_pkey | Primary key | Asc | id |
| idx_schedules_next_run | Performance | Asc | next_run_at |