Bug 36220 - Connect cover_images and uploaded_files
Summary: Connect cover_images and uploaded_files
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Architecture, internals, and plumbing (show other bugs)
Version: Main
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-03-04 14:07 UTC by Magnus Enger
Modified: 2024-03-04 14:07 UTC (History)
0 users

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Magnus Enger 2024-03-04 14:07:36 UTC
When a local cover image is uploaded, the image ("full" and thumbnail) and the connection to the biblio record are stored in the "cover_images" table: 
https://schema.koha-community.org/23_11/tables/cover_images.html

Some information is also stored in the "uploaded_files" table:
https://schema.koha-community.org/23_11/tables/uploaded_files.html

Would it not make sense to connect these to, so cover_images contained a reference to the relevant entry in  uploaded_files? That way we could also make a connection from biblionumber to any existing files in "tmp_path" directories.