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! 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. 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. 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
Archived
This topic is now archived and is closed to further replies.