数据表 → 接口 184 张表

反查用:改表结构、加字段、排查数据从哪来之前,先在这里看这张表被哪些接口读写。表与接口的对应关系由源码遍历实体 @TableName 得出。

开放与对接 43 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
member80C 端聚合接口、会员、平台与系统oauth2Login oauth2MeiKe oauth2session sendCard addCardBind addCardOrder …共 80 个
card_model54C 端聚合接口、商户·店铺·基础数据、开放与对接sendCard addOpenApiCardOrder cardBag exportCard queryCardPage send …共 54 个
card_bind53C 端聚合接口、会员、平台与系统oauth2 addCardBind cancelCardBind cardBag disable queryMemberCardList …共 53 个
openapi_channel_info44C 端聚合接口、平台与系统、开放与对接sendCard addOpenApiCardOrder cardBag cardInfo cardModelDetail disable …共 44 个
order_goods43商品与履约、开放与对接、旅游卡queryAfterSalesList getCardOrder queryCardOrderPage queryOrderCardList test createPay …共 43 个
sku41C 端聚合接口、商品与履约、商户·店铺·基础数据checkerLogin getQrByAppointmentId listCardType appointDetail cardResource queryCarriagePage …共 41 个
order_operatelog40开放与对接、旅游卡、订单·支付·售后sendCard addCardOrder addOpenApiCardOrder send cancelOrder createOrder …共 40 个
card_appointment36C 端聚合接口、开放与对接、旅游卡addCardAppointment cancelCardAppointment cardAppointmentPage deleteCardAppointment getCardAppointment queryCardAppointmentList …共 36 个
openapi_channel_rule33C 端聚合接口、开放与对接、旅游卡sendCard addCardOrder addOpenApiCardOrder query send listCardType …共 33 个
order_payment32开放与对接、旅游卡、订单·支付·售后zfbRefund sendCard getCardOrder send getOrder reapalPayNotify …共 32 个
goods_info30商品与履约、开放与对接、旅游卡getCardAppointmentResource cardResource resourceDetail cardModelDetail listProduct getOrder …共 30 个
openapi_channel_card26C 端聚合接口、开放与对接、旅游卡disable query queryOrderCardList updateCardState getOrder getOrderDetail …共 26 个
openapi_channel_order26开放与对接、订单·支付·售后zfbRefund sendCard query send activateCibCard sendCibCard …共 26 个
goods24C 端聚合接口、商品与履约、商户·店铺·基础数据cardResource createOrder goodsDetail goodsList addGoods deleteGoods …共 24 个
openapi_channel_business22开放与对接sendCard send activateCibCard cibActiveBind cibStat exportCibStatDetail …共 22 个
openapi_cqy_record20开放与对接、门票与景区addOpenapiCqyRecord bindGoods cqyCheck createOrder deleteOpenapiCqyRecord getOpenapiCqyRecord …共 20 个
openapi_platform_info19开放与对接addOpenapiPlatformInfo deleteOpenapiPlatformInfo getOpenapiPlatformInfo queryOpenapiPlatformInfoList queryOpenapiPlatformInfoPage updateOpenapiPlatformInfo …共 19 个
openapi_nydm_order18C 端聚合接口、开放与对接、旅游卡cancelCardAppointment cancelAppoint manageAppoint cancelTicket consumeNotify manualCheckStatus …共 18 个
openapi_channel_operator18开放与对接sendCard send activateCibCard cibOperatorList cibStat getOperatorActivationStatus …共 18 个
openapi_xjhlc_order13C 端聚合接口、开放与对接、旅游卡cancelCardAppointment cancelAppoint getQrByAppointmentId appointDetail addOpenapiXjhlcOrder deleteOpenapiXjhlcOrder …共 13 个
openapi_ybx_order13C 端聚合接口、开放与对接、旅游卡cancelCardAppointment cancelAppoint getQrByAppointmentId addOpenapiYbxOrder deleteOpenapiYbxOrder getOpenapiYbxOrder …共 13 个
openapi_ybx_ticket13C 端聚合接口、开放与对接、旅游卡cancelCardAppointment cancelAppoint getQrByAppointmentId addOpenapiYbxTicket deleteOpenapiYbxTicket getOpenapiYbxTicket …共 13 个
openapi_icbc_log13开放与对接queryRefund refundApply unfreezeAccept wechatPay acceptNotify refundNotify …共 13 个
openapi_pft_record12C 端聚合接口、开放与对接、旅游卡cancelCardAppointment cancelAppoint getQrByAppointmentId appointDetail addOpenapiPftRecord deleteOpenapiPftRecord …共 12 个
openapi_log12开放与对接cancel confirm consume create reConsume refund …共 12 个
openapi_tgy_order11开放与对接addOpenapiTgyOrder deleteOpenapiTgyOrder getOpenapiTgyOrder queryOpenapiTgyOrderList queryOpenapiTgyOrderPage updateOpenapiTgyOrder …共 11 个
openapi_tstc_order10开放与对接addOpenapiTstcOrder deleteOpenapiTstcOrder getOpenapiTstcOrder queryOpenapiTstcOrderList queryOpenapiTstcOrderPage updateOpenapiTstcOrder …共 10 个
openapi_bjc_appoint_scenic9开放与对接appointInfo consume reConsume addOpenapiBjcAppointScenic deleteOpenapiBjcAppointScenic getOpenapiBjcAppointScenic …共 9 个
openapi_xgh_purchage8开放与对接addOpenapiXghPurchage deleteOpenapiXghPurchage exportOpenapiXghPurchageList getOpenapiXghPurchage queryOpenapiXghPurchageList queryOpenapiXghPurchagePage …共 8 个
sku_entrance7商品与履约、平台与系统、开放与对接checkerLogin singleRecordCardCheckSzh queryResourceSkuEntrance goodsDetail goodsList getGoods …共 7 个
openapi_ssk_user7开放与对接addOpenapiSskUser deleteOpenapiSskUser getOpenapiSskUser queryOpenapiSskUserList queryOpenapiSskUserPage updateOpenapiSskUser …共 7 个
openapi_ssk_card7开放与对接addOpenapiSskCard deleteOpenapiSskCard getOpenapiSskCard queryOpenapiSskCardList queryOpenapiSskCardPage updateOpenapiSskCard …共 7 个
openapi_bjc_appoint_config7开放与对接appointInfo addOpenapiBjcAppointConfig deleteOpenapiBjcAppointConfig getOpenapiBjcAppointConfig queryOpenapiBjcAppointConfigList queryOpenapiBjcAppointConfigPage …共 7 个
hh_card_log7开放与对接thirdNotify addHhCardLog deleteHhCardLog getHhCardLog queryHhCardLogList queryHhCardLogPage …共 7 个
openapi_pingan_record7开放与对接addOpenapiPinganRecord deleteOpenapiPinganRecord getOpenapiPinganRecord queryOpenapiPinganRecordList queryOpenapiPinganRecordPage updateOpenapiPinganRecord …共 7 个
openapi_bjc_card_info6开放与对接addOpenapiBjcCardInfo deleteOpenapiBjcCardInfo getOpenapiBjcCardInfo queryOpenapiBjcCardInfoList queryOpenapiBjcCardInfoPage updateOpenapiBjcCardInfo
openapi_bjc_log6开放与对接addOpenapiBjcLog deleteOpenapiBjcLog getOpenapiBjcLog queryOpenapiBjcLogList queryOpenapiBjcLogPage updateOpenapiBjcLog
openapi_bjc_consume_record6开放与对接addOpenapiBjcConsumeRecord deleteOpenapiBjcConsumeRecord getOpenapiBjcConsumeRecord queryOpenapiBjcConsumeRecordList queryOpenapiBjcConsumeRecordPage updateOpenapiBjcConsumeRecord
openapi_bjc_appoint_record6开放与对接addOpenapiBjcAppointRecord deleteOpenapiBjcAppointRecord getOpenapiBjcAppointRecord queryOpenapiBjcAppointRecordList queryOpenapiBjcAppointRecordPage updateOpenapiBjcAppointRecord
openapi_card_config6开放与对接addOpenapiCardConfig deleteOpenapiCardConfig getOpenapiCardConfig queryOpenapiCardConfigList queryOpenapiCardConfigPage updateOpenapiCardConfig
openapi_xc_log6开放与对接addOpenapiXcLog deleteOpenapiXcLog getOpenapiXcLog queryOpenapiXcLogList queryOpenapiXcLogPage updateOpenapiXcLog
openapi_bjc_token6开放与对接addOpenapiBjcToken deleteOpenapiBjcToken getOpenapiBjcToken queryOpenapiBjcTokenList queryOpenapiBjcTokenPage updateOpenapiBjcToken
openapi_ticket_code_pool3开放与对接import page stats

