How to model government organization hierarchies so that the list can expand and compress

Alex Glaros alexglaros at
Mon Aug 17 22:37:33 CEST 2015

Perhaps most jointly parented governmental organizations are functionally, collaborative "projects" (not organizations) which my model handles. But thanks to Laura, will not assume there are none, or will never be any in the future, so will use adjacent list (see fast response times documented in article below), but created new 1:M table to handle multiple parents.

1. organization_Id (PK)
2. organization_name

1. organization_Id (FK to above table) - can have multiple parents
2. adjacent_parent_id (FK to above table) 

Thanks to all for the assistance.  Led me to some great articles including


More information about the Python-list mailing list