Hi all,

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...


  • id
  • site
  • value

So, this would go...

1 | UK | 12345-12345-12345-12345
1 | IE | 67890-67890-67890-67890
1 | DE | ABCDE-ABCDE-ABCDE-ABCDE-ABCDE

Seems messy.

Cheers!