ngds/sql/2021_01/jxStandard/AR_PERF_STANDARD.sql

DROP TABLE IF EXISTS `AR_PERF_STANDARD`;
CREATE TABLE `AR_PERF_STANDARD` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `USER_ID` varchar(32) NOT NULL COMMENT '会员ID',
  `LAST_DEC_LV` varchar(32) DEFAULT '' COMMENT '结算时会员级别',
  `LAST_EMP_LV` varchar(32) DEFAULT '' COMMENT '结算时会员聘级',
  `LAST_STATUS` tinyint(1) NOT NULL DEFAULT 0 COMMENT '结算时的状态',
  `AMOUNT_PCS` decimal(16,3) NOT NULL DEFAULT 0.000 COMMENT '个人销售额',
  `AMOUNT_PSS` decimal(16,3) NOT NULL DEFAULT 0.000 COMMENT '团队销售额',
  `CALC_MONTH` int(10) NOT NULL COMMENT '结算月',
  `P_CALC_MONTH` date NOT NULL COMMENT '表分区日期索引',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `CALC_MONTH` (`CALC_MONTH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='达标业绩记录';