okr_nodes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.okr_nodes_id_seq'::regclass)
checkin_summaries.okr_node_id fk_checkin_summaries_okr_nodesC
group_okr_nodes.okr_node_id fk_group_okr_nodes_okr_nodesC
key_results.okr_node_id fk_key_results_okr_nodesC
objectives.okr_node_id fk_objectives_okr_nodesC
okr_labels_nodes.okr_node_id fk_okr_labels_notes_okr_nodesC
okr_node_slack_integration_channels.okr_node_id fk_okr_node_slack_integrarion_channels_okr_nodesC
path "okr"."ltree" 2147483647 null
slack_incoming_webhook_url text 2147483647 √ null
slack_channel text 2147483647 √ null
slack_integration_enabled bool 1 false
chatwork_api_token text 2147483647 √ null
chatwork_room_id text 2147483647 √ null
chatwork_integration_enabled bool 1 false
teams_incoming_webhook_url text 2147483647 √ null
teams_integration_enabled bool 1 false
okr_term_id int8 19 null
okr_terms.id fk_okr_nodes_okr_termsC
organization_id int8 19 null
organizations.id fk_okr_nodes_organizationsC
disabled_at timestamptz 35,6 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
display_order int4 10 null
path_text text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
okr_nodes_pkey Primary key Asc id
idx_okr_nodes_on_display_order Performance Asc display_order
idx_okr_nodes_on_okr_term_id Performance Asc okr_term_id
idx_okr_nodes_on_organization_id Performance Asc organization_id
idx_okr_nodes_on_path Performance Asc path

Relationships

Close relationships within degrees of separation