objectives

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.objectives_id_seq'::regclass)
notes.objective_id fk_notes_objectivesC
notifications.objective_id fk_notifications_objective_idC
objective_attachments.objective_id fk_objective_attachments_objectivesC
objective_confidence_scores.objective_id fk_objective_confidence_scores_objectivesC
objective_confidences.objective_id fk_objective_confidences_objectivesC
objective_events.objective_id fk_objective_events_objectivesC
objective_members.objective_id fk_objective_members_objectivesC
objective_parent_key_results.objective_id fk_objective_parent_key_results_objectivesC
name text 2147483647 null
description text 2147483647 √ null
progress_rate int4 10 √ null
result text 2147483647 √ null
okr_node_id int8 19 null
okr_nodes.id fk_objectives_okr_nodesC
organization_id int8 19 null
organizations.id fk_objectives_organizationsC
disabled_at timestamptz 35,6 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
plain_text text 2147483647 √ null
use_weighting bool 1 false
is_description_changed bool 1 √ null
progress_rate_updated_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
objectives_pkey Primary key Asc id
idx_objectives_on_disabled_at Performance Asc disabled_at
idx_objectives_on_okr_node_id Must be unique Asc okr_node_id
idx_objectives_on_organization_id Performance Asc organization_id

Relationships

Close relationships within degrees of separation