key_result_attachments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.key_result_attachments_id_seq'::regclass)
name text 2147483647 null
file_path text 2147483647 null
key_result_id int8 19 null
key_results.id fk_key_result_attachments_key_resultsC
organization_id int8 19 null
organizations.id fk_key_result_attachments_organizationsC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
key_result_attachments_pkey Primary key Asc id
idx_key_result_attachments_on_key_result_id Performance Asc key_result_id
idx_key_result_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