Table: addresses
| Name | Type | Details |
|---|---|---|
| id | autoinc | |
| type* | enum, Address Type | AddressType (optional) |
| name | string | The name on the address (person/org) |
| country_id | char(2) | fk -> countries |
| province_id | int | The province the address belongs to (optional) |
| postalcode | string(12) | National identification code. (optional) Why 12? |
| city | string | The city/settlement (optional) |
| address | string (384) | The address details (street, nr, building, etc) |
*: type is really optional, you may completely omit using it, or decide to use set on another level, eg.: using a pivot table like
client_shipping_addresses
| Name | Type | Returns |
|---|---|---|
| country | Country | The country the address belongs to |
| province | Province | null | The province the address belongs to |