Let’s say I have two key as primary.
One is a date and the other is name.
However the name could change due to naming convention changes but is still the same item and also due to careless spelling mistakes.
Should I keep it as primary key but make sure the name is always consistent when upload or should I create another ID for the name in conjunction with the date becomes the primary key.