旅游卡 17 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
card_resource_rule69C 端聚合接口、商品与履约、开放与对接addCardAppointment cancelCardAppointment verifyFace appointmentPrepay cancelAppoint consumeRecordAsync …共 69 个
card64C 端聚合接口、会员、开放与对接sendCard addCard addCardBind addCardOrder addOpenApiCardOrder cancelCardActived …共 64 个
card_check23C 端聚合接口、开放与对接、旅游卡verifyFace addCardCheck cardCheckFootPrintList cardCheckPage deleteCardCheck getCardCheck …共 23 个
card_stock17C 端聚合接口、开放与对接、旅游卡test faceFlag downloadCardBatch importCardStockChip addCardBind faceFlag …共 17 个
card_model_rule16开放与对接、旅游卡addCardBind test updateCardActived updateCardActivedZeng addCardBind queryCardModelPage …共 16 个
card_appointment_payment14C 端聚合接口、开放与对接、旅游卡addCardAppointmentPayment deleteCardAppointmentPayment getCardAppointmentPayment queryCardAppointmentPaymentList queryCardAppointmentPaymentPage updateCardAppointmentPayment …共 14 个
card_package_rule_resource_packet12C 端聚合接口、开放与对接、旅游卡addCardAppointment manageAppoint singleRecordCardCheckSzh queryCardPackageRule appointmentNotify addCardPackageRuleResourcePacket …共 12 个
card_resource_calender11开放与对接、旅游卡copyCardModelResource addCardResourceCalender deleteCardResourceCalender getCardResourceCalender queryAppointmentResourceCalenderList queryCardResourceCalenderList …共 11 个
card_model_notice10C 端聚合接口、开放与对接、旅游卡addCardModelNotice cardBag deleteCardModelNotice getCardModelNotice queryCardModelNoticeList queryCardModelNoticePage …共 10 个
card_package_rule8C 端聚合接口、开放与对接、旅游卡addCardAppointment manageAppoint singleRecordCardCheckSzh addCardPackageRule deleteCardPackageRule queryCardPackageRule …共 8 个
card_resource_calender_time_slot8旅游卡addCardResourceCalenderTimeSlot deleteCardResourceCalenderTimeSlot getCardResourceCalenderTimeSlot queryCardResourceCalenderTimeSlotList queryCardResourceCalenderTimeSlotPage updateCardResourceCalenderTimeSlot …共 8 个
card_batch8旅游卡addCardBatch deleteCardBatch downloadCardBatch downloadCardStockChip getCardBatch importCardStockChip …共 8 个
card_num_appoint_rule8C 端聚合接口、旅游卡addCardNumAppointRule deleteCardNumAppointRule getCardNumAppointRule queryCardNumAppointRuleList queryCardNumAppointRulePage updateCardNumAppointRule …共 8 个
card_package_rule_resource7C 端聚合接口、开放与对接、旅游卡addCardAppointment manageAppoint singleRecordCardCheckSzh deleteCardPackageRule queryCardPackageRule appointmentNotify …共 7 个
card_number_rule7旅游卡addCardNumberRule deleteCardNumberRule getByModelRuleId getCardNumberRule queryCardNumberRuleList queryCardNumberRulePage …共 7 个
member_face6C 端聚合接口、旅游卡cancelCardBind verifyFace resetCardFace updateCardBindBy queryCardCheckPage checkFaceBind
card_assignment6旅游卡addCardAssignment deleteCardAssignment downloadCardAssignment getCardAssignment queryCardAssignmentList updateCardAssignment

