ngds/sql/v2.0.0/aikang_db_struct.sql

-- MySQL dump 10.13  Distrib 5.7.22, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: aikang_db
-- ------------------------------------------------------
-- Server version	5.7.25-TiDB-v4.0.0-beta-232-g902c6ca2b

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AR_AD`
--

DROP TABLE IF EXISTS `AR_AD`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_AD` (
  `ID` varchar(32) NOT NULL,
  `TITLE` varchar(48) NOT NULL,
  `IMAGE` varchar(1000) NOT NULL,
  `TYPE` tinyint(1) NOT NULL,
  `LID` varchar(32) NOT NULL,
  `CONTENT` varchar(1000) DEFAULT NULL,
  `SORT` tinyint(2) NOT NULL DEFAULT '10',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `TITLE` (`TITLE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='广告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ADMIN`
--

DROP TABLE IF EXISTS `AR_ADMIN`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ADMIN` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `ADMIN_NAME` varchar(255) NOT NULL COMMENT '用户名',
  `REAL_NAME` varchar(128) NOT NULL COMMENT '会员姓名',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '备注',
  `ROLE_ID` varchar(32) NOT NULL COMMENT '角色ID',
  `IS_ENABLE` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否启用',
  `AUTH_KEY` varchar(255) DEFAULT NULL COMMENT '认证KEY',
  `PASSWORD_HASH` varchar(255) NOT NULL COMMENT '密码',
  `PASSWORD_RESET_TOKEN` varchar(255) DEFAULT NULL COMMENT '重设密码TOKEN',
  `DONT_DEL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '不可删除',
  `IS_DEL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否删除',
  `LOGIN_NUMS` int(10) NOT NULL DEFAULT '0' COMMENT '登录次数',
  `FAIL_NUMS` int(10) NOT NULL DEFAULT '0' COMMENT '登录失败次数',
  `LAST_LOGIN_IP` varchar(16) NOT NULL DEFAULT '0.0.0.0' COMMENT '上次登录IP',
  `LAST_LOGIN_AT` int(10) NOT NULL DEFAULT '0' COMMENT '上次登录时间',
  `BIND_IP` text DEFAULT NULL COMMENT '绑定IP',
  `CREATE_ADMIN` varchar(32) NOT NULL COMMENT '创建管理员',
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL COMMENT '更新管理员',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '删除时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ADMIN_NAME` (`ADMIN_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='管理员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ADMIN_ROLE`
--

DROP TABLE IF EXISTS `AR_ADMIN_ROLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ADMIN_ROLE` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `ROLE_NAME` varchar(255) NOT NULL COMMENT '角色名',
  `REMARK` varchar(255) DEFAULT NULL COMMENT '描述',
  `PERMISSION` text DEFAULT NULL COMMENT '权限',
  `COLUMN_PERMISSION` text DEFAULT NULL COMMENT '列表字段权限',
  `DONT_DEL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '不可删除',
  `CREATE_ADMIN` varchar(32) DEFAULT NULL COMMENT '创建管理员',
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL COMMENT '更新管理员',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ROLE_NAME` (`ROLE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='管理员角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ADMIN_TOKEN`
--

DROP TABLE IF EXISTS `AR_ADMIN_TOKEN`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ADMIN_TOKEN` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `ADMIN_ID` varchar(32) NOT NULL COMMENT '管理员ID',
  `PC_ACCESS_TOKEN` varchar(255) DEFAULT NULL COMMENT 'PC认证TOKEN',
  `APP_ACCESS_TOKEN` varchar(255) DEFAULT NULL COMMENT 'APP认证TOKEN',
  `PC_REFRESH_TOKEN` varchar(255) DEFAULT NULL COMMENT 'PC刷新TOKEN',
  `APP_REFRESH_TOKEN` varchar(255) DEFAULT NULL COMMENT 'APP刷新TOKEN',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `PAT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'PCACCESSTOKEN更新时间',
  `AAT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'APPACCESSTOKEN更新时间',
  `PRT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'PCREFRESHTOKEN更新时间',
  `ART_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'PCREFRESHTOKEN更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PC_ACCESS_TOKEN` (`PC_ACCESS_TOKEN`),
  UNIQUE KEY `APP_ACCESS_TOKEN` (`APP_ACCESS_TOKEN`),
  UNIQUE KEY `PC_REFRESH_TOKEN` (`PC_REFRESH_TOKEN`),
  UNIQUE KEY `APP_REFRESH_TOKEN` (`APP_REFRESH_TOKEN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='管理员TOKEN表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_AD_LOCATION`
--

DROP TABLE IF EXISTS `AR_AD_LOCATION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_AD_LOCATION` (
  `ID` varchar(32) NOT NULL,
  `LOCATION_NAME` varchar(48) NOT NULL,
  `REMARK` varchar(255) NOT NULL,
  `TYPE` tinyint(1) NOT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `LOCATION_NAME` (`LOCATION_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='广告位';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ARTICLE`
--

DROP TABLE IF EXISTS `AR_ARTICLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ARTICLE` (
  `ID` varchar(32) NOT NULL,
  `TITLE` varchar(255) NOT NULL,
  `CID` varchar(32) NOT NULL,
  `CONTENT` text DEFAULT NULL,
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `TITLE` (`TITLE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='文章表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ARTICLE_CATEGORY`
--

DROP TABLE IF EXISTS `AR_ARTICLE_CATEGORY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ARTICLE_CATEGORY` (
  `ID` varchar(32) NOT NULL,
  `CATE_NAME` varchar(48) NOT NULL,
  `SORT` tinyint(2) NOT NULL DEFAULT '10',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `CATE_NAME` (`CATE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='文章分类表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_BALANCE_AUDIT`
--

DROP TABLE IF EXISTS `AR_BALANCE_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_BALANCE_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `LAST_DEC_LV` varchar(32) DEFAULT '',
  `LAST_EMP_LV` varchar(32) DEFAULT '',
  `LAST_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `TYPE` varchar(48) NOT NULL,
  `DEAL_TYPE` varchar(32) NOT NULL,
  `AMOUNT` float(16,2) NOT NULL DEFAULT '0.00',
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `UPDATE_ADMIN_ID` varchar(32) DEFAULT NULL,
  `AUDIT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TYPE` (`TYPE`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='钱包变更审核记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_BILL`
--

DROP TABLE IF EXISTS `AR_BILL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_BILL` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `BILL_NO` varchar(255) NOT NULL,
  `BILL_AMOUNT` float(16,2) NOT NULL DEFAULT '0.00',
  `USED_AMOUNT` float(16,2) NOT NULL DEFAULT '0.00',
  `EXPIRY_DATE` int(10) NOT NULL,
  `INPUT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员提供的税票';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `LAST_USER_NAME` varchar(16) NOT NULL,
  `LAST_REAL_NAME` varchar(128) NOT NULL,
  `LAST_DEC_LV` varchar(32) DEFAULT '',
  `LAST_EMP_LV` varchar(32) DEFAULT '',
  `LAST_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `LAST_MOBILE` varchar(11) DEFAULT '',
  `LAST_PERIOD_AT` int(10) NOT NULL DEFAULT '0',
  `LAST_CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `LAST_SUB_COM_ID` varchar(32) DEFAULT '',
  `LAST_PROVINCE` int(6) DEFAULT '0',
  `LAST_CITY` int(6) DEFAULT '0',
  `LAST_COUNTY` int(9) DEFAULT '0',
  `LAST_SYSTEM_ID` varchar(32) NOT NULL,
  `LAST_IS_DIRECT_SELLER` tinyint(1) NOT NULL DEFAULT '0',
  `LAST_REC_USER_NAME` varchar(16) DEFAULT '',
  `LAST_REC_REAL_NAME` varchar(128) DEFAULT '',
  `LAST_CON_USER_NAME` varchar(16) DEFAULT '',
  `LAST_CON_REAL_NAME` varchar(128) DEFAULT '',
  `LAST_LOCATION` tinyint(1) NOT NULL,
  `BONUS_QY` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_YC` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_FX` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_LS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_FW` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_BT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_BT_PROD` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_BT_TOOL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `DEDUCT_ZR` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_FL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_CF` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_LX` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SHOULD_QY` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SHOULD_DEDUCT_ZR` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_PCS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_LS_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_LS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_LS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_REAL` decimal(16,3) unsigned NOT NULL DEFAULT '0.000' COMMENT '实际奖金',
  `BONUS_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_INCOME` 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,
  `CALCULATED_AT` int(10) NOT NULL,
  `IS_SENT` tinyint(1) NOT NULL DEFAULT '0',
  `SENT_AT` int(10) NOT NULL DEFAULT '0',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `BONUS_QY_MONTH` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_BD` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_BD` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_TG` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_TG` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_YJ` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_YJ` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_QY` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_YC` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_GX` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_GX` decimal(16,3) NOT NULL DEFAULT '0.000',
  `BONUS_GL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORI_BONUS_GL` 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 `IS_SENT` (`IS_SENT`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `USER_ID` (`USER_ID`),
  KEY `CALC_MONTH` (`CALC_MONTH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='总奖金结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_BD`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_BD`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_BD` (
  `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='报单奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_BT`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_BT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_BT` (
  `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',
  `LAST_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `BT_TYPE` varchar(8) NOT NULL,
  `FROM_ORDER_SN` varchar(32) DEFAULT '',
  `ORDER_TIME` int(10) NOT NULL DEFAULT '0',
  `ORDER_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_AT` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT '0',
  `PAY_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PAY_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TRANSFER_SN` varchar(32) DEFAULT '',
  `TRANSFER_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TRANSFER_AT` int(10) NOT NULL DEFAULT '0',
  `TRANSFER_PERIOD` int(10) NOT NULL DEFAULT '0',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `LOGS` varchar(2000) DEFAULT '',
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_YEAR` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单中心店补补贴记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_CF`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_CF`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_CF` (
  `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',
  `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,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='车房养老结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_FL`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_FL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_FL` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `LAST_DEC_ROLE_ID` varchar(32) NOT NULL,
  `DEC_SN` varchar(32) NOT NULL,
  `TO_USER_ID` varchar(32) NOT NULL,
  `DEC_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DEC_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `DEC_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `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,
  `ORDER_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `LOGS` varchar(2000) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='货补记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_FW`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_FW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
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',
  `LAST_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `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',
  `LAST_FROM_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `LAST_FROM_PROVINCE` int(6) DEFAULT '0',
  `LAST_FROM_CITY` int(6) DEFAULT '0',
  `LAST_FROM_COUNTY` int(6) DEFAULT '0',
  `FROM_ORDER_SN` varchar(32) DEFAULT '',
  `ORDER_TIME` int(10) NOT NULL DEFAULT '0',
  `ORDER_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_AT` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT '0',
  `PAY_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PAY_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `ORDER_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `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,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='区级店业绩提成结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_FX`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_FX`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_FX` (
  `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',
  `DEEP` int(10) NOT NULL,
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERIOD_NUM` 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,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='复销奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_GL`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_GL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_GL` (
  `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='管理奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_GX`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_GX`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_GX` (
  `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='共享奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_LS`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_LS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_LS` (
  `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',
  `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,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='零售结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_LX`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_LX`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_LX` (
  `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',
  `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,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='领袖分红结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_QY`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_QY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_QY` (
  `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',
  `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 `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='区域津贴结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_TG`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_TG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_TG` (
  `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='推广奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_YC`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_YC`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_YC` (
  `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',
  `DEEP` int(10) NOT NULL,
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERIOD_NUM` 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='育成津贴结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CALC_BONUS_YJ`
--

DROP TABLE IF EXISTS `AR_CALC_BONUS_YJ`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CALC_BONUS_YJ` (
  `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='业绩奖结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CF_LX_AUDIT`
--

DROP TABLE IF EXISTS `AR_CF_LX_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CF_LX_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `CF` float(16,2) NOT NULL DEFAULT '0.00',
  `LX` float(16,2) NOT NULL DEFAULT '0.00',
  `YEAR` int(4) NOT NULL DEFAULT '0',
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `YEAR` (`YEAR`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='车房领袖年度发放审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_COMPANY_BANK`
--

DROP TABLE IF EXISTS `AR_COMPANY_BANK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_COMPANY_BANK` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `OPEN_NAME` varchar(255) NOT NULL,
  `OPEN_BANK` varchar(255) NOT NULL,
  `BANK_ADDRESS` varchar(255) NOT NULL,
  `BANK_NO` varchar(32) NOT NULL,
  `BANK_PROVINCE` int(6) NOT NULL,
  `BANK_CITY` int(6) NOT NULL,
  `BANK_COUNTY` int(9) NOT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='公司银行信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_CONFIG`
--

DROP TABLE IF EXISTS `AR_CONFIG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_CONFIG` (
  `CONFIG_NAME` varchar(32) NOT NULL COMMENT '配置参数名',
  `TITLE` varchar(48) NOT NULL COMMENT '标题',
  `UNIT` varchar(32) DEFAULT NULL COMMENT '单位',
  `INPUT_TYPE` int(2) NOT NULL DEFAULT '1' COMMENT '表单类型',
  `OPTIONS` text DEFAULT NULL COMMENT '参数配置的选项',
  `VALUE` text NOT NULL COMMENT '配置值',
  `TYPE` varchar(32) NOT NULL COMMENT '类型',
  `SORT` int(10) NOT NULL DEFAULT '1' COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='系统配置表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DEAL_TYPE`
--

DROP TABLE IF EXISTS `AR_DEAL_TYPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DEAL_TYPE` (
  `ID` varchar(32) NOT NULL,
  `TYPE_NAME` varchar(255) NOT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `UPDATE_REMARK` text DEFAULT NULL,
  `IS_PRESET` tinyint(1) NOT NULL DEFAULT '0',
  `IS_ENABLE` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `SORT_ORDER` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='交易类型表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DECLARATION_LEVEL`
--

DROP TABLE IF EXISTS `AR_DECLARATION_LEVEL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DECLARATION_LEVEL` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `LEVEL_NAME` varchar(48) NOT NULL COMMENT '级别名称',
  `PERF` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '累计业绩',
  `QY_PERCENT` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '区域津贴百分比',
  `QY_TOUCH_CAP` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '对碰封顶',
  `QY_BIG_CAP` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '大区封顶',
  `FX_MIN_DEEP` int(10) NOT NULL DEFAULT '1' COMMENT '复销奖拿奖最小层数',
  `FX_MAX_DEEP` int(10) NOT NULL DEFAULT '1' COMMENT '复销奖拿奖最大层数',
  `FX_PERCENT` float(16,2) NOT NULL DEFAULT '0.00' COMMENT '复销奖百分比',
  `IS_ADJUST_GIFT` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可调整礼包',
  `IS_DEC` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否可以报单',
  `SORT` int(10) NOT NULL DEFAULT '0' COMMENT '级别排序',
  `CREATE_ADMIN` varchar(32) NOT NULL COMMENT '创建管理员',
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL COMMENT '更新管理员',
  `UPDATE_PERIOD` float NOT NULL DEFAULT '0' COMMENT '更新期数',
  `ORDER_PERMISSION` text DEFAULT NULL COMMENT '订单权限',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  `GL_ODD_DEEP_ONE` int(10) NOT NULL DEFAULT '1' COMMENT '共享奖推荐1人拿的代数',
  `GL_ODD_DEEP_TWO` int(10) NOT NULL DEFAULT '1' COMMENT '共享奖推荐2人拿的代数',
  `GL_ODD_DEEP_THREE` int(10) NOT NULL DEFAULT '1' COMMENT '共享奖推荐3人拿的代数',
  `INCOME_CAP` decimal(16,2) NOT NULL DEFAULT '0.00' COMMENT '收入上限',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `LEVEL_NAME` (`LEVEL_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单级别';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DECLARATION_PACKAGE`
--

DROP TABLE IF EXISTS `AR_DECLARATION_PACKAGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DECLARATION_PACKAGE` (
  `ID` varchar(32) NOT NULL,
  `PACKAGE_NAME` varchar(48) NOT NULL,
  `PACKAGE_NO` varchar(32) NOT NULL DEFAULT 'PG546763',
  `AMOUNT` float(16,2) NOT NULL DEFAULT '0.00',
  `PV` float(16,2) NOT NULL DEFAULT '0.00',
  `LEVEL_ID` varchar(32) NOT NULL,
  `PACKAGE_CONTENT` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `IS_DEL` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  `DELETED_AT` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
  `STATUS` tinyint(2) unsigned NOT NULL DEFAULT '1' COMMENT '上下架',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PACKAGE_NAME` (`PACKAGE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单套餐';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DEC_LEVEL_LOG`
--

DROP TABLE IF EXISTS `AR_DEC_LEVEL_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DEC_LEVEL_LOG` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `FROM_ID` varchar(32) NOT NULL,
  `TO_ID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `REMARK` text NOT NULL,
  `ADMIN_ID` varchar(32) NOT NULL DEFAULT '',
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `STATUS` (`STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单级别变动记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DEC_ORDER`
--

DROP TABLE IF EXISTS `AR_DEC_ORDER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DEC_ORDER` (
  `ID` varchar(32) NOT NULL,
  `DEC_SN` varchar(32) NOT NULL DEFAULT '',
  `ORDER_SN` varchar(32) NOT NULL DEFAULT '',
  `USER_ID` varchar(32) NOT NULL,
  `TO_USER_ID` varchar(32) NOT NULL,
  `TYPE` varchar(32) NOT NULL,
  `IS_ADMIN` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `DEC_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PAID_WALLET` varchar(48) NOT NULL,
  `IS_BATCH` tinyint(1) NOT NULL DEFAULT '0',
  `REMARK` text DEFAULT NULL,
  `REC_USER_ID` varchar(32) DEFAULT '',
  `CON_USER_ID` varchar(32) DEFAULT '',
  `PERIOD_NUM` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `CALC_MONTH` int(8) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `UPDATER` varchar(32) DEFAULT '',
  `UPDATED_AT` varchar(32) NOT NULL DEFAULT '0',
  `IS_DEL` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_ID` varchar(32) DEFAULT '',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `DEC_SN` (`DEC_SN`),
  KEY `USER_ID` (`USER_ID`),
  KEY `TYPE` (`TYPE`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_DEL` (`IS_DEL`),
  KEY `ORDER_SN` (`ORDER_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='报单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_DEC_ROLE`
--

DROP TABLE IF EXISTS `AR_DEC_ROLE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_DEC_ROLE` (
  `ID` varchar(32) NOT NULL,
  `ROLE_NAME` varchar(255) NOT NULL COMMENT '名称',
  `FW_BONUS_PERCENT` decimal(16,2) unsigned NOT NULL DEFAULT '0.00' COMMENT '推荐奖比例',
  `SORT` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL COMMENT '更新时间',
  `UPDATER` varchar(16) DEFAULT NULL COMMENT '更新人',
  `ADM_NAME` varchar(16) NOT NULL COMMENT '创建人',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `ROLE_NAME` (`ROLE_NAME`),
  KEY `SORT` (`SORT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EMPLOY_LEVEL`
--

DROP TABLE IF EXISTS `AR_EMPLOY_LEVEL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EMPLOY_LEVEL` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `LEVEL_NAME` varchar(48) 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) DEFAULT NULL COMMENT '几个区域内分别有几个最低什么聘级的会员',
  `YC_PERCENT_ARR` text DEFAULT NULL 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) NOT NULL COMMENT '创建管理员',
  `UPDATE_ADMIN` varchar(32) 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='聘级';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EMPLOY_LEVEL_LOG`
--

DROP TABLE IF EXISTS `AR_EMPLOY_LEVEL_LOG`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EMPLOY_LEVEL_LOG` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `FROM_ID` varchar(32) NOT NULL,
  `TO_ID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='聘级变动记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXCEL_ADD_USER`
--

DROP TABLE IF EXISTS `AR_EXCEL_ADD_USER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXCEL_ADD_USER` (
  `ID` varchar(32) NOT NULL,
  `EXCEL_IMPORT_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(32) DEFAULT NULL,
  `DEC_LV` varchar(32) DEFAULT NULL,
  `REAL_NAME` varchar(32) DEFAULT NULL,
  `ID_CARD` varchar(32) DEFAULT NULL,
  `MOBILE` varchar(32) DEFAULT NULL,
  `TEL` varchar(32) DEFAULT NULL,
  `AREA_PROVINCE` varchar(32) DEFAULT NULL,
  `AREA_CITY` varchar(32) DEFAULT NULL,
  `AREA_COUNTY` varchar(32) DEFAULT NULL,
  `ADDRESS` varchar(32) DEFAULT NULL,
  `OPEN_BANK` varchar(32) DEFAULT NULL,
  `BANK_ADDRESS` varchar(32) DEFAULT NULL,
  `BANK_NO` varchar(32) DEFAULT NULL,
  `BANK_PROVINCE` varchar(32) DEFAULT NULL,
  `BANK_CITY` varchar(32) DEFAULT NULL,
  `BANK_COUNTY` varchar(32) DEFAULT NULL,
  `IS_DEC` varchar(32) DEFAULT NULL,
  `DEC_ROLE` varchar(32) DEFAULT NULL,
  `DEC_USER_NAME` varchar(32) DEFAULT NULL,
  `BIRTHDAY` varchar(32) DEFAULT NULL,
  `CON_USER_NAME` varchar(32) DEFAULT NULL,
  `REC_USER_NAME` varchar(32) DEFAULT NULL,
  `LOCATION` varchar(32) DEFAULT NULL,
  `SORT` int(10) NOT NULL,
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `ERROR_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='空单录入待导入表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXCEL_CHANGE_BALANCE`
--

DROP TABLE IF EXISTS `AR_EXCEL_CHANGE_BALANCE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXCEL_CHANGE_BALANCE` (
  `ID` varchar(32) NOT NULL,
  `EXCEL_IMPORT_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(32) NOT NULL,
  `TYPE` varchar(20) NOT NULL,
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `DEAL_TYPE` varchar(128) NOT NULL,
  `REMARK` varchar(2000) DEFAULT '',
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '0',
  `SORT` int(5) NOT NULL DEFAULT '0',
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `ERROR_REMARK` varchar(1000) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='调整会员余额待导入表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXCEL_IMPORT`
--

DROP TABLE IF EXISTS `AR_EXCEL_IMPORT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXCEL_IMPORT` (
  `ID` varchar(32) NOT NULL,
  `OPTION_NAME` varchar(32) NOT NULL,
  `TABLE_NAME` varchar(32) DEFAULT NULL,
  `UPLOAD_ID` varchar(32) DEFAULT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `IMPORT_ADMIN_ID` varchar(32) NOT NULL,
  `AUDIT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='Excel导入记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXCEL_REG_INFO`
--

DROP TABLE IF EXISTS `AR_EXCEL_REG_INFO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXCEL_REG_INFO` (
  `ID` varchar(32) NOT NULL,
  `EXCEL_IMPORT_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(32) DEFAULT NULL,
  `REAL_NAME` varchar(32) DEFAULT NULL,
  `ID_CARD` varchar(32) DEFAULT NULL,
  `REG_TYPE` varchar(32) DEFAULT NULL,
  `REG_NAME` varchar(255) DEFAULT NULL,
  `CREDIT_CODE` varchar(255) DEFAULT NULL,
  `PREMISES` varchar(255) DEFAULT NULL,
  `REG_EXPIRES` varchar(255) DEFAULT NULL,
  `LEGAL_PERSON` varchar(255) DEFAULT NULL,
  `OPEN_NAME` varchar(255) DEFAULT NULL,
  `OPEN_BANK` varchar(255) DEFAULT NULL,
  `BANK_ADDRESS` varchar(255) DEFAULT NULL,
  `BANK_NO` varchar(32) DEFAULT NULL,
  `BANK_PROVINCE` varchar(32) DEFAULT NULL,
  `BANK_CITY` varchar(32) DEFAULT NULL,
  `BANK_COUNTY` varchar(32) DEFAULT NULL,
  `REMARK` text DEFAULT NULL,
  `SORT` int(10) NOT NULL,
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `ERROR_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='注册信息待导入表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXCEL_WITHDRAW_PAID_FALSE`
--

DROP TABLE IF EXISTS `AR_EXCEL_WITHDRAW_PAID_FALSE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXCEL_WITHDRAW_PAID_FALSE` (
  `ID` varchar(32) NOT NULL,
  `EXCEL_IMPORT_ID` varchar(32) NOT NULL,
  `SN` varchar(32) NOT NULL,
  `WITHDRAW_PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `PAID_AT` varchar(32) NOT NULL DEFAULT '',
  `PAID_FAIL_REMARK` varchar(1000) DEFAULT '',
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(32) NOT NULL,
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BANK_REAL_NAME` varchar(255) NOT NULL,
  `BANK_NO` varchar(32) NOT NULL,
  `SORT` int(5) NOT NULL DEFAULT '0',
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `ERROR_REMARK` varchar(1000) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  KEY `EXCEL_IMPORT_ID` (`EXCEL_IMPORT_ID`),
  KEY `USER_NAME` (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='提现标记失败待导入表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXPORT`
--

DROP TABLE IF EXISTS `AR_EXPORT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXPORT` (
  `ID` varchar(32) NOT NULL,
  `EXPORT_NAME` varchar(255) NOT NULL,
  `MODULE_NAME` varchar(255) NOT NULL,
  `REMARK` varchar(255) DEFAULT NULL,
  `IS_EXPORTING` tinyint(1) NOT NULL DEFAULT '0',
  `ADMIN_ID` varchar(32) DEFAULT NULL,
  `EXPORT_PERCENT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `ENDED_AT` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `FILE_NAME` varchar(255) DEFAULT '',
  `REMOTE_URL` varchar(2000) DEFAULT '',
  `FILE_SIZE` bigint(16) NOT NULL DEFAULT '0',
  `UPDATER` varchar(16) DEFAULT NULL,
  `UPDATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `EXPORT_NAME` (`EXPORT_NAME`),
  KEY `MODULE_NAME` (`MODULE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='导出表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_EXPORT_FILE`
--

DROP TABLE IF EXISTS `AR_EXPORT_FILE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_EXPORT_FILE` (
  `ID` varchar(32) NOT NULL,
  `FILE_NAME` varchar(255) NOT NULL,
  `EXPORT_ID` varchar(32) NOT NULL,
  `URL` varchar(1000) DEFAULT NULL,
  `FILE_SIZE` varchar(255) DEFAULT NULL,
  `MD5` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `FILE_NAME` (`FILE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='导出文件表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_BONUS`
--

DROP TABLE IF EXISTS `AR_FLOW_BONUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_BONUS` (
  `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',
  `CALC_ID` varchar(32) DEFAULT NULL,
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '1',
  `DEAL_TYPE_ID` varchar(32) DEFAULT NULL,
  `DEAL_TYPE_IS_PRESET` tinyint(1) NOT NULL DEFAULT '1',
  `ADMIN_NAME` varchar(32) DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `TRANSFER_SN` varchar(32) DEFAULT '',
  `SORT` int(10) NOT NULL DEFAULT '0',
  `AUTO_SORT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='总奖金流水';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_CF`
--

DROP TABLE IF EXISTS `AR_FLOW_CF`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_CF` (
  `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',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '1',
  `DEAL_TYPE_ID` varchar(32) DEFAULT NULL,
  `DEAL_TYPE_IS_PRESET` tinyint(1) NOT NULL DEFAULT '1',
  `ADMIN_NAME` varchar(32) DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='车房养老奖流水';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_DEDUCT_ZR`
--

DROP TABLE IF EXISTS `AR_FLOW_DEDUCT_ZR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_DEDUCT_ZR` (
  `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',
  `ZR` decimal(16,3) NOT NULL DEFAULT '0.000',
  `LOGS` varchar(2000) DEFAULT '',
  `SURPLUS_BONUS` 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,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='责任业绩扣除记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_LX`
--

DROP TABLE IF EXISTS `AR_FLOW_LX`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_LX` (
  `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',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '1',
  `DEAL_TYPE_ID` varchar(32) DEFAULT NULL,
  `DEAL_TYPE_IS_PRESET` tinyint(1) NOT NULL DEFAULT '1',
  `ADMIN_NAME` varchar(32) DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='领袖分红奖流水';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_RECONSUME_POINTS`
--

DROP TABLE IF EXISTS `AR_FLOW_RECONSUME_POINTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_RECONSUME_POINTS` (
  `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',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `REMARK_IS_SHOW` tinyint(1) NOT NULL DEFAULT '1',
  `DEAL_TYPE_ID` varchar(32) DEFAULT NULL,
  `DEAL_TYPE_IS_PRESET` tinyint(1) NOT NULL DEFAULT '1',
  `ADMIN_NAME` varchar(32) DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='重消积分流水';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_FLOW_WALLET`
--

DROP TABLE IF EXISTS `AR_FLOW_WALLET`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_FLOW_WALLET` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `CALC_ID` varchar(32) DEFAULT NULL,
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `ADMIN_NAME` varchar(32) DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `SORT` int(10) NOT NULL DEFAULT '0',
  `TRANSFER_SN` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='现金钱包流水';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_HISTORY_BONUS`
--

DROP TABLE IF EXISTS `AR_HISTORY_BONUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_HISTORY_BONUS` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(32) NOT NULL,
  `REAL_NAME` varchar(32) NOT NULL,
  `DEC_LV` varchar(32) NOT NULL,
  `EMP_LV` varchar(32) NOT NULL,
  `IS_DEC` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_ROLE_ID` varchar(32) DEFAULT '',
  `SYSTEM_NAME` varchar(32) DEFAULT '',
  `BONUS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CF` decimal(16,2) NOT NULL DEFAULT '0.00',
  `LX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `WITHDRAW` decimal(16,2) NOT NULL DEFAULT '0.00',
  `WITHDRAW_TAX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `WITHDRAW_DEDUCT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `WITHDRAW_REAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `WITHDRAW_FAIL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `USER_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `USER_STATUS_AT` int(10) NOT NULL DEFAULT '0',
  `HIGHEST_EMP_LV` varchar(32) DEFAULT '',
  `PERIOD_AT` varchar(32) DEFAULT '',
  `DEC_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `DEC_USER_NAME` varchar(32) DEFAULT '',
  `DEC_REAL_NAME` varchar(32) DEFAULT '',
  `MOBILE` varchar(11) DEFAULT '',
  `TEL` varchar(11) DEFAULT '',
  `PROVINCE` int(10) NOT NULL DEFAULT '0',
  `CITY` int(10) NOT NULL DEFAULT '0',
  `COUNTY` int(10) NOT NULL DEFAULT '0',
  `SUB_COM_ID` varchar(32) DEFAULT '',
  `IS_DIRECT_SELLER` tinyint(1) NOT NULL DEFAULT '0',
  `BACKUP_AT` int(10) NOT NULL DEFAULT '0',
  `PARTITION_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='历史奖金余额';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_INVOICE_AUDIT`
--

DROP TABLE IF EXISTS `AR_INVOICE_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_INVOICE_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `WITHDRAW_ID` varchar(32) NOT NULL,
  `INVOICE_CODE` varchar(255) NOT NULL,
  `INVOICE_NUM` varchar(255) NOT NULL,
  `INVOICE_DATE` varchar(255) NOT NULL,
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `TAX_RATE` varchar(10) DEFAULT NULL,
  `PURCHASER_NAME` varchar(255) NOT NULL,
  `PURCHASER_REGISTER_NUM` varchar(255) NOT NULL,
  `PURCHASER_ADDRESS` varchar(255) NOT NULL,
  `PURCHASER_BANK` varchar(255) NOT NULL,
  `SELLER_NAME` varchar(255) NOT NULL,
  `SELLER_REGISTER_NUM` varchar(255) NOT NULL,
  `SELLER_ADDRESS` varchar(255) NOT NULL,
  `SELLER_BANK` varchar(255) NOT NULL,
  `ITEM_NAME` varchar(255) NOT NULL,
  `INVOICE_REMARK` varchar(255) DEFAULT NULL,
  `UPLOAD_ID` varchar(255) DEFAULT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) DEFAULT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `INVOICE_NUM` (`INVOICE_NUM`),
  KEY `USER_ID` (`USER_ID`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='发票审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_INVOICE_BALANCE_AUDIT`
--

DROP TABLE IF EXISTS `AR_INVOICE_BALANCE_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_INVOICE_BALANCE_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='发票余额审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_INVOICE_FLOW`
--

DROP TABLE IF EXISTS `AR_INVOICE_FLOW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_INVOICE_FLOW` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `REAL_NAME` varchar(128) NOT NULL,
  `DEC_LV` varchar(32) NOT NULL,
  `EMP_LV` varchar(32) NOT NULL,
  `MOBILE` varchar(32) NOT NULL,
  `REG_TYPE` varchar(32) NOT NULL,
  `REG_NAME` varchar(255) NOT NULL,
  `CREDIT_CODE` varchar(255) NOT NULL,
  `SALE_NAME` varchar(255) DEFAULT NULL,
  `TAXPAYER_NUMBER` varchar(255) DEFAULT NULL,
  `INVOICE_ACCOUNT` varchar(255) NOT NULL,
  `INVOICE_SN` varchar(255) DEFAULT NULL,
  `TAX_ACCOUNT` varchar(255) NOT NULL,
  `OUTED_AT` int(10) NOT NULL DEFAULT '0',
  `DEDUCT_PERIOD_NUM` bigint(32) NOT NULL DEFAULT '0',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  `WITHDRAW_SN` varchar(255) DEFAULT NULL,
  `IS_INCR` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `CREATE_TIME` int(10) NOT NULL,
  `AUDIT_ADMIN` varchar(32) NOT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `AUDIT_TIME` int(10) NOT NULL,
  `P_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='发票交易记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_MESSAGE`
--

DROP TABLE IF EXISTS `AR_MESSAGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_MESSAGE` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `TEXT_ID` varchar(32) NOT NULL,
  `IS_READ` tinyint(1) NOT NULL DEFAULT '0',
  `IS_DEL` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `READ_AT` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `IS_READ` (`IS_READ`),
  KEY `IS_DEL` (`IS_DEL`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='站内信';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_MESSAGE_TEXT`
--

DROP TABLE IF EXISTS `AR_MESSAGE_TEXT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_MESSAGE_TEXT` (
  `ID` varchar(32) NOT NULL,
  `TITLE` varchar(48) NOT NULL,
  `CONTENT` text NOT NULL,
  `TO_UID` varchar(32) NOT NULL DEFAULT '0',
  `IS_DEL` tinyint(1) NOT NULL DEFAULT '0',
  `ADMIN_ID` varchar(32) NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `TO_UID` (`TO_UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='站内信内容';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_OCR_API`
--

DROP TABLE IF EXISTS `AR_OCR_API`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_OCR_API` (
  `ID` varchar(32) NOT NULL,
  `API_NAME` varchar(48) NOT NULL,
  `DESCRIPTION` varchar(255) NOT NULL,
  `CONFIG` text DEFAULT NULL,
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `API_NAME` (`API_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='OCR识别接口表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_OPEN_BANK`
--

DROP TABLE IF EXISTS `AR_OPEN_BANK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_OPEN_BANK` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `BANK_NAME` varchar(64) NOT NULL COMMENT '银行名称',
  `BANK_CODE` varchar(32) NOT NULL COMMENT '银行代码',
  `LIST_ORDER` int(5) NOT NULL DEFAULT '0' COMMENT '排序',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '修改时间',
  `ADM_NAME` varchar(16) NOT NULL COMMENT '操作人',
  `MIN_CHARGE` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '最低手续费',
  `MAX_CHARGE` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '最高手续费',
  `CHARGE_PROP` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '手续费比例',
  `UPDATER` varchar(16) DEFAULT '' COMMENT '修改人',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `BANK_CODE` (`BANK_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开户行';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ORDER`
--

DROP TABLE IF EXISTS `AR_ORDER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ORDER` (
  `ID` varchar(32) NOT NULL,
  `SN` varchar(32) NOT NULL DEFAULT '',
  `DEC_SN` varchar(32) DEFAULT '',
  `USER_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `ORDER_TYPE` varchar(12) NOT NULL,
  `ORDER_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AT` int(10) NOT NULL DEFAULT '0',
  `FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `PAY_FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `DELIVERY_STATUS` tinyint(2) NOT NULL DEFAULT '0',
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_AT` int(10) NOT NULL DEFAULT '0',
  `EXPRESS_COMPANY` varchar(128) DEFAULT '',
  `ORDER_TRACK_NO` varchar(32) DEFAULT '',
  `EXPRESS_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `FRONT_REMARK` varchar(1000) DEFAULT '',
  `REMARK` text DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `STATUS` int(3) NOT NULL DEFAULT '0',
  `CONSIGNEE` varchar(120) DEFAULT '',
  `MOBILE` varchar(11) DEFAULT '',
  `TEL` varchar(16) DEFAULT '',
  `PROVINCE` int(6) NOT NULL DEFAULT '0',
  `CITY` int(6) NOT NULL DEFAULT '0',
  `COUNTY` int(9) NOT NULL DEFAULT '0',
  `ADDRESS` varchar(255) NOT NULL DEFAULT '',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `CREATE_USER` varchar(16) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATER` varchar(16) DEFAULT '',
  `IS_DELETE` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `PAY_TYPE` varchar(32) NOT NULL DEFAULT 'cash',
  `WAREHOUSE` varchar(16) NOT NULL DEFAULT '01',
  PRIMARY KEY (`ID`),
  KEY `SN` (`SN`),
  KEY `USER_ID` (`USER_ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_DELETE` (`IS_DELETE`),
  KEY `ORDER_TYPE` (`ORDER_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ORDER_GOODS`
--

DROP TABLE IF EXISTS `AR_ORDER_GOODS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ORDER_GOODS` (
  `ID` varchar(32) NOT NULL,
  `ORDER_SN` varchar(32) NOT NULL,
  `GOODS_ID` varchar(32) NOT NULL,
  `GOODS_TITLE` varchar(255) NOT NULL,
  `PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SKU_CODE` varchar(16) NOT NULL,
  `BUY_NUMS` int(10) NOT NULL DEFAULT '0',
  `P_CALC_MONTH` date NOT NULL,
  `POINT` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `GOODS_ID` (`GOODS_ID`),
  KEY `ORDER_SN` (`ORDER_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='订单中包含的商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ORDER_GOODS_SHOP`
--

DROP TABLE IF EXISTS `AR_ORDER_GOODS_SHOP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ORDER_GOODS_SHOP` (
  `ID` varchar(32) NOT NULL,
  `ORDER_SN` varchar(32) NOT NULL,
  `GOODS_TITLE` varchar(255) NOT NULL,
  `PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PRICE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SKU_CODE` varchar(16) NOT NULL,
  `BUY_NUMS` int(10) NOT NULL DEFAULT '0',
  `P_CALC_MONTH` date NOT NULL,
  `POINT` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ORDER_SN` (`ORDER_SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='订单中包含的商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_ORDER_SHOP`
--

DROP TABLE IF EXISTS `AR_ORDER_SHOP`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_ORDER_SHOP` (
  `ID` varchar(32) NOT NULL,
  `SN` varchar(32) NOT NULL DEFAULT '',
  `DEC_SN` varchar(32) DEFAULT '',
  `USER_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `ORDER_TYPE` varchar(12) NOT NULL,
  `ORDER_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PAY_AT` int(10) NOT NULL DEFAULT '0',
  `FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `PAY_FREIGHT` float(10,2) NOT NULL DEFAULT '0.00',
  `DELIVERY_STATUS` tinyint(2) NOT NULL DEFAULT '0',
  `DELIVERY_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DELIVERY_AT` int(10) NOT NULL DEFAULT '0',
  `EXPRESS_COMPANY` varchar(128) DEFAULT '',
  `ORDER_TRACK_NO` varchar(32) DEFAULT '',
  `EXPRESS_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `FRONT_REMARK` varchar(1000) DEFAULT '',
  `REMARK` text DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `STATUS` int(3) NOT NULL DEFAULT '0',
  `CONSIGNEE` varchar(120) DEFAULT '',
  `MOBILE` varchar(11) DEFAULT '',
  `TEL` varchar(16) DEFAULT '',
  `PROVINCE` varchar(32) DEFAULT '0',
  `CITY` varchar(32) DEFAULT '0',
  `COUNTY` varchar(32) DEFAULT '0',
  `ADDRESS` varchar(255) DEFAULT '',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `CREATE_USER` varchar(16) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATER` varchar(16) DEFAULT '',
  `IS_DELETE` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `PAY_TYPE` varchar(32) NOT NULL DEFAULT 'cash',
  `WAREHOUSE` varchar(16) NOT NULL DEFAULT '01',
  PRIMARY KEY (`ID`),
  KEY `SN` (`SN`),
  KEY `USER_ID` (`USER_ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_DELETE` (`IS_DELETE`),
  KEY `ORDER_TYPE` (`ORDER_TYPE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品订单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERF_AUDIT`
--

DROP TABLE IF EXISTS `AR_PERF_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERF_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PV_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_LS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERF_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `PERF_LOCATION` tinyint(1) NOT NULL DEFAULT '1',
  `PERF_BEFORE` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERF_AFTER` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) DEFAULT '',
  `REMARK` text DEFAULT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='调整业绩审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERF_COMPANY`
--

DROP TABLE IF EXISTS `AR_PERF_COMPANY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERF_COMPANY` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `PV` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '月总业绩',
  `CALC_YEAR` int(10) NOT NULL COMMENT '结算年',
  `CALC_MONTH` int(10) NOT NULL COMMENT '结算月',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`),
  KEY `CALC_YEAR` (`CALC_YEAR`),
  KEY `CALC_MONTH` (`CALC_MONTH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='公司总业绩';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERF_MONTH`
--

DROP TABLE IF EXISTS `AR_PERF_MONTH`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERF_MONTH` (
  `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 '个人消费',
  `PV_PCS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场业绩',
  `PV_1L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场业绩',
  `PV_2L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场业绩',
  `PV_3L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场业绩',
  `PV_4L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场业绩',
  `PV_5L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场历史累计加该月业绩',
  `PV_1L_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场历史累计加该月业绩',
  `PV_2L_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场历史累计加该月业绩',
  `PV_3L_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场历史累计加该月业绩',
  `PV_4L_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场历史累计加该月业绩',
  `PV_5L_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场历史累计加该月业绩',
  `CF_PERCENT` int(10) NOT NULL DEFAULT '0' COMMENT '车房养老奖分工系数',
  `LX_PERCENT` int(10) NOT NULL DEFAULT '0' COMMENT '领袖分红分工系数',
  `FX_STATUS` tinyint(1) NOT NULL DEFAULT '0' COMMENT '本月复销状态作为下月发奖资格',
  `CALC_MONTH` int(10) NOT NULL COMMENT '结算月',
  `P_CALC_MONTH` date NOT NULL COMMENT '表分区日期索引',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `PV_PSS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PV_PSS_TOTAL` decimal(16,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `CALC_MONTH` (`CALC_MONTH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='月业绩记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERF_ORDER`
--

DROP TABLE IF EXISTS `AR_PERF_ORDER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERF_ORDER` (
  `ID` varchar(32) NOT NULL,
  `SN` varchar(32) NOT NULL,
  `DEC_SN` varchar(32) DEFAULT NULL,
  `DEC_TYPE` varchar(32) NOT NULL,
  `DEC_STATUS` tinyint(1) DEFAULT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `LAST_DEC_LV` varchar(32) DEFAULT '',
  `LAST_EMP_LV` varchar(32) DEFAULT '',
  `LAST_STATUS` tinyint(1) DEFAULT '0',
  `LAST_REC_USER_NAME` varchar(16) DEFAULT '',
  `LAST_REC_REAL_NAME` varchar(128) DEFAULT '',
  `PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `DEC_AMOUNT` float(16,2) NOT NULL DEFAULT '0.00',
  `LAST_SUB_COM_ID` varchar(32) DEFAULT '',
  `LAST_PROVINCE` int(6) DEFAULT '0',
  `LAST_CITY` int(6) DEFAULT '0',
  `LAST_COUNTY` int(9) DEFAULT '0',
  `DEC_USER_ID` varchar(32) DEFAULT '',
  `LAST_DEC_DEC_LV` varchar(32) DEFAULT '',
  `LAST_DEC_SUB_COM_ID` varchar(32) DEFAULT '',
  `LAST_DEC_PROVINCE` int(6) DEFAULT '0',
  `LAST_DEC_CITY` int(6) DEFAULT '0',
  `LAST_DEC_COUNTY` int(9) DEFAULT '0',
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `CLOSED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SN` (`SN`),
  KEY `USER_ID` (`USER_ID`),
  KEY `DEC_USER_ID` (`DEC_USER_ID`),
  KEY `DEC_TYPE` (`DEC_TYPE`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='业绩单';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERF_PERIOD`
--

DROP TABLE IF EXISTS `AR_PERF_PERIOD`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERF_PERIOD` (
  `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 '结算时会有状态',
  `PV_PCS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费',
  `PV_PCS_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费注册单',
  `PV_PCS_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费优惠单',
  `PV_PCS_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费增购单',
  `PV_PCS_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费零售单',
  `PV_PCS_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '个人消费复销单',
  `PV_1L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场业绩',
  `PV_1L_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场对碰业绩',
  `PV_1L_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场注册单业绩',
  `PV_1L_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场优惠单业绩',
  `PV_1L_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场增购单业绩',
  `PV_1L_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场零售单业绩',
  `PV_1L_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场复销单业绩',
  `PV_2L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场业绩',
  `PV_2L_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场对碰业绩',
  `PV_2L_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场注册单业绩',
  `PV_2L_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场优惠单业绩',
  `PV_2L_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场增购单业绩',
  `PV_2L_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场零售单业绩',
  `PV_2L_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场复销单业绩',
  `PV_3L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场业绩',
  `PV_3L_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场对碰业绩',
  `PV_3L_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场优惠单业绩',
  `PV_3L_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场优惠单业绩',
  `PV_3L_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场增购单业绩',
  `PV_3L_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场零售单业绩',
  `PV_3L_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场复销单业绩',
  `PV_4L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场业绩',
  `PV_4L_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场对碰业绩',
  `PV_4L_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场优惠单业绩',
  `PV_4L_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场优惠单业绩',
  `PV_4L_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场增购单业绩',
  `PV_4L_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场零售单业绩',
  `PV_4L_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场复销单业绩',
  `PV_5L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场业绩',
  `PV_5L_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场对碰业绩',
  `PV_5L_ZC` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场优惠单业绩',
  `PV_5L_YH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场优惠单业绩',
  `PV_5L_ZG` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场增购单业绩',
  `PV_5L_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场零售单业绩',
  `PV_5L_FX` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场复销单业绩',
  `PV_LS_TOUCH` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '隐藏零售区业绩30%后的',
  `SURPLUS_1L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '一市场结余业绩',
  `SURPLUS_2L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '二市场结余业绩',
  `SURPLUS_3L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '三市场结余业绩',
  `SURPLUS_4L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '四市场结余业绩',
  `SURPLUS_5L` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '五市场结余业绩',
  `SURPLUS_LS` decimal(16,3) NOT NULL DEFAULT '0.000' COMMENT '零售隐藏区结余业绩',
  `PERIOD_NUM` int(10) NOT NULL COMMENT '期数',
  `CALC_MONTH` int(10) NOT NULL COMMENT '结算月YYYYMM',
  `P_CALC_MONTH` date NOT NULL COMMENT '表分区日期索引',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `PV_PSS` decimal(16,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `CALC_MONTH` (`CALC_MONTH`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='业绩记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_PERIOD`
--

DROP TABLE IF EXISTS `AR_PERIOD`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_PERIOD` (
  `ID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` tinyint(2) NOT NULL,
  `CALC_YEAR` int(4) NOT NULL,
  `START_TIME` int(10) NOT NULL,
  `END_TIME` int(10) NOT NULL,
  `IS_MONTH` tinyint(1) NOT NULL DEFAULT '0',
  `IS_YEAR` tinyint(1) NOT NULL DEFAULT '0',
  `IS_CLOSED` tinyint(1) NOT NULL DEFAULT '0',
  `IS_PERFED` tinyint(1) NOT NULL DEFAULT '0',
  `IS_CALCULATED` tinyint(1) NOT NULL DEFAULT '0',
  `IS_SENT` tinyint(1) NOT NULL DEFAULT '0',
  `IS_PERFING` tinyint(1) NOT NULL DEFAULT '0',
  `IS_CALCING` tinyint(1) NOT NULL DEFAULT '0',
  `IS_SENDING` tinyint(1) NOT NULL DEFAULT '0',
  `PERF_PERCENT` int(3) NOT NULL DEFAULT '0',
  `CALC_PERCENT` int(3) NOT NULL DEFAULT '0',
  `SENT_PERCENT` int(3) NOT NULL DEFAULT '0',
  `PERF_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CLOSE_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CALC_ADMIN_ID` varchar(32) DEFAULT NULL,
  `SENT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `CLOSED_AT` int(10) DEFAULT NULL,
  `PERF_STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `PERFED_AT` int(10) NOT NULL DEFAULT '0',
  `CALCULATE_STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `CALCULATED_AT` int(10) NOT NULL DEFAULT '0',
  `SEND_STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `SENT_AT` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_CLOSED` (`IS_CLOSED`),
  KEY `IS_PERFED` (`IS_PERFED`),
  KEY `IS_CALCULATED` (`IS_CALCULATED`),
  KEY `IS_SENT` (`IS_SENT`),
  KEY `IS_PERFING` (`IS_PERFING`),
  KEY `IS_CALCING` (`IS_CALCING`),
  KEY `IS_SENDING` (`IS_SENDING`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='期数';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_RECEIVE_ADDRESS`
--

DROP TABLE IF EXISTS `AR_RECEIVE_ADDRESS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_RECEIVE_ADDRESS` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `CONSIGNEE` varchar(120) NOT NULL,
  `MOBILE` varchar(11) NOT NULL,
  `PROVINCE` int(6) NOT NULL,
  `CITY` int(6) NOT NULL,
  `COUNTY` int(6) NOT NULL,
  `ADDRESS` varchar(255) NOT NULL,
  `IS_DEFAULT` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATER` varchar(10) DEFAULT '',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `USER_NAME` (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='收货地址';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_RECHARGE`
--

DROP TABLE IF EXISTS `AR_RECHARGE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_RECHARGE` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `SN` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `ID_CARD` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `RECHARGE_PERIOD_NUM` int(10) DEFAULT NULL,
  `RECHARGE_YEAR` int(4) DEFAULT NULL,
  `RECHARGE_MONTH` tinyint(2) DEFAULT NULL,
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_NAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OPEN_BANK` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_ADDRESS` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_NO` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_PROVINCE` int(6) DEFAULT NULL,
  `BANK_CITY` int(6) DEFAULT NULL,
  `BANK_COUNTY` int(9) DEFAULT NULL,
  `P_MONTH` date NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `BANK_PROVE` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `REMARK` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `AUDIT_ADMIN` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SN` (`SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='充值申请';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_REGION`
--

DROP TABLE IF EXISTS `AR_REGION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_REGION` (
  `ID` varchar(32) NOT NULL,
  `REGION_CODE` int(9) NOT NULL DEFAULT '0',
  `DEEP` tinyint(2) NOT NULL DEFAULT '0',
  `REGION_NAME` varchar(128) NOT NULL DEFAULT '',
  `PID` int(9) NOT NULL DEFAULT '0',
  `AREA_CODE` varchar(6) NOT NULL DEFAULT '',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATER` varchar(16) DEFAULT '',
  `ADM_NAME` varchar(16) NOT NULL DEFAULT '',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `REGION_CODE` (`REGION_CODE`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='地区';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_REG_INFO_AUDIT`
--

DROP TABLE IF EXISTS `AR_REG_INFO_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_REG_INFO_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `REG_TYPE` varchar(32) NOT NULL,
  `REG_NAME` varchar(255) NOT NULL,
  `CREDIT_CODE` varchar(255) NOT NULL,
  `PREMISES` varchar(255) DEFAULT NULL,
  `LEGAL_PERSON` varchar(255) DEFAULT NULL,
  `REG_EXPIRES` int(10) NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATE_PERIOD` int(10) NOT NULL DEFAULT '0',
  `AUDIT_PERIOD` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `REG_TYPE` (`REG_TYPE`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员注册信息审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_REG_TYPE`
--

DROP TABLE IF EXISTS `AR_REG_TYPE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_REG_TYPE` (
  `ID` varchar(32) NOT NULL,
  `TYPE_NAME` varchar(48) NOT NULL,
  `IS_PACT` tinyint(1) NOT NULL DEFAULT '1',
  `MONTH_LIMIT_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `YEAR_LIMIT_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SORT` int(10) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) DEFAULT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `REMARK` varchar(255) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `TYPE_NAME` (`TYPE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='聘级';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_RESEND_QY`
--

DROP TABLE IF EXISTS `AR_RESEND_QY`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_RESEND_QY` (
  `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',
  `LAST_SUB_COM_ID` varchar(32) DEFAULT '',
  `LAST_PROVINCE` int(6) DEFAULT '0',
  `LAST_CITY` int(6) DEFAULT '0',
  `LAST_COUNTY` int(6) DEFAULT '0',
  `LAST_SYSTEM_ID` varchar(32) NOT NULL,
  `BONUS_QY` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SHOULD_QY` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_1L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_2L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_3L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_4L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_5L` decimal(16,3) NOT NULL DEFAULT '0.000',
  `QY_LS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `SURPLUS_LS` 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,
  `RESEND_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `RESEND_AUDIT_ID` varchar(32) DEFAULT NULL,
  `RESEND_AUDIT_STATUS` tinyint(1) DEFAULT '0',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='总奖金结算记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_RESEND_QY_AUDIT`
--

DROP TABLE IF EXISTS `AR_RESEND_QY_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_RESEND_QY_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `RESEND_ID` varchar(32) NOT NULL,
  `SHOULD_BONUS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `RESEND_BONUS` decimal(16,3) NOT NULL DEFAULT '0.000',
  `PERIOD_NUM` int(10) NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `RESEND_ADMIN_ID` varchar(32) NOT NULL,
  `AUDIT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `RESEND_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='补发区域津贴审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_SHOP_GOODS`
--

DROP TABLE IF EXISTS `AR_SHOP_GOODS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_SHOP_GOODS` (
  `ID` varchar(32) NOT NULL,
  `GOODS_NAME` varchar(255) NOT NULL,
  `CATE_ID` varchar(32) NOT NULL,
  `TYPE` tinyint(2) NOT NULL DEFAULT '1',
  `GOODS_NO` varchar(32) NOT NULL,
  `UNIT` varchar(16) NOT NULL,
  `COVER` varchar(255) NOT NULL,
  `IMAGES` text DEFAULT NULL,
  `CONTENT` text NOT NULL,
  `SELL_PRICE` float(16,2) NOT NULL DEFAULT '0.00',
  `MARKET_PRICE` float(16,2) NOT NULL DEFAULT '0.00',
  `PRICE_PV` float(16,2) NOT NULL DEFAULT '0.00',
  `STORE_NUMS` int(10) NOT NULL DEFAULT '0',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `SORT` int(10) NOT NULL DEFAULT '0',
  `IS_DEL` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `POINT` int(10) unsigned NOT NULL DEFAULT '0',
  `SELL_TYPE` varchar(32) NOT NULL DEFAULT '1,2',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='商品';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_SMS_API`
--

DROP TABLE IF EXISTS `AR_SMS_API`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_SMS_API` (
  `ID` varchar(32) NOT NULL,
  `API_NAME` varchar(48) NOT NULL,
  `DESCRIPTION` varchar(255) NOT NULL,
  `CONFIG` text DEFAULT NULL,
  `STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `API_NAME` (`API_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='SMS短信接口表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_SMS_TEMPLATE`
--

DROP TABLE IF EXISTS `AR_SMS_TEMPLATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_SMS_TEMPLATE` (
  `ID` varchar(32) NOT NULL,
  `TITLE` varchar(32) NOT NULL,
  `DESCRIPTION` varchar(255) NOT NULL,
  `FIELD` varchar(255) NOT NULL,
  `DEC_LEVEL` varchar(32) DEFAULT NULL,
  `EMP_LEVEL` varchar(32) DEFAULT NULL,
  `CONTENT` varchar(255) NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='短信模板';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TASK_QUEUE`
--

DROP TABLE IF EXISTS `AR_TASK_QUEUE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TASK_QUEUE` (
  `ID` varchar(32) NOT NULL,
  `MAIN_ID` varchar(32) NOT NULL,
  `TYPE` int(10) NOT NULL DEFAULT '1',
  `CONTENT` varchar(255) NOT NULL,
  `PARAMS` text NOT NULL,
  `TOTAL_LOOP` int(10) NOT NULL DEFAULT '0',
  `DONE_TIMES` int(10) NOT NULL DEFAULT '0',
  `LOOP_TYPE` int(10) NOT NULL DEFAULT '0',
  `LOOP_CYCLE_CONTENT` varchar(255) DEFAULT NULL,
  `NEXT_AT` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `FINISHED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='任务队列列表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TMP_FREEZE_USER`
--

DROP TABLE IF EXISTS `AR_TMP_FREEZE_USER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TMP_FREEZE_USER` (
  `ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(128) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='冻结会员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TMP_OLD_NETWORK`
--

DROP TABLE IF EXISTS `AR_TMP_OLD_NETWORK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TMP_OLD_NETWORK` (
  `ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(128) NOT NULL,
  `PARENT_USER_NAME` varchar(16) NOT NULL,
  `PARENT_REAL_NAME` varchar(128) NOT NULL,
  `NET_USER_NAME` varchar(16) NOT NULL,
  `NET_REAL_NAME` varchar(128) NOT NULL,
  `SORT` int(10) unsigned NOT NULL DEFAULT '0',
  `NET_DEEP` int(10) unsigned NOT NULL DEFAULT '0',
  `REC_DEEP` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `PARENT_USER_NAME` (`PARENT_USER_NAME`),
  KEY `NET_USER_NAME` (`NET_USER_NAME`),
  KEY `SORT` (`SORT`),
  KEY `NET_DEEP` (`NET_DEEP`),
  KEY `REC_DEEP` (`REC_DEEP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='老系统会员关系临时表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TMP_OLD_NETWORK_ERROR`
--

DROP TABLE IF EXISTS `AR_TMP_OLD_NETWORK_ERROR`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TMP_OLD_NETWORK_ERROR` (
  `ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(128) NOT NULL,
  `PARENT_USER_NAME` varchar(16) NOT NULL,
  `PARENT_REAL_NAME` varchar(128) NOT NULL,
  `NET_USER_NAME` varchar(16) NOT NULL,
  `NET_REAL_NAME` varchar(128) NOT NULL,
  `SORT` int(10) unsigned NOT NULL DEFAULT '0',
  `NET_DEEP` int(10) unsigned NOT NULL DEFAULT '0',
  `REC_DEEP` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `PARENT_USER_NAME` (`PARENT_USER_NAME`),
  KEY `NET_USER_NAME` (`NET_USER_NAME`),
  KEY `SORT` (`SORT`),
  KEY `NET_DEEP` (`NET_DEEP`),
  KEY `REC_DEEP` (`REC_DEEP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='补充会员表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TMP_OLD_USER`
--

DROP TABLE IF EXISTS `AR_TMP_OLD_USER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TMP_OLD_USER` (
  `ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `REAL_NAME` varchar(128) NOT NULL,
  `REC_USER_NAME` varchar(16) NOT NULL,
  `REC_REAL_NAME` varchar(128) NOT NULL,
  `NET_USER_NAME` varchar(16) NOT NULL,
  `NET_REAL_NAME` varchar(128) NOT NULL,
  `SORT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_NAME` (`USER_NAME`),
  KEY `REC_USER_NAME` (`REC_USER_NAME`),
  KEY `NET_USER_NAME` (`NET_USER_NAME`),
  KEY `SORT` (`SORT`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='老系统会员关系临时表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_TRANSFER`
--

DROP TABLE IF EXISTS `AR_TRANSFER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_TRANSFER` (
  `ID` varchar(32) NOT NULL,
  `TRANSFER_SN` varchar(32) NOT NULL,
  `OUT_UID` varchar(32) NOT NULL,
  `LAST_OUT_USER_NAME` varchar(16) NOT NULL,
  `LAST_OUT_REAL_NAME` varchar(128) NOT NULL,
  `LAST_OUT_DEC_LV` varchar(32) DEFAULT '',
  `LAST_OUT_DEC_ROLE_ID` varchar(32) DEFAULT '',
  `OUT_WALLET` varchar(128) NOT NULL DEFAULT 'bonus',
  `LAST_OUT_SYSTEM_ID` varchar(32) NOT NULL,
  `IN_UID` varchar(32) NOT NULL,
  `LAST_IN_USER_NAME` varchar(16) NOT NULL,
  `LAST_IN_REAL_NAME` varchar(128) NOT NULL,
  `LAST_IN_DEC_LV` varchar(32) DEFAULT '',
  `IN_WALLET` varchar(128) NOT NULL DEFAULT 'bonus',
  `LAST_IN_SYSTEM_ID` varchar(32) NOT NULL,
  `ORI_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `FEE` decimal(16,3) NOT NULL DEFAULT '0.000',
  `AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  `REMARK` text DEFAULT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='转账记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_UPLOADS`
--

DROP TABLE IF EXISTS `AR_UPLOADS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_UPLOADS` (
  `ID` varchar(32) NOT NULL,
  `FILE_NAME` varchar(255) NOT NULL,
  `CATEGORY` varchar(255) NOT NULL,
  `REMARK` varchar(255) DEFAULT NULL,
  `URL` varchar(1000) NOT NULL,
  `FILE_SIZE` varchar(255) DEFAULT NULL,
  `MD5` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `CATEGORY` (`CATEGORY`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='上传文件表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER`
--

DROP TABLE IF EXISTS `AR_USER`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER` (
  `ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `PASSWORD_HASH` varchar(255) NOT NULL,
  `PAY_PASSWORD` varchar(255) NOT NULL,
  `NATION` tinyint(2) NOT NULL DEFAULT '0',
  `REAL_NAME` varchar(128) NOT NULL,
  `ID_CARD` varchar(18) NOT NULL,
  `ID_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `MOBILE` varchar(11) DEFAULT '',
  `ADDRESS` varchar(2000) DEFAULT '',
  `ID_IMAGE` varchar(255) DEFAULT '',
  `OPEN_BANK` varchar(32) DEFAULT '',
  `BANK_ADDRESS` varchar(255) DEFAULT '',
  `BANK_NO` varchar(32) DEFAULT '',
  `BANK_PROVINCE` int(6) DEFAULT '0',
  `BANK_CITY` int(6) DEFAULT '0',
  `BANK_COUNTY` int(9) DEFAULT '0',
  `SPOUSE_NAME` varchar(16) DEFAULT '',
  `SPOUSE_IDCARD` varchar(18) DEFAULT '',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `STATUS` tinyint(1) NOT NULL DEFAULT '1',
  `DEC_CLOSED` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_CLOSED_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_LV` varchar(32) DEFAULT '',
  `EMP_LV` varchar(32) DEFAULT '',
  `PROVINCE` int(6) NOT NULL DEFAULT '0',
  `CITY` int(6) NOT NULL DEFAULT '0',
  `COUNTY` int(9) NOT NULL DEFAULT '0',
  `TEL` varchar(16) DEFAULT '',
  `LOGIN_TIMES` int(10) NOT NULL DEFAULT '0',
  `LOGIN_IP` varchar(15) DEFAULT '',
  `LOGIN_AT` int(10) NOT NULL DEFAULT '0',
  `PULL_MESSAGE_AT` int(10) NOT NULL DEFAULT '0',
  `SUB_COM_ID` varchar(32) DEFAULT '',
  `AVATAR` varchar(255) NOT NULL,
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `ALLOW_TRANSFER` tinyint(1) NOT NULL DEFAULT '1',
  `TRANSFER_PROP` float(10,2) NOT NULL DEFAULT '0.00',
  `PARTITION_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `IS_DEC` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_ID` varchar(32) NOT NULL DEFAULT '1',
  `BIRTHDAY` date DEFAULT '1990-09-09',
  `DEC_ROLE_ID` varchar(32) DEFAULT '',
  `PERIOD_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_PROVINCE` int(6) NOT NULL DEFAULT '0',
  `DEC_CITY` int(6) NOT NULL DEFAULT '0',
  `DEC_COUNTY` int(9) NOT NULL DEFAULT '0',
  `IS_UNION` tinyint(1) NOT NULL DEFAULT '0',
  `STATUS_AT` int(10) NOT NULL DEFAULT '0',
  `VERIFIED` tinyint(1) NOT NULL DEFAULT '0',
  `VERIFIED_AT` int(10) NOT NULL DEFAULT '0',
  `ALLOW_LOGIN` tinyint(1) NOT NULL DEFAULT '1',
  `NOT_OPERATING` tinyint(1) NOT NULL DEFAULT '0',
  `REG_FROM` tinyint(1) NOT NULL DEFAULT '1',
  `ID_CARD_PREFIX` varchar(32) DEFAULT '',
  `ALLOW_BONUS_LOGIN` tinyint(1) NOT NULL DEFAULT '1',
  `SEX` varchar(32) DEFAULT '',
  `DEC_ACCOUNT_OLD` varchar(64) DEFAULT '',
  `BANK_UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `IS_DIRECT_SELLER` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_LV_UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_LV_UPDATED_PERIOD` int(10) NOT NULL DEFAULT '0',
  `DEC_ADDRESS` varchar(2000) DEFAULT '',
  `DEC_PHONE` varchar(32) DEFAULT '',
  `GUARANTOR` varchar(32) DEFAULT '',
  `GUARANTOR_NAME` varchar(64) DEFAULT '',
  `PART_FUNC_CLOSED` tinyint(1) NOT NULL DEFAULT '0',
  `LAST_DEC_LV_UPDATED_PERIOD` int(10) NOT NULL DEFAULT '0',
  `USER_CREATOR` varchar(32) DEFAULT '',
  `USER_UPDATER` varchar(32) DEFAULT '',
  `LAST_DEC_LV_UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `DEC_CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `PART_FUNC_CLOSED_REMARK` text DEFAULT NULL,
  `DEC_CREATED_PERIOD` int(10) NOT NULL DEFAULT '0',
  `PASSWORD_CHANGED` tinyint(1) NOT NULL DEFAULT '0',
  `SUB_COM_LEADER` tinyint(1) NOT NULL DEFAULT '0',
  `LOGIN_FAIL_TIMES` int(10) NOT NULL DEFAULT '0',
  `ZG_UPGRADE_PV` decimal(16,2) NOT NULL DEFAULT '0.00',
  `APP_CLIENT_ID` varchar(128) DEFAULT '',
  `READ_AGREEMENT` tinyint(1) NOT NULL DEFAULT '1',
  `LAST_DEC_LV` varchar(32) DEFAULT '',
  `BONUS_APP_CLIENT_ID` varchar(128) DEFAULT '',
  `IS_FIRST_OPEN` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_NAME` (`USER_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_BIND`
--

DROP TABLE IF EXISTS `AR_USER_BIND`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_BIND` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `MAIN_UID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `IS_DEL` int(10) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) DEFAULT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_USER` varchar(32) DEFAULT NULL,
  `UPDATE_USER` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `MAIN_UID` (`MAIN_UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='点位合作';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_BONUS`
--

DROP TABLE IF EXISTS `AR_USER_BONUS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_BONUS` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `BONUS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BONUS_FREEZE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CF` decimal(16,2) NOT NULL DEFAULT '0.00',
  `LX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `QY_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `YC_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `FX_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `LS_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `FW_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BT_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BT_PROD_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BT_TOOL_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CF_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `LX_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `DEDUCT_ZR_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `FL_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `VER` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `BD_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `TG_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `YJ_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `GX_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `GL_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `RECONSUME_POINTS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `RECONSUME_POINTS_EXPIRED` decimal(16,2) NOT NULL DEFAULT '0.00',
  `RECONSUME_POINTS_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `MANAGE_TAX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_QY_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_YC_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_BD_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_TG_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_YJ_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_GX_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `ORI_GL_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  `BONUS_TOTAL` decimal(16,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员奖金表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_CLOSE`
--

DROP TABLE IF EXISTS `AR_USER_CLOSE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_CLOSE` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `TYPE` tinyint(1) NOT NULL DEFAULT '1',
  `IS_MANUAL` tinyint(1) NOT NULL DEFAULT '0',
  `PERIOD_NUM` int(10) NOT NULL,
  `IS_CLOSE` tinyint(1) NOT NULL DEFAULT '1',
  `REMARK` varchar(255) NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `ADMIN_ID` varchar(32) DEFAULT NULL,
  `AUDIT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `AUDITED_AT` int(10) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `TYPE` (`TYPE`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `IS_CLOSE` (`IS_CLOSE`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员关停和停发表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_INFO`
--

DROP TABLE IF EXISTS `AR_USER_INFO`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_INFO` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `USER_NAME` varchar(16) NOT NULL,
  `ZC_PV` decimal(16,3) NOT NULL DEFAULT '0.000',
  `CON_UID` varchar(32) NOT NULL,
  `REC_UID` varchar(32) NOT NULL,
  `CON_NUM` int(10) NOT NULL DEFAULT '0',
  `REC_NUM` int(10) NOT NULL DEFAULT '0',
  `NETWORK_DEEP` int(10) NOT NULL DEFAULT '0',
  `RELATION_DEEP` int(10) NOT NULL DEFAULT '0',
  `SYSTEM_ID` varchar(32) DEFAULT NULL,
  `IS_GROUP_LEADER` tinyint(1) NOT NULL DEFAULT '0',
  `IS_SYSTEM_LEADER` tinyint(1) NOT NULL DEFAULT '0',
  `IS_TEAM` tinyint(1) NOT NULL DEFAULT '0',
  `IS_BIND` tinyint(1) NOT NULL DEFAULT '0',
  `IS_TEAM_MAIN` tinyint(1) NOT NULL DEFAULT '0',
  `IS_BIND_MAIN` tinyint(1) NOT NULL DEFAULT '0',
  `IS_AUTO_WITHDRAW` tinyint(1) NOT NULL DEFAULT '0',
  `CLOSE_LOGIN` tinyint(1) NOT NULL DEFAULT '0',
  `REG_TYPE` varchar(32) NOT NULL DEFAULT '56D9181C0F5D428FA2DBD4CAB263BF2F',
  `SHOULD_REG_TYPE` varchar(32) DEFAULT '56D9181C0F5D428FA2DBD4CAB263BF2F',
  `REG_NAME` varchar(255) DEFAULT NULL,
  `CREDIT_CODE` varchar(255) DEFAULT NULL,
  `PREMISES` varchar(255) DEFAULT NULL,
  `LEGAL_PERSON` varchar(255) DEFAULT NULL,
  `REG_EXPIRES` int(10) DEFAULT NULL,
  `STORE_TYPE` tinyint(1) NOT NULL DEFAULT '0',
  `INVOICE_BALANCE` decimal(16,2) NOT NULL DEFAULT '0.00',
  `HIGHEST_EMP_LV` varchar(32) DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `CLOSE_LOGIN_AT` int(10) NOT NULL DEFAULT '0',
  `PULLED_AT` int(10) NOT NULL DEFAULT '0',
  `DELETED` tinyint(1) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  `GROUP_LEADER_AT` int(10) NOT NULL DEFAULT '0',
  `ALLOW_TRANSFER` tinyint(1) NOT NULL DEFAULT '1',
  `ALLOW_RECONSUME_SMS` tinyint(1) NOT NULL DEFAULT '0',
  `ALLOW_RECONSUME_SMS_TO` int(10) NOT NULL DEFAULT '0',
  `HIGHEST_EMP_LV_PERIOD` int(10) NOT NULL DEFAULT '1',
  `TRANSFER_PROP` float(10,2) NOT NULL DEFAULT '100.00',
  `LOGIN_NUMS` int(10) NOT NULL DEFAULT '0',
  `FAIL_NUMS` int(10) NOT NULL DEFAULT '0',
  `LAST_LOGIN_IP` varchar(16) NOT NULL DEFAULT '0.0.0.0',
  `LAST_LOGIN_AT` int(10) NOT NULL DEFAULT '0',
  `SHOW_EMP_LV` varchar(32) DEFAULT '',
  `ZC_AMOUNT` decimal(16,3) NOT NULL DEFAULT '0.000',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_ID` (`USER_ID`),
  KEY `USER_NAME_DELETED` (`USER_NAME`,`DELETED`),
  KEY `NETWORK_DEEP` (`NETWORK_DEEP`),
  KEY `RELATION_DEEP` (`RELATION_DEEP`),
  KEY `REC_UID` (`REC_UID`),
  KEY `CON_UID` (`CON_UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员资料表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_MOVE`
--

DROP TABLE IF EXISTS `AR_USER_MOVE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_MOVE` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `USER_TOP_DEEP` int(10) unsigned NOT NULL DEFAULT '0',
  `FROM_UID` varchar(32) NOT NULL,
  `TO_UID` varchar(32) NOT NULL,
  `LOCATION` tinyint(1) NOT NULL DEFAULT '0',
  `TYPE` varchar(48) NOT NULL,
  `IS_MOVING` tinyint(1) NOT NULL DEFAULT '0',
  `MOVE_PERCENT` int(3) NOT NULL DEFAULT '0',
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `PERIOD_NUM` int(10) NOT NULL,
  `UPDATE_PERIOD_NUM` int(10) DEFAULT NULL,
  `AUDIT_PERIOD_NUM` int(10) DEFAULT NULL,
  `MOVE_ADMIN_ID` varchar(32) NOT NULL,
  `AUDIT_ADMIN_ID` varchar(32) DEFAULT NULL,
  `NET_TABLE_NAME` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `STARTED_AT` int(10) NOT NULL DEFAULT '0',
  `ENDED_AT` int(10) NOT NULL DEFAULT '0',
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员移网记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_NETWORK`
--

DROP TABLE IF EXISTS `AR_USER_NETWORK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_NETWORK` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PARENT_UID` varchar(32) NOT NULL,
  `LOCATION` tinyint(1) NOT NULL,
  `TOP_UID` varchar(32) NOT NULL,
  `TOP_DEEP` int(10) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `LOCATION` (`LOCATION`),
  KEY `TOP_DEEP` (`TOP_DEEP`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='安置关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_NETWORK_NEW`
--

DROP TABLE IF EXISTS `AR_USER_NETWORK_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_NETWORK_NEW` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `PARENT_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '安置人ID',
  `LOCATION_TAG` varchar(5000) COLLATE utf8mb4_general_ci NOT NULL COMMENT '网体标记',
  `RELATIVE_LOCATION` tinyint(1) NOT NULL DEFAULT '0' COMMENT '相对父级的区位',
  `TOP_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '顶级会员ID',
  `TOP_DEEP` int(10) NOT NULL DEFAULT '0' COMMENT '总网体中层数',
  `PARENT_UIDS` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '所有上级ID',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_ID` (`USER_ID`),
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `TOP_DEEP` (`TOP_DEEP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='新安置关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_PERF`
--

DROP TABLE IF EXISTS `AR_USER_PERF`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_PERF` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PV_PCS_ZC` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_YH` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_ZG` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_LS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_FX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_1L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_2L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_3L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_4L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_5L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CREATED_AT` int(10) NOT NULL,
  `PV_PSS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SURPLUS_1L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_2L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_3L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_4L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_5L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `PV_PSS_TOTAL` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员累计业绩表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_PERF_NEW`
--

DROP TABLE IF EXISTS `AR_USER_PERF_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_PERF_NEW` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PV_PCS_ZC` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_YH` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_ZG` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_LS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_PCS_FX` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_1L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_2L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_3L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_4L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PV_5L` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CREATED_AT` int(10) NOT NULL,
  `PV_PSS` decimal(16,2) NOT NULL DEFAULT '0.00',
  `SURPLUS_1L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_2L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_3L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_4L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `SURPLUS_5L` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  `PV_PSS_TOTAL` decimal(16,2) unsigned NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员累计业绩表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_PERF_UPDATE`
--

DROP TABLE IF EXISTS `AR_USER_PERF_UPDATE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_PERF_UPDATE` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL DEFAULT '0',
  `P_CALC_MONTH` date NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员累计业绩更新期数';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_PERIOD_POINTS`
--

DROP TABLE IF EXISTS `AR_USER_PERIOD_POINTS`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_PERIOD_POINTS` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `USER_ID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) unsigned NOT NULL DEFAULT '0',
  `RECONSUME_POINTS` decimal(16,3) unsigned NOT NULL DEFAULT '0.000' COMMENT '复消积分',
  `REMAINDER_POINTS` decimal(16,3) unsigned NOT NULL DEFAULT '0.000' COMMENT '剩余积分',
  `EXPIRED` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否过期,1已过期，0未过期',
  `EXPIRED_PERIOD` int(10) NOT NULL DEFAULT '0' COMMENT '过期期数',
  `EXPIRED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '过期时间',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `EXPIRED` (`EXPIRED`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='用户期数复消积分记录表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_RELATION`
--

DROP TABLE IF EXISTS `AR_USER_RELATION`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_RELATION` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `PARENT_UID` varchar(32) NOT NULL,
  `TOP_UID` varchar(32) NOT NULL,
  `TOP_DEEP` int(10) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `TOP_DEEP` (`TOP_DEEP`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='开拓关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_RELATION_NEW`
--

DROP TABLE IF EXISTS `AR_USER_RELATION_NEW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_RELATION_NEW` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '用户ID',
  `PARENT_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '上级ID',
  `TOP_UID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '顶级会员ID',
  `TOP_DEEP` int(10) NOT NULL DEFAULT '0' COMMENT '开拓总深度',
  `PARENT_UIDS` longtext COLLATE utf8mb4_general_ci NOT NULL COMMENT '所有的上级ID',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `USER_ID` (`USER_ID`),
  KEY `PARENT_UID` (`PARENT_UID`),
  KEY `TOP_DEEP` (`TOP_DEEP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='新开拓关系表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_STATUS_AUDIT`
--

DROP TABLE IF EXISTS `AR_USER_STATUS_AUDIT`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_STATUS_AUDIT` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `STATUS_VALUE` tinyint(1) NOT NULL DEFAULT '1',
  `ORI_VALUE` tinyint(1) NOT NULL DEFAULT '1',
  `PERIOD_NUM` int(10) NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `DEC_LV` varchar(32) DEFAULT NULL,
  `EMP_LV` varchar(32) DEFAULT NULL,
  `PV_1L` decimal(16,2) DEFAULT NULL,
  `PV_2L` decimal(16,2) DEFAULT NULL,
  `PV_3L` decimal(16,2) DEFAULT NULL,
  `PV_4L` decimal(16,2) DEFAULT NULL,
  `PV_5L` decimal(16,2) DEFAULT NULL,
  `SURPLUS_1L` decimal(16,2) DEFAULT NULL,
  `SURPLUS_2L` decimal(16,2) DEFAULT NULL,
  `SURPLUS_3L` decimal(16,2) DEFAULT NULL,
  `SURPLUS_4L` decimal(16,2) DEFAULT NULL,
  `SURPLUS_5L` decimal(16,2) DEFAULT NULL,
  `IS_PERIOD_ADD_T` tinyint(1) NOT NULL DEFAULT '0',
  `ADD_T_PERIOD_NUM` int(10) DEFAULT NULL,
  `IS_PERIOD_OPEN` tinyint(1) NOT NULL DEFAULT '0',
  `OPEN_PERIOD_NUM` int(10) DEFAULT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `AUDIT_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `AUDIT_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `PERIOD_NUM` (`PERIOD_NUM`),
  KEY `AUDIT_STATUS` (`AUDIT_STATUS`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员状态审核表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_SYSTEM`
--

DROP TABLE IF EXISTS `AR_USER_SYSTEM`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_SYSTEM` (
  `ID` varchar(32) NOT NULL,
  `SYSTEM_NAME` varchar(32) NOT NULL,
  `LEADER_UID` varchar(32) NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `UPDATE_PERIOD_NUM` int(10) DEFAULT NULL,
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `UPDATE_REMARK` text DEFAULT NULL,
  `IS_DEL` tinyint(1) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SYSTEM_NAME` (`SYSTEM_NAME`),
  UNIQUE KEY `LEADER_UID` (`LEADER_UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员体系';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_TEAMWORK`
--

DROP TABLE IF EXISTS `AR_USER_TEAMWORK`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_TEAMWORK` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `MAIN_UID` varchar(32) NOT NULL,
  `DIVIDE_PERCENT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `PERIOD_NUM` int(10) NOT NULL,
  `IS_DEL` int(10) NOT NULL DEFAULT '0',
  `CREATE_ADMIN` varchar(32) NOT NULL,
  `UPDATE_ADMIN` varchar(32) DEFAULT NULL,
  `CREATE_REMARK` text DEFAULT NULL,
  `UPDATE_REMARK` text DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATED_PERIOD` int(10) DEFAULT NULL,
  `DELETED_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `MAIN_UID` (`MAIN_UID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='点位合作';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_TOKEN`
--

DROP TABLE IF EXISTS `AR_USER_TOKEN`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_TOKEN` (
  `ID` varchar(32) NOT NULL COMMENT 'ID',
  `USER_ID` varchar(32) NOT NULL COMMENT '会员ID',
  `PC_ACCESS_TOKEN` varchar(255) DEFAULT NULL COMMENT 'PC端TOKEN',
  `APP_ACCESS_TOKEN` varchar(255) DEFAULT NULL COMMENT 'APP端TOKEN',
  `PC_REFRESH_TOKEN` varchar(255) DEFAULT NULL COMMENT 'PC刷新TOKEN',
  `APP_REFRESH_TOKEN` varchar(255) DEFAULT NULL COMMENT 'APP刷新TOKEN',
  `CREATED_AT` int(10) NOT NULL COMMENT '创建时间',
  `PAT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'PC端TOKEN更新时间',
  `AAT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'APP端TOKEN更新时间',
  `PRT_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'PC刷新TOKEN更新时间',
  `ART_UPDATED_AT` int(10) NOT NULL DEFAULT '0' COMMENT 'APP刷新TOKEN更新时间',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `PC_ACCESS_TOKEN` (`PC_ACCESS_TOKEN`),
  UNIQUE KEY `APP_ACCESS_TOKEN` (`APP_ACCESS_TOKEN`),
  UNIQUE KEY `PC_REFRESH_TOKEN` (`PC_REFRESH_TOKEN`),
  UNIQUE KEY `APP_REFRESH_TOKEN` (`APP_REFRESH_TOKEN`),
  KEY `USER_ID` (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员TOKEN表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_USER_WALLET`
--

DROP TABLE IF EXISTS `AR_USER_WALLET`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_USER_WALLET` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `CASH` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CLEAR_BY_CLOSED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  KEY `USER_ID` (`USER_ID`),
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='钱包';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_WITHDRAW`
--

DROP TABLE IF EXISTS `AR_WITHDRAW`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_WITHDRAW` (
  `ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `SN` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_general_ci NOT NULL,
  `ID_CARD` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `WITHDRAW_PERIOD_NUM` int(10) DEFAULT NULL,
  `WITHDRAW_YEAR` int(4) DEFAULT NULL,
  `WITHDRAW_MONTH` tinyint(2) DEFAULT NULL,
  `PAY_TYPE` tinyint(1) NOT NULL DEFAULT '1',
  `IS_AUTO_WITHDRAW` tinyint(1) NOT NULL DEFAULT '0',
  `AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `FEES` decimal(16,2) NOT NULL DEFAULT '0.00',
  `REAL_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `INVOICE_ID` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `REAL_NAME` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `OPEN_BANK` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_ADDRESS` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_NO` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BANK_PROVINCE` int(6) DEFAULT NULL,
  `BANK_CITY` int(6) DEFAULT NULL,
  `BANK_COUNTY` int(9) DEFAULT NULL,
  `P_MONTH` date NOT NULL,
  `AUDIT_STATUS` tinyint(1) NOT NULL DEFAULT '0',
  `REMARK` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UPDATE_ADMIN` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `UPDATE_REMARK` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `AUDIT_ADMIN` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `CREATED_AT` int(10) NOT NULL,
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `AUDITED_AT` int(10) NOT NULL DEFAULT '0',
  `PLAN_PAID_AT` int(10) NOT NULL,
  `PAID_AT` int(10) NOT NULL DEFAULT '0',
  `PAID_FAIL_REMARK` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `PAID_FAIL_AT` int(10) NOT NULL DEFAULT '0',
  `BACK_REMARK` text COLLATE utf8mb4_general_ci DEFAULT NULL,
  `BACK_FAIL_AT` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  UNIQUE KEY `SN` (`SN`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='提现申请';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_WITHDRAW_LEVEL`
--

DROP TABLE IF EXISTS `AR_WITHDRAW_LEVEL`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_WITHDRAW_LEVEL` (
  `ID` varchar(32) NOT NULL,
  `TYPE` varchar(32) NOT NULL,
  `MIN_AMOUNT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `MAX_AMOUNT` decimal(16,2) DEFAULT NULL,
  `TAX_PERCENT` decimal(16,2) NOT NULL DEFAULT '0.00',
  `CREATED_AT` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='提现金额等级';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `AR_YEAR_HIGHEST_EMP_LV`
--

DROP TABLE IF EXISTS `AR_YEAR_HIGHEST_EMP_LV`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AR_YEAR_HIGHEST_EMP_LV` (
  `ID` varchar(32) NOT NULL,
  `USER_ID` varchar(32) NOT NULL,
  `YEAR` int(4) NOT NULL DEFAULT '0',
  `HIGHEST_EMP_LV` varchar(32) NOT NULL,
  `HIGHEST_EMP_LV_SORT` int(10) NOT NULL DEFAULT '0',
  `HIGHEST_EMP_LV_PERIOD` int(10) NOT NULL DEFAULT '0',
  `CREATED_AT` int(10) NOT NULL DEFAULT '0',
  `UPDATED_AT` int(10) NOT NULL DEFAULT '0',
  `PARTITION_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`),
  KEY `USER_ID` (`USER_ID`),
  KEY `YEAR` (`YEAR`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='会员年度最高聘级';
/*!40101 SET character_set_client = @saved_cs_client */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-07-28 10:30:46