07-20-2023, 02:48 PM
***To cover international addresses, address fields should not be too specific and too abstract.***
It will cover almost all addresses in this world as shown below:
```
*****************************************************************
Type Field name Displayed name in your form
*****************************************************************
INT id (PK)
VARCHAR(100) country Country
VARCHAR(100) zip_code Zip code
VARCHAR(100) state State, province or prefecture
VARCHAR(100) city City
VARCHAR(100) street Street address or PO Box
VARCHAR(100) building Apt, office, suite, etc. (Optional)
*****************************************************************
```
It will cover almost all addresses in this world as shown below:
```
*****************************************************************
Type Field name Displayed name in your form
*****************************************************************
INT id (PK)
VARCHAR(100) country Country
VARCHAR(100) zip_code Zip code
VARCHAR(100) state State, province or prefecture
VARCHAR(100) city City
VARCHAR(100) street Street address or PO Box
VARCHAR(100) building Apt, office, suite, etc. (Optional)
*****************************************************************
```