Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| chatbot_id | VARCHAR | 100 | null |
|
|
チャットボットのID |
||||
| api_key | VARBINARY | 255 | null |
|
|
API key |
||||
| dify_app_id | VARCHAR | 255 | √ | null |
|
|
Dify アプリID (dify_apps.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 |
|
|
||||
| tts_id | VARCHAR | 100 | null |
|
|
tts_configsのID |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | chatbot_id |
| ai_chatbot_config_tts_id_foreign | Performance | Asc | tts_id |
| ai_chatbot_configs_kind_organization_id | Performance | Asc/Asc | kind + organization_id |
| ai_chatbot_configs_organization_id_foreign | Performance | Asc | organization_id |
| fk_ai_chatbot_configs_dify_app_id | Performance | Asc | dify_app_id |
Relationships
Close relationships within degrees of separation
