使用datax导入MYSQL数据到ES

一、生成配置

打开项目下的这个类 ：com.soeasycenter.api.utils.es.DataxJsonGenerator 运行main方法，这里已经写好了需要导入的实体类，直接运行即可，注意需要修改一下配置存放目录的位置 结果如图：

二、创建索引

1、打开kibana地址 http://8.129.162.175:9201/ (opens new window)

2、进入开发工具并输入刚才生成的索引创建语句，这里以co_order_detail为例

3、目前需要创建的索引语句如下

--------------------co_order_main 索引添加语句------------------
PUT /co_order_main
{
  "mappings":{
    
    "properties": {"orderType":{"type":"text"},"financeAuditUserId":{"type":"text"},"referOrderCode":{"type":"text"},"departmentId":{"type":"text"},"accpetanceLevel":{"type":"text"},"startBidtime":{"type":"date"},"deliverPlace":{"type":"text"},"readCount":{"type":"integer"},"isDxCollege":{"type":"text"},"payedConfirm":{"type":"text"},"isAdvanceEndbid":{"type":"text"},"isPublishBidresult":{"type":"text"},"deliverType":{"type":"text"},"bidAmountRenminbi":{"type":"double"},"orderTime":{"type":"date"},"agentRealName":{"type":"text"},"payType":{"type":"text"},"officePhone":{"type":"text"},"exchangeRate":{"type":"double"},"bidFinished":{"type":"text"},"currentProceeTime":{"type":"date"},"supplierReqs":{"type":"text"},"invoiceType":{"type":"text"},"budget":{"type":"double"},"deviceType":{"type":"text"},"isReaudit":{"type":"text"},"compusId":{"type":"text"},"createUserid":{"type":"text"},"isResearch":{"type":"text"},"bidAmount":{"type":"double"},"payedStatus":{"type":"text"},"packLevel":{"type":"text"},"contractLimit":{"type":"text"},"foundsSubject":{"type":"text"},"contractReqs":{"type":"text"},"waitingEvaluate":{"type":"text"},"collegeName":{"type":"text"},"isExtend":{"type":"text"},"currentProcee":{"type":"text"},"sourceType":{"type":"text"},"bidCount":{"type":"integer"},"projectName":{"type":"text"},"dataSource":{"type":"text"},"purchaseDesc":{"type":"text"},"lastUpdateTime":{"type":"date"},"orderMainId":{"type":"text"},"minDetailBidCount":{"type":"integer"},"agentUserName":{"type":"text"},"isDeliver":{"type":"text"},"lastUpdateUserid":{"type":"text"},"installations":{"type":"text"},"winningPrinciple":{"type":"text"},"orderStatus":{"type":"text"},"remark":{"type":"text"},"budgetIsOpen":{"type":"text"},"referOrderType":{"type":"text"},"personPhone":{"type":"text"},"itemNum":{"type":"integer"},"isAutoSubmit":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"orderTotalAmount":{"type":"double"},"collegeId":{"type":"text"},"transportType":{"type":"text"},"currentProceeName":{"type":"text"},"orderUnit":{"type":"text"},"isExchequer":{"type":"text"},"orderTitle":{"type":"text"},"isTax":{"type":"text"},"lastUpdateUsername":{"type":"text"},"installationgSite":{"type":"text"},"adviceExpiredTime":{"type":"date"},"foundsCode":{"type":"text"},"deliverTime":{"type":"text"},"isDxCenter":{"type":"text"},"isInvoice":{"type":"text"},"otherId":{"type":"text"},"financeAuditUserName":{"type":"text"},"responseTime":{"type":"text"},"priceType":{"type":"text"},"publishBidresultTime":{"type":"date"},"publicityTime":{"type":"date"},"deviceType2":{"type":"text"},"confNum":{"type":"text"},"agentUserId":{"type":"text"},"createTime":{"type":"date"},"isImplemented":{"type":"text"},"endBidtime":{"type":"date"},"orderCode":{"type":"text"},"usingCorrency":{"type":"text"},"institueId":{"type":"text"},"orderPerson":{"type":"text"},"procurementType":{"type":"text"}}
   }
}

--------------------co_order_detail 索引添加语句------------------
PUT /co_order_detail
{
  "mappings":{
    
    "properties": {"companyName":{"type":"text"},"detailId":{"type":"text"},"sellerIsAssessed":{"type":"text"},"unNo":{"type":"text"},"readCount":{"type":"integer"},"payedConfirm":{"type":"text"},"isDxCollege":{"type":"text"},"deviceName":{"type":"text"},"isMandatoryAttachment":{"type":"text"},"bidAmountRenminbi":{"type":"double"},"deviceNameEn":{"type":"text"},"exchangeRate":{"type":"double"},"isCheapest":{"type":"text"},"closeReason":{"type":"text"},"isReaudit":{"type":"text"},"createUserid":{"type":"text"},"isAccessory":{"type":"text"},"priceCompany":{"type":"text"},"bidAmount":{"type":"double"},"payedStatus":{"type":"text"},"bidPrice":{"type":"double"},"reagentStatus":{"type":"text"},"unit":{"type":"text"},"companyId":{"type":"text"},"currentProcee":{"type":"text"},"otherDetailId":{"type":"text"},"bidCount":{"type":"integer"},"usingBrandModel":{"type":"text"},"projectName":{"type":"text"},"dataSource":{"type":"text"},"deviceSpec":{"type":"text"},"deviceBrand":{"type":"text"},"status":{"type":"text"},"lastUpdateTime":{"type":"date"},"orderMainId":{"type":"text"},"afterService":{"type":"text"},"avgPrice":{"type":"double"},"lastUpdateUserid":{"type":"text"},"userInitReason":{"type":"text"},"orderNum":{"type":"double"},"remark":{"type":"text"},"initBidId":{"type":"text"},"manufacturer":{"type":"text"},"isAutoSubmit":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"casNo":{"type":"text"},"collegeId":{"type":"text"},"diffrencesDesc":{"type":"text"},"producingArea":{"type":"text"},"lastUpdateUsername":{"type":"text"},"inquireRemark":{"type":"text"},"buyerIsAssessed":{"type":"text"},"isDxCenter":{"type":"text"},"detailBudget":{"type":"double"},"dangliang":{"type":"double"},"bidId":{"type":"text"},"acceptanceStatus":{"type":"text"},"bidResultTime":{"type":"date"},"publicityTime":{"type":"date"},"isStandard":{"type":"text"},"createTime":{"type":"date"},"reTradeCount":{"type":"integer"},"orderCode":{"type":"text"},"showOrder":{"type":"integer"},"deviceModel":{"type":"text"},"inquirePrice":{"type":"double"}}
   }
}

