...
The "namespace" or "origin" of every "id" hast has to be part of the primary key. It seems to be natural in the context of manufacturing to choose the "site" as this namespace identifier, i.e. every table which may be used in a different context have to implement this "site"-column.
...