Document library

By goofy78270 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums