CREATE TABLE `supplier_activity` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`activity_id` bigint(20) DEFAULT NULL COMMENT '所属活动id',
PRIMARY KEY (`id`),
KEY `idx_activity_id` (`activity_id`) USING BTREE,
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='xxx ';
KEY `idx_activity_id` (`activity_id`) USING BTREE,
是在activity_id上建立了BTREE的索引