/*
 Navicat Premium Data Transfer

 Source Server         : 北京环境
 Source Server Type    : MySQL
 Source Server Version : 80021
 Source Host           : 192.168.101.27:3306
 Source Schema         : jingbo_test

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

 Date: 11/12/2024 14:41:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for v_tbl_crude_oil_warning
-- ----------------------------
DROP TABLE IF EXISTS `v_tbl_crude_oil_warning`;
CREATE TABLE `v_tbl_crude_oil_warning`  (
  `ID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'ID',
  `TENANT_CODE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '租户代码',
  `WARNING_TYPE_NAME` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预警类型',
  `WARNING_CONTENT` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '预警内容',
  `WARNING_DATE` datetime NULL DEFAULT NULL COMMENT '预警时间',
  `INDICATOR_NAME` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '指标名称',
  `INDICATOR_ID` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '指标ID',
  `FREQUENCY` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '频度',
  `UPDATE_FREQUENCY` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '更新频率，例：每周二，每月2日',
  `DATA_SOURCE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '数据来源，例：wind、彭博',
  `UPDATE_SUSPENSION_CYCLE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '停更周期',
  `LAST_UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '最后更新日期',
  `REMARK` varchar(5120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  `OPT_ORGAN_CODE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登记机构',
  `OPT_DEPT_CODE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '登记部门',
  `OPT_EMPLOYEE_CODE` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '操作员',
  `RESERVED_STR1` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预备文字1',
  `RESERVED_STR2` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预备文字2',
  `RESERVED_STR3` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预备文字3',
  `RESERVED_STR4` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预备文字4',
  `RESERVED_STR5` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '预备文字5',
  `RESERVED_NUM1` decimal(20, 8) NULL DEFAULT NULL COMMENT '预备数值1',
  `RESERVED_NUM2` decimal(20, 8) NULL DEFAULT NULL COMMENT '预备数值2',
  `RESERVED_NUM3` decimal(20, 8) NULL DEFAULT NULL COMMENT '预备数值3',
  `RESERVED_NUM4` decimal(20, 8) NULL DEFAULT NULL COMMENT '预备数值4',
  `RESERVED_NUM5` decimal(20, 8) NULL DEFAULT NULL COMMENT '预备数值5',
  `VERSION_NUM` decimal(10, 0) NOT NULL DEFAULT 1 COMMENT '乐观锁',
  `DELETE_FLAG` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '0' COMMENT '逻辑删除标志',
  `CREATE_USER` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '创建人',
  `CREATE_DATE` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `UPDATE_USER` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '修改人',
  `UPDATE_DATE` datetime NULL DEFAULT NULL COMMENT '修改时间',
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '原油预警信息' ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;
