可信百科公众绑定企业

数据库

wiki
SQL

CREATE TABLE `tb_wiki_wechat_bind` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `openid` varchar(50) NOT NULL DEFAULT '' COMMENT '用户微信openid',
  `phone` varchar(11) NOT NULL DEFAULT '' COMMENT '绑定手机号',
  `company_name_digest` varchar(32) NOT NULL DEFAULT '' COMMENT '企业digest',
  `company_name` varchar(50) NOT NULL DEFAULT '' COMMENT '企业名称',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态，1为待生效，2为已生效，3为删除',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_At` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_openid` (`openid`),
  KEY `idx_digest` (`company_name_digest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='可信百科公众账号企业绑定表';