ngds/sql/2020_11/AR_DEC_ROLE_LOG.sql

/*
 Navicat Premium Data Transfer

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

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

 Date: 11/11/2020 14:19:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for AR_DEC_ROLE_LOG
-- ----------------------------
DROP TABLE IF EXISTS `AR_DEC_ROLE_LOG`;
CREATE TABLE `AR_DEC_ROLE_LOG` (
  `ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `USER_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `FROM_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `TO_ID` varchar(32) COLLATE utf8mb4_bin NOT NULL,
  `PERIOD_NUM` int(10) NOT NULL,
  `CALC_MONTH` int(10) NOT NULL,
  `REMARK` text COLLATE utf8mb4_bin NOT NULL,
  `ADMIN_ID` varchar(32) COLLATE utf8mb4_bin 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='报单中心级别变动记录';

SET FOREIGN_KEY_CHECKS = 1;