-- ----------------------------
|
-- Table structure for BLADE_VISUAL_CATEGORY
|
-- ----------------------------
|
-- DROP TABLE "BLADE_VISUAL_CATEGORY";
|
CREATE TABLE "BLADE_VISUAL_CATEGORY"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"CATEGORY_KEY" NVARCHAR2(12),
|
"CATEGORY_VALUE" NVARCHAR2(64),
|
"IS_DELETED" NUMBER(11)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
INITIAL 65536
|
NEXT 1048576
|
MINEXTENTS 1
|
MAXEXTENTS 2147483645
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CATEGORY"."ID" IS '主键';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CATEGORY"."CATEGORY_KEY" IS '分类键值';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CATEGORY"."CATEGORY_VALUE" IS '分类名称';
|
COMMENT
|
ON TABLE "BLADE_VISUAL_CATEGORY" IS '可视化分类表';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_VISUAL_CATEGORY
|
-- ----------------------------
|
ALTER TABLE "BLADE_VISUAL_CATEGORY"
|
ADD CONSTRAINT "1655780298PrimaryId" PRIMARY KEY ("ID");
|
|
-- ----------------------------
|
-- Table structure for BLADE_VISUAL_CONFIG
|
-- ----------------------------
|
-- DROP TABLE "BLADE_VISUAL_CONFIG";
|
CREATE TABLE "BLADE_VISUAL_CONFIG"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"VISUAL_ID" NUMBER(20),
|
"DETAIL" NCLOB,
|
"COMPONENT" NCLOB
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
INITIAL 65536
|
NEXT 1048576
|
MINEXTENTS 1
|
MAXEXTENTS 2147483645
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CONFIG"."ID" IS '主键';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CONFIG"."VISUAL_ID" IS '可视化表主键';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CONFIG"."DETAIL" IS '配置json';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_CONFIG"."COMPONENT" IS '组件json';
|
COMMENT
|
ON TABLE "BLADE_VISUAL_CONFIG" IS '可视化配置表';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_VISUAL_CONFIG
|
-- ----------------------------
|
ALTER TABLE "BLADE_VISUAL_CONFIG"
|
ADD CONSTRAINT "1655780301PrimaryId" PRIMARY KEY ("ID");
|
|
-- ----------------------------
|
-- Table structure for BLADE_VISUAL_DB
|
-- ----------------------------
|
-- DROP TABLE "BLADE_VISUAL_DB";
|
CREATE TABLE "BLADE_VISUAL_DB"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"NAME" NVARCHAR2(100),
|
"DRIVER_CLASS" NVARCHAR2(100),
|
"URL" NVARCHAR2(500),
|
"USERNAME" NVARCHAR2(50),
|
"PASSWORD" NVARCHAR2(50),
|
"REMARK" NVARCHAR2(255),
|
"CREATE_USER" NUMBER(20),
|
"CREATE_DEPT" NUMBER(20),
|
"CREATE_TIME" DATE,
|
"UPDATE_USER" NUMBER(20),
|
"UPDATE_TIME" DATE,
|
"STATUS" NUMBER(11),
|
"IS_DELETED" NUMBER(11)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."ID" IS '主键';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."NAME" IS '名称';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."DRIVER_CLASS" IS '驱动类';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."URL" IS '连接地址';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."USERNAME" IS '用户名';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."PASSWORD" IS '密码';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."REMARK" IS '备注';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."CREATE_USER" IS '创建人';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."CREATE_DEPT" IS '创建部门';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."CREATE_TIME" IS '创建时间';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."UPDATE_USER" IS '修改人';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."UPDATE_TIME" IS '修改时间';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_DB"."STATUS" IS '状态';
|
COMMENT
|
ON TABLE "BLADE_VISUAL_DB" IS '可视化数据源配置表';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_VISUAL_DB
|
-- ----------------------------
|
ALTER TABLE "BLADE_VISUAL_DB"
|
ADD CONSTRAINT "1655780302PrimaryId" PRIMARY KEY ("ID");
|
|
|
-- ----------------------------
|
-- Table structure for BLADE_VISUAL_MAP
|
-- ----------------------------
|
-- DROP TABLE "BLADE_VISUAL_MAP";
|
CREATE TABLE "BLADE_VISUAL_MAP"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"NAME" NVARCHAR2(255),
|
"DATA" NCLOB
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_MAP"."ID" IS '主键';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_MAP"."NAME" IS '地图名称';
|
COMMENT
|
ON COLUMN "BLADE_VISUAL_MAP"."DATA" IS '地图数据';
|
COMMENT
|
ON TABLE "BLADE_VISUAL_MAP" IS '可视化地图配置表';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_VISUAL_MAP
|
-- ----------------------------
|
ALTER TABLE "BLADE_VISUAL_MAP"
|
ADD CONSTRAINT "1655780304PrimaryId" PRIMARY KEY ("ID");
|
|
|
-- ----------------------------
|
-- Records of BLADE_VISUAL_CATEGORY
|
-- ----------------------------
|
INSERT INTO "BLADE_VISUAL_CATEGORY"
|
VALUES ('1235454865361166337', '我的数据大屏', '3', '0');
|
INSERT INTO "BLADE_VISUAL_CATEGORY"
|
VALUES ('1235454865361166338', '模板', '1', '0');
|
INSERT INTO "BLADE_VISUAL_CATEGORY"
|
VALUES ('1235455054851432448', '组件库', '2', '1647502991');
|
INSERT INTO BLADE_VISUAL_CATEGORY
|
VALUES ('1235455054851432449', '产线实况', '4', '0');
|
-- ----------------------------
|
-- Records of BLADE_VISUAL
|
-- ----------------------------
|
INSERT INTO "BLADE_VISUAL"
|
VALUES ('1510135236343095298', '兴航大数据模板', '/img/692bda428b2336a5b3f86ffddff7f8f8.jpg', '1', NULL, '1123598821738675201',
|
'2825020601448242', TO_DATE('2022-04-02 14:01:12', 'SYYYY-MM-DD HH24:MI:SS'), '1123598821738675201',
|
TO_DATE('2022-04-02 16:28:38', 'SYYYY-MM-DD HH24:MI:SS'), '1', '0', NULL, '0', '0');
|
