members

CREATE TABLE `members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `member_rating` int(11) DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `twitter_username` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `lead_rating` int(11) DEFAULT '0',
  `follow_rating` int(11) DEFAULT '0',
  `unfollow_rating` int(11) DEFAULT '0',
  `followers_count` int(11) DEFAULT NULL,
  `hidden` tinyint(1) DEFAULT '0',
  `persona_id` int(11) NOT NULL,
  `member_state` int(11) DEFAULT '0',
  `entered_state_at` datetime DEFAULT NULL,
  `entered_state_reason` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `high_value_type` int(11) DEFAULT NULL,
  `starred` tinyint(1) NOT NULL DEFAULT '0',
  `high_value_type_changed_at` datetime DEFAULT NULL,
  `engagements_count` int(11) DEFAULT NULL,
  `twitter_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`,`user_id`),
  UNIQUE KEY `user_id` (`user_id`,`persona_id`),
  KEY `starred_index` (`user_id`,`starred`),
  KEY `hidden_index` (`user_id`,`hidden`),
  KEY `members_state_index` (`user_id`,`member_state`),
  KEY `high_value_members_index` (`user_id`,`high_value_type`),
  KEY `twitter_id_index` (`user_id`,`twitter_id`),
  KEY `persona_id_index` (`user_id`,`persona_id`)
) ENGINE=InnoDB AUTO_INCREMENT=311238675 DEFAULT CHARSET=latin1
/*!50100 PARTITION BY HASH (user_id)
PARTITIONS 1000 */