数据需求管理 » 商城数据协助

<p>CREATE TABLE `data_tele_marketing` (<br />
&nbsp; `id` int(10) unsigned NOT NULL AUTO_INCREMENT,<br />
&nbsp; `user_id` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户ID&#39;,<br />
&nbsp; `click_num` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;点击商品款数&#39;,<br />
&nbsp; `add_num` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;加购款数&#39;,<br />
&nbsp; `unpay_num` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;待支付件数&#39;,<br />
&nbsp; `unpay_money` double(10,2) NOT NULL DEFAULT &#39;0.00&#39; COMMENT &#39;待支付金额&#39;,<br />
&nbsp; `close_num` int(10) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;关闭件数&#39;,<br />
&nbsp; `status` tinyint(3) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;分配状态{0:未分配,1:已分配,}&#39;,<br />
&nbsp; `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT &#39;创建时间&#39;,<br />
&nbsp; PRIMARY KEY (`id`)<br />
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COMMENT=&#39;电销用户&#39;;</p>

<p>&nbsp;</p>

<p>CREATE TABLE `data_tele_goods` (<br />
&nbsp; `id` int(11) unsigned NOT NULL AUTO_INCREMENT,<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`,`type`,`goods_no`) USING BTREE<br (`user_id`),<br />
&nbsp; KEY `goods_no` (`goods_no`)<br />
) ENGINE=InnoDB DEFAULT ENGINE=InnoDB&nbsp;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>