CREATE TABLE "BLADE_DNC_ARCHIVE_DIRECTORY"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"TENANT_ID" NVARCHAR2(12) DEFAULT 000000,
|
"PARENT_ID" NUMBER(20) DEFAULT 0,
|
"NAME" NVARCHAR2(45),
|
"ALL_PATH" NVARCHAR2(500),
|
"IS_DELETED" NUMBER(11),
|
"STATUS" NUMBER(11),
|
"CREATE_TIME" DATE,
|
"CREATE_USER" NUMBER(20),
|
"UPDATE_TIME" DATE,
|
"UPDATE_USER" NUMBER(20),
|
"CREATE_DEPT" NUMBER(20),
|
"DEPT_ID" NUMBER(20)
|
) 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_DNC_ARCHIVE_DIRECTORY"."ID" IS '主键';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."TENANT_ID" IS '租户ID';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."PARENT_ID" IS '父主键';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."NAME" IS '工艺目录名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."ALL_PATH" IS '全路径(包含自身)';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."STATUS" IS '状态';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."CREATE_TIME" IS '创建时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."CREATE_USER" IS '创建人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."UPDATE_TIME" IS '更新时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."UPDATE_USER" IS '更新人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."CREATE_DEPT" IS '创建部门';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ARCHIVE_DIRECTORY"."DEPT_ID" IS '职权域id';
|
COMMENT
|
ON TABLE "BLADE_DNC_ARCHIVE_DIRECTORY" IS 'dnc 归档目录';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_ARCHIVE_DIRECTORY
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_ARCHIVE_DIRECTORY"
|
ADD CONSTRAINT "1655780199PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
CREATE TABLE "DNC_ARCHIVE_DIRECTORY_FILE"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"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),
|
"TENANT_ID" NVARCHAR2(10) DEFAULT 000000,
|
"ORIGINAL_FILENAME" NVARCHAR2(100),
|
"FILENAME" NVARCHAR2(100),
|
"CONTENT_LENGTH" NUMBER(20),
|
"CONTENT_MD5" NVARCHAR2(100),
|
"CONTENT_TYPE" NVARCHAR2(100),
|
"OBJECT_KEY" NVARCHAR2(100),
|
"SUFFIX" NVARCHAR2(50),
|
"IS_CURRENT" NUMBER(11),
|
"LINK" NVARCHAR2(500),
|
"BUSINESS_IDENTIFICATION" NVARCHAR2(50),
|
"WORKSTATION_FILE_ID" NUMBER(20),
|
"WORKSTATION_ID" NUMBER(20),
|
"ARCHIVE_DIRECTORY_ID" NUMBER(20),
|
"VERSION" NUMBER(11)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."REMARK" IS '备注';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."ORIGINAL_FILENAME" IS '原始文件名称';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."FILENAME" IS '文件名称';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."CONTENT_MD5" IS '文件md5值';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."CONTENT_TYPE" IS '文件类型';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."OBJECT_KEY" IS '文件的objectKey';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."SUFFIX" IS '文件后缀';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."IS_CURRENT" IS '是否为当前版本,1是0否';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."LINK" IS '文件链接';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."BUSINESS_IDENTIFICATION" IS '业务标识';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."WORKSTATION_FILE_ID" IS '工位文件id';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."WORKSTATION_ID" IS '工位id';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."ARCHIVE_DIRECTORY_ID" IS '归档目录id';
|
COMMENT
|
ON COLUMN "DNC_ARCHIVE_DIRECTORY_FILE"."VERSION" IS '文件版本';
|
COMMENT
|
ON TABLE "DNC_ARCHIVE_DIRECTORY_FILE" IS '归档目录文件';
|
|
|
-- ----------------------------
|
-- Primary Key structure for table DNC_ARCHIVE_DIRECTORY_FILE
|
-- ----------------------------
|
ALTER TABLE "DNC_ARCHIVE_DIRECTORY_FILE"
|
ADD CONSTRAINT "1655780317PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_ART_BAG
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_ART_BAG"
|
ADD CONSTRAINT "1655780200PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
CREATE TABLE "BLADE_DNC_ART_BAG_LOG"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"FILE_ID" NUMBER(20),
|
"FILE_NAME" NVARCHAR2(255),
|
"OBJECT_KEY" NVARCHAR2(255),
|
"SUFFIX" NVARCHAR2(100),
|
"OPERATOR_ID" NUMBER(20),
|
"OPERATOR_NAME" NVARCHAR2(255),
|
"OPERATION_TIME" DATE,
|
"SOURCE_TYPE" NUMBER(11),
|
"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),
|
"TENANT_ID" NVARCHAR2(10) DEFAULT 000000,
|
"LINK" NVARCHAR2(200),
|
"ART_BAG_ID" NUMBER(20),
|
"ART_FILE_ID" NUMBER(20),
|
"OPERATION_TYPE" NUMBER(11),
|
"FILE_TYPE" NUMBER(11),
|
"FILE_BELONG" NUMBER(11),
|
"STORAGE" NUMBER(11),
|
"VERSION" NUMBER(11)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."FILE_ID" IS '文件id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."FILE_NAME" IS '文件名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."OBJECT_KEY" IS '文件存储的key';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."SUFFIX" IS '文件后缀';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."OPERATOR_ID" IS '操作人员id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."OPERATOR_NAME" IS '操作人员姓名';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."OPERATION_TIME" IS '操作时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."SOURCE_TYPE" IS '源类型：本地文件0 我的文档1 加工程序2 通用文件3 回传文件 4 非通用文件 5 产品 6';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."REMARK" IS '备注';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."LINK" IS '文件链接';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."ART_BAG_ID" IS '工艺包id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."ART_FILE_ID" IS '工位报文件id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."OPERATION_TYPE" IS '操作类型：添加1 覆盖2 删除3';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."FILE_TYPE" IS '属性 程序1 文档2';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."FILE_BELONG" IS '文件归属 工厂1 工位2';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."STORAGE" IS '存储空间 固定空间1 常规空间2';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_BAG_LOG"."VERSION" IS '版本';
|
COMMENT
|
ON TABLE "BLADE_DNC_ART_BAG_LOG" IS '工艺包操作历史';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_ART_BAG_LOG
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_ART_BAG_LOG"
|
ADD CONSTRAINT "1655780201PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_ART_FILE
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_ART_FILE"
|
ADD CONSTRAINT "1655780202PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
CREATE TABLE "BLADE_DNC_ART_PRODUCT"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"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),
|
"TENANT_ID" NVARCHAR2(10) DEFAULT 000000,
|
"PRODUCT_ID" NUMBER(20),
|
"ART_BAG_ID" NUMBER(20),
|
"PRODUCT_TYPE_ID" NUMBER(20),
|
"PRODUCT_TYPE_NAME" NVARCHAR2(50),
|
"PRODUCT_NAME" NVARCHAR2(50),
|
"PRODUCT_CODE" NVARCHAR2(50)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."REMARK" IS '备注';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."PRODUCT_ID" IS '产品id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."ART_BAG_ID" IS '工艺包id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."PRODUCT_TYPE_ID" IS '产品类型id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."PRODUCT_TYPE_NAME" IS '产品类型名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."PRODUCT_NAME" IS '产品名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_ART_PRODUCT"."PRODUCT_CODE" IS '产品编码';
|
COMMENT
|
ON TABLE "BLADE_DNC_ART_PRODUCT" IS '工艺包关联产品';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_ART_PRODUCT
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_ART_PRODUCT"
|
ADD CONSTRAINT "1655780203PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
CREATE TABLE "BLADE_DNC_CRAFT_FILE"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"TENANT_ID" NVARCHAR2(12) DEFAULT 000000,
|
"DISPLAY_NAME" NVARCHAR2(100),
|
"PID" NUMBER(20),
|
"ALL_PATH" NVARCHAR2(500),
|
"CONTENT_LENGTH" NUMBER(20),
|
"CONTENT_TYPE" NVARCHAR2(100),
|
"SUFFIX" NVARCHAR2(10),
|
"FILE_TYPE" NUMBER(11),
|
"OBJECT_KEY" NVARCHAR2(100),
|
"CONTENT_MD5" NVARCHAR2(100),
|
"IS_LOCKED" NUMBER(4),
|
"OWNER" NUMBER(20),
|
"CREATE_USER" NUMBER(20),
|
"CREATE_TIME" DATE,
|
"UPDATE_USER" NUMBER(20),
|
"UPDATE_TIME" DATE,
|
"IS_DELETED" NUMBER(11),
|
"CREATE_DEPT" NUMBER(20),
|
"STATUS" NUMBER(11),
|
"LINK" NVARCHAR2(255),
|
"IS_CURRENT" NUMBER(4) DEFAULT 0 NOT NULL,
|
"COVER_TIME" DATE,
|
"VERSION" 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_DNC_CRAFT_FILE"."TENANT_ID" IS '租户id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."DISPLAY_NAME" IS '文件显示名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."PID" IS '上级id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."ALL_PATH" IS '全路径';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."CONTENT_TYPE" IS '文件mini类型';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."SUFFIX" IS '后缀名';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."FILE_TYPE" IS '文件类型，1 文件夹 2 文件 3 资源文件';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."OBJECT_KEY" IS '文件key';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."CONTENT_MD5" IS '文件md5';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."IS_LOCKED" IS '是否上锁';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."OWNER" IS '拥有者';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."CREATE_USER" IS '创建人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."CREATE_TIME" IS '创建时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."UPDATE_USER" IS '更新人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."UPDATE_TIME" IS '更新时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."CREATE_DEPT" IS '部门';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."STATUS" IS '状态';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."LINK" IS '文件外连接';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."IS_CURRENT" IS '是否为当前版本,1是0否';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."COVER_TIME" IS '覆盖时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_CRAFT_FILE"."VERSION" IS '版本';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_CRAFT_FILE
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_CRAFT_FILE"
|
ADD CONSTRAINT "1655780204PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
CREATE TABLE "BLADE_DNC_FACTORY_FILE"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"ORIGINAL_FILENAME" NVARCHAR2(100),
|
"FILENAME" NVARCHAR2(100),
|
"CONTENT_LENGTH" NUMBER(20),
|
"CONTENT_MD5" NVARCHAR2(100),
|
"LAST_MODIFIED" DATE,
|
"CONTENT_TYPE" NVARCHAR2(100),
|
"OBJECT_KEY" NVARCHAR2(100),
|
"SUFFIX" NVARCHAR2(50),
|
"CREATE_USER" NUMBER(20),
|
"CREATE_TIME" DATE,
|
"UPDATE_USER" NUMBER(20),
|
"UPDATE_TIME" DATE,
|
"IS_DELETED" NUMBER(11),
|
"CREATE_DEPT" NUMBER(20),
|
"STATUS" NUMBER(11),
|
"LINK" NVARCHAR2(255),
|
"IS_CURRENT" NUMBER(11),
|
"VERSION" NUMBER(11),
|
"WHETHER_ARCHIVE" NUMBER(11) DEFAULT 1
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."ORIGINAL_FILENAME" IS '原始文件名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."FILENAME" IS '文件名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."CONTENT_MD5" IS '文件md5值';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."LAST_MODIFIED" IS '最后修改时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."OBJECT_KEY" IS '文件的objectKey';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."CREATE_USER" IS '创建人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."CREATE_TIME" IS '创建时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."UPDATE_USER" IS '更新人';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."UPDATE_TIME" IS '更新时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."CREATE_DEPT" IS '创建部门';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."STATUS" IS '业务状态';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."LINK" IS '文件地址';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."IS_CURRENT" IS '是否为当前版本,1是0否';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."VERSION" IS '文件版本';
|
COMMENT
|
ON COLUMN "BLADE_DNC_FACTORY_FILE"."WHETHER_ARCHIVE" IS '文件是否归档：1 未归档 2 已归档';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_FACTORY_FILE
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_FACTORY_FILE"
|
ADD CONSTRAINT "1655780205PrimaryId" PRIMARY KEY ("ID");
|
|
|
CREATE TABLE "BLADE_DNC_OPERATION_LOG"
|
(
|
"ID" NUMBER(20) NOT NULL,
|
"FILE_ID" NUMBER(20),
|
"FILE_NAME" NVARCHAR2(255),
|
"OBJECT_KEY" NVARCHAR2(255),
|
"SUFFIX" NVARCHAR2(100),
|
"OPERATOR_ID" NUMBER(20),
|
"OPERATOR_NAME" NVARCHAR2(255),
|
"OPERATION_TYPE" NUMBER(11),
|
"OPERATION_RESPONSE" NUMBER(11),
|
"OPERATION_TIME" DATE,
|
"SOURCE_TYPE" NUMBER(11),
|
"SOURCE_PATH_ID" NVARCHAR2(255),
|
"SOURCE_PATH_NAME" NVARCHAR2(255),
|
"TARGET_TYPE" NUMBER(11),
|
"TARGET_PATH_ID" NVARCHAR2(255),
|
"TARGET_PATH_NAME" NVARCHAR2(255),
|
"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),
|
"TENANT_ID" NVARCHAR2(10) DEFAULT 000000,
|
"LINK" NVARCHAR2(200),
|
"WORKSTATION_ID" NUMBER(20),
|
"FILE_TYPE" NUMBER(11) DEFAULT 0,
|
"VERSION" NUMBER(11),
|
"STORAGE_SPACE" NUMBER(11),
|
"FILE_LOCATION" NVARCHAR2(255)
|
) TABLESPACE "USERS"
|
LOGGING
|
NOCOMPRESS
|
PCTFREE 10
|
INITRANS 1
|
STORAGE
|
(
|
BUFFER_POOL DEFAULT
|
)
|
PARALLEL 1
|
NOCACHE
|
DISABLE ROW MOVEMENT
|
;
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."FILE_ID" IS '文件id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."FILE_NAME" IS '文件名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OBJECT_KEY" IS '文件存储的key';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."SUFFIX" IS '文件后缀';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OPERATOR_ID" IS '操作人员id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OPERATOR_NAME" IS '操作人员姓名';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OPERATION_TYPE" IS '操作类型：上传1 下载2 删除3 更新4 5移动 6复制';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OPERATION_RESPONSE" IS '操作结果';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."OPERATION_TIME" IS '操作时间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."SOURCE_TYPE" IS '源类型：本地文件0 我的文档1 工位文件-加工程序2 工位文件-工位文件3 FTP 4';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."SOURCE_PATH_ID" IS '源全路径id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."SOURCE_PATH_NAME" IS '源全路径名称';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."TARGET_TYPE" IS '源类型：本地文件0 我的文档1 工位文件-加工程序2 工位文件-工位文件3 FTP 4';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."TARGET_PATH_ID" IS '目标全路径id：格式，/1/123/456';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."TARGET_PATH_NAME" IS '目标全路径名称:格式，/我的文档/文件夹1/文件夹2';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."REMARK" IS '备注';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."LINK" IS '文件链接';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."WORKSTATION_ID" IS '工位id';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."FILE_TYPE" IS '文件类型 1:代表文件夹 0:代表文件';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."VERSION" IS '版本';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."STORAGE_SPACE" IS '存储位置：1 常规空间 2 固定空间';
|
COMMENT
|
ON COLUMN "BLADE_DNC_OPERATION_LOG"."FILE_LOCATION" IS '文件位置：1 内部存储 2 以太网';
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_OPERATION_LOG
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_OPERATION_LOG"
|
ADD CONSTRAINT "1655780206PrimaryId" PRIMARY KEY ("ID");
|
|
|
|
-- ----------------------------
|
-- Primary Key structure for table BLADE_DNC_PROCESS_CATALOGUE
|
-- ----------------------------
|
ALTER TABLE "BLADE_DNC_PROCESS_CATALOGUE"
|
ADD CONSTRAINT "1655780207PrimaryId" PRIMARY KEY ("ID");
|
|
|
-- 初始化菜单脚本
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1481428245788037121, 0, 'dnc', '生产工艺', 'dnc', '/dnc', 'iconfont saber-shengchangongyi', 5, 0, 0, 1, '', 0,
|
'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1481428568128688130, 1481428245788037121, 'transfer', '文件传输', 'transfer', '/dnc/transport/index',
|
'iconfont iconicon_exchange', 3, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1481429369576296449, 1481428245788037121, 'station_file', '工位文件', 'station_file', '/dnc/station-file/index',
|
'iconfont iconicon_doc', 2, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1481429815657304065, 1481428245788037121, 'my_documents', '我的文档', 'my_documents', '/dnc/document/index',
|
'iconfont iconicon_subordinate', 1, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1495960929735061505, 1481428245788037121, 'operation_log', '操作日志', 'operation_log', '/dnc/log/index',
|
'iconfont icon-biaodan', 7, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1496427333921992705, 1498201919430000641, 'technology_files', '工艺文件', 'technology_files',
|
'/dnc/craft/document/index', 'iconfont iconicon_dispose', 1, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1497029135171686401, 1481428245788037121, 'factory_file', '工厂文件', 'factory_file', '/dnc/factory-file/index',
|
'iconfont iconicon_doc', 6, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1497030448508932097, 1481428245788037121, 'archive', '文件归档', 'archive', '/dnc/archive',
|
'iconfont iconicon_coinpurse_line', 5, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1497129165478219777, 1497030448508932097, 'archived_files', '归档管理', 'archived_files', '/dnc/file/admin/index',
|
'iconfont iconicon_dispose', 2, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1497132713708535809, 1497030448508932097, 'archive_catalog', '归档目录', 'archive_catalog',
|
'/dnc/file/catalog/index', 'iconfont iconicon_addresslist', 1, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1498201919430000641, 1481428245788037121, 'technology_file', '工艺管理', 'technology_file', '/dnc/process',
|
'iconfont iconicon_coinpurse_line', 4, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1498202645019426818, 1498201919430000641, 'technology_catalog', '工艺目录', 'technology_catalog',
|
'/dnc/craft/catalog/index', 'iconfont iconicon_addresslist', 2, 1, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1551739877858926594, 1481428245788037121, 'dnc_app_setting', 'dnc应用设置', 'dnc_app_setting', '/dnc/setting/index',
|
'', 8, 1, 0, 1, '', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552474588642234369, 1551739877858926594, 'ftp_directory_root_add', '创建FTP目录', 'ftp_directory_root_add', '', '',
|
1, 2, 0, 1, '', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552475927401156610, 1551739877858926594, 'bind_workstation', '关联工位', 'bind_workstation', '', '', 2, 2, 0, 1,
|
'', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552476695336300545, 1551739877858926594, 'ftp_directory_add', '新增', 'ftp_directory_add', '', '', 4, 2, 0, 1,
|
'', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552476901159186434, 1551739877858926594, 'ftp_directory_rename', '重命名', 'ftp_directory_rename', '', '', 5, 2,
|
0, 1, '', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552477030549270530, 1551739877858926594, 'ftp_directory_delete', '删除子目录', 'ftp_directory_delete', '', '', 6, 2,
|
0, 1, '', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1552477343062667265, 1551739877858926594, 'ftp_directory_root_delete', '删除根目录', 'ftp_directory_root_delete', '',
|
'', 3, 2, 0, 1, '', 0, 'cps', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1585554742799319042, 0, 'hmi_dnc', '文件传输', 'hmi_dnc', '/dnc', '', 2, 1, 0, 1, '', 0, 'HMI', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1592786664948154369, 1551739877858926594, 'dnc_filedriectory_save', '文件配置设置', 'dnc_filedriectory_save', '', '',
|
10, 2, 0, 1, '', 0, 'CPS', 1);
|
INSERT INTO blade_menu (id, parent_id, code, name, alias, path, source, sort, category, action, is_open, remark,
|
is_deleted, belong_application, keep_alive)
|
VALUES (1592786889846734850, 1551739877858926594, 'dnc_filedriectory_switch', '文件配置开关', 'dnc_filedriectory_switch', '',
|
'', 11, 2, 0, 1, '', 0, 'CPS', 1);
|
|
|
-- 初始化脚本
|
|
INSERT INTO "BLADE_DNC_ARCHIVE_DIRECTORY"
|
VALUES ('0', '000000', '-1', '默认目录', '0', '0', NULL, TO_DATE('2022-06-21 10:08:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL,
|
TO_DATE('2022-06-21 10:08:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
|
|
INSERT INTO "BLADE_DNC_PROCESS_CATALOGUE"
|
VALUES ('0', '000000', '-1', '默认目录', '0', '0', '1', TO_DATE('2022-06-21 10:08:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL,
|
TO_DATE('2022-06-21 10:08:13', 'SYYYY-MM-DD HH24:MI:SS'), NULL, NULL, NULL);
|
|
INSERT INTO "BLADE_DNC_CRAFT_FILE"
|
VALUES ('0', '000000', '我的文档', '-1', '0', '0', NULL, NULL, '1', NULL, NULL, '0', NULL, NULL, NULL, NULL, NULL, '0',
|
NULL, '1', NULL, '1', NULL, '1');
|
|
|
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
|
create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
|
VALUES (1592793061815402498, 1592786664948154369, 'dnc_directory_settings.update_file_setting_data', '更新文件目录设置',
|
'/blade-dnc/dnc-directory-settings/update-setting', NULL, NULL, 'POST', 1123598821738675201,
|
1123598813738675201,
|
TO_DATE('2022-11-16 16:13:53', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201,
|
TO_DATE('2022-11-16 16:13:53', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0);
|
INSERT INTO blade_scope_api (id, menu_id, resource_code, scope_name, scope_path, scope_type, remark, http_method,
|
create_user, create_dept, create_time, update_user, update_time, status, is_deleted)
|
VALUES (1592793108263124993, 1592786889846734850, 'dnc_directory_settings.switch_state', '文件设置：开启、关闭',
|
'/blade-dnc/dnc-directory-settings/change', NULL, NULL, 'POST', 1123598821738675201, 1123598813738675201,
|
TO_DATE('2022-11-16 16:14:04', 'SYYYY-MM-DD HH24:MI:SS'), 1123598821738675201,
|
TO_DATE('2022-11-16 16:14:04', 'SYYYY-MM-DD HH24:MI:SS'), 1, 0);
|
