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

数据库字段定义

merchant表

字段 类型 长度 备注
m_id int 10 m_id(主键自增)
m_nationid int 10 国家
m_cityid int 10 城市
m_provinceid int 10 省份
m_name varchar 100 商家名称
m_avatarurl varchar 100 商家图片地址
m_description varchar 255 商家描述
m_type tinyint 4 商家类型(0快餐便当 1果蔬生鲜 2料理 3甜品饮品)
m_address varchar 100 商家地址
u_lon double 8 地址经度
u_lat double 8 地址纬度
m_tel varchar 20 商家联系电话
m_evaluate double 8 商家总评
m_rank tinyint 3 商家等级(0普通 1黄金 2钻石)
m_begintime varchar 100 营业开始时间
m_endtime varchar 100 营业结束时间
m_status tinyint 2 商家状态(0营业 1休息)
m_avatime int 11 送餐平均时间
m_price double 8 起送价
m_sendprice double 8 配送费
m_sale int 255 月销量
m_redactivity varchar 255 满减活动
m_timedelivery tinyint 2 是否支持及时配送(0是 1否)
m_notice varchar 255 商家公告
m_foodrating double 18 食物总评
m_sendrating double 18 配送总评
m_distance double 20 用户与商家距离
m_key varchar 255 商家关键字(用于搜索)

sql

DROP TABLE IF EXISTS `merchant`;
CREATE TABLE `merchant` (
  `m_id` int(10) NOT NULL AUTO INCREMENT,
  `m_nationid` int(10) NOT NULL,
  `m_provinceid` int(10) NOT NULL,
  `m_cityid` int(10) NOT NULL,
  `m_name` varchar(10) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_avatarurl` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_description` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_type` tinyint(4) DEFAULT '0',
  `m_address` varchar(100) COLLATE utf8_bin DEFAULT '',
  `m_lon` double(18,8) DEFAULT '0.00000000',
  `m_lat` double(18,8) DEFAULT '0.00000000',
  `m_tel` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
  `m_evaluate` double(18,8) DEFAULT '5.00000000',
  `m_rank` tinyint(3) DEFAULT '0',
  `m_begintime` varchar(100) COLLATE utf8_bin DEFAULT '',
  `m_endtime` varchar(100) COLLATE utf8_bin DEFAULT '',
  `m_status` tinyint(2) DEFAULT '0',
  `m_avatime` int(11) DEFAULT '60',
  `m_price` double(18,8) DEFAULT '15.00000000',
  `m_sendprice` double(18,8) DEFAULT '3.50000000',
  `m_sale` int(255) DEFAULT '100',
  `m_redactivity` varchar(255) COLLATE utf8_bin DEFAULT '',
  `m_timedelivery` tinyint(2) DEFAULT '0',
  `m_notice` varchar(255) COLLATE utf8_bin DEFAULT '',
  `m_foodrating` double(18,8) DEFAULT '5.00000000',
  `m_sendrating` double(18,8) DEFAULT '5.00000000',
  `m_distance` double(18,8) DEFAULT '0.00000000',
  `m_key` varchar(255) COLLATE utf8_bin DEFAULT '',
  PRIMARY KEY (`m_id`),
  KEY `m_nationid` (`m_nationid`),
  KEY `m_provinceid` (`m_provinceid`),
  KEY `m_cityid` (`m_cityid`),
  CONSTRAINT `m_cityid` FOREIGN KEY (`m_cityid`) REFERENCES `city` (`c_id`),
  CONSTRAINT `m_nationid` FOREIGN KEY (`m_nationid`) REFERENCES `nation` (`n_id`),
  CONSTRAINT `m_provinceid` FOREIGN KEY (`m_provinceid`) REFERENCES `province` (`p_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
⚠️ **GitHub.com Fallback** ⚠️