Newbie - primary key for product database?
I'm working on creating a Products database, where each product code (or sku) is unique and alphanumeric. For example, ABG624397-CXC would be one product number.
In this situation, what would be the best practice regarding the primary key? Is it okay to make the actual Product Code the primary key? Or is it better to create a separate field that is an auto-entered Serial number as the ID for the product?