cpsipo-init.sql 18.7 KB
--2026-10-13
--公告信息
CREATE TABLE `t_auto_hfca_zlujkl_tzeeoq`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gglx`       varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ggnr`       varchar(500) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zt`         varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--5S责任图
CREATE TABLE `t_auto_hfca_zlujkl_xaibhg`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `dwcjxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zrtp_img`   varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `remark`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--安全观察与履职检查
CREATE TABLE `t_auto_hfca_zlujkl_dnqsvp`
(
    `id`            varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`     varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at`    datetime(3) NOT NULL COMMENT '创建时间',
    `created_by`    varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at`    datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by`    varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `qyxx`          varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `bzxx`          varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `jcrq`          datetime(3) DEFAULT NULL,
    `gcgw`          varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `bgcr`          varchar(32) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ibpfgw`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ifqtio`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ryfxgczhwtzxw` varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `mytzlbyp`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `mygbgzzt`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `mytzgz`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `myjsyx`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `lbypzqpd`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `tbxx`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ybjl`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ebxx`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `hxxt`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gbhs`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `sq`            varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `tbjj`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `fhczgc`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zqsy`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gjwkwps`       varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gjgzzklh`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `sbzcyx`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zyhjzklh`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zmgxlh`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `clbfzq`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `tflh`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `dmzj`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `wptfx`         varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `lbdkyfh`       varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `aqtdct`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `wzfxkk`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `bzfxkk`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `jzjyfxkk`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ddhbdfxkk`     varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gcdlfxkk`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `jdwdfxkk`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `cdfxkk`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `yhwzfxkk`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `xryhwzfxkk`    varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zybz`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zyzdwj`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zyzdwjkczx`    varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zyzdwjzy`      varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `aecplyqgsp`    varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zsfbzyzxyq`    varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `zswxzyzxyq`    varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ccxm`          varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ccjg`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `jlnryy`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `xwyg`          varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gtygaq`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `glyjy`         varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `gykuog`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `hghmqi`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `wfoiev`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `mivqpz`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `vivwyg`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ctbjdl`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    `ozhpmw`        varchar(50) COLLATE utf8mb4_general_ci  DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--多能工信息
CREATE TABLE `t_auto_hfca_zlujkl_yzswum`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bzxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gwxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `level`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyygxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--区域员工信息
CREATE TABLE `t_auto_hfca_zlujkl_zzumlq`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bzxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygxm`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygh`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zw`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `rzrq`       datetime(3) DEFAULT NULL,
    `zz`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygxs`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ois`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--区域员工考勤信息
CREATE TABLE `t_auto_hfca_zlujkl_uwjpei`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `kqrq`       datetime(3) DEFAULT NULL,
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bcxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--区域员工考勤明细
CREATE TABLE `t_auto_hfca_zlujkl_aaimmb`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `kqrq`       datetime(3) DEFAULT NULL,
    `qyygxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bzxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygxm`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygh`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zw`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gangw`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jbem`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jbsc` double (21,6) DEFAULT NULL,
    `dgryxm`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `stclsh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `wtclsh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyygkqxx`   varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyygbhmxxx` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyyglzmcxx` varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--区域员工离职明细
CREATE TABLE `t_auto_hfca_zlujkl_qfamxy`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `qyygxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bzxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `yg`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygh`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zwem`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gangw`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--区域员工变化明细
CREATE TABLE `t_auto_hfca_zlujkl_jqdips`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `qyygxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bzxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `yg`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `ygh`        varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zwem`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `gangw`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bh_date`    datetime(3) DEFAULT NULL,
    `jbem`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `jbsc` double (21,6) DEFAULT NULL,
    `dgryxm`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `stclsh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `wtclsh`     varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--区域板块指标信息
CREATE TABLE `t_auto_hfca_zlujkl_tqcghb`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zhib`       varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zt`         varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--区域记分卡
CREATE TABLE `t_auto_hfca_zlujkl_qfiace`
(
    `id`          varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`   varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at`  datetime(3) NOT NULL COMMENT '创建时间',
    `created_by`  varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at`  datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by`  varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `year`        datetime(3) DEFAULT NULL,
    `xtxx`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxx`        varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zhibxx`      varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `yuefem`      varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `_c_mb_val`   varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `_c_real_val` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `sfdb_flag`   tinyint(1) DEFAULT NULL,
    `mb_val` double (21,6) DEFAULT NULL,
    `real_val` double (21,6) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;


--区域板块指标每日明细
CREATE TABLE `t_auto_hfca_zlujkl_lpuzga`
(
    `id`         varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ID',
    `corp_code`  varchar(50) COLLATE utf8mb4_general_ci NOT NULL COMMENT '公司编号',
    `created_at` datetime(3) NOT NULL COMMENT '创建时间',
    `created_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '创建人ID',
    `updated_at` datetime(3) NOT NULL COMMENT '最后更新时间',
    `updated_by` varchar(32) COLLATE utf8mb4_general_ci NOT NULL COMMENT '最后更新人',
    `sjqk_date`  datetime(3) DEFAULT NULL,
    `xtxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `cjxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `szxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `qyxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `bkxx`       varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `zhibxx`     varchar(32) COLLATE utf8mb4_general_ci DEFAULT NULL,
    `real_val` double (21,6) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;