Adding an additional attribute is the answer to pretty much any question ;-)

To be complete,  we are using a tagnumbering attribute for almost all objects, including pipes. That adds a lot of flexibility, without having to adapt the structure of the database for each new tagnumbering scheme.