I am designing a database for an e-commerce company. Each product will be identified by a unique ID (SKU). We want to format the SKU as LLLL000
. LLLL
is the parent product, for example Iphone X.
000
is the variation product, for example color: Gold, storage: 256, status: Open Box.
Following the example, the SKU for Iphone X, color: Gold, storage: 256, status: Open Box, would be something like: LKGH177
A different Iphone X would have: LKGH178
.
My questions are:
Should I consider the entire SKU as a single-column primary key that contains two distinct data points, and so violating 1NF?
Should I consider the SKU split in two columns and set a two-column composite primary key?
Database is not my main field so I hope it is clear.