Tutorial on Dev Best Practice

Tutorial on Best Practice in Application Development - Reference Data

Standards for Reference Data

Where we use Reference Data, it is good practice to comply with relevant national or international Standards.

For example, in the Addresses Table, we can see a field called 'iso_country_code'.

The ISO prefix emphasises the fact that we have adopted conventions endorsed by the International Standards Organisation,('ISO').

Then, if we want to use our Database Schema on an international scale, our approach will be 'future proof'.