| 字段 |
类型 |
长度 |
备注 |
| m_id |
int |
10 |
m_id(主键) |
| m_mid |
int |
10 |
所属商家id(外键) |
| m_name |
varchar |
255 |
商家名/菜品名 |
| m_mapping |
varchar |
255 |
商家名关键字/菜品名关键字(搜索匹配) |
DROP TABLE IF EXISTS `map`;
CREATE TABLE `map` (
`m_id` int(10) NOT NULL AUTO_INCREMENT,
`m_name` varchar(255) COLLATE utf8_bin DEFAULT '',
`m_mid` int(10) NOT NULL,
`m_mapping` varchar(255) COLLATE utf8_bin DEFAULT '',
PRIMARY KEY (`m_id`),
KEY `m_mid` (`m_mid`),
CONSTRAINT `m_mid` FOREIGN KEY (`m_mid`) REFERENCES `merchant` (`m_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;