note_comment_attachments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.note_comment_attachments_id_seq'::regclass)
name text 2147483647 null
file_path text 2147483647 null
note_comment_id int8 19 null
note_comments.id fk_note_comment_attachments_note_commentsC
organization_id int8 19 null
organizations.id fk_note_comment_attachments_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
note_comment_attachments_pkey Primary key Asc id
idx_note_comment_attachments_on_note_comment_id Performance Asc note_comment_id
idx_note_comment_attachments_on_organization_id Performance Asc organization_id

Check Constraints

Constraint Name Constraint
check_file_path ((file_path ~ (('^files/'::text || organization_id) || '/(.+)$'::text)))

Relationships

Close relationships within degrees of separation