schedules


Description

{“what”:“A recurring job that scans a URL through a sequence of phases.”,“why”:“Without it, there is no definition of periodic scanning tasks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:18:52.444659236+00:00”}

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

Relationships