137 lines
6.3 KiB
SQL
137 lines
6.3 KiB
SQL
/*
|
||
Navicat Premium Data Transfer
|
||
|
||
Source Server : 全过程新框架数据库190
|
||
Source Server Type : Oracle
|
||
Source Server Version : 110200
|
||
Source Host : 172.16.31.190:1521
|
||
Source Schema : QGC_REFA
|
||
|
||
Target Server Type : Oracle
|
||
Target Server Version : 110200
|
||
File Encoding : 65001
|
||
|
||
Date: 08/07/2026 18:30:27
|
||
*/
|
||
|
||
|
||
-- ----------------------------
|
||
-- Table structure for SD_AIBOX_B_H
|
||
-- ----------------------------
|
||
DROP TABLE "QGC_REFA"."SD_AIBOX_B_H";
|
||
CREATE TABLE "QGC_REFA"."SD_AIBOX_B_H" (
|
||
"STCD" VARCHAR2(36 BYTE) NOT NULL ,
|
||
"STNM" VARCHAR2(255 BYTE) NOT NULL ,
|
||
"STTP" VARCHAR2(64 BYTE) NOT NULL ,
|
||
"TM" DATE ,
|
||
"LGTD" NUMBER(10,6) ,
|
||
"LTTD" NUMBER(10,6) ,
|
||
"ELEV" NUMBER(10,6) ,
|
||
"STLC" VARCHAR2(200 BYTE) ,
|
||
"JCDT" DATE ,
|
||
"WDDT" DATE ,
|
||
"BLDSTT_CODE" NUMBER(1) ,
|
||
"USFL" NUMBER(1) ,
|
||
"DTIN" NUMBER(1) ,
|
||
"DTIN_TM" DATE ,
|
||
"MWAY" NUMBER(1) ,
|
||
"STINDX" VARCHAR2(1000 BYTE) ,
|
||
"ORDER_INDEX" NUMBER(8) ,
|
||
"RSTCD" VARCHAR2(64 BYTE) ,
|
||
"BASE_ID" VARCHAR2(64 BYTE) ,
|
||
"HBRVCD" VARCHAR2(64 BYTE) ,
|
||
"RVCD" VARCHAR2(64 BYTE) ,
|
||
"INTRODUCE" VARCHAR2(3000 BYTE) ,
|
||
"LOGO" VARCHAR2(255 BYTE) ,
|
||
"INFFILE" VARCHAR2(1000 BYTE) ,
|
||
"FWDX" VARCHAR2(1000 BYTE) ,
|
||
"GDFS" VARCHAR2(512 BYTE) ,
|
||
"AIPZ" VARCHAR2(1000 BYTE) ,
|
||
"MXBB" VARCHAR2(512 BYTE) ,
|
||
"IPADDR" VARCHAR2(512 BYTE) ,
|
||
"SIMINFO" VARCHAR2(512 BYTE) ,
|
||
"LXR" VARCHAR2(512 BYTE) ,
|
||
"PURPOSE" VARCHAR2(512 BYTE) ,
|
||
"DTFRQCY" NUMBER(7) ,
|
||
"REMARK" VARCHAR2(512 BYTE) ,
|
||
"VLSR" VARCHAR2(512 BYTE) ,
|
||
"VLSR_TM" DATE ,
|
||
"RECORD_USER" VARCHAR2(36 BYTE) ,
|
||
"RECORD_TIME" DATE DEFAULT SYSDATE NOT NULL ,
|
||
"MODIFY_USER" VARCHAR2(36 BYTE) ,
|
||
"MODIFY_TIME" DATE ,
|
||
"IS_DELETED" NUMBER(1) DEFAULT 0 NOT NULL ,
|
||
"DELETE_USER" VARCHAR2(36 BYTE) ,
|
||
"DELETE_TIME" DATE
|
||
)
|
||
TABLESPACE "QGC_REFA_DATA"
|
||
LOGGING
|
||
NOCOMPRESS
|
||
PCTFREE 10
|
||
INITRANS 1
|
||
STORAGE (
|
||
BUFFER_POOL DEFAULT
|
||
)
|
||
PARALLEL 1
|
||
NOCACHE
|
||
DISABLE ROW MOVEMENT
|
||
;
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."STCD" IS '站码';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."STNM" IS '站名';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."STTP" IS '站类';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."TM" IS '数据时间';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."LGTD" IS '经度（单位：°）';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."LTTD" IS '纬度（单位：°）';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."ELEV" IS '高程（单位：m）';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."STLC" IS '站址/位置';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."JCDT" IS '建成日期';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."WDDT" IS '退役/拆除日期';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."BLDSTT_CODE" IS '建设状态分类';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."USFL" IS '是否启用';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."DTIN" IS '数据是否接入';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."DTIN_TM" IS '数据接入时间';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."MWAY" IS '监测方式';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."STINDX" IS '监测指标';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."ORDER_INDEX" IS '排序';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."RSTCD" IS '所属电站编码';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."BASE_ID" IS '所属水电基地编码';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."HBRVCD" IS '所属水电基地流域编码';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."RVCD" IS '所属流域编码';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."INTRODUCE" IS '简介';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."LOGO" IS 'LOGO图片';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."INFFILE" IS '介绍弹窗图片';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."FWDX" IS '服务对象';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."GDFS" IS '供电方式';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."AIPZ" IS 'AI盒子配置';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."MXBB" IS '模型版本';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."IPADDR" IS 'IP地址';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."SIMINFO" IS 'SIM卡信息';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."LXR" IS '联系人及联系电话';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."PURPOSE" IS '用途';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."DTFRQCY" IS '数据监测频次（单位：min）';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."REMARK" IS '备注';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."VLSR" IS '数据来源';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."VLSR_TM" IS '数据来源时间';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."RECORD_USER" IS '创建人：关联SYS_USER.ID';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."RECORD_TIME" IS '创建时间';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."MODIFY_USER" IS '更新人：关联SYS_USER.ID';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."MODIFY_TIME" IS '更新时间';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."IS_DELETED" IS '是否已删除：0=未删除 1=已删除；存储字典值，字典项为comm.is_deleted';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."DELETE_USER" IS '删除人：关联SYS_USER.ID';
|
||
COMMENT ON COLUMN "QGC_REFA"."SD_AIBOX_B_H"."DELETE_TIME" IS '删除时间';
|
||
COMMENT ON TABLE "QGC_REFA"."SD_AIBOX_B_H" IS 'AI边缘计算盒子基本属性表';
|
||
|
||
-- ----------------------------
|
||
-- Primary Key structure for table SD_AIBOX_B_H
|
||
-- ----------------------------
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SD_AIBOX_B_H_PK" PRIMARY KEY ("STCD");
|
||
|
||
-- ----------------------------
|
||
-- Checks structure for table SD_AIBOX_B_H
|
||
-- ----------------------------
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SYS_C0057611" CHECK ("STCD" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SYS_C0057612" CHECK ("STNM" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SYS_C0057613" CHECK ("STTP" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SYS_C0057615" CHECK ("RECORD_TIME" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|
||
ALTER TABLE "QGC_REFA"."SD_AIBOX_B_H" ADD CONSTRAINT "SYS_C0057616" CHECK ("IS_DELETED" IS NOT NULL) NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;
|