notes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.notes_id_seq'::regclass)
note_attachments.note_id fk_note_attachments_notesC
note_comments.note_id fk_note_comments_notesC
note_labels_notes.note_id fk_note_labels_notes_notesC
note_reactions.note_id fk_note_reactions_notesC
note_users.note_id fk_note_users_notesC
notifications.note_id fk_notifications_note_idC
title text 2147483647 null
body text 2147483647 √ null
user_id int8 19 null
users.id fk_notes_usersC
objective_id int8 19 √ null
objectives.id fk_notes_objectivesC
key_result_id int8 19 √ null
key_results.id fk_notes_key_resultsC
organization_id int8 19 null
organizations.id fk_notes_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
plain_text text 2147483647 √ null
permission "okr"."notes_permission" 2147483647 'PUBLIC'::okr.notes_permission
last_updated_user_id int8 19 null
users.id fk_notes_last_updated_user_idC

Indexes

Constraint Name Type Sort Column(s)
notes_pkey Primary key Asc id
idx_notes_on_key_result_id Performance Asc key_result_id
idx_notes_on_objective_id Performance Asc objective_id
idx_notes_on_organization_id Performance Asc organization_id
idx_notes_on_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation