ai_session_messages

Individual messages within an AI session.

id

Primary key
Unique identifier for the row.

ai_session_id

Foreign key
ID of the associated AI session.

external_id

Foreign key
External identifier for the message, provided by the AI tool.

timestamp

date
Timestamp when the message was sent.

content

string
Text content of the message. Requires transcript capture to be enabled.

role

string
Role of the message sender ("user" or "ai").

model

string
AI model used to generate the message.

tokens_input

number
Number of input tokens used for this message.

tokens_cached_input

number
Number of cached input tokens used for this message.

tokens_output

number
Number of output tokens used for this message.

row_created_at

date
Timestamp when the record was created.

row_updated_at

date
Timestamp when the record was last updated.