Bug 36220

Summary: Connect cover_images and uploaded_files
Product: Koha Reporter: Magnus Enger <magnus>
Component: Architecture, internals, and plumbingAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

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.