app.integration_route_events
View
Domain events matched to the channel routes of Connected chat connections. The runner reads events after its cursor (domain event ids are time ordered) and posts each one once.
| Column | Type | Nullable | Description |
|---|---|---|---|
| integration_channel_route_id | uuid | Yes | Route that matched. |
| integration_connection_id | uuid | Yes | Chat connection. |
| org_id | uuid | Yes | Org of the event. |
| external_channel_id | text | Yes | Channel to post to. |
| domain_event_id | uuid | Yes | Domain event, time-ordered UUID v7. |
| event_type | text | Yes | Event type. |
| subject_table | text | Yes | Table of the subject. |
| subject_id | uuid | Yes | Subject row. |
| project_id | uuid | Yes | Project of the event. |
| project_name | text | Yes | Project name, for the message. |
| data | jsonb | Yes | Event payload: named, non-restricted fields only. |
| occurred_at | timestamp with time zone | Yes | When the event happened. |