>- see footer for list info -< Forgive the off topic request but the database list appears to have disappeared. Please see my email below.
Dear All, I have a client who needs to be able to hold the structure of various organisations in a database, the problem is, each of the organisations has a completely different hierarchy structure and an unlimited number of levels. It is also a case that something at level 3 in the hierarchy may have more than 1 parent. This is a sports related project where by governing bodies, down through regional divisions, counties, leagues, divisions, clubs, teams, age groups etc all are known by different names. In this example, clubs are linked directly to counties as well as directly to divisions and hence the multiple parents. My question is this, If I wanted to hold this information, how is the best way, i.e. if I have a table called org_hierarchy with 3 fields in it as follows: EntityID EntityLevel EntityParent I would hold the actual organisation information in a different table linked by entityID, how would I ultimately in 1 query be able to return all of the underlying structure for a given ID, i.e. I give it the ID of the FA, from this I want the English FA (and all the leagues, divisions, clubs, teams etc), Scottish FA (and all the leagues, divisions, clubs, teams etc) into a structure I can use. To give you an idea of how big this table could be, it might ultimately end up holding the individual player ids to link them to clubs, teams etc. Your help in this one is appreciated. Regards, Lee _______________________________________________ For details on ALL mailing lists and for joining or leaving lists, go to http://list.cfdeveloper.co.uk/mailman/listinfo -- CFDeveloper Sponsors:- >- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -< >- Lists hosted by www.Gradwell.com -< >- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
