pulse


Description

{“what”:“A scheduled query that runs periodically and can trigger alerts.”,“why”:“Without it, scheduled queries and their alert configurations cannot be persisted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:05:20.370328117+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
pulse_card.pulse_id fk_pulse_card_ref_pulse_id C
pulse_channel.pulse_id fk_pulse_channel_ref_pulse_id C

{“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
core_user.id fk_pulse_ref_creator_id C

{“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
collection.id fk_pulse_collection_id N

{“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
report_dashboard.id fk_pulse_ref_dashboard_id C

{“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

Relationships