Results 1 to 7 of 7
May 10, 2013, 11:01 #1
- Join Date
- Aug 2010
- 2 Post(s)
- 0 Thread(s)
Can you use Unique Indexed Fields for Joins?
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...