|
id
|
int(11)
|
|
|
|
|
address_id
|
varchar(50)
|
|
|
|
|
source_type
|
varchar(20)
|
|
|
|
|
cust_id
|
varchar(20)
|
|
|
|
|
vend_id
|
varchar(20)
|
|
|
|
|
addr_type
|
varchar(30)
|
|
|
office
|
|
is_default
|
tinyint(4)
|
|
|
0
|
|
contact_person
|
varchar(100)
|
|
|
|
|
contact_phone
|
varchar(50)
|
|
|
|
|
country
|
varchar(50)
|
|
|
中国
|
|
province
|
varchar(50)
|
|
|
|
|
city
|
varchar(50)
|
|
|
|
|
district
|
varchar(50)
|
|
|
|
|
detail_address
|
varchar(500)
|
|
|
|
|
postal_code
|
varchar(20)
|
|
|
|
|
addr_memo
|
varchar(500)
|
|
|
|
|
sort_order
|
int(11)
|
|
|
0
|
|
is_active
|
tinyint(4)
|
|
|
1
|
|
create_date
|
datetime
|
|
|
current_timestamp()
|
|
last_modify_date
|
datetime
|
|
|
current_timestamp()
|