I've been tasked to build a database to store some of our products, thing is, as we sell these products under many guises they can be named many things.
Could any point to a satisfactory solution?
To add some context, we have 54 sites, all refer to a product using their own GUID. As potentially, all of these sites will be using the database, I'd prefer not use a local GUID for each product.
Initially, I thought of doing...
So, this would go...
1 | UK | 12345-12345-12345-12345
1 | IE | 67890-67890-67890-67890
1 | DE | ABCDE-ABCDE-ABCDE-ABCDE-ABCDE