I'm working on a new Data Model, and am leaning towards using "Natural Keys".

This seems to be a good move, except in one area...

I have an "Article" table, and I think it would be awkward to use Article Slug's as the primary keys.

So could I have an "id" field using Auto Increment, and use that as my Primary Key. And then add a Unique Index to my "slug" field, and use that when I want to join to the "Article" table?

For large tables, I just think its nice to have a numerical ID that you can easily refer to if needed...

Sincerely,


Debbie