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

数据库字段定义

food表

字段 类型 长度 备注
f_id int 10 f_id(主键)
f_ftid int 10 菜品分类id(外键)
f_mid int 10 所属商家id(外键)
f_name varchar 25 菜品名称
f_avatarurl varchar 255 菜品图片url
f_price double 8 菜品单价
f_dprice double 8 菜品折后价
f_ischara tinyint 2 是否是特色菜(0是 1否)
f_status tinyint 2 菜品状态(0售空 1未售空)
f_description varchar 255 菜品描述
f_sale int 255 菜品销量
f_key varchar 255 菜品关键字(用于搜索)
f_evaluate double 8 菜品评价

sql

DROP TABLE IF EXISTS `food`;
CREATE TABLE `food` (
  `f_id` int(10) NOT NULL AUTO_INCREMENT,
  `f_ftid` int(10) NOT NULL,
  `f_mid` int(10) NOT NULL,
  `f_name` varchar(25) COLLATE utf8_bin DEFAULT '',
  `f_avatarurl` varchar(255) COLLATE utf8_bin DEFAULT '',
  `f_price` double(18,8) DEFAULT '0.00000000',
  `f_dprice` double(18,8) DEFAULT '0.00000000',
  `f_ischara` tinyint(2) DEFAULT '0',
  `f_status` tinyint(2) DEFAULT '0',
  `f_description` varchar(255) COLLATE utf8_bin DEFAULT '',
  `f_sale` int(255) DEFAULT '10',
  `f_key` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`f_id`),
  KEY `f_ftid` (`f_ftid`),
  KEY `f_mid` (`f_mid`),
  CONSTRAINT `f_ftid` FOREIGN KEY (`f_ftid`) REFERENCES `foodtype` (`ft_id`),
  CONSTRAINT `f_mid` FOREIGN KEY (`f_mid`) REFERENCES `merchant` (`m_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
⚠️ **GitHub.com Fallback** ⚠️