酒店 22 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
hotel_order22开放与对接、酒店addHotelOrder cancelHotelOrder checkInHotelOrder checkOutHotelOrder confirmHotelOrder deleteHotelOrder …共 22 个
hotel_room_type_plan22酒店addHotelRoomPriceCalendar addHotelRoomTypePlan batchUpdateRoomPriceCalendar batchUpdateRoomPriceCalendarStatus deleteHotelRoomTypePlan getHotelOrderDetail …共 22 个
hotel_info21营销与触达、酒店addHotelAutoOrderRule addHotelInfo addHotelRoomPriceCalendar addHotelRoomType batchUpdateRoomPriceCalendar deleteHotelInfo …共 21 个
hotel_room_type20酒店addHotelRoomType deleteHotelRoomType getHotelOrderDetail getHotelRoomType getHotelRoomTypeMaxSort getHotelRoomTypeTree …共 20 个
hotel_room_price_calendar16酒店addHotelRoomPriceCalendar batchUpdateRoomPriceCalendar batchUpdateRoomPriceCalendarStatus deleteHotelRoomPriceCalendar getHotelRoomPriceCalendar queryHotelRoomPriceCalendarByDate …共 16 个
hotel_room_attr_rel13酒店addHotelRoomAttrRel deleteHotelRoomAttrRel getHotelRoomAttrRel getHotelRoomTypeTree queryHotelRoomAttrRelList queryHotelRoomAttrRelPage …共 13 个
hotel_room_attr13酒店addHotelRoomAttr deleteHotelRoomAttr getHotelRoomAttr getHotelRoomTypeTree queryHotelRoomAttrList queryHotelRoomAttrPage …共 13 个
hotel_order_room11酒店addHotelOrderRoom cancelHotelOrder deleteHotelOrderRoom getHotelOrderDetail getHotelOrderRoom queryHotelOrderRoomList …共 11 个
hotel_member_traveler11酒店addHotelMemberTraveler deleteHotelMemberTraveler getHotelMemberTraveler getHotelOrderDetail queryHotelMemberTravelerList queryHotelMemberTravelerPage …共 11 个
hotel_comment11酒店addHotelComment addHotelCommentReply auditHotelComment batchAuditHotelComment batchDeleteHotelComment deleteHotelComment …共 11 个
hotel_facility_rel9酒店addHotelFacilityRel deleteHotelFacilityRel getHotelFacilityRel getHotelInfo queryHotelFacilityRelList queryHotelFacilityRelPage …共 9 个
hotel_facility9酒店addHotelFacility deleteHotelFacility getHotelFacility getHotelInfo queryHotelFacilityList queryHotelFacilityPage …共 9 个
hotel_order_log8酒店addHotelOrderLog deleteHotelOrderLog getHotelOrderLog getHotelOrderLogs queryHotelOrderLogList queryHotelOrderLogPage …共 8 个
hotel_facility_template7酒店addHotelFacilityTemplate deleteHotelFacilityTemplate getHotelFacilityTemplate getHotelTemplateDetail queryHotelFacilityTemplateList queryHotelFacilityTemplatePage …共 7 个
hotel_facility_template_detail7酒店addHotelFacilityTemplateDetail deleteHotelFacilityTemplateDetail getHotelFacilityTemplateDetail getHotelTemplateDetail queryHotelFacilityTemplateDetailList queryHotelFacilityTemplateDetailPage …共 7 个
hotel_auto_order_room_limit7酒店addHotelAutoOrderRoomLimit deleteHotelAutoOrderRoomLimit getHotelAutoOrderRoomLimit getHotelAutoOrderRule queryHotelAutoOrderRoomLimitList queryHotelAutoOrderRoomLimitPage …共 7 个
hotel_auto_order_exclude_date7酒店addHotelAutoOrderExcludeDate deleteHotelAutoOrderExcludeDate getHotelAutoOrderExcludeDate getHotelAutoOrderRule queryHotelAutoOrderExcludeDateList queryHotelAutoOrderExcludeDatePage …共 7 个
hotel_auto_order_rule_log7酒店addHotelAutoOrderRuleLog deleteHotelAutoOrderRuleLog getHotelAutoOrderRuleLog getHotelAutoOrderRuleLogs queryHotelAutoOrderRuleLogList queryHotelAutoOrderRuleLogPage …共 7 个
hotel_comment_log7酒店addHotelCommentLog deleteHotelCommentLog getHotelCommentLog queryHotelCommentLogList queryHotelCommentLogPage queryHotelCommentLogs …共 7 个
hotel_comment_reply7酒店addHotelCommentReply deleteHotelCommentReply getHotelCommentReply queryHotelCommentReplyList queryHotelCommentReplyPage queryHotelCommentReplys …共 7 个
hotel_order_payment6酒店addHotelOrderPayment deleteHotelOrderPayment getHotelOrderPayment queryHotelOrderPaymentList queryHotelOrderPaymentPage updateHotelOrderPayment
hotel_auto_order_rule5酒店deleteHotelAutoOrderRule getHotelAutoOrderRule queryHotelAutoOrderRuleList queryHotelAutoOrderRulePage updateHotelAutoOrderRule

