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
employee_ai_contexts.organization_id fk_eac_organizationC
helpdesk_conversations.organization_id fk_helpdesk_conversations_organization_idR
legend_story_content_principles.organization_id organization_id_foreignR
organization_action_plan_goal_types.organization_id organization_action_plan_goal_types_ibfk_1C
organization_ai_contexts.organization_id Implied ConstraintR
organization_dify_apps.organization_id organization_dify_apps_ibfk_1C
organization_features.organization_id fk_organization_features_organizationC
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
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）

Indexes

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

Relationships

Close relationships within degrees of separation