| Field | Type | Null | Key | Default | Extra |
| address_id | int(11) | NO | PRI | auto_increment | |
| customer_id | int(11) | NO | MUL | ||
| firstname | varchar(32) | NO | |||
| lastname | varchar(32) | NO | |||
| address_1 | varchar(128) | YES | |||
| address_2 | varchar(128) | YES | |||
| city | varchar(128) | YES | |||
| country_id | int(11) | YES | 0 | ||
| zone_id | int(11) | YES | 0 |