平台与系统 26 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
system_user24平台与系统、开放与对接、旅游卡login queryPermissionList simulateLogin queryCardAssignmentPage cibLogin sendLoginVerifyCode …共 24 个
system_user_role19商户·店铺·基础数据、平台与系统、开放与对接queryPermissionList exportCard queryCardList queryCardPage queryCardAppointmentPage queryCardCheckPage …共 19 个
system_role18商户·店铺·基础数据、平台与系统、开放与对接queryPermissionList exportCard queryCardList queryCardPage queryCardAppointmentPage queryCardCheckPage …共 18 个
system_oauth2_access_token14平台与系统、开放与对接checkerLogin login oauth2 oauth2Login oauth2MeiKe oauth2session …共 14 个
system_user_relation13商品与履约、商户·店铺·基础数据、平台与系统login simulateLogin queryCardModelList cibLogin updateGoods getOpenapiChannelOperator …共 13 个
system_operate_log10C 端聚合接口、平台与系统appoint bind addSystemOperateLog deleteSystemOperateLog getSystemOperateLog queryAppointOperateLogPage …共 10 个
system_dict_data9C 端聚合接口、平台与系统、门票与景区cardResource addDictData deleteDictData getDictData queryDictDataList queryDictDataPage …共 9 个
system_role_menu9平台与系统queryPermissionList addRoleMenu assignRoleMenu deleteRoleMenu getRoleMenu getSessionUserMenuList …共 9 个
system_menu9平台与系统queryPermissionList addMenu deleteMenu getMenu queryMenuList queryMenuPage …共 9 个
system_dept9平台与系统addDept deleteDept getDept queryAllList queryDeptList queryDeptPage …共 9 个
system_user_post8平台与系统addUser updateUser addUserPost deleteUserPost getUserPost queryUserPostList …共 8 个
infra_codegen_table7平台与系统addCodegenTable deleteCodegenTable getCodegenTable queryCodegenTableList queryCodegenTablePage queryDatabaseTableList …共 7 个
sms_log7平台与系统、开放与对接sendLoginVerifyCode addSmsLog deleteSmsLog getSmsLog querySmsLogList querySmsLogPage …共 7 个
system_oauth2_client7平台与系统、开放与对接cibLogin addOauth2Client deleteOauth2Client getOauth2Client queryOauth2ClientList queryOauth2ClientPage …共 7 个
system_post7平台与系统addPost deletePost getPost queryPostList queryPostPage updatePost …共 7 个
infra_codegen_column6平台与系统addCodegenColumn deleteCodegenColumn getCodegenColumn queryCodegenColumnList queryCodegenColumnPage updateCodegenColumn
infra_data_source_config6平台与系统addDataSourceConfig deleteDataSourceConfig getDataSourceConfig queryDataSourceConfigList queryDataSourceConfigPage updateDataSourceConfig
system_oauth2_code6平台与系统addOauth2Code deleteOauth2Code getOauth2Code queryOauth2CodeList queryOauth2CodePage updateOauth2Code
system_login_log6平台与系统addLoginLog deleteLoginLog getLoginLog queryLoginLogList queryLoginLogPage updateLoginLog
system_page_tracking6平台与系统addSystemPageTracking deleteSystemPageTracking getSystemPageTracking querySystemPageTrackingList querySystemPageTrackingPage updateSystemPageTracking
system_notice6平台与系统addSystemNotice deleteSystemNotice getSystemNotice querySystemNoticeList querySystemNoticePage updateSystemNotice
system_oauth2_refresh_token6平台与系统addOauth2RefreshToken deleteOauth2RefreshToken getOauth2RefreshToken queryOauth2RefreshTokenList queryOauth2RefreshTokenPage updateOauth2RefreshToken
system_oauth2_approve6平台与系统addOauth2Approve deleteOauth2Approve getOauth2Approve queryOauth2ApproveList queryOauth2ApprovePage updateOauth2Approve
system_dict_type6平台与系统addDictType deleteDictType getDictType queryDictTypeList queryDictTypePage updateDictType
system_tenant6平台与系统addTenant deleteTenant getTenant queryTenantList queryTenantPage updateTenant
system_tenant_package6平台与系统addTenantPackage deleteTenantPackage getTenantPackage queryTenantPackageList queryTenantPackagePage updateTenantPackage

