Constraints

168 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_objective_attachments_organizations

objective_attachments.organization_id

organizations.id

Cascade on delete

fk_objective_attachments_objectives

objective_attachments.objective_id

Cascade on delete

fk_stripe_customers_organization_id

stripe_customers.organization_id

organizations.id

Cascade on delete

fk_groups_organizations

groups.organization_id

organizations.id

Cascade on delete

fk_key_result_others_checkin_users

key_result_others.checkin_user_id

checkin_users.id

Cascade on delete

fk_key_result_others_checkin_key_results

key_result_others.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_others_organizations

key_result_others.organization_id

organizations.id

Cascade on delete

fk_key_result_confidences_checkin_key_result_id

key_result_confidences.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_confidences_organizations

key_result_confidences.organization_id

organizations.id

Cascade on delete

fk_key_result_confidences_key_results

key_result_confidences.key_result_id

Cascade on delete

fk_key_result_confidences_users

key_result_confidences.user_id

Cascade on delete

fk_okr_node_slack_integrarion_channels_okr_nodes

okr_node_slack_integration_channels.okr_node_id

Cascade on delete

fk_okr_node_slack_integrarion_channels_organizations

okr_node_slack_integration_channels.organization_id

organizations.id

Cascade on delete

fk_checkin_summaries_organizations

checkin_summaries.organization_id

organizations.id

Cascade on delete

fk_checkin_summaries_okr_nodes

checkin_summaries.okr_node_id

Cascade on delete

fk_checkin_summaries_before

checkin_summaries.before_checkin_summary_id

checkin_summaries.id

Cascade on delete

fk_checkin_summaries_users

checkin_summaries.changer_id

Null on delete

fk_key_results_organizations

key_results.organization_id

organizations.id

Cascade on delete

fk_key_results_okr_nodes

key_results.okr_node_id

Cascade on delete

fk_user_organizations_organizations

user_organizations.organization_id

organizations.id

Cascade on delete

fk_user_organizations_users

user_organizations.user_id

Cascade on delete

fk_saml_settings_organizations

saml_settings.organization_id

organizations.id

Cascade on delete

fk_key_result_problems_checkin_key_results

key_result_problems.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_problems_checkin_users

key_result_problems.checkin_user_id

checkin_users.id

Cascade on delete

fk_key_result_problems_organizations

key_result_problems.organization_id

organizations.id

Cascade on delete

fk_note_comment_reactions_note_comment_id

note_comment_reactions.note_comment_id

note_comments.id

Cascade on delete

fk_note_comment_reactions_user_id

note_comment_reactions.user_id

Cascade on delete

fk_note_comment_reactions_organization_id

note_comment_reactions.organization_id

organizations.id

Cascade on delete

fk_note_comments_organizations

note_comments.organization_id

organizations.id

Cascade on delete

fk_note_comments_users

note_comments.user_id

Cascade on delete

fk_note_comments_notes

note_comments.note_id

Cascade on delete

fk_organizations_tenants

organizations.tenant_id

Cascade on delete

fk_group_members_users

group_members.user_id

Cascade on delete

fk_group_members_organizations

group_members.organization_id

organizations.id

Cascade on delete

fk_group_members_groups

group_members.group_id

Cascade on delete

fk_objective_parent_key_results_objectives

objective_parent_key_results.objective_id

Cascade on delete

fk_objective_parent_key_results_key_results

objective_parent_key_results.key_result_id

Cascade on delete

fk_objective_parent_key_results_organizations

objective_parent_key_results.organization_id

organizations.id

Cascade on delete

fk_personal_notes_last_updated_user_id

personal_notes.last_updated_user_id

Cascade on delete

fk_personal_notes_organizations

personal_notes.organization_id

organizations.id

Cascade on delete

fk_personal_notes_users

personal_notes.user_id

Cascade on delete

fk_personal_notes_authors

personal_notes.author_id

Cascade on delete

fk_key_result_win_sessions_checkin_key_results

key_result_win_sessions.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_win_sessions_checkin_users

key_result_win_sessions.checkin_user_id

checkin_users.id

Cascade on delete

fk_key_result_win_sessions_organizations

key_result_win_sessions.organization_id

organizations.id

Cascade on delete

fk_personal_note_reactions_organizations

personal_note_reactions.organization_id

organizations.id

Cascade on delete

