organizations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.organizations_id_seq'::regclass)
action_plan_users.organization_id fk_action_plan_users_organizationsC
action_plans.organization_id fk_action_plans_organizationsC
bookmarks.organization_id fk_bookmarks_organizationsC
checkin_key_results.organization_id fk_checkin_key_results_organizationsC
checkin_summaries.organization_id fk_checkin_summaries_organizationsC
checkin_summary_key_results.organization_id fk_checkin_summary_key_results_organizationsC
checkin_summary_reactions.organization_id fk_checkin_summary_reactions_organizationsC
checkin_users.organization_id fk_checkin_users_organizationsC
custom_okr_glossaries.organization_id fk_custom_okr_glossaries_organizationsC
group_members.organization_id fk_group_members_organizationsC
group_okr_nodes.organization_id fk_group_okr_nodes_organizationsC
group_settings.organization_id fk_group_settings_organizationsR
groups.organization_id fk_groups_organizationsC
key_result_attachments.organization_id fk_key_result_attachments_organizationsC
key_result_confidence_scores.organization_id fk_key_result_confidence_scores_organizationsC
key_result_confidences.organization_id fk_key_result_confidences_organizationsC
key_result_events.organization_id fk_key_result_events_organizationsC
key_result_members.organization_id fk_key_result_members_organizationsC
key_result_others.organization_id fk_key_result_others_organizationsC
key_result_priorities.organization_id fk_key_result_priorities_organizationsC
key_result_problems.organization_id fk_key_result_problems_organizationsC
key_result_win_sessions.organization_id fk_key_result_win_sessions_organizationsC
key_results.organization_id fk_key_results_organizationsC
note_attachments.organization_id fk_note_attachments_organizationsC
note_comment_attachments.organization_id fk_note_comment_attachments_organizationsC
note_comment_reactions.organization_id fk_note_comment_reactions_organization_idC
note_comments.organization_id fk_note_comments_organizationsC
note_labels.organization_id fk_note_labels_organizationsC
note_labels_notes.organization_id fk_note_labels_notes_organizationsC
note_labels_personal_notes.organization_id fk_note_labels_personal_notes_organizationsC
note_reactions.organization_id fk_note_reactions_organizationsC
note_users.organization_id fk_note_users_organizationsC
notes.organization_id fk_notes_organizationsC
notifications.organization_id fk_notifications_organization_idC
objective_attachments.organization_id fk_objective_attachments_organizationsC
objective_confidence_scores.organization_id fk_objective_confidence_scores_organizationsC
objective_confidences.organization_id fk_objective_confidences_organizationsC
objective_events.organization_id fk_objective_events_organizationsC
objective_members.organization_id fk_objective_members_organizationsC
objective_parent_key_results.organization_id fk_objective_parent_key_results_organizationsC
objectives.organization_id fk_objectives_organizationsC
okr_labels.organization_id fk_okr_labels_organizationsC
okr_labels_nodes.organization_id fk_okr_labels_notes_organizationsC
okr_node_slack_integration_channels.organization_id fk_okr_node_slack_integrarion_channels_organizationsC
okr_nodes.organization_id fk_okr_nodes_organizationsC
okr_terms.organization_id fk_okr_terms_organizationsC
personal_note_attachments.organization_id fk_personal_note_attachments_organizationsC
personal_note_comment_attachments.organization_id fk_personal_note_comment_attachments_organizationsC
personal_note_comment_reactions.organization_id fk_personal_note_comment_reactions_organization_idC
personal_note_comments.organization_id fk_personal_note_comments_organizationsC
personal_note_reactions.organization_id fk_personal_note_reactions_organizationsC
personal_note_users.organization_id fk_personal_note_users_organizationsC
personal_notes.organization_id fk_personal_notes_organizationsC
saml_settings.organization_id fk_saml_settings_organizationsC
smart_hr_departments.organization_id fk_smart_hr_departments_organizationsR
smart_hr_employee_change_histories.organization_id fk_smart_hr_employee_change_histories_organizationsR
smart_hr_employees.organization_id fk_smart_hr_employees_organizationsR
smart_hr_settings.organization_id fk_smart_hr_settings_organizationsR
stripe_customers.organization_id fk_stripe_customers_organization_idC
user_bookmarks.organization_id fk_user_bookmarks_organizationsC
user_organizations.organization_id fk_user_organizations_organizationsC
name varchar 255 null
varchar 255 √ null
is_trial_account bool 1 false
ip_whitelist _text 2147483647 √ null
oauth_whitelist _text 2147483647 √ null
disabled_at timestamptz 35,6 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
slack_integration_enabled bool 1 false
slack_access_token text 2147483647 √ null
slack_oauth_response jsonb 2147483647 √ null
tenant_id int8 19 null
tenants.id fk_organizations_tenantsC
bulk_update_notification_enabled bool 1 true
smart_hr_enabled bool 1 false
is_self_serve bool 1 false

セルフサーブのOrganizationかどうか
trial_expires_at timestamptz 35,6 √ null

トライアル期間の有効期限
memo text 2147483647 ''::text

メモ
one_on_one_enabled bool 1 true

1on1機能を公開するかどうか
slack_team_id varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
organizations_pkey Primary key Asc id
idx_organizations_on_disabled_at Performance Asc disabled_at
idx_organizations_on_is_self_serve Performance Asc is_self_serve
idx_organizations_on_tenant_id Performance Asc tenant_id
idx_organizations_on_trial_expires_at Performance Asc trial_expires_at

Check Constraints

Constraint Name Constraint
check_self_serve ( CASE WHEN (is_self_serve IS TRUE) THEN (trial_expires_at IS NOT NULL) ELSE true END)
check_logo_path (((logo)::text ~ (('^logos/'::text || id) || '/(.+)$'::text)))
check_self_serve_or_trial ((NOT ((is_trial_account IS TRUE) AND (is_self_serve IS TRUE))))

Relationships

Close relationships within degrees of separation