门票与景区 11 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
tickets25商户·店铺·基础数据、开放与对接、核销getTicketsList deleteShop addTickets addTicketsCheck addTicketsSku deleteTickets …共 25 个
tickets_sku23平台与系统、门票与景区checkerLogin addTicketsCalendar addTicketsCalenderTimeSlot addTicketsCheck addTicketsSku deleteTicketsSku …共 23 个
tickets_order21开放与对接、门票与景区addTicketsCheck cancelTicketsOrder deleteTicketsOrder exportTicketsOrderPage getTicketsOrder getTicketsOrderDetail …共 21 个
tickets_order_goods19开放与对接、门票与景区addTicketsCheck addTicketsOrderGoods deleteTicketsOrderGoods getTicketsOrderGoods cancelTicketsOrder exportTicketsOrderPage …共 19 个
tickets_order_payment16开放与对接、门票与景区addTicketsOrderPayment deleteTicketsOrderPayment getTicketsOrderPayment exportTicketsOrderPage getTicketsOrderDetail payNotify …共 16 个
tickets_order_tourist15开放与对接、门票与景区addTicketsCheck addTicketsOrderTourist deleteTicketsOrderTourist getTicketsOrderTourist createTicketsOrder getTicketsOrderDetail …共 15 个
tickets_check14核销、门票与景区queryTicketsCheck statTicketsCheck countTicketsCheckToday deleteTicketsCheck exportTicketsCheckPage getTicketsCheck …共 14 个
tickets_order_operatelog14开放与对接、门票与景区addTicketsOrderOperatelog deleteTicketsOrderOperatelog getTicketsOrderOperatelog createTicketsOrder getTicketsOrderDetail payNotify …共 14 个
tickets_calendar13门票与景区addTicketsCalendar deleteTicketsCalendar getSkuDetail getTicketsCalendar getTicketsDetail cancelTicketsOrder …共 13 个
tickets_calender_time_slot12门票与景区addTicketsCalenderTimeSlot deleteTicketsCalenderTimeSlot getSkuDetail getTicketsCalenderTimeSlot getTicketsDetail cancelTicketsOrder …共 12 个
tickets_member_tourist9门票与景区addTicketsMemberTourist deleteTicketsMemberTourist getMemberTourist getTicketsMemberTourist createTicketsOrder queryTicketsMemberTouristList …共 9 个

