活動數據表說明 · 商城二開文檔

![](https://box.kancloud.cn/51d318db0886e99abd49935ed4b579d9_950x655.png) <div style="width: 0px; height: 0px; padding: 0px; border: 0px; margin: 0px; position: absolute; top: 0px; left: -9999px; opacity: 0; overflow: hidden;">   </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.審核中 2.正常 3.結束 4.審核失敗 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>