ngds/sql/2020_08/AR_CALC_BONUS_XF.sql

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_CALC_BONUS_XF
-- ----------------------------
DROP TABLE IF EXISTS `AR_CALC_BONUS_XF`;
CREATE TABLE `AR_CALC_BONUS_XF` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `LAST_DEC_LV` varchar(32) DEFAULT '',
  `LAST_EMP_LV` varchar(32) DEFAULT '',
  `LAST_STATUS` tinyint(1) NOT NULL DEFAULT 0,
  `FROM_USER_ID` varchar(32) NOT NULL,
  `LAST_FROM_DEC_LV` varchar(32) DEFAULT '',
  `LAST_FROM_EMP_LV` varchar(32) DEFAULT '',
  `LAST_FROM_STATUS` tinyint(1) NOT NULL DEFAULT 0,
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT 0.000,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_YEAR` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `LOGS` varchar(2000) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL,
  `ORI_BONUS` decimal(16,3) NOT NULL DEFAULT 0.000,
  `RECONSUME_POINTS` decimal(16,3) NOT NULL DEFAULT 0.000,
  `MANAGE_TAX` decimal(16,3) NOT NULL DEFAULT 0.000,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `FROM_USER_ID` (`FROM_USER_ID`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='消费奖结算记录';

SET FOREIGN_KEY_CHECKS = 1;