22. November 2017 00:00

Primary Keys

By : Eric A. 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.

Etiketten: coding

Zu diesem Artikel gibt es keine Kommentare.

Anmeldung oder register kommentieren