Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
スコアID |
||||
| report_id | CHAR | 36 | null |
|
|
DCレポートID |
||||
| goal_id | CHAR | 36 | null |
|
|
目標ID（employee_goals or team_goals） |
||||
| goal_source | enum('EMPLOYEE', 'TEAM') | 8 | null |
|
|
個人目標/チーム目標の区分 |
||||
| user_id | CHAR | 36 | null |
|
|
対象ユーザーID |
||||
| goal_setting_id | CHAR | 36 | null |
|
|
目標設定期間ID |
||||
| mention_date | DATE | 10 | null |
|
|
言及日（JST基準） |
||||
| is_mentioned | BIT | 1 | 0 |
|
|
言及有無 |
||||
| mention_count | INT | 10 | 0 |
|
|
ユーザー発話ターン単位の言及回数 |
||||
| mention_depth | enum('S', 'A', 'R') | 1 | √ | null |
|
|
S=表面的, A=具体的, R=内省的 |
|||
| created_at | BIGINT UNSIGNED | 20 | null |
|
|
作成日時（unixtime） |
||||
| updated_at | BIGINT UNSIGNED | 20 | null |
|
|
更新日時（unixtime） |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| fk_gms_goal_setting | Performance | Asc | goal_setting_id |
| idx_user_goal_setting | Performance | Asc/Asc/Asc | user_id + goal_setting_id + mention_date |
| uk_report_goal | Must be unique | Asc/Asc | report_id + goal_id |
Relationships
Close relationships within degrees of separation
