def evaluate - Campus-take-out/take-out GitHub Wiki

数据库字段定义

evaluate表

字段 类型 长度 备注
e_id int 10 e_id(主键)
e_mid int 10 商家id(外键)
e_uid int 10 用户id(外键)
e_allrating double 8 总评
e_foodrating double 8 食物总评
e_sendrating double 8 骑手总评
e_comment varchar 255 评论
e_imgurl varchar 255 评价图片(数组)
e_createtime datetime 4 评价创建时间

sql

DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `e_id` int(10) NOT NULL AUTO_INCREMENT,
  `e_mid` int(10) NOT NULL,
  `e_uid` int(10) NOT NULL,
  `e_allrating` double(18,8) DEFAULT '5.00000000',
  `e_foodrating` double(18,8) DEFAULT '5.00000000',
  `e_sendrating` double(18,8) DEFAULT '5.00000000',
  `e_comment` varchar(255) COLLATE utf8_bin DEFAULT '',
  `e_imgurl` varchar(255) COLLATE utf8_bin DEFAULT '',
  `e_createtime` datetime(4) DEFAULT NULL,
  PRIMARY KEY (`e_id`),
  KEY `e_mid` (`e_mid`),
  KEY `e_uid` (`e_uid`),
  CONSTRAINT `e_mid` FOREIGN KEY (`e_mid`) REFERENCES `merchant` (`m_id`),
  CONSTRAINT `e_uid` FOREIGN KEY (`e_uid`) REFERENCES `user` (`u_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
⚠️ **GitHub.com Fallback** ⚠️