Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
目標ID (UUIDv7) |
||||
| employee_id | CHAR | 36 | null |
|
|
従業員ID |
||||
| goal_setting_id | CHAR | 36 | null |
|
|
目標設定期間ID |
||||
| organization_id | CHAR | 36 | null |
|
|
組織ID |
||||
| category | enum('PERSONAL_GROWTH', 'PERSONAL_ACHIEVEMENT', 'PERSONAL_ACTION') | 20 | null |
|
|
目標カテゴリ |
||||
| goal_type | enum('QUALITATIVE', 'QUANTITATIVE') | 12 | null |
|
|
目標種別（定性/定量） |
||||
| text | VARCHAR | 200 | null |
|
|
目標テキスト |
||||
| target_value | FLOAT | 12 | √ | null |
|
|
目標値（定量目標の場合） |
|||
| actual_value | FLOAT | 12 | √ | null |
|
|
実績値（定量目標の場合） |
|||
| unit | VARCHAR | 10 | √ | null |
|
|
単位（定量目標の場合） |
|||
| display_order | INT | 10 | 0 |
|
|
表示順 |
||||
| created_at | BIGINT UNSIGNED | 20 | null |
|
|
作成日時（UNIX秒） |
||||
| updated_at | BIGINT UNSIGNED | 20 | null |
|
|
更新日時（UNIX秒） |
||||
| is_tracked | BIT | 1 | 1 |
|
|
チェックイン追跡フラグ |
||||
| tracking_type | enum('CUMULATIVE', 'LATEST_VALUE') | 12 | CUMULATIVE |
|
|
実績入力方式（累積型/最新値型） |
||||
| is_achieved | BIT | 1 | 0 |
|
|
達成フラグ（定性目標用） |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_employee_goals_emp_goal_setting | Performance | Asc/Asc | employee_id + goal_setting_id |
| idx_employee_goals_employee_id | Performance | Asc | employee_id |
| idx_employee_goals_goal_setting_id | Performance | Asc | goal_setting_id |
Relationships
Close relationships within degrees of separation
