# springboot-dubbo-beetlsql-redis-activemq

**Repository Path**: hice/springboot-dubbo-beetlsql-redis-activemq

## Basic Information

- **Project Name**: springboot-dubbo-beetlsql-redis-activemq
- **Description**: springboot-dubbo-beetlsql-redis-activemq
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 2
- **Forks**: 0
- **Created**: 2017-02-24
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

#springboot-dubbo-beetlsql-redis-activemq

SQL-INIT
===
CREATE TABLE `user` (
  `id` bigint(64) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(64) NOT NULL COMMENT '*用户编码',
  `user_name` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '用户名',
  `nickname` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '用户昵称',
  `phone` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '手机号（格式+86）',
  `email` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '邮箱',
  `user_password` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '*新密码',
  `user_password_old` varchar(64) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '！旧密码',
  `salt` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '！密码盐责',
  `sex` tinyint(1) DEFAULT NULL COMMENT '性别(0：男，1：女）',
  `age` int(11) DEFAULT NULL COMMENT '年龄',
  `card_id` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '身份证编码',
  `card_name` varchar(32) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '身份证姓名',
  `create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '表更新时间',
  `json_info` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT '~json扩展信息',
  PRIMARY KEY (`id`),
  UNIQUE KEY `userid` (`user_id`) USING HASH
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='会员注册+登录信息表';