| id_address |
int(10)
|
|
|
|
| id_country |
int(10)
|
|
|
|
| id_state |
int(10)
|
|
|
|
| id_customer |
int(10)
|
|
|
|
| id_manufacturer |
int(10)
|
|
|
|
| id_supplier |
int(10)
|
|
|
|
| alias |
varchar(32)
|
utf8_general_ci
|
|
|
| company |
varchar(32)
|
utf8_general_ci
|
|
|
| lastname |
varchar(32)
|
utf8_general_ci
|
|
|
| firstname |
varchar(32)
|
utf8_general_ci
|
|
|
| address1 |
varchar(128)
|
utf8_general_ci
|
|
|
| address2 |
varchar(128)
|
utf8_general_ci
|
|
|
| postcode |
varchar(12)
|
utf8_general_ci
|
|
|
| city |
varchar(64)
|
utf8_general_ci
|
|
|
| other |
text
|
utf8_general_ci
|
|
|
| phone |
varchar(16)
|
utf8_general_ci
|
|
|
| phone_mobile |
varchar(16)
|
utf8_general_ci
|
|
|
| date_add |
datetime
|
|
|
|
| date_upd |
datetime
|
|
|
|
| active |
tinyint(1)
|
|
|
|
| deleted |
tinyint(1)
|
|
|
|
