?
There are various complaints about OSM data model but this is a new one to me. In OSM basically everything is mixed together and there is no real separation into layers.
What you mean by "many tables"?
"many tables" is definitely osm2pgsql design decision