If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > help designing an archive db

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-19-07, 06:25
demiurgen demiurgen is offline
Registered User
 
Join Date: Apr 2006
Location: Norway
Posts: 26
help designing an archive db

i need a little help designing my dvd job-archive db.

i have a folder structure that looks like this:
0923 | 14975 | Layout, Links, Originals, PrintFiles, Proofs

the first 4 digit number is the name/number of the dvd.
the second 5 digit number represent the job (often many job-folders per dvd) and the next five folders is the content of the job-folder which in turn contain many different types of files like fonts, images etc...

how can i set this up in a professional way??

the main thing i want is to quickly search for a job-number and get the dvd-number where that job is backed up.

maybe i can do a more complex system so if i want a particular font i might also find all the jobs with that font and their dvds...
Reply With Quote
  #2 (permalink)  
Old 08-19-07, 11:33
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,726
A DVD can have more than one job.

Can a job be associated with more than one DVD?
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #3 (permalink)  
Old 08-19-07, 13:01
demiurgen demiurgen is offline
Registered User
 
Join Date: Apr 2006
Location: Norway
Posts: 26
nope.
a job is only backed up on one dvd with a unique 4 digit number.
but there can be many jobs per dvd, depending on how much space they need, some jobs are bigger than others.
Reply With Quote
  #4 (permalink)  
Old 08-19-07, 17:52
gvee gvee is offline
www.gvee.co.uk
 
Join Date: Jan 2007
Location: UK
Posts: 10,156
One DVD can have many jobs
One job can have ____ Layouts
One job can have ____ Links
One job can have ____ Originals
One job can have ____ PrintFiles
One job can have ____ Proofs

The pluralization suggests many, but it's always nice to be sure
__________________
George
Twitter | Blog
Reply With Quote
  #5 (permalink)  
Old 08-20-07, 14:12
demiurgen demiurgen is offline
Registered User
 
Join Date: Apr 2006
Location: Norway
Posts: 26
a job folder can only have one of each sub folder but for instance the Layouts folder can have many indesign or quark documents and the PrintFiles folder can have many postscript files etc.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On