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

相关接口：

api/supplier/supply_question_info

api/supply_question/save_supply_answer

api/supply_question/cancel_answer_useful

api/supply_question/answer_useful

api/supply_question/save_question

api/supply_question/question_detail

api/supply_question/shopkeeper_question_list

数据表：

ALTER TABLE `fmys_supply_question`
ADD COLUMN `user_id`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '发问者用户id' AFTER `supply_question`,
ADD COLUMN `question_status`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '问题审核状态，0：待审核，1：审核通过，2：审核不通过' AFTER `user_id`,
ADD COLUMN `is_show`  tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否展示，0：不展示，1：展示' AFTER `question_status`,
ADD INDEX `user_id` (`user_id`) USING BTREE ;

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

CREATE TABLE `fmys_supply_answer_useful` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `answer_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '档口问答-回答id',
  `user_id` int(11) NOT NULL DEFAULT '0' COMMENT '点有用的用户id',
  `auto_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '自动时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`,`answer_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='档口问答回答有用记录表';

ALTER TABLE `fmys_supply_answer_count`
ADD COLUMN `update_time`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '回答后更新时间' AFTER `create_time`;