订单·支付·售后 16 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
order10订单·支付·售后addOrder deleteOrder exportOrderList exportOrderTradeList getOrder getOrderByOrderId …共 10 个
after_sales9订单·支付·售后approve cancel exportAfterSales getAfterSales queryAfterSalesList queryAfterSalesPage …共 9 个
order_track7订单·支付·售后addOrderTrack deleteOrderTrack getOrderTrack queryOrderTrackList queryOrderTrackListByOrderId queryOrderTrackPage …共 7 个
order_delivery7订单·支付·售后addOrderDelivery deleteOrderDelivery getOrderDelivery queryOrderDeliveryList queryOrderDeliveryListByOrderId queryOrderDeliveryPage …共 7 个
order_after_sales_operationlog7订单·支付·售后getAfterSales addOrderAfterSalesOperationlog deleteOrderAfterSalesOperationlog getOrderAfterSalesOperationlog queryOrderAfterSalesOperationlogList queryOrderAfterSalesOperationlogPage …共 7 个
order_comment6订单·支付·售后addOrderComment deleteOrderComment getOrderComment queryOrderCommentList queryOrderCommentPage updateOrderComment
order_refund_response6订单·支付·售后addOrderRefundResponse deleteOrderRefundResponse getOrderRefundResponse queryOrderRefundResponseList queryOrderRefundResponsePage updateOrderRefundResponse
channel_sub6订单·支付·售后addChannelSub deleteChannelSub getChannelSub queryChannelSubList queryChannelSubPage updateChannelSub
order_refund_request6订单·支付·售后addOrderRefundRequest deleteOrderRefundRequest getOrderRefundRequest queryOrderRefundRequestList queryOrderRefundRequestPage updateOrderRefundRequest
order_payment_request_info6订单·支付·售后addOrderPaymentRequestInfo deleteOrderPaymentRequestInfo getOrderPaymentRequestInfo queryOrderPaymentRequestInfoList queryOrderPaymentRequestInfoPage updateOrderPaymentRequestInfo
order_comment_img6订单·支付·售后addOrderCommentImg deleteOrderCommentImg getOrderCommentImg queryOrderCommentImgList queryOrderCommentImgPage updateOrderCommentImg
channel_paymodel6订单·支付·售后addChannelPaymodel deleteChannelPaymodel getChannelPaymodel queryChannelPaymodelList queryChannelPaymodelPage updateChannelPaymodel
order_after_sales_image6订单·支付·售后addOrderAfterSalesImage deleteOrderAfterSalesImage getOrderAfterSalesImage queryOrderAfterSalesImageList queryOrderAfterSalesImagePage updateOrderAfterSalesImage
channel6订单·支付·售后addChannel deleteChannel getChannel queryChannelList queryChannelPage updateChannel
order_after_sales6订单·支付·售后addOrderAfterSales deleteOrderAfterSales getOrderAfterSales queryOrderAfterSalesList queryOrderAfterSalesPage updateOrderAfterSales
order_payment_response_info6订单·支付·售后addOrderPaymentResponseInfo deleteOrderPaymentResponseInfo getOrderPaymentResponseInfo queryOrderPaymentResponseInfoList queryOrderPaymentResponseInfoPage updateOrderPaymentResponseInfo

