Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | null |
|
|
スキルID |
||||
| category_id | VARCHAR | 50 | null |
|
|
カテゴリID |
||||
| title | VARCHAR | 255 | null |
|
|
スキルタイトル |
||||
| description | TEXT | 65535 | null |
|
|
スキル説明 |
||||
| icon_name | VARCHAR | 255 | null |
|
|
スキルアイコンのファイル名 |
||||
| chatbot_id | VARCHAR | 100 | null |
|
|
スキルに紐づくChatbotのID |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | id + category_id |
| idx_ai_skills_category_id | Performance | Asc | category_id |
Relationships
Close relationships within degrees of separation
