rondog Posted January 8, 2008 Share Posted January 8, 2008 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! Quote Link to comment https://forums.phpfreaks.com/topic/85081-solved-structuring-a-database-for-this-scenario/ Share on other sites More sharing options...
dbo Posted January 8, 2008 Share Posted January 8, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/85081-solved-structuring-a-database-for-this-scenario/#findComment-434024 Share on other sites More sharing options...
rondog Posted January 8, 2008 Author Share Posted January 8, 2008 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. Quote Link to comment https://forums.phpfreaks.com/topic/85081-solved-structuring-a-database-for-this-scenario/#findComment-434039 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.