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

<p>后端分支：feature/4.1#23497店主认证增加月均拿货额收集</p>

<p>接口更新：api/auth/get_question 返回多一条答题</p>

<p>SQL:</p>

<p>CREATE TABLE `fmys_user_account_survey_log` (<br />
&nbsp;&nbsp; &nbsp;`id` INT ( 10 ) NOT NULL COMMENT &#39;自增id&#39;,<br />
&nbsp;&nbsp; &nbsp;`user_id` INT ( 10 ) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;用户id&#39;,<br />
&nbsp;&nbsp; &nbsp;`type` INT ( 10 ) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;选择类型1-月均拿货额&#39;,<br />
&nbsp;&nbsp; &nbsp;`val` VARCHAR ( 30 ) NOT NULL DEFAULT &#39;&#39; COMMENT &#39;选择值&#39;,<br />
&nbsp;&nbsp; &nbsp;`val_no` INT ( 10 ) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;选择值序号&#39;,<br />
&nbsp;&nbsp; &nbsp;`create_time` INT ( 10 ) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;创建时间&#39;,<br />
&nbsp;&nbsp; &nbsp;`update_time` INT ( 10 ) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;更新时间&#39;,<br />
&nbsp;&nbsp; &nbsp;`is_delete` TINYINT ( 1 ) NOT NULL DEFAULT &#39;1&#39; COMMENT &#39;是否删除1-否2-是&#39;,<br />
&nbsp;&nbsp; &nbsp;PRIMARY KEY ( `id` ),<br />
KEY `idx_uid_type` ( `user_id`, `type` ) USING BTREE COMMENT &#39;用户id&#39;&nbsp;<br />
) ENGINE = INNODB DEFAULT CHARSET = utf8 COMMENT = &#39;用户答题认证调查问题记录&#39;;</p>

<p>目的：</p>

<p>在店主认证增加一个页面收集春夏各渠道合计月均拿货额，提高该标签的月活覆盖率</p>

<p>衡量指标：</p>

<p>春夏各渠道合计月均拿货额标签的月活覆盖率</p>

<p>PRD描述：</p>

<p>&nbsp;http://192.168.1.244:7777/newOS/23497/</p>