jy/doc/mysql表结构/pushsubscribe.sql

CREATE TABLE `wcjtest` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userid` char(24) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户id',
  `infoid` char(24) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '信息id',
  `matchkeys` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '匹配词',
  `area` smallint(6) DEFAULT NULL COMMENT '省份',
  `city` smallint(6) DEFAULT NULL COMMENT '城市',
  `buyerclass` int(11) DEFAULT NULL COMMENT '采购单位行业',
  `toptype` int(11) DEFAULT NULL COMMENT '一级信息类型',
  `subtype` int(11) DEFAULT NULL COMMENT '二级信息类型',
  `date` int(11) NOT NULL COMMENT '推送时间',
  `isvisit` tinyint(4) DEFAULT NULL COMMENT '是否访问过',
  `isvip` tinyint(4) DEFAULT NULL COMMENT '0-免费用户 1-付费用户',
  `type` tinyint(4) DEFAULT NULL COMMENT '0-信息匹配  1-项目匹配',
  PRIMARY KEY (`id`,`userid`),
  KEY `index_userid` (`userid`) USING BTREE,
  KEY `index_date` (`date`) USING BTREE,
  KEY `index_city` (`city`) USING BTREE,
  KEY `index_toptype` (`toptype`) USING BTREE,
  KEY `index_subtype` (`subtype`) USING BTREE,
  KEY `index_area` (`area`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=185010353 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
PARTITION BY KEY (userid)
PARTITIONS 10 ;