Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| chatbot_id | VARCHAR | 100 | null |
|
|
チャットボットのID |
||||
| api_key | VARBINARY | 255 | null |
|
|
API key |
||||
| openai_tts_id | VARCHAR | 100 | null |
|
|
openai_ttsのID |
||||
| thumbnail_name | VARCHAR | 100 | null |
|
|
サムネイル画像のファイル名 |
||||
| description_icon_name | VARCHAR | 100 | null |
|
|
chatbot の説明用画像のファイル名 |
||||
| description_title | VARCHAR | 100 | null |
|
|
chatbot の説明のタイトル |
||||
| description | TEXT | 65535 | √ | null |
|
|
chatbot の説明 |
|||
| kind | INT UNSIGNED | 10 | 9999 |
|
|
種別 |
||||
| organization_id | VARCHAR | 100 | √ | null |
|
|
組織ID |
|||
| use_daily_checkin_scenario | BIT | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | chatbot_id |
| ai_chatbot_config_openai_tts_id_foreign | Performance | Asc | openai_tts_id |
| ai_chatbot_configs_kind_organization_id | Performance | Asc/Asc | kind + organization_id |
| ai_chatbot_configs_organization_id_foreign | Performance | Asc | organization_id |
Relationships
Close relationships within degrees of separation
