Tables


SchemaSpy Analysis of resily

Generated on Thu Sep 04 02:25 UTC 2025

XML Representation
Insertion Order Deletion Order
TABLES 69
VIEWS 5
COLUMNS 678
Constraints 168
Anomalies 0
Routines 320

Database Properties

Database Type: PostgreSQL - 14.19 (Debian 14.19-1.pgdg13+1)

Schema okr

standard public schema

Tables

Table / View Children Parents Columns Rows Type Comments
objective_attachments 0 2 7 0 Table
stripe_customers 0 1 8 0 Table

ResilyのOrganizationとStripe上の顧客を紐付けるテーブル
groups 4 1 9 0 Table
key_result_others 0 3 8 0 Table
key_result_confidences 0 4 8 0 Table
okr_node_slack_integration_channels 0 2 6 0 Table
checkin_summaries 3 4 12 0 Table
key_results 11 2 23 0 Table
flyway_schema_history 0 0 10 165 Table
user_organizations 0 2 5 0 Table
saml_settings 0 1 5 0 Table
key_result_problems 0 3 8 0 Table
note_comment_reactions 0 3 7 0 Table
note_comments 2 3 8 0 Table
organizations 61 1 20 0 Table
group_members 0 3 7 0 Table
objective_parent_key_results 0 3 6 0 Table
personal_notes 5 4 11 0 Table
key_result_win_sessions 0 3 8 0 Table
personal_note_reactions 0 3 7 0 Table
smart_hr_employees 1 2 12 0 Table
smart_hr_departments 0 2 8 0 Table
personal_note_comment_attachments 0 2 7 0 Table
smart_hr_settings 0 1 8 0 Table
note_comment_attachments 0 2 7 0 Table
personal_note_comment_reactions 0 3 7 0 Table
key_result_events 1 5 14 0 Table
objective_confidence_scores 0 2 6 0 Table
personal_note_attachments 0 2 7 0 Table
note_attachments 0 2 7 0 Table
key_result_priorities 0 3 8 0 Table
checkin_summary_key_results 2 4 12 0 Table
note_users 0 3 6 0 Table
users 32 1 29 0 Table
note_labels 2 1 6 0 Table
group_settings 0 2 6 0 Table
checkin_users 5 2 8 0 Table
group_okr_nodes 0 3 6 0 Table
okr_labels 1 2 7 0 Table
user_settings 0 2 14 0 Table
objective_events 0 3 11 0 Table
okr_labels_nodes 0 3 6 0 Table
smart_hr_employee_change_histories 0 2 5 0 Table
objectives 8 2 14 0 Table
objective_confidences 0 3 7 0 Table
notes 6 5 12 0 Table
bookmarks 0 2 7 0 Table
tenants 4 0 3 0 Table
notifications 0 6 12 0 Table
action_plans 1 3 17 0 Table
checkin_summary_reactions 0 3 7 0 Table
note_labels_personal_notes 0 3 6 0 Table
objective_members 0 3 7 0 Table
key_result_members 0 3 8 0 Table
key_result_confidence_scores 0 2 6 0 Table
okr_glossaries 1 0 4 15 Table
note_reactions 0 3 7 0 Table
okr_nodes 6 2 17 0 Table
note_labels_notes 0 3 6 0 Table
custom_okr_glossaries 0 2 7 0 Table
okr_terms 4 1 9 0 Table
user_bookmarks 0 3 12 0 Table
temporary_registrations 0 0 7 0 Table
personal_note_comments 2 3 7 0 Table
checkin_key_results 6 4 9 0 Table
personal_note_users 0 3 6 0 Table
key_result_attachments 0 2 7 0 Table
action_plan_users 0 3 6 0 Table
user_oauths 0 2 7 0 Table
activity_key_result_events 0 0 15 0 View
group_nodes 0 0 11 0 View
activity_checkin_comments 0 0 13 0 View
activities 0 0 13 0 View
okrs 0 0 19 0 View