file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
app_store_android.id_cover_image app_store_android_fk0R
app_store_android.id_icon app_store_android_fk1R
app_store_ios.id_developer_certificate app_store_ios_developer_certificate_fkR
app_store_ios.id_icon app_store_ios_fk5R
app_store_ios.id_mobile_provision app_store_ios_fk6R
app_store_ios.id_push_certificate app_store_ios_push_certificat_fkR
base_activity.id_cover_image_file file_fkN
category.button_image category_fk2R
category.button_image_selected category_fk3R
category.cover_image category_fk4R
category.icon category_fk5R
category.icon_sticker category_fk6R
category_group.icon category_group_fk1R
category_group.inner_icon category_group_fk2R
category_group.outer_icon category_group_fk3R
challenge.id_cover_image_file file_fkR
community.id_logo_file file_fkN
community.id_qr community_qr_fkN
conversation_message.id_file file_fkN
file_image.id_file file_fkC
goal.id_icon goal_icon_fkR
group.id_icon group_fk1R
group_image.id_file group_image_fk1R
instance_comment.id_photo activity_comment_fk3R
instance_rating.id_file file_fkN
pinned_board.id_cover pinned_board___fk_fileN
post.id_file file_fkN
screenshot.id_file file_fkR
template_event.id_cover_image template_event_fk0R
user_profile.id_avatar_file file_fkN
welcome_screen.id_file file_fkR
size int4 10 0
url text 2147483647 √ null
name text 2147483647 null
id_dd_media_type int2 5 null
dd_media_type.id dd_media_type_fkR
created_at timestamptz 35,6 √ null
updated_at timestamptz 35,6 √ null
mime text 2147483647 √ null
bucket text 2147483647 √ null
id_dd_file_status int2 5 √ null
dd_file_status.id dd_file_status_fkN
id_community int4 10 null
community.id community_fkN

Indexes

Constraint Name Type Sort Column(s)
file_pk Primary key Asc id

Relationships

Close relationships within degrees of separation