id | int(10) unsigned |
|
|
|
mch_name | varchar(30) |
|
|
|
mchDealType | tinyint(4) |
|
|
|
mchType | tinyint(4) |
|
|
|
industrId | char(10) |
|
|
|
industr | varchar(30) |
|
|
|
province | char(7) |
|
|
|
province_name | varchar(20) |
|
|
|
city | char(7) |
|
|
|
city_name | varchar(20) |
|
|
|
county | char(7) |
|
|
|
county_name | varchar(20) |
|
|
|
address | varchar(50) |
|
|
|
customerPhone | char(11) |
|
|
|
legalPerson | varchar(30) |
|
|
|
principal | varchar(10) |
|
|
|
idCode | varchar(20) |
|
|
|
idExpTime | char(21) |
|
|
|
mch_phone | char(11) |
|
|
|
indentityPhoto | varchar(500) |
|
|
|
bussLicense | varchar(30) |
|
|
|
bussTerm | char(21) |
|
|
|
bussLicensePhoto | varchar(500) |
|
|
|
bussScope | varchar(500) |
|
|
|
mainPhoto | varchar(500) |
|
|
|
bankId | char(4) |
|
|
|
bankHeadName | varchar(20) |
|
|
|
bank_code | varchar(40) |
|
|
|
bankName | varchar(40) |
|
|
|
bProvince | char(10) |
|
|
|
bProvince_name | varchar(10) |
|
|
|
bCity | char(10) |
|
|
|
bCity_name | varchar(30) |
|
|
|
card_no | varchar(30) |
|
|
|
acc_name | varchar(40) |
|
|
|
user_key | char(64) |
|
|
|
user_id | char(20) |
|
|
|
accountType | tinyint(4) |
|
|
|
cert_code | char(18) |
|
|
|
cert_address | varchar(40) |
|
|
|
bank_phone | char(11) |
|
|
|
divid | char(10) |
|
|
|