--------------------cp_bid_order 索引添加语句------------------
PUT /cp_bid_order
{
  "mappings":{
    
    "properties": {"bidReason":{"type":"text"},"companyName":{"type":"text"},"foreordainId":{"type":"text"},"detailId":{"type":"text"},"isDxCollege":{"type":"text"},"deviceName":{"type":"text"},"deliverType":{"type":"text"},"bidTime":{"type":"date"},"bidSuccessNum":{"type":"integer"},"encodePrice":{"type":"text"},"reAuditTime":{"type":"date"},"isForeordain":{"type":"text"},"deliverUsername":{"type":"text"},"createUserid":{"type":"text"},"reAuditUserid":{"type":"text"},"bidTotalNum":{"type":"integer"},"isInquire":{"type":"text"},"orderBidType":{"type":"text"},"bidPrice":{"type":"double"},"bidUserId":{"type":"text"},"sendTime":{"type":"text"},"totalAmount":{"type":"double"},"isDelivered":{"type":"text"},"unit":{"type":"text"},"companyId":{"type":"text"},"initUserId":{"type":"text"},"eccNum":{"type":"text"},"dataSource":{"type":"text"},"deviceSpec":{"type":"text"},"deviceBrand":{"type":"text"},"bidCompanyLevel":{"type":"text"},"lastUpdateTime":{"type":"date"},"orderMainId":{"type":"text"},"afterService":{"type":"text"},"initUsername":{"type":"text"},"sourceCompanyId":{"type":"text"},"quotingAmountRenminbi":{"type":"double"},"lastUpdateUserid":{"type":"text"},"orderNum":{"type":"double"},"remark":{"type":"text"},"shipName":{"type":"text"},"badAssessNum":{"type":"integer"},"manufacturer":{"type":"text"},"disobeyNum":{"type":"integer"},"warrantyPeriod":{"type":"integer"},"createUsername":{"type":"text"},"casNo":{"type":"text"},"nodeReason":{"type":"text"},"diffrencesDesc":{"type":"text"},"producingArea":{"type":"text"},"lastUpdateUsername":{"type":"text"},"bidStatus":{"type":"text"},"deliverTime":{"type":"date"},"isDxCenter":{"type":"text"},"otherId":{"type":"text"},"giveupUserid":{"type":"text"},"examAbnormalNum":{"type":"integer"},"isFulfil":{"type":"text"},"reAuditReason":{"type":"text"},"sourceCollegeId":{"type":"text"},"totalAmountRenminbi":{"type":"double"},"celNum":{"type":"text"},"bidId":{"type":"text"},"giveupTime":{"type":"date"},"shipCode":{"type":"text"},"deliverRemark":{"type":"text"},"productCode":{"type":"text"},"isStandard":{"type":"text"},"createTime":{"type":"date"},"bidPerson":{"type":"text"},"blackNum":{"type":"integer"},"reAuditUsername":{"type":"text"},"giveupUsername":{"type":"text"},"orderCode":{"type":"text"},"deviceModel":{"type":"text"},"deliverUserid":{"type":"text"},"initTime":{"type":"date"},"installWay":{"type":"text"}}
   }
}

