I am designing a database which stores a large list of products. Each product can have multiple photos.
I am looking at a interface that allows the user to upload and download one or more photos of each product.
For scalability purpose, the interface should automatically store the photo in a specific folder and insert an entry in the photo table which records the:
- key
- product ID (foreign key)
- path of the photo
Can the above be accomplished by Libreoffice, or should I use some other tools?
Given that the above is a very common feature, are there any templates or wizards that has the above feature?