-- ----------------------------
-- 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');