I am looking to create a document library, but it does not seem to be as simple as it sounds.
I would like to have three tables:
1 – Document Information – name, desc, etc.
2 – Sections – name, body, etc
3 – Document sections – docid and sectionid
In this, I would like to store individual sections of text, kind of like the different chapters to a book, as a blob or such.
Multiple sections may contain the same document.
Multiple documents may contain the same section.
I am looking to do this in order to have a central point of reference for all project documents. This will offer a single point of reference for updates to multiple documents in which the changed section is the same. This will also allow contributors to track revisions by section rather than by document.
I have read numerous post about storing documents in a db, and it being a bad idea.
My question is if I desire to keep versioned information, document formatting, and prevent a file structure from being deleted, what are the best options out there?