一手商城需求管理 » 一手APP版本里程碑

<p>相关接口：</p>

<p><span style="color:#3498db;">api/supplier/supply_question_info</span></p> style="color:#f1c40f;">api/supply_question/save_supply_answer</span></p>

<p><span style="color:#3498db;">api/supply_question/save_supply_answer</span></p> style="color:#f1c40f;">api/supply_question/cancel_answer_useful</span></p>

<p><span style="color:#3498db;">api/supply_question/cancel_answer_useful</span></p> style="color:#f1c40f;">api/supply_question/answer_useful</span></p>

<p><span style="color:#3498db;">api/supply_question/answer_useful</span></p> style="color:#f1c40f;">api/supply_question/save_question</span></p>

<p><span style="color:#3498db;">api/supply_question/save_question</span></p> style="color:#f1c40f;">api/supply_question/question_detail</span></p>

<p><span style="color:#3498db;">api/supply_question/question_detail</span></p> style="color:#f1c40f;">api/supply_question/shopkeeper_question_list</span></p>

<p><span style="color:#3498db;">api/supply_question/shopkeeper_question_list</span></p>

<p>数据表：</p>

<pre>
<span style="color:#2980b9;">ALTER style="color:#f1c40f;">ALTER TABLE `fmys_supply_question`
ADD COLUMN `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;发问者用户id&#39; AFTER `supply_question`,
ADD COLUMN `question_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;问题审核状态，0：待审核，1：审核通过，2：审核不通过&#39; AFTER `user_id`,
ADD COLUMN `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;是否展示，0：不展示，1：展示&#39; AFTER `question_status`,
ADD INDEX `user_id` (`user_id`) USING BTREE ;</span></pre>

<pre>
<span style="color:#2980b9;">ALTER style="color:#f1c40f;">ALTER TABLE `fmys_supply_answer`
ADD COLUMN `virtual_user_key` smallint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;系统回答匹配虚拟用户键值&#39; AFTER `user_id`,
ADD COLUMN `answer_status` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;回答审核状态，0：待审核，1：审核通过，2：审核不通过&#39; AFTER `answer`,
ADD COLUMN `is_show` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;是否展示，0：不展示，1：展示&#39; AFTER `answer_status`,
ADD COLUMN `useful_count` mediumint(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;评有用次数&#39; AFTER `create_time`,
ADD COLUMN `str_sort` smallint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;字数长度排序&#39; AFTER `create_time`,
ADD COLUMN `is_read` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT &#39;是否已读回答，0：否，1：是&#39; AFTER `str_sort`;</span></pre>

<pre>
<span style="color:#2980b9;">CREATE style="color:#f1c40f;">CREATE TABLE `fmys_supply_answer_useful` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT &#39;主键id&#39;,
`answer_id` int(11) unsigned NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;档口问答-回答id&#39;,
`user_id` int(11) NOT NULL DEFAULT &#39;0&#39; COMMENT &#39;点有用的用户id&#39;,
`auto_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT &#39;自动时间&#39;,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`,`answer_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=&#39;档口问答回答有用记录表&#39;;</span></pre>

<pre>
<span style="color:#2980b9;">ALTER style="color:#f1c40f;">ALTER TABLE `fmys_supply_answer_count`
ADD COLUMN `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT &#39;回答后更新时间&#39; AFTER `create_time`;</span></pre>