xtu_mall/app/common/model/feedback.sql

CREATE TABLE IF NOT EXISTS `yzn_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `feedback_type` varchar(32) NOT NULL DEFAULT '' COMMENT '评价类型标识',
  `feedback_type_text` varchar(100) NOT NULL DEFAULT '' COMMENT '评价类型文本',
  `rating` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '评分 1-5',
  `lang` varchar(16) NOT NULL DEFAULT 'cn' COMMENT '语言',
  `source_page` varchar(255) NOT NULL DEFAULT '' COMMENT '来源页面',
  `ip` varchar(64) NOT NULL DEFAULT '' COMMENT 'IP',
  `user_agent` varchar(255) NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `updatetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniq_ip_type` (`ip`,`feedback_type`),
  KEY `idx_feedback_type` (`feedback_type`),
  KEY `idx_lang` (`lang`),
  KEY `idx_createtime` (`createtime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='前台评价打分';