[thelist] recursive database design discussion
rudy
r937 at interlog.com
Fri Oct 11 15:50:01 CDT 2002
hi jacques, sorry for the delay in answering
the second method is better -- use a recursive structure rather than
separate tables for organizations, departments, and groups
yes, the queries to access the same table three times will be tricky, but
they will be no more complex than the queries involving three separate
tables
there are plenty of examples on the web for code to process the recursive
hierarchy, holler if you need any of them
queries such as which user has access to which group are actually simpler
rudy
More information about the thelist
mailing list