activity_media_files

-1 rows


Description

Information about activity-related media such as photos and videos.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int8 19 null
files.id activity_media_files_file_id_fkey C
activity_id int8 19 null
activities.id activity_media_files_activity_id_fkey R
activity_media_type_id int4 10 null
activity_media_types.id activity_media_files_activity_media_type_id_fkey R
is_cover_photo bool 1 null
caption text 2147483647 √ null
is_hidden_on_map bool 1 false
list_position int4 10 null

Indexes

Constraint Name Type Sort Column(s)
activity_media_files_pkey Primary key Asc file_id
activity_media_files_activity_id_idx Performance Asc activity_id
one_cover_per_activity Must be unique Asc activity_id
unambiguous_list_order Must be unique Asc/Asc activity_id + list_position

Check Constraints

Constraint Name Constraint
cover_photo_only ((is_cover_photo = false) OR (activity_media_type_id = 1))

Relationships

Close relationships within degrees of separation