thread_activity_reaction

Fields

Field	Type	Description
id	uuid	Unique identifier for the reaction (auto-generated)
activityId	uuid	Reference to the thread activity being reacted to
userId	uuid	Reference to the user who added the reaction
shortcode	String	Unicode emoji character or shortcode
createdAt	Timestamp	When the reaction was created (defaults to current timestamp)

Relationships

Object Relationships

• activity — The thread activity this reaction belongs to

Query Examples

List Reactions for an Activity

query GetActivityReactions($activityId: uuid!) {
  thread_activity_reaction(
    where: { activityId: { _eq: $activityId } }
    order_by: { createdAt: asc }
  ) {
    id
    shortcode
    userId
    createdAt
  }
}

Mutation Examples

Add a Reaction

mutation CreateActivityReaction {
  insert_thread_activity_reaction_one(
    object: { activityId: "activity-id", shortcode: "👍" }
  ) {
    id
    shortcode
    createdAt
  }
}

Remove a Reaction

mutation DeleteActivityReaction {
  delete_thread_activity_reaction_by_pk(id: "reaction-id") {
    id
    shortcode
  }
}

Permissions

Reaction access is controlled based on organization membership:

• View — All authenticated users can view reactions
• Create — Organization members (with Member, Admin, or Owner role) can add reactions. The userId is automatically set to the authenticated user
• Delete — Users can only remove their own reactions