CREATE TABLE `citic_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '工号',
  `password` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `name` varchar(30) CHARACTER SET utf8mb4 DEFAULT NULL,
  `telephone` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL,
  `activate` tinyint(4) DEFAULT NULL COMMENT '1 = 已激活， 2 = 未激活， 3 = 已禁用',
  `org_code` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '组织机构代码',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP,
  `activate_time` datetime DEFAULT NULL,
  `branch_id` bigint(20) DEFAULT NULL COMMENT '分公司_id',
  `branch_name` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '分公司_name',
  `sub_branch_id` bigint(20) DEFAULT NULL COMMENT '支公司_id',
  `sub_branch_name` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '支公司_name',
  `marketing_channel` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '营销渠道',
  `departed` tinyint(4) DEFAULT NULL COMMENT '是否离职 1 = 离职 2 = 在职',
  `user_type` tinyint(4) DEFAULT NULL COMMENT '1 = app端 2 = web端(信诚) 3 = web端(思图)',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后一次登录时间',
  `directly_agency_id` bigint(11) DEFAULT NULL COMMENT '直属机构id',
  `directly_agency_name` varchar(45) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '直属机构名字',
  `id_card` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '身份证',
  `licensed` varchar(50) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '职业证',
  `open_id` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '微信号',
  `emp_no` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '业务员工号',
  `extra_info` text CHARACTER SET utf8mb4 COMMENT '额外信息',
  `email` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL,
  `employee_id` varchar(100) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '工号',
  `source` tinyint(4) DEFAULT NULL COMMENT '用户来源：1=本地注册，2=统一登录获取',
  `group_id` bigint(20) DEFAULT NULL COMMENT '团队id',
  `company_name` varchar(225) CHARACTER SET utf8mb4 DEFAULT '' COMMENT '销售人员所属中介公司名称',
  `company_code` varchar(50) DEFAULT NULL COMMENT '销售人员所属经代公司编码',
  `cert_type` varchar(4) DEFAULT NULL COMMENT '证件类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=8204 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;