ngds/sql/2021_04/bonus_two/AR_CALC_MONTH_BONUS_USER.sql

-- ----------------------------
-- Table structure for AR_CALC_MONTH_BONUS_USER
-- ----------------------------
DROP TABLE IF EXISTS `AR_CALC_MONTH_BONUS_USER`;
CREATE TABLE `AR_CALC_MONTH_BONUS_USER` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '用户名',
  `CALC_MONTH` int(10) unsigned NOT NULL COMMENT '结算月',
  `PERIOD_NUM` int(10) unsigned NOT NULL COMMENT '期数',
  `CREATED_AT` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`) USING BTREE,
  KEY `CALC_MONTH` (`CALC_MONTH`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='月奖会员表';