Skip to content

app.feed_acknowledgments

TableRow level security on

Append-only record of members acknowledging a feed post that requires it, one per member.

Primary key: id

Columns of app.feed_acknowledgments
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.feed_posts on insert; never accepted from the caller and never changed.References app.organizations.id
feed_post_iduuidNoPost acknowledged.References app.feed_posts.id
membership_iduuidNoMember who acknowledged.References app.memberships.id
acknowledged_attimestamp with time zoneNoWhen they acknowledged.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.