Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  How to store different types of resources

Author  Topic  Beer Starting Member 7 Posts Posted - 2010-04-29 : 19:24:34 Hey! I am working with few customers (5-10), manage their computers, store some important info, that helps me solve the problem in case of emergency. I have a folder for each customer and put all files inside (txt, vnc shortcuts, images,...). I would like to store this in database (SQL Server 2008). Here is what I have now: - Table for Customers - Table for Resources (FK_CustomerID) The idea behind "Resources" table is that every information I want to store in database is a Resource. For example: 1. Remote Computers Fields (name, ip addresses, remote access adr.: VNC, RDP,..) 2. Images Fields (keywords, description, date taken,...) 3. Simple note Fileds (keywords, text) 4. .... Is it possible to make such relation between tables? I guess I would still need table for each resource type (ComputerInfo, Image, TextNote,...)? Right? Note: I should be able to assign several different "resources" to the customer. If there is new computer, I just add new resource (of type ComputerInfo). What would be the right approch? Thanks, Beer