checkin_summaries

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.checkin_summaries_id_seq'::regclass)
checkin_summaries.before_checkin_summary_id fk_checkin_summaries_beforeC
checkin_summary_key_results.checkin_summary_id fk_checkin_summary_key_results_checkin_summariesC
checkin_summary_reactions.checkin_summary_id fk_checkin_summary_reactions_checkin_summariesC
organization_id int8 19 null
organizations.id fk_checkin_summaries_organizationsC
okr_node_id int8 19 null
okr_nodes.id fk_checkin_summaries_okr_nodesC
description text 2147483647 √ null
plain_text text 2147483647 √ null
status "okr"."checkin_summary_status" 2147483647 'PREVIOUS'::okr.checkin_summary_status
start_date timestamptz 35,6 null
end_date timestamptz 35,6 null
changer_id int8 19 √ null
users.id fk_checkin_summaries_usersN
before_checkin_summary_id int8 19 √ null
checkin_summaries.id fk_checkin_summaries_beforeC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
checkin_summaries_pkey Primary key Asc id
idx_checkin_okr_summaries_on_before_id Performance Asc before_checkin_summary_id
idx_checkin_summaries_on_okr_node_id Performance Asc okr_node_id
idx_checkin_summaries_on_organization_id Performance Asc organization_id
idx_checkin_summaries_on_user_id Performance Asc changer_id

Relationships

Close relationships within degrees of separation