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