goal_settings

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
aggregated_team_goal_items.goal_setting_id fk_agg_team_goal_items_goal_setting_idC
employee_goals.goal_setting_id fk_employee_goals_goal_setting_idC
goal_mention_scores.goal_setting_id fk_gms_goal_settingC
team_goals.goal_setting_id fk_team_goals_goal_setting_idC

目標設定ID (UUIDv7)
team_setting_id CHAR 36 null
reflection_settings.id fk_goal_settings_team_setting_idC

チーム設定ID
organization_id CHAR 36 null

組織ID
start_date DATE 10 null

期間開始日
end_date DATE 10 null

期間終了日
created_at BIGINT UNSIGNED 20 null

作成日時（UNIX秒）
updated_at BIGINT UNSIGNED 20 null

更新日時（UNIX秒）

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_goal_settings_team_setting_id Performance Asc team_setting_id

Relationships

Close relationships within degrees of separation