report_photos

0 rows


Description

Linking table between reports and files for photos.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
report_id int8 19 null
reports.id report_photos_report_id_fkeyR
file_id int8 19 null
files.id report_photos_photo_id_fkeyC
caption text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
report_photos_pkey Primary key Asc/Asc report_id + file_id
photo_not_shared_between_reports Must be unique Asc file_id

Relationships

Close relationships within degrees of separation