ngds/sql/2020_07/AR_EMPLOY_LEVEL.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : aikang_online

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 14/07/2020 10:24:17
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_EMPLOY_LEVEL
-- ----------------------------
DROP TABLE IF EXISTS `AR_EMPLOY_LEVEL`;
CREATE TABLE `AR_EMPLOY_LEVEL` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT 'ID',
  `LEVEL_NAME` varchar(48) COLLATE utf8mb4_bin NOT NULL COMMENT '级别名称',
  `LOCATION_NUM` int(10) NOT NULL DEFAULT '0' COMMENT '区数量',
  `LOCATION_PERF` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '单区业绩',
  `NEW_PERF` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '新增业绩',
  `MIN_EMPLOY_LEVEL` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '几个区域内分别有几个最低什么聘级的会员',
  `YC_PERCENT_ARR` text COLLATE utf8mb4_bin COMMENT '育成津贴比例集合',
  `CF_BASE_NUM` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '车房奖基数',
  `CF_PERCENT` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '车房奖系数',
  `LX_BASE_NUM` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '领袖奖奖基数',
  `LX_PERCENT` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '领袖奖系数',
  `SORT` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `CREATE_ADMIN` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '创建管理员',
  `UPDATE_ADMIN` varchar(32) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新管理员',
  `ICON_TYPE` tinyint(1) NOT NULL DEFAULT '0' COMMENT '图表类型',
  `ICON_NUM` tinyint(2) NOT NULL DEFAULT '0' COMMENT '图标个数',
  `RX_PERCENT` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '荣衔奖比例',
  `OTHER_DEPART_PERF` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '去除最大部门，其它部门的累计推荐业绩',
  `MIN_EMPLOY_NUM` int(10) NOT NULL DEFAULT '0' COMMENT '最小聘级的数量',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `LEVEL_NAME` (`LEVEL_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='聘级';

-- ----------------------------
-- Records of AR_EMPLOY_LEVEL
-- ----------------------------
BEGIN;
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE1C6C21F81B32E055736AECE8644D', '无聘级', 0, 0.00, 0.00, NULL, '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 0, 1521436806, 1594603737, 'admin', 'adminy', 0, 0, 0.00, 0.00, 0);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE5FE7857C216AE055736AECE8644D', '主任', 2, 0.00, 0.00, 'E121497617216708615', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 2, 1521437938, 1594603783, 'admin', 'adminy', 1, 2, 3.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE6A4D03C52288E055736AECE8644D', '经理', 2, 0.00, 0.00, 'E121497617216708616', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 4, 1521438113, 1594191015, 'admin', 'adminy', 2, 1, 4.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE6EA2070D22EBE055736AECE8644D', '高级经理', 2, 0.00, 0.00, '67BE6A4D03C52288E055736AECE8644D', '[\"10\",0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 5, 1521438185, 1594191004, 'admin', 'adminy', 2, 2, 4.50, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE742A336F2370E055736AECE8644D', '总监', 3, 0.00, 0.00, '67BE6EA2070D22EBE055736AECE8644D', '[\"10\",\"10\",0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 6, 1521438278, 1594191007, 'admin', 'adminy', 3, 1, 5.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE805032C22492E055736AECE8644D', '高级总监', 3, 0.00, 0.00, '67BE742A336F2370E055736AECE8644D', '[\"10\",\"10\",\"10\",0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 7, 1521438482, 1594191010, 'admin', 'adminy', 3, 2, 5.50, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('67BE82019BE524CAE055736AECE8644D', '首席总监', 3, 0.00, 0.00, '67BE742A336F2370E055736AECE8644D', '[\"10\",\"10\",\"10\",\"5\",0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 8, 1521438510, 1594630563, 'admin', 'adminy', 3, 3, 6.00, 0.00, 1);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('E121497617216708615', '见习主任', 0, 0.00, 0.00, NULL, '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 1, 1521437938, 1594609178, 'admin', 'adminy', 1, 1, 2.00, 100000.00, 0);
INSERT INTO `AR_EMPLOY_LEVEL` VALUES ('E121497617216708616', '高级主任', 2, 0.00, 0.00, '67BE5FE7857C216AE055736AECE8644D', '[0,0,0,0,0,0,0,0,0,0]', 0.00, 0.00, 0.00, 0.00, 3, 1521438113, 1594190968, 'admin', 'adminy', 1, 3, 3.50, 0.00, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;