Database design for document management system
Posted by: Saurabh Sharma
Date: December 03, 2013 03:49AM

Hi everyone,

I want to design a web based DOCUMENT MANAGEMENT SYSTEM to store files on server and their meta information like File name, file upload date, user details who uploaded, file path etc. in database.

Architecture is :
a user can be present in one or more domain like Infrastructure, HR, finance
a domain can have 1 or more component (H/W, S/W, devices, Applications etc.)
a component can have 1 or more categories (Knowledge docs, Reports, S/W dumps, Logs files)
every category can have 0 or more files
like :
Users --> (1 or more)Domain --> (1 or more)Component --> (1 or more)Category --> (0 or more)Files

whose UI look like
Domain1:
-----Component1:
---------Category1
---------Category2
-----Component2:
---------Category1
---------Category2

..
..
..

users login with their credentials and cannot access files in domains it is not part of.

Please give me a sample & simple database design to work on

Options: ReplyQuote


Subject
Written By
Posted
Database design for document management system
December 03, 2013 03:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.