Alerts queue

alerts_queue

• Schema: public
• PK: id (int4, serial)

Columns

Column	Type	Nullable	Default	Notes
id	int4	NO	serial	PK
source	varchar	NO
source_workspace	varchar	YES
source_channel_id	varchar	YES
source_channel_name	varchar	YES
source_message_id	varchar	YES
source_message_text	text	YES
source_user_id	varchar	YES
is_urgent	bool	YES	false
urgency_confidence	numeric	YES
urgency_reason	text	YES
status	varchar	YES	'new'
tech_channel_message_id	varchar	YES
created_at	timestamp	YES	now()
alerted_at	timestamp	YES
escalated_channel_at	timestamp	YES
escalated_cto_at	timestamp	YES
resolved_at	timestamp	YES
resolved_by	varchar	YES
group_id	uuid	YES

Key indexes

• alerts_queue_pkey — primary key on id
• UNIQUE on (source, source_workspace, source_channel_id, source_message_id)
• Index on status
• Index on group_id
• Index on created_at
• Index on (source, source_workspace)
• Index on (source_channel_id, created_at)

---