一手商城需求管理 » 一手商城后台优化

<p>PRD：http://192.168.1.244:7777/newOS/22756/</p>

<p>&nbsp;</p>

<p>相关需求：众唛外呼的调研 http://14.29.126.108:30001/issues/22111\</p>

<p>&nbsp;</p>

<p>CREATE TABLE `data_tele_goods` (<br />
&nbsp; `id` int(11) unsigned NOT NULL,<br />
&nbsp; `user_id` int(11) unsigned NOT NULL COMMENT &#39;用户id&#39;,<br />
&nbsp; `goods_no` int(11) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;商品货号\r\n&#39;,<br />
&nbsp; `type` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;商品状态 [1.点击, 2.加购物车, 3.代付款]&#39;,<br />
&nbsp; `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT &#39;创建时间&#39;,<br />
&nbsp; `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT &#39;更新时间&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; UNIQUE KEY `user_id` (`user_id`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=&#39;电销CRM外呼用户池的用户商品货号表&#39;;</p>

<p>&nbsp;</p>

<p>CREATE TABLE `date_tele_province_goods` (<br />
&nbsp; `id` int(11) unsigned NOT NULL AUTO_INCREMENT,<br />
&nbsp; `goods_no` int(11) unsigned NOT NULL COMMENT &#39;商品货号&#39;,<br />
&nbsp; `num` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;销售数量&#39;,<br />
&nbsp; `province_id` int(10) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;省份id&#39;,<br />
&nbsp; PRIMARY KEY (`id`),<br />
&nbsp; KEY `province_id` (`province_id`,`goods_no`)<br />
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT=&#39;电销CRM省份商品销售&#39;;</p> COMMENT=&#39;外呼用户池的用户商品货号表&#39;;</p>