pulse_channel_recipient


Description

{“what”:“Links a pulse channel to a user who receives it.”,“why”:“Without it, the set of recipients per channel is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:12.923676960+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Integer primary key, unique per association row.”,“why”:“Without it, individual channel-user links cannot be referenced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:12.953423704+00:00”}

pulse_channel_id int4 10 null
pulse_channel.id fk_pulse_channel_recipient_ref_pulse_channel_id C

{“what”:“Foreign key to the pulse channel being subscribed to.”,“why”:“Without it, the channel for each recipient is unidentified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:12.991074449+00:00”}

user_id int4 10 null
core_user.id fk_pulse_channel_recipient_ref_user_id C

{“what”:“Foreign key to the user who is a recipient of the channel.”,“why”:“Without it, the user for each subscription is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:13.059120671+00:00”}

Indexes

Constraint Name Type Sort Column(s)
pulse_channel_recipient_pkey Primary key Asc id
idx_pulse_channel_recipient_pulse_channel_id Performance Asc pulse_channel_id
idx_pulse_channel_recipient_user_id Performance Asc user_id

Relationships