reflection_settings

4 rows


Description

リフレクション設定

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
goal_settings.team_setting_id fk_goal_settings_team_setting_idC
reflection_daily_employee_reports.reflection_setting_id reflection_reports_reflection_setting_id_foreignC
reflection_kpis.reflection_setting_id reflection_kpis_reflection_setting_id_foreignC
reflection_settings_assignments.reflection_id reflection_settings_assignments_reflection_id_foreignC
reflection_summarize_employee_reports.reflection_setting_id reflection_setting_id_foreignC
reflection_summarize_reports.reflection_setting_id reflection_summarize_reports_reflection_setting_id_foreignC
reflection_team_knowledge_bases.reflection_setting_id fk_reflection_team_kb_setting_idC
reflection_user_knowledge_bases.reflection_setting_id fk_user_kb_reflection_setting_idC

リフレクション設定のユニークID
organization_id VARCHAR 100 null
organizations.id reflection_settings_organization_id_foreignC

組織ID
name VARCHAR 255 null

リフレクション設定の名称
start_date DATE 10 √ null

設定期間の開始日
end_date DATE 10 √ null

設定期間の終了日
status VARCHAR 20 active
reflection_setting_status.status reflection_settings_status_foreignR

計画のステータス
week_closing_day VARCHAR 10 null
week_days.day_code reflection_settings_week_closing_day_foreignR

週締め曜日
coaching_start_time TIME 8 null

AIコーチング開始時間
month_closing_day TINYINT UNSIGNED 3 0

月報締め日 (0=月末, 1-28=具体的な日付)
created_at BIGINT UNSIGNED 20 unix_timestamp(now())

設定が作成された日時
updated_at BIGINT UNSIGNED 20 unix_timestamp(now())

設定が最後に更新された日時

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
reflection_settings_organization_id_foreign Performance Asc organization_id
reflection_settings_status_foreign Performance Asc status
reflection_settings_week_closing_day_foreign Performance Asc week_closing_day

Relationships

Close relationships within degrees of separation