Wednesday 22 November 2017 at 15:39

Primary Keys

By Eric Antoine Scuccimarra

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


Comments

Login or Register to leave a comment..


Archives