Results 1 to 15 of 15
Jul 17, 2012, 10:05 #1
- Join Date
- Jul 2012
- Toronto, Ontario
- 0 Post(s)
- 0 Thread(s)
Foreign Keys and Field Value Population, What's the More Efficient Approach?
I'm trying to design a database and I want to know what's the most efficient way to populate fields with referenced values.
I have the following database design:
For the country table, my unique ID is not a number but rather an ISO two-letter country code, i.e. JP, US, DE, etc. This leads to my first question:
Q1) Is this an efficient approach, using a non-numerical ID, or is numerical ID's always the best?
For the vehicles table, I have the vehicleBrand field referencing the vehicleBrandID field of the vehicleBrands table. When I do this though of course, the dropdown to select what vehicleBrand entry is just a list of the vehicleBrands IDs, like so:
This leads me to my second question:
Is it best to use a numerical ID for internal database operations, and then when you generate some kind of view, i.e. a dropdown, add extra code to just populate those dropdown options with another field from that row
Thanks in advance!