fk_personal_note_reactions_users

personal_note_reactions.user_id

Cascade on delete

fk_personal_note_reactions_personal_notes

personal_note_reactions.personal_note_id

personal_notes.id

Cascade on delete

fk_smart_hr_employees_users

smart_hr_employees.user_id

Restrict delete

fk_smart_hr_employees_organizations

smart_hr_employees.organization_id

organizations.id

Restrict delete

fk_smart_hr_departments_groups

smart_hr_departments.group_id

Restrict delete

fk_smart_hr_departments_organizations

smart_hr_departments.organization_id

organizations.id

Restrict delete

fk_personal_note_comment_attachments_personal_note_comments

personal_note_comment_attachments.personal_note_comment_id

personal_note_comments.id

Cascade on delete

fk_personal_note_comment_attachments_organizations

personal_note_comment_attachments.organization_id

organizations.id

Cascade on delete

fk_smart_hr_settings_organizations

smart_hr_settings.organization_id

organizations.id

Restrict delete

fk_note_comment_attachments_organizations

note_comment_attachments.organization_id

organizations.id

Cascade on delete

fk_note_comment_attachments_note_comments

note_comment_attachments.note_comment_id

note_comments.id

Cascade on delete

fk_personal_note_comment_reactions_personal_note_comment_id

personal_note_comment_reactions.personal_note_comment_id

personal_note_comments.id

Cascade on delete

fk_personal_note_comment_reactions_user_id

personal_note_comment_reactions.user_id

Cascade on delete

fk_personal_note_comment_reactions_organization_id

personal_note_comment_reactions.organization_id

organizations.id

Cascade on delete

fk_key_result_events_users

key_result_events.user_id

Cascade on delete

fk_key_result_events_checkin_key_result_id

key_result_events.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_events_key_results

key_result_events.key_result_id

Cascade on delete

fk_key_result_events_organizations

key_result_events.organization_id

organizations.id

Cascade on delete

fk_key_result_events_linked_key_result_events

key_result_events.linked_key_result_event_id

key_result_events.id

Cascade on delete

fk_objective_confidence_scores_organizations

objective_confidence_scores.organization_id

organizations.id

Cascade on delete

fk_objective_confidence_scores_objectives

objective_confidence_scores.objective_id

Cascade on delete

fk_personal_note_attachments_personal_notes

personal_note_attachments.personal_note_id

personal_notes.id

Cascade on delete

fk_personal_note_attachments_organizations

personal_note_attachments.organization_id

organizations.id

Cascade on delete

fk_note_attachments_notes

note_attachments.note_id

Cascade on delete

fk_note_attachments_organizations

note_attachments.organization_id

organizations.id

Cascade on delete

fk_key_result_priorities_organizations

key_result_priorities.organization_id

organizations.id

Cascade on delete

fk_key_result_priorities_checkin_key_results

key_result_priorities.checkin_key_result_id

checkin_key_results.id

Cascade on delete

fk_key_result_priorities_checkin_users

key_result_priorities.checkin_user_id

checkin_users.id

Cascade on delete

fk_checkin_summary_key_results_checkin_summaries

checkin_summary_key_results.checkin_summary_id

checkin_summaries.id

Cascade on delete

fk_checkin_summary_key_results_previous

checkin_summary_key_results.before_checkin_summary_key_result_id

checkin_summary_key_results.id

Cascade on delete

fk_checkin_summary_key_results_organizations

checkin_summary_key_results.organization_id

organizations.id

Cascade on delete

fk_checkin_summary_key_results_key_results

checkin_summary_key_results.key_result_id

Cascade on delete

fk_note_users_users

note_users.user_id

Cascade on delete

fk_note_users_organizations

note_users.organization_id

organizations.id

Cascade on delete

fk_note_users_notes

note_users.note_id

Cascade on delete

fk_users_tenants

users.tenant_id

Cascade on delete

fk_note_labels_organizations

note_labels.organization_id

organizations.id

Cascade on delete

fk_group_settings_groups

group_settings.group_id

Restrict delete

fk_group_settings_organizations

group_settings.organization_id

organizations.id

Restrict delete

fk_checkin_users_organizations

checkin_users.organization_id

organizations.id

Cascade on delete

fk_checkin_users_users

checkin_users.user_id

Null on delete

fk_group_okr_nodes_organizations

