Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for the pulse.”,“why”:“Without it, pulses cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.388390745+00:00”} |
|||||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“User ID of the person who created the pulse.”,“why”:“Without it, ownership and permission checks are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.413646360+00:00”} |
||||||||
| name | varchar | 254 | √ | null |
|
|
{“what”:“Human-readable name for the pulse.”,“why”:“Without it, pulses cannot be labeled or distinguished in lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.425796649+00:00”} |
|||||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the pulse was created.”,“why”:“Without it, creation time is unknown, breaking audit trails and sorting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.444802068+00:00”} |
||||||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last modification to the pulse.”,“why”:“Without it, last modification time is unknown, breaking stale detection and concurrency checks.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.465235788+00:00”} |
||||||||
| skip_if_empty | bool | 1 | false |
|
|
{“what”:“Boolean flag: if true, skip execution when query returns no rows.”,“why”:“Without it, empty results would trigger alerts or actions unintentionally.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.493251188+00:00”} |
||||||||
| alert_condition | varchar | 254 | √ | null |
|
|
{“what”:“Condition string (e.g., SQL expression) that triggers an alert.”,“why”:“Without it, alert triggering logic is undefined, making alerts impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.511533282+00:00”} |
|||||||
| alert_first_only | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag: if true, alert only on first occurrence.”,“why”:“Without it, repeated alerts would spam users for the same condition.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.532202960+00:00”} |
|||||||
| alert_above_goal | bool | 1 | √ | null |
|
|
{“what”:“Boolean flag: if true, alert when value exceeds goal.”,“why”:“Without it, the comparison direction for alerts is ambiguous, causing incorrect triggers.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.544635700+00:00”} |
|||||||
| collection_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the collection this pulse belongs to.”,“why”:“Without it, pulses cannot be grouped into collections for organization.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.559807939+00:00”} |
|||||||
| collection_position | int2 | 5 | √ | null |
|
|
{“what”:“Position of the pulse within its collection.”,“why”:“Without it, ordering within a collection is undefined, making display order arbitrary.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.576324154+00:00”} |
|||||||
| archived | bool | 1 | √ | false |
|
|
{“what”:“Boolean flag: if true, pulse is archived and hidden.”,“why”:“Without it, pulses cannot be hidden without deletion, risking data loss.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.591732192+00:00”} |
|||||||
| dashboard_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the dashboard associated with this pulse.”,“why”:“Without it, the associated dashboard is unknown, losing context for the pulse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.614989788+00:00”} |
|||||||
| parameters | text | 2147483647 | null |
|
|
{“what”:“Serialized parameters (e.g., JSON) for the pulse query.”,“why”:“Without it, the pulse’s query configuration is missing, so execution fails.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.627507814+00:00”} |
||||||||
| entity_id | bpchar | 21 | √ | null |
|
|
{“what”:“Identifier of an entity (e.g., user or group) related to the pulse.”,“why”:“Without it, the target entity is unknown, so alerts cannot be directed appropriately.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.646337121+00:00”} |
|||||||
| disable_links | bool | 1 | √ | false |
|
|
{“what”:“Boolean flag: if true, links in alerts are disabled.”,“why”:“Without it, links in alerts would be exposed, posing a security risk.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.661452767+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pulse_pkey | Primary key | Asc | id |
| idx_pulse_collection_id | Performance | Asc | collection_id |
| idx_pulse_creator_id | Performance | Asc | creator_id |
| idx_pulse_dashboard_id | Performance | Asc | dashboard_id |
| pulse_entity_id_key | Must be unique | Asc | entity_id |