核销 8 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
checker25平台与系统、开放与对接、旅游卡checkerLogin exportCardAppointment queryCardAppointmentPage singleRecordCardCheck addChecker cardUseNotify …共 25 个
checker_relation14商品与履约、商户·店铺·基础数据、平台与系统checkerLogin addCheckerRelation deleteCheckerRelation getChecker getCheckerListByResourceId getCheckerRelation …共 14 个
checker_tickets_relation11平台与系统、核销、门票与景区checkerLogin addCheckerTicketsRelation deleteCheckerTicketsRelation getChecker getCheckerTicketsRelation queryCheckerTicketsRelationList …共 11 个
checker_cqy_relation10平台与系统、开放与对接、核销checkerLogin addCheckerCqyRelation deleteCheckerCqyRelation getChecker getCheckerCqyRelation queryCheckerCqyRelationList …共 10 个
checker_config9平台与系统、核销checkerLogin addCheckerConfig deleteCheckerConfig getChecker getCheckerConfig queryCheckerConfigList …共 9 个
checker_consume_record8旅游卡、核销deleteCardCheck addCheckerConsumeRecord cardCheckStat deleteCheckerConsumeRecord getCheckerConsumeRecord queryCheckerConsumeRecord1 …共 8 个
checker_release7核销addCheckerRelease deleteCheckerRelease getCheckerRelease queryCheckerReleaseList queryCheckerReleasePage updateCheckerRelease …共 7 个
checker_face_log1核销queryCheckerFaceLogPage

商户·店铺·基础数据 10 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
shop20C 端聚合接口、商品与履约、商户·店铺·基础数据getChecker goodsDetail goodsList detail list detail …共 20 个
merchant_contract11商户·店铺·基础数据、旅游卡queryCardResourceDietList queryCardResourceLodgList queryCardResourcePlayList queryCardResourceShopList addMerchantContract deleteMerchantContract …共 11 个
region10商户·店铺·基础数据、开放与对接、核销hhQrDecode goodsDetail goodsList cardModel addRegion deleteRegion …共 10 个
merchant9商户·店铺·基础数据、核销getChecker addMerchant deleteMerchant getMerchant importMerchant queryMerchantList …共 9 个
shop_notice8C 端聚合接口、商户·店铺·基础数据queryShopNoticePage addShopNotice deleteShopNotice getShopNotice queryShopNoticeList queryShopNoticePage …共 8 个
merchant_finance7商户·店铺·基础数据addMerchantFinance deleteMerchantFinance getMerchantFinance queryMerchantFinanceAllPage queryMerchantFinanceList queryMerchantFinancePage …共 7 个
sales6商户·店铺·基础数据addSales deleteSales getSales querySalesList querySalesPage updateSales
industry6商户·店铺·基础数据addIndustry deleteIndustry getIndustry queryIndustryList queryIndustryPage updateIndustry
shop_relation4C 端聚合接口、商户·店铺·基础数据detail list getShop updateShop
system_user_dept2商户·店铺·基础数据、平台与系统updateShop updateUser

