okr_terms

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.okr_terms_id_seq'::regclass)
bookmarks.okr_term_id fk_bookmarks_okr_termsC
okr_labels.okr_term_id fk_okr_labels_okr_termsC
okr_nodes.okr_term_id fk_okr_nodes_okr_termsC
user_bookmarks.okr_term_id fk_user_bookmarks_okr_termsC
name varchar 255 null
start_date date 13 null
end_date date 13 null
organization_id int8 19 null
organizations.id fk_okr_terms_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
deleted_at timestamp 29,6 √ null
copy_source_id int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
okr_terms_pkey Primary key Asc id
idx_okr_periods_on_organization_id Performance Asc organization_id

Relationships

Close relationships within degrees of separation