3000 lines
118 KiB
SQL
3000 lines
118 KiB
SQL
/*M!999999\- enable the sandbox mode */
|
|
-- MariaDB dump 10.19 Distrib 10.11.14-MariaDB, for debian-linux-gnu (x86_64)
|
|
--
|
|
-- Host: localhost Database: softspm_his
|
|
-- ------------------------------------------------------
|
|
-- Server version 10.11.14-MariaDB-0+deb12u2
|
|
|
|
/*!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 utf8mb4 */;
|
|
/*!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 `rec_dev_resources_piezo_16`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_16`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_16` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=351155 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_17`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_17`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_17` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=427512 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_18`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_18`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_18` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=437705 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_19`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_19`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_19` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=444652 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_20`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_20`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_20` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=455630 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_21`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_21`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_21` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=401311 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_dev_resources_piezo_list`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_dev_resources_piezo_list`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_dev_resources_piezo_list` (
|
|
`ID` bigint(12) DEFAULT NULL,
|
|
`DRD_PIEZO_NAME` varchar(64) DEFAULT NULL,
|
|
`DRD_STATUS` varchar(64) DEFAULT NULL,
|
|
`DRD_YEAR` varchar(64) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rec_piezo_resources_21full`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rec_piezo_resources_21full`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rec_piezo_resources_21full` (
|
|
`DRD_ID` bigint(12) NOT NULL AUTO_INCREMENT,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL COMMENT 'sys_dictionaries',
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) NOT NULL DEFAULT '0',
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`DRD_ID`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_EXP_SEGAP` (`DRD_EXPORT_SEGAP`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=3140299102 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2014_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2014_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2014_q1` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2014_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2014_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2014_q2` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2014_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2014_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2014_q3` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2014_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2014_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2014_q4` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2015_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2015_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2015_q1` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2015_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2015_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2015_q2` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2015_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2015_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2015_q3` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2015_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2015_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2015_q4` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2016_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2016_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2016_q1` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2016_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2016_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2016_q2` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2016_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2016_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2016_q3` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2016_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2016_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2016_q4` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2017_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2017_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2017_q1` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2017_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2017_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2017_q2` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2017_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2017_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2017_q3` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2017_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2017_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2017_q4` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2018_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2018_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2018_q1` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2018_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2018_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2018_q2` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2018_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2018_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2018_q3` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2018_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2018_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2018_q4` (
|
|
`RHD_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2019_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2019_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2019_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2019_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2019_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2019_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2019_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2019_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2019_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2019_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2019_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2019_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2020_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2020_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2020_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2020_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2020_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2020_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2020_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2020_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2020_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2020_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2020_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2020_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2021_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2021_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2021_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2021_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2021_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2021_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2021_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2021_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2021_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2021_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2021_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2021_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2022_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2022_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2022_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2022_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2022_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2022_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2022_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2022_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2022_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2022_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2022_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2022_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2023_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2023_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2023_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2023_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2023_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2023_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2023_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2023_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2023_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2023_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2023_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2023_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2024_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2024_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2024_q1` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2024_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2024_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2024_q2` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2024_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2024_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2024_q3` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_2024_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_2024_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_2024_q4` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(11) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_RHD_ID` (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `rep_his_data_everyday_his`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `rep_his_data_everyday_his`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `rep_his_data_everyday_his` (
|
|
`RHD_ID` bigint(12) unsigned NOT NULL DEFAULT 0,
|
|
`RHD_DRS_ID` int(11) DEFAULT NULL,
|
|
`RHD_DATE` datetime DEFAULT NULL,
|
|
`RHD_HST0_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HST_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HD_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_Q_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P1_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_P2_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_I_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_U_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PE_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_COS_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_PP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_HH_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_VM3_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_WTEMP_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_DGN_VAL` int(3) DEFAULT NULL,
|
|
`RHD_WORK_TIME_VAL` double(11,2) DEFAULT NULL,
|
|
`RHD_SPM_WT` float(11,2) DEFAULT NULL,
|
|
`RHD_SPM_PW` float(11,2) DEFAULT NULL,
|
|
`RHD_AUDIT_CD` datetime DEFAULT NULL,
|
|
PRIMARY KEY (`RHD_ID`),
|
|
KEY `INX_RHD_DRS_ID` (`RHD_DRS_ID`),
|
|
KEY `INX_RHD_DATE` (`RHD_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2014_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2014_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2014_q1` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2014_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2014_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2014_q2` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2014_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2014_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2014_q3` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2014_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2014_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2014_q4` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2015_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2015_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2015_q1` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2015_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2015_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2015_q2` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2015_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2015_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2015_q3` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2015_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2015_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2015_q4` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2016_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2016_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2016_q1` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2016_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2016_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2016_q2` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2016_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2016_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2016_q3` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2016_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2016_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2016_q4` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2017_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2017_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2017_q1` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2017_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2017_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2017_q2` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2017_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2017_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2017_q3` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2017_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2017_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2017_q4` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2018_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2018_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2018_q1` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2018_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2018_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2018_q2` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2018_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2018_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2018_q3` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2018_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2018_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2018_q4` (
|
|
`DRD_ID` int(11) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2019_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2019_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2019_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2019_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2019_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2019_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2019_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2019_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2019_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2019_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2019_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2019_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2020_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2020_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2020_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2020_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2020_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2020_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2020_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2020_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2020_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2020_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2020_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2020_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2021_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2021_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2021_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2021_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2021_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2021_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2021_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2021_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2021_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2021_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2021_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2021_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2022_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2022_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2022_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2022_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2022_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2022_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2022_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2022_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2022_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2022_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2022_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2022_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2023_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2023_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2023_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2023_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2023_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2023_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2023_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2023_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2023_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2023_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2023_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2023_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2024_q1`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2024_q1`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2024_q1` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2024_q2`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2024_q2`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2024_q2` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2024_q3`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2024_q3`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2024_q3` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_2024_q4`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_2024_q4`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_2024_q4` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL,
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime DEFAULT NULL,
|
|
UNIQUE KEY `INX_DRD_ID` (`DRD_ID`),
|
|
KEY `INX_DRD_DRS_ID` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_AUDIT_DATE` (`DRD_AUDIT_DATE`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_dev_resources_det_his`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_dev_resources_det_his`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_dev_resources_det_his` (
|
|
`DRD_ID` bigint(12) NOT NULL DEFAULT 0,
|
|
`DRD_DRS_ID` int(11) DEFAULT NULL,
|
|
`DRD_RESOURCES_DETAIL` int(11) DEFAULT NULL COMMENT 'sys_dictionaries',
|
|
`DRD_VALUE` varchar(128) DEFAULT NULL,
|
|
`DRD_DESCRIPTION` varchar(255) DEFAULT NULL,
|
|
`DRD_EXPORT_SEGAP` char(1) DEFAULT NULL,
|
|
`DRD_AUDIT_USR` varchar(64) DEFAULT NULL,
|
|
`DRD_AUDIT_DATE` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
KEY `INX_DRD_AUDIT_DATE1` (`DRD_AUDIT_DATE`),
|
|
KEY `INX_DRD_DRS_ID1` (`DRD_DRS_ID`),
|
|
KEY `INX_DRD_RES_DET1` (`DRD_RESOURCES_DETAIL`),
|
|
KEY `INX_DRD_ID` (`DRD_ID`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_object_column_fillings`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_object_column_fillings`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_object_column_fillings` (
|
|
`CLO_ID` int(11) NOT NULL DEFAULT 0,
|
|
`CLO_DRS_ID` int(11) DEFAULT NULL,
|
|
`CLO_COL_ID` int(11) DEFAULT NULL,
|
|
`CLO_NAME` varchar(128) DEFAULT NULL,
|
|
`CLO_FROM` double(9,2) NOT NULL DEFAULT 0.00,
|
|
`CLO_TO` double(9,2) NOT NULL DEFAULT 0.00,
|
|
`CLO_DESC` varchar(255) DEFAULT NULL,
|
|
`CLO_AUDIT_CU` varchar(64) DEFAULT NULL,
|
|
`CLO_AUDIT_CD` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_object_column_filters`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_object_column_filters`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_object_column_filters` (
|
|
`CLF_ID` int(11) NOT NULL DEFAULT 0,
|
|
`CLF_DRS_ID` int(11) DEFAULT NULL,
|
|
`CLF_COL_ID` int(11) DEFAULT NULL,
|
|
`CLF_NAME` varchar(128) DEFAULT NULL,
|
|
`CLF_FROM` double(9,2) NOT NULL DEFAULT 0.00,
|
|
`CLF_TO` double(9,2) NOT NULL DEFAULT 0.00,
|
|
`CLF_DESC` varchar(255) DEFAULT NULL,
|
|
`CLF_AUDIT_CU` varchar(64) DEFAULT NULL,
|
|
`CLF_AUDIT_CD` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_object_columns`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_object_columns`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_object_columns` (
|
|
`COL_ID` int(11) NOT NULL DEFAULT 0,
|
|
`COL_DRS_ID` int(11) DEFAULT NULL,
|
|
`COL_NO` varchar(128) DEFAULT NULL,
|
|
`COL_NAME` varchar(128) DEFAULT NULL,
|
|
`COL_HORYZONT` varchar(16) DEFAULT NULL,
|
|
`COL_DIAMETER` float(9,2) DEFAULT NULL,
|
|
`COL_DEPTH` float(9,2) DEFAULT NULL,
|
|
`COL_DESC` varchar(255) DEFAULT NULL,
|
|
`COL_AUDIT_CU` varchar(64) DEFAULT NULL,
|
|
`COL_AUDIT_CD` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_object_hole_cards`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_object_hole_cards`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_object_hole_cards` (
|
|
`OHC_ID` int(11) unsigned NOT NULL DEFAULT 0,
|
|
`OHC_DRS_ID` int(11) DEFAULT NULL,
|
|
`OHC_UJ` varchar(255) DEFAULT NULL,
|
|
`OHC_NAME` varchar(255) DEFAULT NULL,
|
|
`OHC_POZW` varchar(255) DEFAULT NULL,
|
|
`OHC_POZW_DATE` date DEFAULT NULL,
|
|
`OHC_WYKONAWCA` varchar(255) DEFAULT NULL,
|
|
`OHC_ROK_WYKON` varchar(16) DEFAULT NULL,
|
|
`OHC_ROZP_WIER_DATE` date DEFAULT NULL,
|
|
`OHC_ZAK_WIER_DATE` date DEFAULT NULL,
|
|
`OHC_DATA_ODDANIA` date DEFAULT NULL,
|
|
`OHC_ZDJECIE_EXPL_DATE` date DEFAULT NULL,
|
|
`OHC_URZ_WIERT` varchar(255) DEFAULT NULL,
|
|
`OHC_SPOS_WIERC` varchar(255) DEFAULT NULL,
|
|
`OHC_GLEB_ODWIER` varchar(16) DEFAULT NULL,
|
|
`OHC_GLEB_OSTAT` varchar(16) DEFAULT NULL,
|
|
`OHC_DL_GEOGR` varchar(16) DEFAULT NULL,
|
|
`OHC_SZER_GEOGR` varchar(16) DEFAULT NULL,
|
|
`OHC_RZEDNA_TEREN` float(9,2) DEFAULT NULL,
|
|
`OHC_RZEDNA_KRYZY` varchar(16) DEFAULT NULL,
|
|
`OHC_RZEDNA_TERENU_ACT` float(9,2) DEFAULT NULL,
|
|
`OHC_RZEDNA_DATE` date DEFAULT NULL,
|
|
`OHC_ZWIERC_NAWIERC` varchar(16) DEFAULT NULL,
|
|
`OHC_ZWIERC_USTAL` varchar(16) DEFAULT NULL,
|
|
`OHC_POZIOM_WODONOS` varchar(255) DEFAULT NULL,
|
|
`OHC_WYDAJ_EXPL` varchar(16) DEFAULT NULL,
|
|
`OHC_DEPR_EXPL` varchar(16) DEFAULT NULL,
|
|
`OHC_PROM_LEJA_DEPR` varchar(16) DEFAULT NULL,
|
|
`OHC_WYDAJ_WG_PW` varchar(16) DEFAULT NULL,
|
|
`OHC_PROFIL_LITO` text DEFAULT NULL,
|
|
`OHC_KONSTR_OTWOR` text DEFAULT NULL,
|
|
`OHC_Q1` varchar(16) DEFAULT NULL,
|
|
`OHC_S1` varchar(16) DEFAULT NULL,
|
|
`OHC_T1` varchar(16) DEFAULT NULL,
|
|
`OHC_Q2` varchar(16) DEFAULT NULL,
|
|
`OHC_S2` varchar(16) DEFAULT NULL,
|
|
`OHC_T2` varchar(16) DEFAULT NULL,
|
|
`OHC_Q3` varchar(16) DEFAULT NULL,
|
|
`OHC_S3` varchar(16) DEFAULT NULL,
|
|
`OHC_T3` varchar(16) DEFAULT NULL,
|
|
`OHC_Q4` varchar(16) DEFAULT NULL,
|
|
`OHC_S4` varchar(16) DEFAULT NULL,
|
|
`OHC_T4` varchar(16) DEFAULT NULL,
|
|
`OHC_Q5` varchar(16) DEFAULT NULL,
|
|
`OHC_S5` varchar(16) DEFAULT NULL,
|
|
`OHC_T5` varchar(16) DEFAULT NULL,
|
|
`OHC_C` varchar(16) DEFAULT NULL,
|
|
`OHC_QE` varchar(16) DEFAULT NULL,
|
|
`OHC_SE` varchar(16) DEFAULT NULL,
|
|
`OHC_WYD_JEDN` varchar(16) DEFAULT NULL,
|
|
`OHC_WSP_SPR_HYDRO` varchar(16) DEFAULT NULL,
|
|
`OHC_POZ_WOD_NO` varchar(255) DEFAULT NULL,
|
|
`OHC_POZ_DATE_TO` date DEFAULT NULL,
|
|
`OHC_POZ_Q_DOP` varchar(16) DEFAULT NULL,
|
|
`OHC_UWAGI` text DEFAULT NULL,
|
|
`OHC_PLC` varchar(32) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Table structure for table `seg_object_hole_cards_his`
|
|
--
|
|
|
|
DROP TABLE IF EXISTS `seg_object_hole_cards_his`;
|
|
/*!40101 SET @saved_cs_client = @@character_set_client */;
|
|
/*!40101 SET character_set_client = utf8mb4 */;
|
|
CREATE TABLE `seg_object_hole_cards_his` (
|
|
`OHH_ID` int(11) NOT NULL DEFAULT 0,
|
|
`OHH_DRS_ID` int(11) DEFAULT NULL,
|
|
`OHH_UJ` varchar(32) DEFAULT NULL,
|
|
`OHH_NAME` varchar(128) DEFAULT NULL,
|
|
`OHH_DATE` date DEFAULT NULL,
|
|
`OHH_RZEDNA` varchar(32) DEFAULT NULL,
|
|
`OHH_ZASYP` varchar(32) DEFAULT NULL,
|
|
`OHH_ZMIAN_UMIEJ_LOCAL` varchar(255) DEFAULT NULL,
|
|
`OHH_ZMIAN_UMIEJ_REASON` varchar(255) DEFAULT NULL,
|
|
`OHH_PLC` varchar(32) DEFAULT NULL
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
|
|
/*!40101 SET character_set_client = @saved_cs_client */;
|
|
|
|
--
|
|
-- Dumping events for database 'softspm_his'
|
|
--
|
|
|
|
--
|
|
-- Dumping routines for database 'softspm_his'
|
|
--
|
|
/*!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 2026-06-04 12:00:20
|