Primary Keys

Just a little note - if anyone ever has to make a database table of languages, countries, currencies, or anything else that has a unique text code I would recommend that you use the code as the primary key and as the foreign key for related tables.

It will save a lot of database overhead and make the code a lot cleaner if you don't always have to do a table join to get the code from the table.

Labels: coding