Not 100% sure how to go about it right now, just typing out some thoughts - but maybe have a workflow for uploading a new version of a file?
- User has just completely rewrote a document or a new version of a document is given to them to process or add to the system.
- User opens details view of the file that this new one will replace
- User clicks a link titled something like, "Upload New Version" or something similar.
- On the back-end have a new query written that would upload the document to the correct table, maintaining the same doc name and id, that would also increment the version of this document by 1 (ex. from v1.0 to v2.0).
Still not 100% familiar with the DB of this product yet, so I am not sure if there is a version control system currently in place.