What would be the best practice to design a database schema that can have specific country fields.
e.g. a sample customer table
id name email social_security_number (USA person ID) curp (Mexico person ID) cpf (Brazil person ID) zip (USA postal code) cep (Brazil postal code) postcode (UK postal code)
But as we have more specific fields for each country the table will end up with a lot of fields.
The other approach would be to use a code instead
id field001 > name field002 > email field003 > social security number for any country field004 > postal code for any country
I understand that each approach has it's pros and cons.