ngds/sql/2020_10/AR_SCORE_MONTH.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : aikang_online

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 22/10/2020 14:59:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_SCORE_MONTH
-- ----------------------------
DROP TABLE IF EXISTS `AR_SCORE_MONTH`;
CREATE TABLE `AR_SCORE_MONTH` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'ID',
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '会员ID',
  `BASE_SCORE` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '基础分数',
  `LEVEL_SCORE` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '级别分数',
  `UPGRADE_SCORE` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '升级分数',
  `TOTAL_SCORE` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '总分数',
  `PERIOD_NUM` int(10) NOT NULL COMMENT '期数',
  `CALC_MONTH` int(10) NOT NULL COMMENT '结算月',
  `CREATED_AT` int(10) unsigned NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `CALC_MONTH` (`CALC_MONTH`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='月分数记录';

SET FOREIGN_KEY_CHECKS = 1;