I found this reading material on choosing a primary key.
- Is there a guide / blog post on how to choose the primary key for a given table?
- Should I use a auto-incremented/generated key, or should I base the primary key on the data being modeled (assuming it has a truly unique field)?
- Should the primary key always be long for performance's sake, or can I take an external unique id as primary key, even if it's a string?