group_okr_nodes.organization_id

organizations.id

Cascade on delete

fk_group_okr_nodes_okr_nodes

group_okr_nodes.okr_node_id

Cascade on delete

fk_group_okr_nodes_groups

group_okr_nodes.group_id

Cascade on delete

fk_okr_labels_organizations

okr_labels.organization_id

organizations.id

Cascade on delete

fk_okr_labels_okr_terms

okr_labels.okr_term_id

Cascade on delete

fk_user_settings_tenants

user_settings.tenant_id

Cascade on delete

fk_user_settings_users

user_settings.user_id

Cascade on delete

fk_objective_events_objectives

objective_events.objective_id

Cascade on delete

fk_objective_events_organizations

objective_events.organization_id

organizations.id

Cascade on delete

fk_objective_events_users

objective_events.user_id

Cascade on delete

fk_okr_labels_notes_okr_labels

okr_labels_nodes.okr_label_id

Cascade on delete

fk_okr_labels_notes_okr_nodes

okr_labels_nodes.okr_node_id

Cascade on delete

fk_okr_labels_notes_organizations

okr_labels_nodes.organization_id

organizations.id

Cascade on delete

fk_smart_hr_employee_change_histories_organizations

smart_hr_employee_change_histories.organization_id

organizations.id

Restrict delete

fk_smart_hr_employee_change_histories_smart_hr_employees

smart_hr_employee_change_histories.smart_hr_employee_id

smart_hr_employees.id

Restrict delete

fk_objectives_okr_nodes

objectives.okr_node_id

Cascade on delete

fk_objectives_organizations

objectives.organization_id

organizations.id

Cascade on delete

fk_objective_confidences_organizations

objective_confidences.organization_id

organizations.id

Cascade on delete

fk_objective_confidences_objectives

objective_confidences.objective_id

Cascade on delete

fk_objective_confidences_users

objective_confidences.user_id

Cascade on delete

fk_notes_key_results

notes.key_result_id

Cascade on delete

fk_notes_last_updated_user_id

notes.last_updated_user_id

Cascade on delete

fk_notes_users

notes.user_id

Cascade on delete

fk_notes_organizations

notes.organization_id

organizations.id

Cascade on delete

fk_notes_objectives

notes.objective_id

Cascade on delete

fk_bookmarks_okr_terms

bookmarks.okr_term_id

Cascade on delete

fk_bookmarks_organizations

bookmarks.organization_id

organizations.id

Cascade on delete

fk_notifications_key_result_id

notifications.key_result_id

Cascade on delete

fk_notifications_organization_id

notifications.organization_id

organizations.id

Cascade on delete

fk_notifications_user_id

notifications.user_id

Cascade on delete

fk_notifications_triggered_user_id

notifications.triggered_user_id

Cascade on delete

fk_notifications_objective_id

notifications.objective_id

Cascade on delete

fk_notifications_note_id

notifications.note_id

Cascade on delete

fk_action_plans_key_results

action_plans.key_result_id

Cascade on delete

fk_action_plans_organizations

action_plans.organization_id

organizations.id

Cascade on delete

fk_action_plans_authors

action_plans.owner_id

Cascade on delete

fk_checkin_summary_reactions_users

checkin_summary_reactions.user_id

Cascade on delete

fk_checkin_summary_reactions_checkin_summaries

checkin_summary_reactions.checkin_summary_id

checkin_summaries.id

Cascade on delete

fk_checkin_summary_reactions_organizations

checkin_summary_reactions.organization_id

organizations.id

Cascade on delete

fk_note_labels_personal_notes_organizations

note_labels_personal_notes.organization_id

organizations.id

Cascade on delete

fk_note_labels_personal_notes_personal_notes

note_labels_personal_notes.personal_note_id

personal_notes.id

Cascade on delete

fk_note_labels_personal_notes_personal_note_labels

note_labels_personal_notes.note_label_id

Cascade on delete

fk_objective_members_organizations

objective_members.organization_id

organizations.id

Cascade on delete

fk_objective_members_objectives

objective_members.objective_id

Cascade on delete

fk_objective_members_users

objective_members.user_id

Cascade on delete

fk_key_result_members_organizations

key_result_members.organization_id

organizations.id

Cascade on delete

fk_key_result_members_users

key_result_members.user_id

Cascade on delete

fk_key_result_members_key_results

