Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
メッセージID (UUID 文字列 / 現状は uuid.NewString() = v4) |
||||
| conversation_id | CHAR | 36 | null |
|
|
helpdesk_conversations.id |
||||
| role | enum('user', 'assistant') | 9 | null |
|
|
発話者 (user=ユーザー, assistant=AI) |
||||
| content | MEDIUMTEXT | 16777215 | null |
|
|
メッセージ本文 (長文対応 mediumtext) |
||||
| response_time_ms | INT UNSIGNED | 10 | √ | null |
|
|
応答時間ミリ秒 (assistant のみ。エラー時は NULL) |
|||
| created_at | BIGINT UNSIGNED | 20 | unix_timestamp(now()) |
|
|
作成日時 (Unixタイムスタンプ) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_conv_created | Performance | Asc/Desc/Desc | conversation_id + created_at + id |
Relationships
Close relationships within degrees of separation
