ngds/sql/2020_11/AR_CALC_BONUS_FW.sql

-- SET NAMES utf8mb4;
-- SET FOREIGN_KEY_CHECKS = 0;
--
-- -- ----------------------------
-- -- Table structure for AR_CALC_BONUS_FW
-- -- ----------------------------
-- DROP TABLE IF EXISTS `AR_CALC_BONUS_FW`;
-- CREATE TABLE `AR_CALC_BONUS_FW` (
--   `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;