Copilot messages

copilot_messages

• Schema: public
• PK: id (uuid)

Columns

Column	Type	Nullable	Default	Notes
id	uuid	NO		PK
conversation_id	uuid	NO		FK to copilot_conversations
role	text	NO		e.g. user, assistant
user_id	bigint	YES
content	text	NO
widget	text	YES
created_at	timestamptz	YES	now()
created_by	bigint	YES
inserted_at	timestamptz	YES	now()
options	text	YES
status	text	YES	'in_progress'
resource_id	text	YES

Key indexes

• copilot_messages_pkey — primary key on id
• idx_copilot_messages_conversation_id — on conversation_id

---