I am designing a spatial database using PostGIS. My main aim of this spatial database is to organize Administrative (250 polygon layer) and postal layers (154 layers) in a database. These layers covers different countries of the world. Each country has difference administrative/ postal code levels. At last this model should provide a way to update these layers using QGIS.
I have studied difference techniques of organizing spatial data in postgis. Till now inheritance model (PostGIS in Action/chapter 3) impress me but I am not sure how to implement it.
Can inheritance used for geometrical inheritance as well? Like Administrative level 01 is always subset of Administrative level 02 means from the geometry of Administrative level 02 we can extract the geometry of Administrative level 01 using dissolve.
If we update any geometry in Administrative level 02 then geometry of Administrative level 01 should be automatically updated. How can I achieve this?