published_activity_media_files

-1 rows


Description

Media files for published project activities visible to funders. It is possible for a file to continue to appear here after it has been removed from the activity if the removal has not been published yet.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id int8 19 null
files.id published_activity_media_files_file_id_fkey R
activity_id int8 19 null
published_activities.activity_id published_activity_media_files_activity_id_fkey R
activity_media_type_id int4 10 null
activity_media_types.id published_activity_media_files_activity_media_type_id_fkey R
is_cover_photo bool 1 null
is_hidden_on_map bool 1 null
list_position int4 10 null
captured_date date 13 null
caption text 2147483647 √ null
geolocation geometry 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
published_activity_media_files_pkey Primary key Asc file_id
published_activity_media_files_activity_id_list_position_key Must be unique Asc/Asc activity_id + list_position

Relationships

Close relationships within degrees of separation