key_result_members.key_result_id

Cascade on delete

fk_key_result_confidence_scores_organizations

key_result_confidence_scores.organization_id

organizations.id

Cascade on delete

fk_key_result_confidence_scores_objectives

key_result_confidence_scores.key_result_id

Cascade on delete

fk_note_reactions_users

note_reactions.user_id

Cascade on delete

fk_note_reactions_organizations

note_reactions.organization_id

organizations.id

Cascade on delete

fk_note_reactions_notes

note_reactions.note_id

Cascade on delete

fk_okr_nodes_okr_terms

okr_nodes.okr_term_id

Cascade on delete

fk_okr_nodes_organizations

okr_nodes.organization_id

organizations.id

Cascade on delete

fk_note_labels_notes_notes

note_labels_notes.note_id

Cascade on delete

fk_note_labels_notes_organizations

note_labels_notes.organization_id

organizations.id

Cascade on delete

fk_note_labels_notes_note_labels

note_labels_notes.note_label_id

Cascade on delete

fk_custom_okr_glossaries_okr_glossaries

custom_okr_glossaries.okr_glossary

okr_glossaries.glossary

Restrict delete

fk_custom_okr_glossaries_organizations

custom_okr_glossaries.organization_id

organizations.id

Cascade on delete

fk_okr_terms_organizations

okr_terms.organization_id

organizations.id

Cascade on delete

fk_user_bookmarks_organizations

user_bookmarks.organization_id

organizations.id

Cascade on delete

fk_user_bookmarks_users

user_bookmarks.user_id

Cascade on delete

fk_user_bookmarks_okr_terms

user_bookmarks.okr_term_id

Cascade on delete

fk_personal_note_comments_users

personal_note_comments.user_id

Cascade on delete

fk_personal_note_comments_personal_notes

personal_note_comments.personal_note_id

personal_notes.id

Cascade on delete

fk_personal_note_comments_organizations

personal_note_comments.organization_id

organizations.id

Cascade on delete

fk_checkin_key_results_checkin_users

checkin_key_results.checkin_user_id

checkin_users.id

Cascade on delete

fk_checkin_key_results_checkin_summary_key_result_id

checkin_key_results.checkin_summary_key_result_id

checkin_summary_key_results.id

Cascade on delete

fk_checkin_key_results_key_results

checkin_key_results.key_result_id

Cascade on delete

fk_checkin_key_results_organizations

checkin_key_results.organization_id

organizations.id

Cascade on delete

fk_personal_note_users_organizations

personal_note_users.organization_id

organizations.id

Cascade on delete

fk_personal_note_users_personal_notes

personal_note_users.personal_note_id

personal_notes.id

Cascade on delete

fk_personal_note_users_users

personal_note_users.user_id

Cascade on delete

fk_key_result_attachments_key_results

key_result_attachments.key_result_id

Cascade on delete

fk_key_result_attachments_organizations

key_result_attachments.organization_id

organizations.id

Cascade on delete

fk_action_plan_users_users

action_plan_users.user_id

Cascade on delete

fk_action_plan_users_action_plans

action_plan_users.action_plan_id

action_plans.id

Cascade on delete

fk_action_plan_users_organizations

action_plan_users.organization_id

organizations.id

Cascade on delete

fk_user_oauths_tenants

user_oauths.tenant_id

Cascade on delete

fk_user_oauths_users

user_oauths.user_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
objective_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))
organizations	check_logo_path	(((logo)::text ~ (('^logos/'::text \|\| id) \|\| '/(.+)$'::text)))
organizations	check_self_serve	( CASE WHEN (is_self_serve IS TRUE) THEN (trial_expires_at IS NOT NULL) ELSE true END)
organizations	check_self_serve_or_trial	((NOT ((is_trial_account IS TRUE) AND (is_self_serve IS TRUE))))
personal_note_comment_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))
note_comment_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))
personal_note_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))
note_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))
users	check_avatar_path	(((avatar)::text ~ (('^avatars/'::text \|\| id) \|\| '/(.+)$'::text)))
temporary_registrations	check_self_serve_or_trial	((NOT ((is_trial_account IS TRUE) AND (is_self_serve IS TRUE))))
key_result_attachments	check_file_path	((file_path ~ (('^files/'::text \|\| organization_id) \|\| '/(.+)$'::text)))