Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.python > #95386
| From | Laura Creighton <lac@openend.se> |
|---|---|
| Subject | Re: How to model government organization hierarchies so that the list can expand and compress |
| References | <b3c1e2da-9f72-420a-8b68-288dddf9fc67@googlegroups.com> <mailman.5.1439534188.4764.python-list@python.org><ae4e203d-c664-4388-af0b-41c41d5ec724@googlegroups.com> |
| Date | 2015-08-15 06:54 +0200 |
| Newsgroups | comp.lang.python |
| Message-ID | <mailman.15.1439614517.4764.python-list@python.org> (permalink) |
In a message of Fri, 14 Aug 2015 16:42:00 -0700, Alex Glaros writes: >Frank, thanks for describing the terminology of what I'm trying to do. > >1. Do the recursive join Postgres examples you linked to, use a data structure where the child has the adjoining parent-ID? Examples look great. > >2. Not 100% sure that hierarchical is the perfect solution but will go with that now. Of course some agencies will be at equal levels; will ignore for now. > >3. Could not find Laura's response. Was it deleted? > >4. Solution will expressed in the DB, not Python. > >Much appreciated! > >Alex What I said was, that real agencies are almost never perfectly heirarchical. That's an oversimplification. In the real world Organisation A (say Army) and Organisation B (say Navy) decide they have common interests and make a Joint Department. If you run that department you report to superiors in _both_ organisation A and organisation B, get orders from both places and so on and so forth. You must decide now what you want to do when you run into such departments, because that will greatly influence your design. Laura
Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-13 12:10 -0700
Re: How to model government organization hierarchies so that the list can expand and compress "Stéphane Wirtel" <stephane@wirtel.be> - 2015-08-13 21:17 +0200
Re: How to model government organization hierarchies so that the list can expand and compress Ian Kelly <ian.g.kelly@gmail.com> - 2015-08-13 13:26 -0600
Re: How to model government organization hierarchies so that the list can expand and compress Laura Creighton <lac@openend.se> - 2015-08-13 21:43 +0200
Re: How to model government organization hierarchies so that the list can expand and compress "Frank Millman" <frank@chagford.com> - 2015-08-14 08:36 +0200
Re: How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-14 16:42 -0700
Re: How to model government organization hierarchies so that the list can expand and compress Rustom Mody <rustompmody@gmail.com> - 2015-08-14 18:21 -0700
Re: How to model government organization hierarchies so that the list can expand and compress Laura Creighton <lac@openend.se> - 2015-08-15 06:54 +0200
Re: How to model government organization hierarchies so that the list can expand and compress "Frank Millman" <frank@chagford.com> - 2015-08-15 07:59 +0200
Re: How to model government organization hierarchies so that the list can expand and compress Friedrich Rentsch <anthra.norell@bluewin.ch> - 2015-08-14 23:25 +0200
Re: How to model government organization hierarchies so that the list can expand and compress Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2015-08-14 19:38 -0400
Re: How to model government organization hierarchies so that the list can expand and compress Denis McMahon <denismfmcmahon@gmail.com> - 2015-08-15 22:51 +0000
Re: How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-17 13:37 -0700
csiph-web