vmp_db_model

新增买家开团记录vmp_buyer_own_resource_detail

15分钟未付款或关闭订单，我的团中看不到该记录；申请退款，是否需要在我的团页面看到？

新增买家开团数量vmp_buyer_own_resource_quantity

活动资源，对应开团和参团两个库存

未成团未支付

失败

参团

未成团已支付

活动详情，对应一个商品

释放库存、团坑位资源删除买家参团记录和计数团的状态仍旧为未成团

vmp_activity

- activity_id: long- creator_id: String- providerKey: String- name: String- description: String- activityType: int- toolId: Long- toolCode: String- calculateLevel: int- participateRage: int- operationParameter: String- status: int- options: int- startTime: Date- endTime: Date- parentId: long- features: String- gmtCreated: Date- gmtModified: Date

RabbitMQ

北京MQ只有订单id和状态信息，没有买家id，杭州系统无法定位到买家对应的参团记录；希望北京团队能提供buyerId或订详情查询接口

买家持有资源数量(限购)

15分钟内未支付或关闭订单

减开团库存vmp_activity_resource

调北京接口发起退款释放库存、团坑位资源更新买家团的记录和计数

有团的id

开团或参团生成订单

开团

买家申请退款

无团的id系统选择最优团

支付人数达到团上限

需要北京提供实时接口查询订单状态，确保该用户的订单是已支付状态

vmp_buyer_own_resource_quantity

- id: long- buyerId: String- shopId: String- activityId: String- resourceId: long- bizOutId: long- limitStartTime: Date- limitEndTime: Date- count: int- status: int- flag: int- features: String- gmtCreated: Date- gmtModified: Date

biz_vgroupon

- grouponId: long- creatorId: String- resourceId: String- itemId: String- activityId: String- joinCount: int- payCount: int- buyerLimit: int- status: int- participators: String- features: String- gmtCreated: Date- gmtModified: Date

新增团的记录biz_vgroupon

已解散

vmp_tool

- toolId: long- toolCode: String- creator: String- version: String- providerKey: String- name: String- operation: String- checked: int- status: int- calculateLevel: int- description: String- feature: String- gmtCreated: Date- gmtModified: Date

支付人数未达到上限且活动已结束

15分钟内支付

vmp_buyer_own_resource_detail

- id: long- buyerId: String- shopId: String- activityId: String- resourceId: long- bizOutId: long- type: int- stock: int- amount: int- startTime: Date- endTime: Date- status: int- flag: int- features: String- gmtCreated: Date- gmtModified: Date

优惠活动，对应一期微团购

释放库存、团坑位资源更新买家团的记录和计数团的状态仍为已成团

团的状态强依赖MQ，队列存在消息丢失、时序不一致等风险；希望北京能提供订单状态查询接口，杭州团队能规避潜在风险

开始

已成团

团的信息，开团新增一条记录，参团更新记录

未支付买家等待15分钟订单关闭

买家持有资源详情

vmp_activity_resource

- resourceId: long- creatorId: String- itemId: String- skuId: String- detailId: long- activityId: long- toolId: long- toolCode: String- initStock: long- stock: long- price: long- condition: String- type: int- status: int- startTime: Date- endTime: Date- buyerLimit: int- flag1: int- flag2: int- features: String- gmtCreated: Date- gmtModified: Date

订单状态：取消订单、支付订单、退款走MQ消息队列已解散：需要VGroupon定时程序，同时已支付的买家需要调北京接口发起退款风险点：订单状态强依赖MQ，如何保证消息不丢

失败触发立即回滚@TccTransaction

成功

减参团库存vmp_activity_resource

已支付买家系统发起退款

更新团的记录(joinCount)biz_vgroupon

未达到开团上限且活动已结束

vmp_activity_detail

- detailId: long- participateId: String- participateType: int- creator: String- sellerId: String- shopId: String- activityId: long- toolId: long- toolCode: String- name: String- participateRange: int- parentOptions: int- options: int- operationParameter: String- status: int- activityType: int- calculateLevel: int- startTime: Date- endTime: Date- gmtCreated: Date- gmtModified: Date

优惠工具，单库单表