--------------------co_bid_attachment 索引添加语句------------------
PUT /co_bid_attachment
{
  "mappings":{
    
    "properties": {"orderMainId":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"attachmentType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"detailId":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"bidId":{"type":"text"},"collegeName":{"type":"text"},"bidAnnid":{"type":"text"},"infoType":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"attachmentName":{"type":"text"},"ftpPath":{"type":"text"},"attachmentId":{"type":"text"},"projectName":{"type":"text"},"lastUpdateUsername":{"type":"text"},"attachmentPath":{"type":"text"},"lastUpdateTime":{"type":"date"},"ossPath":{"type":"text"}}
   }
}

--------------------co_college_info 索引添加语句------------------
PUT /co_college_info
{
  "mappings":{
    
    "properties": {"purchaseRight":{"type":"text"},"portalLogoPath":{"type":"text"},"backPath":{"type":"text"},"lastUpdateUserid":{"type":"text"},"areaScope":{"type":"text"},"dxType":{"type":"text"},"collegeCode":{"type":"text"},"remark":{"type":"text"},"dbServiceIp":{"type":"text"},"isDxCollege":{"type":"text"},"appPath":{"type":"text"},"createUsername":{"type":"text"},"collegeId":{"type":"text"},"sortNum":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"auditCompany":{"type":"text"},"dbServicePort":{"type":"text"},"confirmReport":{"type":"text"},"decryptType":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"logoPath":{"type":"text"},"dxservicePath":{"type":"text"},"isCompactGoods":{"type":"text"},"inCity":{"type":"text"},"token":{"type":"text"},"isShow":{"type":"text"},"inProvince":{"type":"text"},"collegeName":{"type":"text"},"deploymentType":{"type":"text"},"sourceType":{"type":"text"},"createTime":{"type":"date"},"servicePath":{"type":"text"},"depositStatus":{"type":"text"},"whiteStatus":{"type":"text"},"isRedution":{"type":"text"},"scopeSortNum":{"type":"integer"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_company_info 索引添加语句------------------
PUT /cp_company_info
{
  "mappings":{
    
    "properties": {"isRecommend":{"type":"text"},"regStatus":{"type":"text"},"authorizedEmail":{"type":"text"},"companyAbstract":{"type":"text"},"companyName":{"type":"text"},"companyOrgtype":{"type":"text"},"deliverGoodCount":{"type":"integer"},"deliverSoCount":{"type":"integer"},"publishOrderCount":{"type":"integer"},"serviceBadCount":{"type":"integer"},"serviceToobadCount":{"type":"integer"},"isDxCollege":{"type":"text"},"expDate":{"type":"date"},"bidedCount":{"type":"integer"},"auditorTime":{"type":"date"},"officePhone":{"type":"text"},"productToobadCount":{"type":"integer"},"serviceScore":{"type":"double"},"taxRegistrationUrl":{"type":"text"},"serviceGoodCount":{"type":"integer"},"companyNameUsed":{"type":"text"},"assessedCount":{"type":"double"},"bankAccount":{"type":"text"},"productBadCount":{"type":"integer"},"creditScore":{"type":"double"},"createUserid":{"type":"text"},"serviceSoCount":{"type":"integer"},"companyNameEn":{"type":"text"},"addedTax":{"type":"text"},"businessScope":{"type":"text"},"taxNumber":{"type":"text"},"authorizedBidderTel":{"type":"text"},"serviceVerygoodCount":{"type":"integer"},"productScore":{"type":"double"},"taxRegistration":{"type":"text"},"totalAmount":{"type":"double"},"companyId":{"type":"text"},"regTime":{"type":"date"},"organizationCode":{"type":"text"},"bidCount":{"type":"integer"},"approveEndtime":{"type":"date"},"certificateType":{"type":"text"},"status":{"type":"text"},"lastUpdateTime":{"type":"date"},"abortOrderCount":{"type":"integer"},"deliverBadCount":{"type":"integer"},"lastUpdateUserid":{"type":"text"},"legalPersonEmail":{"type":"text"},"purchaseId":{"type":"text"},"juridicalPerson":{"type":"text"},"remark":{"type":"text"},"bankName":{"type":"text"},"industry":{"type":"text"},"buyerRight":{"type":"text"},"tentderRight":{"type":"text"},"personPhone":{"type":"text"},"productVerygoodCount":{"type":"integer"},"authorizedBidder":{"type":"text"},"createUsername":{"type":"text"},"registrationCode":{"type":"text"},"lastUpdateUsername":{"type":"text"},"email":{"type":"text"},"deliverVerygoodCount":{"type":"integer"},"productGoodCount":{"type":"integer"},"deliverToobadCount":{"type":"integer"},"legalPersonTel":{"type":"text"},"certificateCode":{"type":"text"},"publishRight":{"type":"text"},"auditOpinion":{"type":"text"},"address":{"type":"text"},"isDxCenter":{"type":"text"},"bidRight":{"type":"text"},"productSoCount":{"type":"integer"},"regInstitute":{"type":"text"},"auditor":{"type":"text"},"abortBidCount":{"type":"integer"},"inCity":{"type":"text"},"auditCollegeId":{"type":"text"},"registCapital":{"type":"double"},"inProvince":{"type":"text"},"organizationCodeUrl":{"type":"text"},"createTime":{"type":"date"},"isOwed":{"type":"text"},"deliverScore":{"type":"double"},"kcRight":{"type":"text"},"mallRight":{"type":"text"}}
   }
}

--------------------cp_ignore_enshrine 索引添加语句------------------
PUT /cp_ignore_enshrine
{
  "mappings":{
    
    "properties": {"orderMainId":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"ignoreEnshrineId":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"lastUpdateUsername":{"type":"text"},"status":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------sc_seller_assess 索引添加语句------------------
PUT /sc_seller_assess
{
  "mappings":{
    
    "properties": {"orderMainId":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"performScore":{"type":"integer"},"lastUpdateUserid":{"type":"text"},"assessContent":{"type":"text"},"remark":{"type":"text"},"totalAssess":{"type":"text"},"userName":{"type":"text"},"isDxCollege":{"type":"text"},"totalScore":{"type":"double"},"userId":{"type":"text"},"orderDetailId":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"assessTime":{"type":"date"},"collegeId":{"type":"text"},"buyerType":{"type":"integer"},"publishCompanyId":{"type":"text"},"personId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"assessId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------co_black_info 索引添加语句------------------
PUT /co_black_info
{
  "mappings":{
    
    "properties": {"isAvailable":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"deadTime":{"type":"date"},"description":{"type":"text"},"remark":{"type":"text"},"publishCompanyName":{"type":"text"},"blackReason":{"type":"text"},"isDxCollege":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"sourceType":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"publishCompanyId":{"type":"text"},"punishType":{"type":"text"},"lastUpdateUsername":{"type":"text"},"blackInfoId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_goods 索引添加语句------------------
PUT /shopping_goods
{
  "mappings":{
    
    "properties": {"goodsSalenum":{"type":"integer"},"goodsBrandId":{"type":"text"},"goodsModel":{"type":"text"},"isDxCollege":{"type":"text"},"generatePlace":{"type":"text"},"goodsInventoryDetail":{"type":"text"},"payType":{"type":"text"},"goodsBrandName":{"type":"text"},"zoneId":{"type":"text"},"goodsMainPhotoId":{"type":"long"},"freeInstallDebug":{"type":"text"},"storeRecommend":{"type":null},"goodsName":{"type":"text"},"goodsShowTime":{"type":"date"},"goodsValidTime":{"type":"date"},"inventoryType":{"type":"text"},"createUserid":{"type":"text"},"seoDescription":{"type":"text"},"gcId":{"type":"text"},"orderValidTime":{"type":"integer"},"goodsSpec":{"type":"text"},"goodsProperty":{"type":"text"},"goodsPrice":{"type":"double"},"goodsClick":{"type":"integer"},"goodsSerial":{"type":"text"},"lastUpdateTime":{"type":"date"},"afterService":{"type":"text"},"deliveryTime":{"type":"text"},"goodsId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"salesArea":{"type":"text"},"goodsRecommend":{"type":"integer"},"seoKeywords":{"type":"text"},"storeRecommendTime":{"type":"date"},"goodsWeight":{"type":"double"},"goodsInventory":{"type":"integer"},"manufacturer":{"type":"text"},"createUsername":{"type":"text"},"deleteStatus":{"type":null},"goodsCollect":{"type":"integer"},"goodsTransfee":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"goodsFee":{"type":"text"},"goodsStoreId":{"type":"text"},"goodsDetails":{"type":"text"},"isDxCenter":{"type":"text"},"deliveryType":{"type":"text"},"goodsInventoryUnit":{"type":"text"},"goodsStatus":{"type":"integer"},"createTime":{"type":"date"},"storePrice":{"type":"double"},"goodsSellerTime":{"type":"date"}}
   }
}

--------------------cp_company_level 索引添加语句------------------
PUT /cp_company_level
{
  "mappings":{
    
    "properties": {"feeScale":{"type":"double"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"available":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"companyLevel":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"levelId":{"type":"text"},"electYear":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_photo 索引添加语句------------------
PUT /shopping_photo
{
  "mappings":{
    
    "properties": {"photoOrder":{"type":"integer"},"photoTaskid":{"type":"text"},"createUserid":{"type":"text"},"middleSizeUrl":{"type":"text"},"isDxCenter":{"type":"text"},"goodsId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"photoId":{"type":"long"},"isDxCollege":{"type":"text"},"photoUrl":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"photoThumbnailUrl":{"type":"text"},"photoStatus":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"ossPath":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------co_bid_announcement 索引添加语句------------------
PUT /co_bid_announcement
{
  "mappings":{
    
    "properties": {"lastUpdateUserid":{"type":"text"},"projectType":{"type":"text"},"remark":{"type":"text"},"readCount":{"type":"integer"},"isDxCollege":{"type":"text"},"infoType":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"publishUsername":{"type":"text"},"bidUnit":{"type":"text"},"publishTimeEnd":{"type":"date"},"lastUpdateUsername":{"type":"text"},"publishTime":{"type":"date"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"bidContent":{"type":"text"},"publishUserId":{"type":"text"},"announcementStatus":{"type":"text"},"collegeName":{"type":"text"},"bidAnnid":{"type":"text"},"createTime":{"type":"date"},"projectName":{"type":"text"},"downloadCount":{"type":"integer"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------me_announcement 索引添加语句------------------
PUT /me_announcement
{
  "mappings":{
    
    "properties": {"publishTime":{"type":"date"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"announcementEffect":{"type":"text"},"publishUserId":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"announcementStatus":{"type":"text"},"collegeName":{"type":"text"},"createUsername":{"type":"text"},"sourceType":{"type":"text"},"createTime":{"type":"date"},"receiverType":{"type":"text"},"collegeId":{"type":"text"},"publishUsername":{"type":"text"},"announcementId":{"type":"text"},"announcementTitle":{"type":"text"},"announcementContent":{"type":"text"},"announcementType":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------me_plat_news 索引添加语句------------------
PUT /me_plat_news
{
  "mappings":{
    
    "properties": {"publishTime":{"type":"date"},"newsContent":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"userId":{"type":"text"},"newsType":{"type":"text"},"collegeName":{"type":"text"},"newsId":{"type":"text"},"createUsername":{"type":"text"},"sourceType":{"type":"text"},"createTime":{"type":"date"},"receiverType":{"type":"text"},"newsTitle":{"type":"text"},"publishUsername":{"type":"text"},"isImportant":{"type":"text"},"collegeId":{"type":"text"},"newsStatus":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------co_file 索引添加语句------------------
PUT /co_file
{
  "mappings":{
    
    "properties": {"fileName":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"filePath":{"type":"text"},"orderNum":{"type":"integer"},"remark":{"type":"text"},"type":{"type":"text"},"isDxCollege":{"type":"text"},"newsId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"fileId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------pt_file 索引添加语句------------------
PUT /pt_file
{
  "mappings":{
    
    "properties": {"fileName":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"displayName":{"type":"text"},"filePath":{"type":"text"},"orderNum":{"type":"integer"},"remark":{"type":"text"},"type":{"type":"text"},"isDxCollege":{"type":"text"},"newsId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"fileFormat":{"type":"text"},"fileContent":{"type":"text"},"fileId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_black_info 索引添加语句------------------
PUT /cp_black_info
{
  "mappings":{
    
    "properties": {"isAvailable":{"type":"text"},"orderMainId":{"type":"text"},"isComment":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"description":{"type":"text"},"remark":{"type":"text"},"blackReason":{"type":"text"},"isDxCollege":{"type":"text"},"createUsername":{"type":"text"},"collegeId":{"type":"text"},"punishType":{"type":"text"},"lastUpdateUsername":{"type":"text"},"blackInfoId":{"type":"text"},"punishRange":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"deadTime":{"type":"date"},"collegeName":{"type":"text"},"confirmDate":{"type":"date"},"companyId":{"type":"text"},"confirmUsername":{"type":"text"},"createTime":{"type":"date"},"lastUpdateTime":{"type":"date"},"blackedType":{"type":"text"}}
   }
}

--------------------cp_black_notice 索引添加语句------------------
PUT /cp_black_notice
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"companyName":{"type":"text"},"blackNoticeId":{"type":"text"},"noticeType":{"type":"text"},"isDxCollege":{"type":"text"},"noticeMode":{"type":"text"},"sendTime":{"type":"date"},"revision":{"type":"text"},"noticeContent":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"blackNoticeTitle":{"type":"text"},"cancelTime":{"type":"date"},"createTime":{"type":"date"},"noticeStatus":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_no_biding_list 索引添加语句------------------
PUT /cp_no_biding_list
{
  "mappings":{
    
    "properties": {"isAvailable":{"type":"text"},"nobidingListId":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_white_list 索引添加语句------------------
PUT /cp_white_list
{
  "mappings":{
    
    "properties": {"whiteListId":{"type":"text"},"deviceType":{"type":"text"},"isAvailable":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------co_commerce_clause 索引添加语句------------------
PUT /co_commerce_clause
{
  "mappings":{
    
    "properties": {"blackCount":{"type":"integer"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"unpaidCount":{"type":"integer"},"lastUpdateUserid":{"type":"text"},"supplierArea":{"type":"text"},"areaScope":{"type":"text"},"remark":{"type":"text"},"clauseId":{"type":"text"},"isDxCollege":{"type":"text"},"registCapital":{"type":"double"},"lostCount":{"type":"integer"},"collegeName":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"rigsterYears":{"type":"integer"},"runMonths":{"type":"double"},"supplierType":{"type":"text"},"countPeriod":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"status":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------pt_special_column 索引添加语句------------------
PUT /pt_special_column
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"columnId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"sort":{"type":"integer"},"title":{"type":"text"},"type":{"type":"text"},"columnValue":{"type":"text"},"isDxCollege":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"linkUrl":{"type":"text"},"attachmentId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"status":{"type":"integer"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------co_recommend 索引添加语句------------------
PUT /co_recommend
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"recommendId":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"orderNum":{"type":"integer"},"recommendBidId":{"type":"text"},"remark":{"type":"text"},"isStart":{"type":"text"},"isDxCollege":{"type":"text"},"recommendBidCode":{"type":"text"},"optionType":{"type":"text"},"collegeName":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"recommendType":{"type":"text"},"endBidtime":{"type":"date"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_recommend 索引添加语句------------------
PUT /shopping_recommend
{
  "mappings":{
    
    "properties": {"goodsStoreId":{"type":"text"},"createUserid":{"type":"text"},"recommendId":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"orderNum":{"type":"integer"},"remark":{"type":"text"},"isStart":{"type":"text"},"isDxCollege":{"type":"text"},"recommendGoodsId":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"goodsStoreName":{"type":"text"},"recommendType":{"type":"text"},"lastUpdateUsername":{"type":"text"},"goodsValidTime":{"type":"date"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------sg_feedback 索引添加语句------------------
PUT /sg_feedback
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"feedbackId":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"feedbackUserid":{"type":"text"},"objectType":{"type":"text"},"feedbackTime":{"type":"date"},"feedbackContent":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"isTop":{"type":"text"},"feedbackUsername":{"type":"text"},"feedbackTitle":{"type":"text"},"pFeedbackId":{"type":"text"},"objectName":{"type":"text"},"lastUpdateUsername":{"type":"text"},"feedbackType":{"type":"text"},"feedbackStatus":{"type":"text"},"objectId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------foreign_goods 索引添加语句------------------
PUT /foreign_goods
{
  "mappings":{
    
    "properties": {"isAvailable":{"type":"text"},"goodsId":{"type":"text"},"dataType":{"type":"text"},"goodsModel":{"type":"text"},"paramName":{"type":"text"},"goodsBrand":{"type":"text"},"goodsType":{"type":"text"},"goodsUrl":{"type":"text"},"createTime":{"type":"date"},"goodsPrice":{"type":"double"},"goodsTypeJjw":{"type":"text"},"usingCorrency":{"type":"double"},"goodsName":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_deliver 索引添加语句------------------
PUT /cp_deliver
{
  "mappings":{
    
    "properties": {"orderMainId":{"type":"text"},"orderType":{"type":"text"},"createUserid":{"type":"text"},"arrivalLimitTime":{"type":"date"},"isDxCenter":{"type":"text"},"expressProgress":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"receiveStatus":{"type":"integer"},"isDxCollege":{"type":"text"},"bidId":{"type":"text"},"deliverType":{"type":"text"},"receiveTime":{"type":"date"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"expressCompany":{"type":"text"},"expressCode":{"type":"text"},"remindReceive":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"expressId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_order_form 索引添加语句------------------
PUT /shopping_order_form
{
  "mappings":{
    
    "properties": {"orderType":{"type":"text"},"mallOrderId":{"type":"text"},"addTime":{"type":"date"},"payTime":{"type":"date"},"confirmEndTime":{"type":"date"},"shipTime":{"type":"date"},"userPhone":{"type":"text"},"shipPrice":{"type":"double"},"buyerId":{"type":"text"},"isDxCollege":{"type":"text"},"returnShipCode":{"type":"text"},"payMsg":{"type":"text"},"paymentId":{"type":"text"},"userMobile":{"type":"text"},"invoiceType":{"type":"integer"},"confirmStatus":{"type":"integer"},"createUserid":{"type":"text"},"userAddress":{"type":"text"},"userType":{"type":"text"},"refund":{"type":"double"},"lastUpdateTime":{"type":"date"},"totalPrice":{"type":"double"},"lastUpdateUserid":{"type":"text"},"goodsAmount":{"type":"double"},"orderStatus":{"type":"integer"},"remark":{"type":"text"},"refundType":{"type":"text"},"evaluateStatus":{"type":"integer"},"createUsername":{"type":"text"},"deleteStatus":{"type":null},"storeName":{"type":"text"},"userEmail":{"type":"text"},"isGathering":{"type":"text"},"lastUpdateUsername":{"type":"text"},"ofId":{"type":"text"},"deliverTime":{"type":"date"},"returnContent":{"type":"text"},"isDxCenter":{"type":"text"},"returnShipTime":{"type":"date"},"transport":{"type":"text"},"storeId":{"type":"text"},"buyerName":{"type":"text"},"userName":{"type":"text"},"userId":{"type":"text"},"shipCode":{"type":"text"},"parentOfId":{"type":"text"},"createTime":{"type":"date"},"orderCode":{"type":"text"},"invoice":{"type":"text"},"deliverTimeDesc":{"type":"text"}}
   }
}

--------------------shopping_order_detail 索引添加语句------------------
PUT /shopping_order_detail
{
  "mappings":{
    
    "properties": {"orderType":{"type":"text"},"afterService":{"type":"text"},"totalPrice":{"type":"double"},"goodsId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"goodsAmount":{"type":"double"},"goodsBrandId":{"type":"text"},"orderStatus":{"type":"integer"},"remark":{"type":"text"},"goodsModel":{"type":"text"},"buyerId":{"type":"text"},"isDxCollege":{"type":"text"},"goodsBrandName":{"type":"text"},"createUsername":{"type":"text"},"paymentId":{"type":"text"},"deleteStatus":{"type":null},"outId":{"type":"text"},"storeName":{"type":"text"},"lastUpdateUsername":{"type":"text"},"goodsName":{"type":"text"},"ofId":{"type":"text"},"createUserid":{"type":"text"},"odId":{"type":"text"},"goodsDetails":{"type":"text"},"isDxCenter":{"type":"text"},"gcId":{"type":"text"},"storeId":{"type":"text"},"userName":{"type":"text"},"userId":{"type":"text"},"goodsSpec":{"type":"text"},"parentOfId":{"type":"text"},"goodsProperty":{"type":"text"},"createTime":{"type":"date"},"goodsPrice":{"type":"double"},"storePrice":{"type":"double"},"orderCode":{"type":"text"},"userType":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_goods_deliver 索引添加语句------------------
PUT /shopping_goods_deliver
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"mountType":{"type":"text"},"expressFee":{"type":"double"},"deliverId":{"type":"text"},"deliverType":{"type":"text"},"expressFeeType":{"type":"text"},"revision":{"type":"integer"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"containType":{"type":"text"},"zoneId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_goods_consult 索引添加语句------------------
PUT /shopping_goods_consult
{
  "mappings":{
    
    "properties": {"consultId":{"type":"text"},"orderMainId":{"type":"text"},"buyNum":{"type":"double"},"lastUpdateUserid":{"type":"text"},"fee":{"type":"double"},"companyName":{"type":"text"},"detailId":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"deviceName":{"type":"text"},"agreeUsername":{"type":"text"},"createUsername":{"type":"text"},"collegeId":{"type":"text"},"agreeUserid":{"type":"text"},"lastUpdateUsername":{"type":"text"},"connsultStatus":{"type":"text"},"createUserid":{"type":"text"},"odId":{"type":"text"},"isDxCenter":{"type":"text"},"bidPrice":{"type":"double"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"dealTime":{"type":"date"},"createTime":{"type":"date"},"orderCode":{"type":"text"},"deviceModel":{"type":"text"},"endTime":{"type":"date"},"consultRequire":{"type":"text"},"deviceBrand":{"type":"text"},"remarks":{"type":"text"},"consultPrice":{"type":"double"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_goods_area 索引添加语句------------------
PUT /shopping_goods_area
{
  "mappings":{
    
    "properties": {"pAreaid":{"type":"integer"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"deliverAreaId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDxCollege":{"type":"text"},"deliverId":{"type":"text"},"areaIdList":{"type":"text"},"areaId":{"type":"integer"},"createUsername":{"type":"text"},"areaName":{"type":"text"},"createTime":{"type":"date"},"zoneId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------shopping_store 索引添加语句------------------
PUT /shopping_store
{
  "mappings":{
    
    "properties": {"storeBgPhoto":{"type":"text"},"addTime":{"type":"date"},"companyName":{"type":"text"},"storeQqTwo":{"type":"text"},"weixinBeginTime":{"type":"date"},"weixinStatus":{"type":"integer"},"storeWw":{"type":"text"},"realstoreApprove":{"type":null},"id":{"type":"text"},"storeRecommend":{"type":null},"storeBannerId":{"type":"text"},"deliveryEndTime":{"type":"date"},"storeLat":{"type":"double"},"storeQqThree":{"type":"text"},"storeFile":{"type":"text"},"storeCredit":{"type":"integer"},"storeSeoDescription":{"type":"text"},"companyId":{"type":"text"},"storeAddress":{"type":"text"},"cardId":{"type":"long"},"storeSecondDomain":{"type":"text"},"weixinAppsecret":{"type":"text"},"cardApprove":{"type":null},"storeWeixinLogoId":{"type":"long"},"storeOwerCard":{"type":"text"},"storeMsn":{"type":"text"},"scId":{"type":"long"},"template":{"type":"text"},"storeOwer":{"type":"text"},"storeRecommendTime":{"type":"date"},"updateGradeId":{"type":"long"},"storeStatus":{"type":"integer"},"deleteStatus":{"type":null},"storeZip":{"type":"text"},"storeName":{"type":"text"},"storeTelephone":{"type":"text"},"openTime":{"type":"date"},"storeLng":{"type":"double"},"weixinWelecomeContent":{"type":"text"},"gradeId":{"type":"long"},"domainModifyCount":{"type":"integer"},"storeSeoKeywords":{"type":"text"},"protocolStatus":{"type":"text"},"storeQqOne":{"type":"text"},"mapType":{"type":"text"},"weixinAppid":{"type":"text"},"weixinToken":{"type":"text"},"inCity":{"type":"text"},"combinEndTime":{"type":"date"},"weixinStoreName":{"type":"text"},"inProvince":{"type":"text"},"storeLicenseId":{"type":"long"},"weixinEndTime":{"type":"date"},"violationReseaon":{"type":"text"},"areaId":{"type":"long"},"storeLogo":{"type":"text"},"showOrder":{"type":"integer"},"deliveryBeginTime":{"type":"date"},"storeInfo":{"type":"text"},"validity":{"type":"date"},"combinBeginTime":{"type":"date"},"weixinAccount":{"type":"text"},"favoriteCount":{"type":"integer"},"weixinQrImgId":{"type":"long"}}
   }
}

--------------------shopping_store_banner 索引添加语句------------------
PUT /shopping_store_banner
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"storeId":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"lastUpdateUsername":{"type":"text"},"storeBannerId":{"type":"text"},"ossPath":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_bid_order_goods 索引添加语句------------------
PUT /cp_bid_order_goods
{
  "mappings":{
    
    "properties": {"bidGoodsId":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"goodsId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"type":{"type":"text"},"isDxCollege":{"type":"text"},"bidId":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"delStatus":{"type":"text"},"mainId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"goodsName":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_signup 索引添加语句------------------
PUT /zb_signup
{
  "mappings":{
    
    "properties": {"isPush":{"type":"text"},"biddedTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"signupTime":{"type":"date"},"isDeposit":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"signupId":{"type":"text"},"signupStatus":{"type":"text"},"isSignin":{"type":"text"},"signupName":{"type":"text"},"zbProjectCode":{"type":"text"},"createUsername":{"type":"text"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"certificateCode":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"bidAmount":{"type":"double"},"zbProjectBatchId":{"type":"text"},"buyWay":{"type":"text"},"isBidded":{"type":"text"},"giveupTime":{"type":"date"},"revision":{"type":"integer"},"declassify":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createTime":{"type":"date"},"signinTime":{"type":"date"},"zbProjectGroupId":{"type":"text"},"zbProjectId":{"type":"text"},"signupMobile":{"type":"text"},"projectName":{"type":"text"},"tradeId":{"type":"text"},"certificateType":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_file 索引添加语句------------------
PUT /zb_file
{
  "mappings":{
    
    "properties": {"zbFileId":{"type":"text"},"fileName":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"otherId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"filePath":{"type":"text"},"remark":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"outOtherId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"zbProjectId":{"type":"text"},"zbProjectDetailId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"fileType":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_cash_deposit 索引添加语句------------------
PUT /zb_cash_deposit
{
  "mappings":{
    
    "properties": {"submitType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"zbCashDepositId":{"type":"text"},"cashDepositMoney":{"type":"double"},"delFlag":{"type":"text"},"depositAttachment":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"outCashDepositId":{"type":"text"},"expireDate":{"type":"date"},"lastUpdateUsername":{"type":"text"},"createUserid":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"depositCate":{"type":"text"},"depositUrl":{"type":"text"},"createTime":{"type":"date"},"zbProjectId":{"type":"text"},"projectName":{"type":"text"},"applyDate":{"type":"date"},"depositType":{"type":"text"},"status":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_director 索引添加语句------------------
PUT /zb_director
{
  "mappings":{
    
    "properties": {"amount":{"type":"integer"},"createUserid":{"type":"text"},"directorId":{"type":"text"},"directorCode":{"type":"text"},"lastUpdateUserid":{"type":"text"},"collegeName":{"type":"text"},"unit":{"type":"text"},"createUsername":{"type":"text"},"directorName":{"type":"text"},"createTime":{"type":"date"},"price":{"type":"double"},"collegeId":{"type":"text"},"zbProjectId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_questions 索引添加语句------------------
PUT /zb_questions
{
  "mappings":{
    
    "properties": {"fileName":{"type":"text"},"questionId":{"type":"text"},"answerTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"answerUserid":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"questionStatus":{"type":"text"},"zbProjectCode":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"answerUsername":{"type":"text"},"questionContent":{"type":"text"},"answerStatus":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"filePath":{"type":"text"},"zbProjectBatchId":{"type":"text"},"questionTime":{"type":"date"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createTime":{"type":"date"},"answersContent":{"type":"text"},"zbProjectId":{"type":"text"},"zbProjectDetailId":{"type":"text"},"projectName":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_negotiate 索引添加语句------------------
PUT /zb_negotiate
{
  "mappings":{
    
    "properties": {"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"secendOfferPrice":{"type":"double"},"isConfirm":{"type":"text"},"createUsername":{"type":"text"},"firstOfferPrice":{"type":"double"},"collegeId":{"type":"text"},"negotiateType":{"type":"text"},"lastUpdateUsername":{"type":"text"},"createUserid":{"type":"text"},"zbNegotiateId":{"type":"text"},"isDxCenter":{"type":"text"},"negotiateTime":{"type":"integer"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"outProcjectId":{"type":"text"},"companyId":{"type":"text"},"createTime":{"type":"date"},"thirdlyOfferPrice":{"type":"double"},"zbProjectId":{"type":"text"},"projectName":{"type":"text"},"purchaseWayCode":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_wincompany 索引添加语句------------------
PUT /zb_wincompany
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"isInvalid":{"type":"text"},"isDxCollege":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"zbWinCompanyId":{"type":"text"},"createTime":{"type":"date"},"zbProjectId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_order_main 索引添加语句------------------
PUT /zc_order_main
{
  "mappings":{
    
    "properties": {"companyName":{"type":"text"},"departmentId":{"type":"text"},"projectType":{"type":"text"},"startBidtime":{"type":"date"},"readCount":{"type":"integer"},"deliverPlace":{"type":"text"},"isDxCollege":{"type":"text"},"isPublishBidresult":{"type":"text"},"tendereePersonPhone":{"type":"text"},"bidAmountRenminbi":{"type":"double"},"payType":{"type":"text"},"isAgent":{"type":"text"},"exchangeRate":{"type":"double"},"bidFinished":{"type":"text"},"zcRatioId":{"type":"text"},"currentProceeTime":{"type":"date"},"invoiceType":{"type":"text"},"budget":{"type":"double"},"deviceType":{"type":"text"},"compusId":{"type":"text"},"createUserid":{"type":"text"},"tendereeLinkman":{"type":"text"},"bidAmount":{"type":"double"},"tendereePhone":{"type":"text"},"foundsSubject":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"tendereeAgentId":{"type":"text"},"currentProcee":{"type":"text"},"sourceType":{"type":"text"},"allFlag":{"type":"text"},"tenderee":{"type":"text"},"bidCount":{"type":"integer"},"fundingSource":{"type":"text"},"zcProjectCode":{"type":"text"},"lastUpdateTime":{"type":"date"},"isDeliver":{"type":"text"},"lastUpdateUserid":{"type":"text"},"qualifiedStatus":{"type":"text"},"installations":{"type":"text"},"winningPrinciple":{"type":"text"},"remark":{"type":"text"},"budgetIsOpen":{"type":"text"},"initBidId":{"type":"text"},"tendereeAgent":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"currentProceeName":{"type":"text"},"orderUnit":{"type":"text"},"lastUpdateUsername":{"type":"text"},"projectTitle":{"type":"text"},"foundsCode":{"type":"text"},"deliverTime":{"type":"text"},"isDxCenter":{"type":"text"},"isInvoice":{"type":"text"},"noticeTypePublish":{"type":"text"},"isDelete":{"type":"text"},"publishBidresultTime":{"type":"date"},"isUnpack":{"type":"text"},"zcProjectId":{"type":"text"},"tendereeFaxno":{"type":"text"},"qualifiedTime":{"type":"date"},"bidId":{"type":"text"},"zcRatioName":{"type":"text"},"projectStatus":{"type":"text"},"createTime":{"type":"date"},"evaluatingBidType":{"type":"text"},"endBidtime":{"type":"date"},"usingCorrency":{"type":"text"},"institueId":{"type":"text"}}
   }
}

--------------------zc_order_detail 索引添加语句------------------
PUT /zc_order_detail
{
  "mappings":{
    
    "properties": {"initBidDetailId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"orderNum":{"type":"double"},"isDxCollege":{"type":"text"},"deviceName":{"type":"text"},"bidAmountRenminbi":{"type":"double"},"warrantyPeriod":{"type":"integer"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"detailBudget":{"type":"double"},"isDelete":{"type":"text"},"bidAmount":{"type":"double"},"zcProjectId":{"type":"text"},"bidPrice":{"type":"double"},"bidDetailId":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"unit":{"type":"text"},"createTime":{"type":"date"},"showOrder":{"type":"integer"},"zcProjectCode":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_order_param 索引添加语句------------------
PUT /zc_order_param
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"orderParamType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"orderParamContent":{"type":"text"},"orderParamCode":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"isNeedFile":{"type":"text"},"isImportant":{"type":"text"},"collegeId":{"type":"text"},"showOrder":{"type":"integer"},"orderParamId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_order_param_other 索引添加语句------------------
PUT /zc_order_param_other
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"orderParamType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"orderParamContent":{"type":"text"},"orderParamCode":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"isNeedFile":{"type":"text"},"isImportant":{"type":"text"},"collegeId":{"type":"text"},"showOrder":{"type":"integer"},"orderParamId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_order_attachment 索引添加语句------------------
PUT /zc_order_attachment
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"attachmentType":{"type":"text"},"projectDetailId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"remark":{"type":"text"},"zcProjectId":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"orderAttachmentId":{"type":"text"},"collegeId":{"type":"text"},"attachmentName":{"type":"text"},"lastUpdateUsername":{"type":"text"},"ossPath":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_bid_main 索引添加语句------------------
PUT /zc_bid_main
{
  "mappings":{
    
    "properties": {"initUsername":{"type":"text"},"isRecommend":{"type":"text"},"esignFlowId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"recommendReason":{"type":"text"},"isQualified":{"type":"text"},"remark":{"type":"text"},"signupTime":{"type":"date"},"shipName":{"type":"text"},"isDxCollege":{"type":"text"},"deliverType":{"type":"text"},"bidTime":{"type":"date"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"initBidPerson":{"type":"text"},"lastUpdateUsername":{"type":"text"},"qualifiedReason":{"type":"text"},"bidStatus":{"type":"text"},"deliverUsername":{"type":"text"},"deliverTime":{"type":"date"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"giveupUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"totalAmountRenminbi":{"type":"double"},"bidUserId":{"type":"text"},"giveupTime":{"type":"date"},"shipCode":{"type":"text"},"sendTime":{"type":"text"},"revision":{"type":"integer"},"totalAmount":{"type":"double"},"isDelivered":{"type":"text"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"deliverRemark":{"type":"text"},"initUserId":{"type":"text"},"createTime":{"type":"date"},"bidPerson":{"type":"text"},"giveupUsername":{"type":"text"},"bidMainId":{"type":"text"},"deliverUserid":{"type":"text"},"zcProjectCode":{"type":"text"},"initTime":{"type":"date"},"installWay":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_bid_detail 索引添加语句------------------
PUT /zc_bid_detail
{
  "mappings":{
    
    "properties": {"bidReason":{"type":"text"},"avgPrice":{"type":"double"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"productSources":{"type":"text"},"isDxCollege":{"type":"text"},"deviceName":{"type":"text"},"deviceNum":{"type":"double"},"warrantyPeriod":{"type":"integer"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"diffrencesDesc":{"type":"text"},"lastUpdateUsername":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"dangliang":{"type":"double"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"totalAmountRenminbi":{"type":"double"},"bidPrice":{"type":"double"},"bidDetailId":{"type":"text"},"isWin":{"type":"text"},"revision":{"type":"integer"},"totalAmount":{"type":"double"},"collegeName":{"type":"text"},"unit":{"type":"text"},"companyId":{"type":"text"},"createTime":{"type":"date"},"deviceModel":{"type":"text"},"bidMainId":{"type":"text"},"zcProjectCode":{"type":"text"},"deviceBrand":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_bid_param 索引添加语句------------------
PUT /zc_bid_param
{
  "mappings":{
    
    "properties": {"deviateValue":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"bidParamContent":{"type":"text"},"isDxCollege":{"type":"text"},"bidDetailId":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"bidParamId":{"type":"text"},"showOrder":{"type":"integer"},"orderParamId":{"type":"text"},"bidMainId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"bidParamCode":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_bid_param_other 索引添加语句------------------
PUT /zc_bid_param_other
{
  "mappings":{
    
    "properties": {"deviateValue":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"projectDetailId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"bidParamContent":{"type":"text"},"isDxCollege":{"type":"text"},"bidDetailId":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"bidParamId":{"type":"text"},"showOrder":{"type":"integer"},"orderParamId":{"type":"text"},"bidMainId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"bidParamCode":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_bid_attachment 索引添加语句------------------
PUT /zc_bid_attachment
{
  "mappings":{
    
    "properties": {"isDownload":{"type":"text"},"esignFlowId":{"type":"text"},"attachmentType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"isDxCollege":{"type":"text"},"bidAttachmentId":{"type":"text"},"isSecret":{"type":"text"},"createUsername":{"type":"text"},"collegeId":{"type":"text"},"bidParamId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"ossPath":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"isDelete":{"type":"text"},"secretOssPath":{"type":"text"},"zcProjectId":{"type":"text"},"bidDetailId":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"createTime":{"type":"date"},"attachmentName":{"type":"text"},"bidMainId":{"type":"text"},"stampOssPath":{"type":"text"},"lastUpdateTime":{"type":"date"},"fileId":{"type":"text"}}
   }
}

--------------------zc_charge 索引添加语句------------------
PUT /zc_charge
{
  "mappings":{
    
    "properties": {"comfirmUserid":{"type":"text"},"payTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"comfirmUsername":{"type":"text"},"signupTime":{"type":"date"},"chargeStatus":{"type":"text"},"isDxCollege":{"type":"text"},"comfirmPayTime":{"type":"date"},"bidTime":{"type":"date"},"outObjectId":{"type":"text"},"payType":{"type":"text"},"createUsername":{"type":"text"},"chargeAmount":{"type":"double"},"lastUpdateUsername":{"type":"text"},"objectId":{"type":"text"},"ossPath":{"type":"text"},"bidStatus":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"revision":{"type":"integer"},"companyId":{"type":"text"},"createTime":{"type":"date"},"chargeId":{"type":"text"},"zcProjectCode":{"type":"text"},"balanceId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_notice 索引添加语句------------------
PUT /zc_notice
{
  "mappings":{
    
    "properties": {"lastUpdateUserid":{"type":"text"},"projectType":{"type":"text"},"isDxCollege":{"type":"text"},"noticeTitle":{"type":"text"},"noticeContent":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"noticeStatus":{"type":"text"},"startTime":{"type":"date"},"lastUpdateUsername":{"type":"text"},"projectTitle":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"isDelete":{"type":"text"},"noticeType":{"type":"text"},"zcProjectId":{"type":"text"},"isFinish":{"type":"text"},"noticeId":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"createTime":{"type":"date"},"endTime":{"type":"date"},"zcProjectCode":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zc_questions 索引添加语句------------------
PUT /zc_questions
{
  "mappings":{
    
    "properties": {"questionId":{"type":"text"},"answerTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"remark":{"type":"text"},"answerUserid":{"type":"text"},"isDxCollege":{"type":"text"},"questionStatus":{"type":"text"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"answerUsername":{"type":"text"},"projectTitle":{"type":"text"},"questionContent":{"type":"text"},"answerFileName":{"type":"text"},"answerStatus":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"questionTitle":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"questionTime":{"type":"date"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"answerFile":{"type":"text"},"questionFile":{"type":"text"},"createTime":{"type":"date"},"answersContent":{"type":"text"},"zcProjectCode":{"type":"text"},"questionFileName":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zcgc_bid_main 索引添加语句------------------
PUT /zcgc_bid_main
{
  "mappings":{
    
    "properties": {"registeredCapitalLevel":{"type":"text"},"isRecommend":{"type":"text"},"initUsername":{"type":"text"},"esignFlowId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"recommendReason":{"type":"text"},"isQualified":{"type":"text"},"remark":{"type":"text"},"signupTime":{"type":"date"},"isDxCollege":{"type":"text"},"prizeWinning":{"type":"text"},"fixedAssetsLevel":{"type":"text"},"bidTime":{"type":"date"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"registeredCapital":{"type":"double"},"collegeId":{"type":"text"},"fixedAssets":{"type":"double"},"initBidPerson":{"type":"text"},"lastUpdateUsername":{"type":"text"},"bidStatus":{"type":"text"},"qualifiedReason":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"secretKey":{"type":"text"},"qualificationLevel":{"type":"text"},"giveupUserid":{"type":"text"},"isDelete":{"type":"text"},"zcProjectId":{"type":"text"},"peopleNum":{"type":"integer"},"bidUserId":{"type":"text"},"giveupTime":{"type":"date"},"revision":{"type":"integer"},"peopleNumLevel":{"type":"text"},"totalAmount":{"type":"double"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"initUserId":{"type":"text"},"createTime":{"type":"date"},"bidPerson":{"type":"text"},"giveupUsername":{"type":"text"},"bidMainId":{"type":"text"},"zcProjectCode":{"type":"text"},"initTime":{"type":"date"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------pay_protocol 索引添加语句------------------
PUT /pay_protocol
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"prtclId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"agreeTime":{"type":"date"},"remark":{"type":"text"},"protocolType":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"agreeStatus":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"affirmStatus":{"type":"text"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"affirmTime":{"type":"date"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------pay_protocol_company 索引添加语句------------------
PUT /pay_protocol_company
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"companyPrtclId":{"type":"text"},"prtclId":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"agreeTime":{"type":"date"},"remark":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"companyId":{"type":"text"},"agreeStatus":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------cp_bid_contact 索引添加语句------------------
PUT /cp_bid_contact
{
  "mappings":{
    
    "properties": {"orderType":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"secretKey":{"type":"text"},"contactId":{"type":"text"},"contactName":{"type":"text"},"lastUpdateUserid":{"type":"text"},"companyName":{"type":"text"},"isDxCollege":{"type":"text"},"mainCode":{"type":"text"},"companyId":{"type":"text"},"isSecret":{"type":"text"},"isSendsms":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"collegeId":{"type":"text"},"mainId":{"type":"text"},"contactPhone":{"type":"text"},"lastUpdateUsername":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_project 索引添加语句------------------
PUT /zb_project
{
  "mappings":{
    
    "properties": {"projectStatusTime":{"type":"date"},"departmentId":{"type":"text"},"companyName":{"type":"text"},"projectType":{"type":"text"},"isDxCollege":{"type":"text"},"tendereePersonPhone":{"type":"text"},"payType":{"type":"text"},"deviceType":{"type":"text"},"signupUrl":{"type":"text"},"tendereeLinkman":{"type":"text"},"tendereeMail":{"type":"text"},"purchaseMoney":{"type":"double"},"bidAmount":{"type":"double"},"tendereePhone":{"type":"text"},"executorName":{"type":"text"},"sourceType":{"type":"text"},"allFlag":{"type":"text"},"tenderee":{"type":"text"},"projectLeaderName":{"type":"text"},"publishResultTime":{"type":"date"},"isDeliver":{"type":"text"},"qualifiedStatus":{"type":"text"},"installations":{"type":"text"},"winningPrinciple":{"type":"text"},"designOrg":{"type":"text"},"delFlag":{"type":"text"},"supervisingOrg":{"type":"text"},"projectLeaderMail":{"type":"text"},"tendereeAgent":{"type":"text"},"projectCode":{"type":"text"},"processId":{"type":"text"},"requireCompleteDate":{"type":"date"},"collegeId":{"type":"text"},"orderUnit":{"type":"text"},"bidTimes":{"type":"integer"},"foundsCode":{"type":"text"},"joinBidding":{"type":"text"},"executorId":{"type":"text"},"noticeTypePublish":{"type":"text"},"tendereeFaxno":{"type":"text"},"qualifiedTime":{"type":"date"},"zcRatioName":{"type":"text"},"createTime":{"type":"date"},"usingCorrency":{"type":"text"},"applyDate":{"type":"date"},"purchaseWayCode":{"type":"text"},"evaluateWayCode":{"type":"text"},"executorPhone":{"type":"text"},"sampleMethod":{"type":"text"},"controlPrice":{"type":"double"},"deliverPlace":{"type":"text"},"minCompanyNum":{"type":"integer"},"operator":{"type":"text"},"isPublishBidresult":{"type":"text"},"bidAmountRenminbi":{"type":"double"},"zbProjectCode":{"type":"text"},"isAgent":{"type":"text"},"projectLeaderId":{"type":"text"},"bidFinished":{"type":"text"},"zcRatioId":{"type":"text"},"invoiceType":{"type":"text"},"supplierIds":{"type":"text"},"departmentName":{"type":"text"},"createUserid":{"type":"text"},"flowNode":{"type":"text"},"buildingAddr":{"type":"text"},"foundsSubject":{"type":"text"},"waitingEvaluate":{"type":"text"},"revision":{"type":"integer"},"collegeName":{"type":"text"},"outProcjectId":{"type":"text"},"tendereeAgentId":{"type":"text"},"companyId":{"type":"text"},"scoreMode":{"type":"text"},"costWarningLine":{"type":"double"},"projectName":{"type":"text"},"fundingSource":{"type":"text"},"classifyCode":{"type":"text"},"nodeId":{"type":"text"},"lastUpdateTime":{"type":"date"},"lastUpdateUserid":{"type":"text"},"remark":{"type":"text"},"executorEmail":{"type":"text"},"budgetIsOpen":{"type":"text"},"qualificationsWay":{"type":"text"},"initBidId":{"type":"text"},"duration":{"type":"integer"},"createUsername":{"type":"text"},"maxCompanyNum":{"type":"integer"},"lastUpdateUsername":{"type":"text"},"flowId":{"type":"text"},"buildingDepartment":{"type":"text"},"deliverTime":{"type":"text"},"isDxCenter":{"type":"text"},"pricedWay":{"type":"text"},"isUnpack":{"type":"text"},"confirmLeader":{"type":"text"},"projectStatus":{"type":"text"},"projectLeaderPhone":{"type":"text"},"zbProjectId":{"type":"text"},"outsideUrl":{"type":"text"}}
   }
}

--------------------zb_project_notice 索引添加语句------------------
PUT /zb_project_notice
{
  "mappings":{
    
    "properties": {"lastUpdateUserid":{"type":"text"},"projectType":{"type":"text"},"publicDate":{"type":"date"},"title":{"type":"text"},"delFlag":{"type":"text"},"isDxCollege":{"type":"text"},"content":{"type":"text"},"zbProjectCode":{"type":"text"},"publicDateEnd":{"type":"date"},"createUsername":{"type":"text"},"projectCode":{"type":"text"},"announceUrl":{"type":"text"},"collegeId":{"type":"text"},"noticeStatus":{"type":"text"},"lastUpdateUsername":{"type":"text"},"openDatetime":{"type":"date"},"projectTitle":{"type":"text"},"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"questionDateEnd":{"type":"date"},"outProjectDetailId":{"type":"text"},"zbProjectBatchId":{"type":"text"},"typeCode":{"type":"text"},"collegeName":{"type":"text"},"questionDateStart":{"type":"date"},"applyDateEnd":{"type":"date"},"createTime":{"type":"date"},"publicDateStart":{"type":"date"},"zbProjectGroupId":{"type":"text"},"zbProjectId":{"type":"text"},"zbProjectNoticeId":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}

--------------------zb_project_attachment 索引添加语句------------------
PUT /zb_project_attachment
{
  "mappings":{
    
    "properties": {"createUserid":{"type":"text"},"isDxCenter":{"type":"text"},"attachmentType":{"type":"text"},"lastUpdateUserid":{"type":"text"},"isDelete":{"type":"text"},"remark":{"type":"text"},"isDxCollege":{"type":"text"},"revision":{"type":"integer"},"itemId":{"type":"text"},"collegeName":{"type":"text"},"createUsername":{"type":"text"},"createTime":{"type":"date"},"orderAttachmentId":{"type":"text"},"collegeId":{"type":"text"},"zbProjectId":{"type":"text"},"attachmentName":{"type":"text"},"lastUpdateUsername":{"type":"text"},"ossPath":{"type":"text"},"lastUpdateTime":{"type":"date"}}
   }
}


Process finished with exit code 0

三、使用datax导入数据

1、把刚才生成的datax的json配置复制到远程服务器

文件路径为： /data0/datax/datax/job/

2、运行导入命令 这里以co_order_detail为例

cd /data0/datax/datax/job
 python ../bin/datax.py  co_order_detail.json 

以下为运行结果

所有的运行语句在这里也整理一份

  python ../bin/datax.py  co_order_main.json
  python ../bin/datax.py  co_order_detail.json
  python ../bin/datax.py  cp_bid_order.json
  python ../bin/datax.py  co_bid_attachment.json
  python ../bin/datax.py  co_college_info.json
  python ../bin/datax.py  cp_company_info.json
  python ../bin/datax.py  cp_ignore_enshrine.json
  python ../bin/datax.py  sc_seller_assess.json
  python ../bin/datax.py  co_black_info.json
  python ../bin/datax.py  shopping_goods.json
  python ../bin/datax.py  cp_company_level.json
  python ../bin/datax.py  shopping_photo.json
  python ../bin/datax.py  co_bid_announcement.json
  python ../bin/datax.py  me_announcement.json
  python ../bin/datax.py  me_plat_news.json
  python ../bin/datax.py  co_file.json
  python ../bin/datax.py  pt_file.json
  python ../bin/datax.py  cp_black_info.json
  python ../bin/datax.py  cp_black_notice.json
  python ../bin/datax.py  cp_no_biding_list.json
  python ../bin/datax.py  cp_white_list.json
  python ../bin/datax.py  co_commerce_clause.json
  python ../bin/datax.py  pt_special_column.json
  python ../bin/datax.py  co_recommend.json
  python ../bin/datax.py  shopping_recommend.json
  python ../bin/datax.py  sg_feedback.json
  python ../bin/datax.py  foreign_goods.json
  python ../bin/datax.py  cp_deliver.json
  python ../bin/datax.py  shopping_order_form.json
  python ../bin/datax.py  shopping_order_detail.json
  python ../bin/datax.py  shopping_goods_deliver.json
  python ../bin/datax.py  shopping_goods_consult.json
  python ../bin/datax.py  shopping_goods_area.json
  python ../bin/datax.py  shopping_store.json
  python ../bin/datax.py  shopping_store_banner.json
  python ../bin/datax.py  cp_bid_order_goods.json
  python ../bin/datax.py  zb_signup.json
  python ../bin/datax.py  zb_file.json
  python ../bin/datax.py  zb_cash_deposit.json
  python ../bin/datax.py  zb_director.json
  python ../bin/datax.py  zb_questions.json
  python ../bin/datax.py  zb_negotiate.json
  python ../bin/datax.py  zb_wincompany.json
  python ../bin/datax.py  zc_order_main.json
  python ../bin/datax.py  zc_order_detail.json
  python ../bin/datax.py  zc_order_param.json
  python ../bin/datax.py  zc_order_param_other.json
  python ../bin/datax.py  zc_order_attachment.json
  python ../bin/datax.py  zc_bid_main.json
  python ../bin/datax.py  zc_bid_detail.json
  python ../bin/datax.py  zc_bid_param.json
  python ../bin/datax.py  zc_bid_param_other.json
  python ../bin/datax.py  zc_bid_attachment.json
  python ../bin/datax.py  zc_charge.json
  python ../bin/datax.py  zc_notice.json
  python ../bin/datax.py  zc_questions.json
  python ../bin/datax.py  zcgc_bid_main.json
  python ../bin/datax.py  pay_protocol.json
  python ../bin/datax.py  pay_protocol_company.json
  python ../bin/datax.py  cp_bid_contact.json
  python ../bin/datax.py  zb_project.json
  python ../bin/datax.py  zb_project_notice.json
  python ../bin/datax.py  zb_project_attachment.json

四、创建索引模式

1、进入kibana索引管理创建索引

2、查看所有索引情况