key_result_confidences

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.key_result_confidences_id_seq'::regclass)
confidence int2 5 null
user_id int8 19 null
users.id fk_key_result_confidences_usersC
key_result_id int8 19 null
key_results.id fk_key_result_confidences_key_resultsC
organization_id int8 19 null
organizations.id fk_key_result_confidences_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
checkin_key_result_id int8 19 √ null
checkin_key_results.id fk_key_result_confidences_checkin_key_result_idC

Indexes

Constraint Name Type Sort Column(s)
key_result_confidences_pkey Primary key Asc id
idx_key_result_confidences_on_checkin_key_result_id Performance Asc checkin_key_result_id
idx_key_result_confidences_on_key_result_id Performance Asc key_result_id
idx_key_result_confidences_on_key_result_id_and_user_id_and_cre Performance Asc/Asc/Asc/Asc key_result_id + user_id + created_at + checkin_key_result_id
idx_key_result_confidences_on_organization_id Performance Asc organization_id
idx_key_result_confidences_on_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation