<div style="width: 0px; height: 0px; padding: 0px; border: 0px; margin: 0px; position: absolute; top: 0px; left: -9999px; opacity: 0; overflow: hidden;"> &nbsp; </div> <table style="height:824px; width:807.02pt" class=" cke_show_border"> <tbody> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 活动名称 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 活动表名 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> 活动商品id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> 表字段 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 表字段备注 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 表字段状态 </td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 团购 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_groupbuy_base </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> common_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> groupbuy_starttime </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> groupbuy_endtime </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> common_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> groupbuy_state </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 团购状态 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 1.审核中&nbsp;2.正常&nbsp;3.结束&nbsp;4.审核失败&nbsp;5.管理员关闭 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 加价购 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_increase_base </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> increase_start_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 加价购基础信息表 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> increase_end_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> increase_state </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动状态 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 1-正常/2-已结束/3-管理员关闭 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_increase_goods </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> goods_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> increase_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 加价购活动id </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 参加加价购活动的商品 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_start_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_end_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_increase_redemp_goods </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> rule_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 加价购规则id </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 加价购活动规则中可加价换购的商品 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> increase_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 加价购活动id </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 限时折扣 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_discount_base </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> discount_start_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 限时折扣基础信息表 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> discount_end_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> discount_state </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 状态 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 1-正常/2-结束/3-管理员关闭 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_discount_goods </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> goods_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> discount_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 限时活动id </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 限时折扣商品表 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> discount_goods_state </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 状态 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 1-正常/2-结束/3-管理员关闭 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 满即送 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_mansong_base </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> mansong_start_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 满即送基础信息表 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> mansong_end_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> mansong_state </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 状态 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 1-正常/2-已结束/3-管理员关闭，取消 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_mansong_rule </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> goods_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> mansong_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 活动id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> 满即送规则表 </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"> 拼团 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_pintuan </td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> start_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 开始时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> end_time </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 结束时间 </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> status </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 是否可用 </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:295.82pt"> 是否可用，1为可用。 </td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:127.83pt"> yf_pintuan_detail </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:82.22pt"> goods_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> pintuan_id </td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:94.83pt"> 拼团共用ID </td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:157.82pt"> goods_id </td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> <tr> <td style="height:11.42pt; text-align:general; vertical-align:middle; width:48.63pt"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> <td style="vertical-align:middle"></td> </tr> </tbody> </table>