ngds/sql/2021_01/jxStandard/AR_CALC_BONUS_STANDARD.sql

DROP TABLE IF EXISTS `AR_CALC_BONUS_STANDARD`;
CREATE TABLE `AR_CALC_BONUS_STANDARD` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `LAST_DEC_LV` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `LAST_EMP_LV` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `LAST_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `FROM_USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `LAST_FROM_DEC_LV` varchar(32) COLLATE utf8mb4_bin DEFAULT '',
  `LAST_FROM_EMP_LV` varchar(32) COLLATE utf8mb4_bin 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) COLLATE utf8mb4_bin 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='VIP奖结算记录';