Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
ID |
||||
| organization_id | VARCHAR | 100 | null |
|
|
組織ID |
||||
| previous_prompt_text | TEXT | 65535 | null |
|
|
変更前のプロンプト本文 |
||||
| changed_by | VARCHAR | 255 | null |
|
|
変更者(Admin CognitoユーザーのSub) |
||||
| changed_at | BIGINT UNSIGNED | 20 | √ | unix_timestamp(now()) |
|
|
変更日時 |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_org_meta_coach_prompt_histories_org_id_changed_at | Performance | Asc/Desc | organization_id + changed_at |
Relationships
Close relationships within degrees of separation
