organizations

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 100 null
ai_chatbot_configs.organization_id ai_chatbot_configs_organization_id_foreignR
ai_knowledge_base_configs.dify_dataset_id Implied ConstraintR
ai_knowledge_base_configs.dify_tag_owner_id Implied ConstraintR
ai_knowledge_base_configs.dify_tag_team_id Implied ConstraintR
announcement_target_organizations.organization_id announcement_target_organizations_ibfk_2C
assessment_distributions.organization_id assessment_distributions_organization_id_foreignR
assessment_organization_choice_questions.organization_id assessment_organization_choice_questions_organization_foreignC
assessment_organization_free_text_questions.organization_id assessment_organization_free_text_questions_organization_foreignC
company_videos.organization_id company_videos_organization_foreignR
cs_accounts.organization_id cs_accounts_ibfk_1C
deleted_company_videos.organization_id deleted_company_videos_organization_foreignR
departments.organization_id departments_organization_id_foreignR
legend_story_content_principles.organization_id organization_id_foreignR
organization_action_plan_goal_types.organization_id organization_action_plan_goal_types_ibfk_1C
organization_features.organization_id fk_organization_features_organizationC
organization_implementation_days.organization_id organization_implementation_days_ibfk_1C
organization_principles.organization_id organization_organization_principle_id_foreignR
reflection_daily_employee_reports.organization_id Implied ConstraintR
reflection_report_schedules.organization_id reflection_report_schedules_organization_id_foreignC
reflection_settings.organization_id reflection_settings_organization_id_foreignC
reflection_settings_assignments.organization_id Implied ConstraintR
roles.organization_id roles_organization_id_foreignR
name VARCHAR 255 null
prefecture VARCHAR 4 null
is_active BIT 1 1

組織が有効かどうか（FALSE=利用停止）
license INT UNSIGNED 10 null
token_limit BIGINT UNSIGNED 20 1

AIChat機能に使えるトークン数の上限
used_tokens BIGINT UNSIGNED 20 0

AIChat機能で使用したトークン数
status VARCHAR 20 active

組織のステータス（active/inactive）
ai_reflection_enabled BIT 1 0

AIリフレクション機能の有効/無効
ai_agent_enabled BIT 1 0

AIエージェント機能の有効/無効
goal_management_enabled BIT 1 0

目標管理機能の有効/無効
daily_checkin_app_id CHAR 36 √ null

日報チャットボットアプリID
ai_agent_app_id CHAR 36 √ null

AIエージェントチャットボットアプリID
my_coach_app_id CHAR 36 √ null

Myコーチチャットボットアプリ ID
goal_setting_coach_app_id CHAR 36 √ null

目標設定コーチチャットボットアプリID

Indexes

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

Relationships

Close relationships within degrees of separation