Jump to content

[SOLVED] Structuring a database for this scenario...


rondog

Recommended Posts

I have a client that wants to display a lot of videos categorized by:

 

Client > Shoot1, Shoot2, Shoot3 etc.. > tape1, tape2, tape3 etc..

 

so here I made a quick example sub menu of how the structure would be:

ROTC
Ranger------|
Airborne    |----shoot1
ASB         |----shoot2
            |----shoot3
            |----shoot4-----|
            |----shoot5     |---tape1
            |----shoot6     |---tape2
		    |---tape3
		    |---tape4
	            |---tape5

 

 

similar to this web site: http://www.dvidshub.net/ but rather than B-roll, briefings, greetings etc under "Videos" thats where the client list would be. Can I get some tips on how to go about doing this as dynamic as possible? Thanks guys!

 

 

Link to comment
Share on other sites

You can fill in the details but it would be something like the following:

 

Branch

---------------

Id

Name

 

Shoot

---------------

Id

Name

Branch_Id

 

Tape

---------------

Id

Name

Shoot_Id

 

 

 

This would give you your top level (branch of military?), it would allow you to link as many "shoots" to a particular branch as you would like (Branch_Id) and it would allow you to link as many tapes to a shoot (Shoot_Id) as you would like.

Link to comment
Share on other sites

That seems like a very logical way of doing it. I appreciate your input  ;)

 

If anyone else has other suggestions of different ways to do this I would still be interested in seeing. If not I'll 'topic solve' this in a few hours.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.