结算与分配 12 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
settlement_card_detail15结算与分配afreshSettlementCard checkSettlementDetail deleteSettlementCard exportSettlementCardDetailSplitPage invoiceGetPaymentInvoice invoiceGetPaymentProof …共 15 个
settlement_card_detail_payment13结算与分配deleteSettlementCard exportSettlementCardDetailPaymentPage exportSettlementCardDetailSplitPage getInvoiceSettlementCard invoiceGetPaymentInvoice invoiceGetPaymentProof …共 13 个
settlement_card13结算与分配afreshSettlementCard calcSettlementCard checkSettlementDetail deleteSettlementCard getInvoiceSettlementCard getSettlementCard …共 13 个
estimation_card_check_detail7结算与分配queryEstimationCardCheckDetailPage submitEstimationCard afreshSettlementCard deleteSettlementCard exportSettlementCardCheckDetailPage querySettlementCardCheckDetailPage …共 7 个
settlement_card_log6结算与分配addSettlementCardLog deleteSettlementCardLog getSettlementCardLog querySettlementCardLogList querySettlementCardLogPage updateSettlementCardLog
xuchao_dis5结算与分配addXuchaoDis batchAdd queryXuchaoDisList queryXuchaoDisPage updateXuchaoDis
xuchao_dis_user5结算与分配addXuchaoDisUser batchAdd queryXuchaoDisUserList queryXuchaoDisUserPage updateXuchaoDisUser
distribute_detail4结算与分配deleteDistributeBatch executeCalc exportDistributeDetail queryDistributeDetailPage
settlement_card_check_detail3结算与分配afreshSettlementCard submitSettlementCard testSettlementCardCalc
distribute_batch2结算与分配getDistributeBatch queryDistributeBatchPage
estimation_card2结算与分配getEstimationCard queryEstimationCardPage
estimation_card_detail2结算与分配queryEstimationCardDetailPage submitEstimationCard

商品与履约 9 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
goods_relation19C 端聚合接口、商品与履约、开放与对接addGoodsRelation consumeRecordAsync manageAppoint queryAppointmentResourceCalenderList resourceDetail createOrder …共 19 个
goods_channel15商品与履约、开放与对接goodsOffline addGoodsChannel adjustStock deleteGoodsChannel getGoodsChannel goodsChannelOffline …共 15 个
carriage_rule9商品与履约addCarriage getCarriage updateCarriage addCarriageRule deleteCarriageRule getCarriageRule …共 9 个
goods_channel_extend8商品与履约addGoodsChannel updateGoodsChannel addGoodsChannelExtend deleteGoodsChannelExtend getGoodsChannelExtend queryGoodsChannelExtendList …共 8 个
carriage6商品与履约addCarriage deleteCarriage getCarriage queryCarriageList queryCarriagePage updateCarriage
spu6商品与履约addSpu deleteSpu getSpu querySpuList querySpuPage updateSpu
goods_type6商品与履约addGoodsType deleteGoodsType getGoodsType queryGoodsTypeList queryGoodsTypePage updateGoodsType
goods_channel_snapshot1商品与履约updateGoods
goods_channel_extend_snapshot1商品与履约updateGoods

营销与触达 6 张表

C 端聚合接口 3 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
mp_content7C 端聚合接口getDetail queryList add delete get queryPage …共 7 个
hhrs_winner5C 端聚合接口dates list delete import queryPage
member_relation3C 端聚合接口、开放与对接cardBag userCardList userCardListXgh

会员 1 张表

数据表被多少接口读写涉及业务域接口(前 6 个)
member_contacts7会员、开放与对接、旅游卡addCardBind addMemberContacts deleteMemberContacts getMemberContacts queryMemberContactsList updateMemberContacts …共 7 个
由 tools/build.py 从 data/apis.json 生成 · 生成时间 2026-09-12 19:49 · 数据口径见说明 · 本页数字非手写,均来自同一份数据