select projid,wm_concat(b.custname) from proj_info

最新推荐文章于 2025-03-01 14:20:30 发布
原创 最新推荐文章于 2025-03-01 14:20:30 发布 · 194 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

博客内容包含一条SQL查询语句，使用select关键字从proj_info表中查询projid列，并通过wm_concat函数拼接b表的custname列。体现了SQL在数据查询和处理方面的应用。

select projid,wm_concat(b.custname)  from proj_info

kevin_cat
关注
mkfs.xfs: /dev/sda4 appears to contain an existing filesystem (LVM2_member).
qq_40713201的博客
05-29 3572
[root@localhost lj]# mkfs.xfs /dev/sda4 mkfs.xfs: /dev/sda4 appears to contain an existing filesystem (LVM2_member). mkfs.xfs: Use the -f option to force overwrite. 解决办法：强制执行 -f [root@localhost lj]# mkfs.xfs -f /dev/sda4 meta-data=/dev/sda4 i
projidy:本地项目通知者和经理
04-14
ji 本地项目通知者和经理
linux进程间通信--消息队列相关函数（ftok）详解
热门推荐
andylauren的专栏
12-16 5万+
ftok 消息队列、信号灯、共享内存常用在Linux服务端编程的进程间通信环境中。而此三类编程函数在实际项目中都是用System V IPC函数实现的。System V IPC函数名称和说明如下表15-1所示。 表15-1 System V IPC函数   消息队列 信号灯 共享内存区 头文件
Linux 共享内存
puppy_1mo的博客
03-01 1276
我们之前提到过，进程通信是让两个不同的进程看到同一份资源，所以我们给大家讲解了匿名管道和命名管道。今天我们还有一种方式两个不同的进程看到同一份资源。那就是共享内存！二、共享内存原理我们先来看这张图，我们在物理内存创建一个共享区，我们再让两个不同的进程通过页表分别映射到对应的共享区里，然后返回虚拟地址的起始地址。这就是共享内存，我们总结分为三步申请内存。将该内存挂接到进程地址空间的共享区。返回虚拟地址首地址。以上我们就创建好共享内存了，那我们该如何释放共享内存呢？
09共享内存 函数用法
qq_35602425的博客
05-24 299
1.生成key值 key_t ftok(const char *path, int proj_id); 成功返回合法key值，失败EOF path 存在且可访问的文件的路径 proj_id 用于生成key数字，不能为0 proj_id是可以根据自己的约定，随意设置。这个数字,有的称之为project ID; 在UNIX系统上,它的取值是1到255; 2.创建共享内存 int s...
LinuxIPC通信-共享内存通信原理
godleo0的博客
12-05 907
linux共享内存
Linux -- ftok函数
u013581207的博客
08-10 553
翻译自Ubuntu 19版本下的Linux Programmer's Manual 函数名：ftok – 将一个路径名和一个对象标识符转换为System V IPC键值。 概要：#include <sys/types.h> #include <sys/ipc.h> key_t ftok(const char *pathname, int ...
SELECT * FROM(SELECT DISTINCT NVL(T.ID,A.ID) ID, A.TESTMETHODID, EMPNAME, STARTTIME, T.ENDTIME, T.EQUIPTID, T.EQUIPTNAME, T.ASSETSNO, T.CREATEDTIME,NVL(T.TYPE,A.TYPE) TYPE, NVL(T.SCHEDULESTATUS,A.SCHEDULESTATUS) SCHEDULESTATUS, ISEMPSCHEDULE, NVL(DBMS_LOB.SUBSTR(T.ORDERNO,3000,1),DBMS_LOB.SUBSTR(A.ORDERNO,3000,1)) ORDERNO, T.TEMPERATURE, CONDITION, SAMPLELENGTH, SAMPLEWIDTH, SAMPLEHEIGHT, TESTNO, ORDERNUM, CONSUMABLEINFOS, FAILREASON, A.ID PROJID, ISINSERTPROJ, EMPBEFORESTARTTIME, EMPBEFOREENDTIME, EMPAFTERSTARTTIME, EMPAFTERENDTIME, A.PROJNO, A.TESTMETHODNAME, EQUIPTCATEGORYID, ORIJSON, B.NUM parkNum,C.TESTUSERNUM testUserNum, CASE WHEN T1.ENDTIME IS NOT NULL THEN 2 WHEN T1.ACTIVATETIME IS NULL AND TO_CHAR(SYSDATE,'yyyy-MM-dd')> TO_CHAR(T.STARTTIME,'yyyy-MM-dd') THEN 1 ELSE 0 END AS taskStatus,A.LOCATIONID1 locationId FROM (SELECT ID,TESTMETHODID,PROJNO,SCHEDULESTATUS,TESTMETHODNAME,TYPE,WM_CONCAT(ORDERNO) ORDERNO FROM (SELECT DISTINCT WP.ID,M.ID TESTMETHODID,WP.PROJNO,'-1' SCHEDULESTATUS,M.TESTMETHODNAME, CASE WHEN M.TESTCATEGORY IN ('normal','instruction') THEN '1' ELSE '2' END TYPE,WO.ORDERNO FROM T_HKWS_WL_PROJECT WP LEFT JOIN T_HKWS_WL_ORDER WO ON WP.ID = WO.PROJID LEFT JOIN T_HKWS_WL_ORDER_TASK WOT ON WOT.ORDERID = WO.ID LEFT JOIN T_HKWS_WL_TASK WT ON WOT.TASKID = WT.ID LEFT JOIN T_HKWS_WL_TEST_METHOD M ON M.ID = WT.TESTMETHODID LEFT JOIN (SELECT PROJID,sum(COUNT) count FROM T_HKWS_WL_MTL_ARRIVE_RECORD GROUP BY PROJID) T1 ON T1.PROJID = WP.ID WHERE t1.COUNT>= SAMPLECOUNT AND (wp.NODESTATUS IN ('待领样','试验中') OR wp.NODESTATUS LIKE '%报告%')) GROUP BY ID,TESTMETHODID,PROJNO,SCHEDULESTATUS,TESTMETHODNAME,TYPE UNION ALL SELECT ID,TESTMETHODID,PROJNO,SCHEDULESTATUS,TESTMETHODNAME,TYPE,WM_CONCAT(ORDERNO) ORDERNO FROM ( SELECT a.ID,M.ID TESTMETHODID,a.PROJNO,'-1' SCHEDULESTATUS,M.TESTMETHODNAME, CASE WHEN M.TESTCATEGORY IN ('normal','instruction') THEN '1' ELSE '2' END TYPE,O.ORDERNO FROM T_HKWS_YJ_PROJECT A LEFT JOIN T_HKWS_YJ_PRODUCT B ON A.ID = B.PROJID LEFT JOIN T_HKWS_YJ_ORDER O ON A.ID = O.PROJID LEFT JOIN T_HKWS_YJ_ORDER_TASK OT ON OT.ORDERID = O.ID LEFT JOIN T_HKWS_YJ_TASK T ON OT.TASKID = T.ID LEFT JOIN T_HKWS_WL_TEST_METHOD M ON M.ID = T.TESTMETHODID LEFT JOIN T_HKWS_YJ_ARRIVE_RECORD R ON R.PRODUCTID = B.ID WHERE (B.NODESTATUS IN ('待领样','试验中') OR B.NODESTATUS LIKE '%报告%') AND R.COUNT>=B.ORDERCOUNT)GROUP BY ID,TESTMETHODID,PROJNO,SCHEDULESTATUS,TESTMETHODNAME,TYPE ) A LEFT JOIN T_HKWS_SCHEDULE_RESULT T ON A.ID = T.PROJID AND T.TESTMETHODID = A.TESTMETHODID LEFT JOIN T_HKWS_EQUIPT A ON T.EQUIPTID = A.ID LEFT JOIN T_HKWS_EQUIPT_LOCATION B ON A.LOCATIONID1 = B.ID LEFT JOIN T_HKWS_WL_TEST_METHOD C ON T.TESTMETHODID = C.ID LEFT JOIN (SELECT MIN(ACTIVATETIME) ACTIVATETIME,MAX(ENDTIME) ENDTIME, EQUIPTID,PROJID,TESTMETHODID FROM (SELECT A.ACTIVATETIME,A.ENDTIME,A.EQUIPTID,B.PROJID,B.TESTMETHODID FROM T_HKWS_WL_RUN_EQUIPT A LEFT JOIN T_HKWS_WL_RUN B ON A.RUNID = B.ID UNION ALL SELECT A.ACTIVATETIME,A.ENDTIME,A.EQUIPTID,B.PROJID,B.TESTMETHODID FROM T_HKWS_YJ_RUN_EQUIPT A LEFT JOIN T_HKWS_YJ_RUN B ON A.RUNID = B.ID) GROUP BY EQUIPTID,PROJID,TESTMETHODID)T1 ON T1.PROJID = T.PROJID AND T1.TESTMETHODID = T.TESTMETHODID AND T.EQUIPTID = T1.EQUIPTID)K 帮我优化下这个sql
06-20
FROM (SELECT * FROM orders WHERE date > '2023-01-01') filtered_orders JOIN customers ON ... ``` - **避免Nested Loop JOIN** 当表数据量 > 10万时，强制使用Hash JOIN或Merge JOIN（语法因数据库而异）...
columns: [ { title: "项目", dataIndex: "projectNo", width: 50, type: "project", condition: true, options: { options: [], fieldNames: { label: "projId", value: "projId" } }, decorator: { rules: [{ required: true, message: "请选择项目！" }] } }, { title: "小票号", dataIndex: "pipeNo", condition: true, width: 150 }, { title: "版本号", dataIndex: "pipeVersion", width: 60 }, { title: "是否删除", dataIndex: "isDelete", condition: true, width: 80, type: 'select', options: { options: [{ value: 'Y', label: "Y" }, { value: 'N', label: "N" }] }, decorator: { initialValue: 'N' } }, -- ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO definition CREATE TABLE "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO" ( "PROJECT_NO" VARCHAR2(50), "PIPE_NO" VARCHAR2(100), "PIPE_VERSION" NUMBER, "PART_NO" VARCHAR2(50), "LENGTH" NUMBER, "SYS_NO" VARCHAR2(50), "SYS_NAME" VARCHAR2(50), "PART_TYPE" VARCHAR2(50), "MATERIAL" VARCHAR2(200), "PART_SIZE" VARCHAR2(200), "MAT_DESP" VARCHAR2(200), "MAT_NO" VARCHAR2(100), "IS_DELETE" VARCHAR2(10), "IS_BUY" VARCHAR2(10), "WEIGHT" NUMBER, "IS_BENDING" VARCHAR2(10), "GROOVE_QTY" NUMBER, "IS_OFE" VARCHAR2(10), "SLOT_QTY" NUMBER, "SCREW_QTY" NUMBER, "NESTING_NO" VARCHAR2(100), "THICKNESS" NUMBER, "PIPE_DIA" NUMBER, "ACCESSORY_CLASS" VARCHAR2(50), "CONN_POINT_INFO" VARCHAR2(200), "MATERIAL_SOURCE" VARCHAR2(50), "PAINT_NO" VARCHAR2(50), "CREATE_USER_NO" VARCHAR2(32), "CREATE_USER_NAME" VARCHAR2(50), "CREATE_DATE" DATE, "UPDATE_USER_NO" VARCHAR2(32), "UPDATE_USER_NAME" VARCHAR2(50), "UPDATE_DATE" DATE, "ID" NUMBER NOT NULL ENABLE, "DELETE_DATE" DATE, "OWNER_MAT_NO" VARCHAR2(500), "OLD_LENGTH" NUMBER, CONSTRAINT "CP_PIPE_PART_DESIGN_INFO_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE UNIQUE INDEX "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO_PK" ON "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CP_WELD_DESIGN_4COLS" ON "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO" ("PROJECT_NO", "PIPE_NO", "PIPE_VERSION", "PART_NO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CPPPDI_PART_TYPE_SYS_NO" ON "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO" ("PART_TYPE", "SYS_NO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CPPPDI_COVER_QUERY" ON "ECIMS_AIO"."CP_PIPE_PART_DESIGN_INFO" ("PROJECT_NO", "PIPE_NO", "PIPE_VERSION", "PART_NO", "IS_DELETE", "PART_TYPE", "MATERIAL", "PART_SIZE", "MAT_DESP", "PAINT_NO", "SYS_NO", "SYS_NAME", "MAT_NO", "OWNER_MAT_NO", "IS_BUY", "WEIGHT", "LENGTH", "PIPE_DIA", "IS_BENDING", "GROOVE_QTY", "NESTING_NO", "IS_OFE", "SLOT_QTY", "SCREW_QTY", "ACCESSORY_CLASS", "CONN_POINT_INFO", "MATERIAL_SOURCE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; COMMENT ON TABLE ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO IS '管道零件信息表'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PROJECT_NO IS '项目名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PIPE_NO IS '小票号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PIPE_VERSION IS '版本号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PART_NO IS '零件编号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO."LENGTH" IS '长度'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.SYS_NO IS '系统代码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.SYS_NAME IS '系统名称'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PART_TYPE IS '零件类型'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.MATERIAL IS '材质'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PART_SIZE IS '规格'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.MAT_DESP IS '零件描述'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.MAT_NO IS '物资编码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.IS_DELETE IS '删除标志'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.IS_BUY IS '采购件标志 (Y/N)'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.WEIGHT IS '重量'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.IS_BENDING IS '弯管标志（Y/N）'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.GROOVE_QTY IS '坡口数量'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.IS_OFE IS 'Ofe标识（Y/N）'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.SLOT_QTY IS '槽数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.SCREW_QTY IS '螺纹数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.NESTING_NO IS '套料图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.THICKNESS IS '壁厚'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PIPE_DIA IS '管径'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.ACCESSORY_CLASS IS '部件类型'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.CONN_POINT_INFO IS '连接点坐标'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.MATERIAL_SOURCE IS '来源'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.PAINT_NO IS '涂装代码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.CREATE_USER_NO IS '创建人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.CREATE_USER_NAME IS '创建人姓名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.CREATE_DATE IS '创建时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.UPDATE_USER_NO IS '修改人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.UPDATE_USER_NAME IS '修改人姓名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.UPDATE_DATE IS '修改时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.ID IS '主键id'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.DELETE_DATE IS '删除时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.OWNER_MAT_NO IS '船东物资编码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_PART_DESIGN_INFO.OLD_LENGTH IS '原长度'; 根据sql语句里面的字段，补齐columns剩下的字段
09-27
根据你提供的 `columns` 配置和数据库表 `CP_PIPE_PART_DESIGN_INFO` 的字段结构，我们可以将剩余的字段补齐到 `columns` 数组中。 --- ### ✅ 补齐后的 `columns` 完整配置如下： ```js columns: [ { title: ...
columns: [ { title: "项目", dataIndex: "projectNo", width: 100, type: "project", condition: true, options: { options: [], fieldNames: { label: "projId", value: "projId" } }, decorator: { rules: [{ required: true, message: "请选择项目！" }] } }, { title: "小票号", dataIndex: "pipeNo", condition: true, width: 150 }, { title: "版本号", dataIndex: "pipeVersion", width: 80 }, { title: "最新版", dataIndex: "isTopVersion", condition: true, width: 80, type: 'select', options: { options: [{ value: 'Y', label: "Y" }, { value: 'N', label: "N" }] }, decorator: { initialValue: 'Y' } }, { title: "是否删除", dataIndex: "isDelete", condition: true, width: 80, type: 'select', options: { options: [{ value: 'Y', label: "Y" }, { value: 'N', label: "N" }] }, decorator: { initialValue: 'N' } }, { title: "是否暂停", dataIndex: "isPause", condition: true, width: 80, type: 'select', options: { options: [{ value: 'Y', label: "Y" }, { value: 'N', label: "N" }] }, decorator: { initialValue: 'N' } }, { title: "暂停原因", dataIndex: "pauseReason", width: 100 }, { title: "暂停备注", dataIndex: "pauseRemark", width: 100 }, { title: "暂停人", dataIndex: "pauseUserNo", type: "employeeDescription", options: { fieldNames: { label: "pauseUserName", value: "pauseUserNo" } } }, { title: "暂停时间", dataIndex: "pauseDate", width: 120, type: "date" }, { title: "预计解除暂停日期", dataIndex: "preResumeDate", width: 120, type: "date" }, { title: "解除暂停时间", dataIndex: "resumeDate", width: 120, type: "date" }, { title: "解除暂停人", dataIndex: "resumeUserNo", type: "employeeDescription", options: { fieldNames: { label: "resumeUserName", value: "resumeUserNo" } } }, { title: "图号", dataIndex: "drawNo", width: 150 }, { title: "最新图号", dataIndex: "lastDrawNo", width: 150 }, { title: "原图图号", dataIndex: "originDrawNo", width: 150 }, { title: "修改图号", dataIndex: "modifyDrawNo", width: 150 }, { title: "修改图页号", dataIndex: "modifyDrawPageNo", width: 80 }, { title: "技术施工阶段", dataIndex: "instStage", width: 100 }, { title: "系统代码", dataIndex: "systemNo", width: 60 }, { title: "系统名称", dataIndex: "systemName", width: 60 }, { title: "页号", dataIndex: "pageNo", width: 40 }, { title: "属性", dataIndex: "pipeGrade", width: 60 }, { title: "管路等级", condition: true, type: 'select', dataIndex: "pipeClass", options: { options: [{ value: 'I', label: "I" }, { value: 'II', label: "II" },{ value: 'III', label: "III" }] }, width: 100 }, { title: "测试压力", dataIndex: "testPressure", width: 80 }, { title: "管径壁厚", dataIndex: "pipeDiaThickness", width: 80 }, { title: "长度", dataIndex: "length", width: 50 }, { title: "重量", dataIndex: "weight", width: 50 }, { title: "技术处理方式", dataIndex: "treatment", width: 90 }, { title: "是否通舱件", condition: true, dataIndex: "isThroughCabin", width: 80, type: 'select', options: { options: [{ value: 'Y', label: "Y" }, { value: 'N', label: "N" }] }, }, { title: "内表面积", dataIndex: "inSurface", width: 80 }, { title: "外表面积", dataIndex: "outSurface", width: 80 }, { title: "舱室代码", dataIndex: "cabinNo", width: 80 }, { title: "分段", dataIndex: "block", width: 50 }, { title: "材质", dataIndex: "matDefinition", width: 100, condition: true, type: "select", options: { options: [], fieldNames: {label: "matDefinitionCn", value: "matDefinitionCn"}, ajax: server.matDefinitionDropList().then((res) => { return res }) }, }, { title: "修改方式", dataIndex: "modifyType", condition: true, width: 100 } ] 上面的字段只是一部分；根据我下面提供的建表语句里的字段，补充剩下的，注意上面的顺序不要改变，只是补充缺少的字段； -- ECIMS_AIO.CP_PIPE_DESIGN_INFO definition CREATE TABLE "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ( "PROJECT_NO" VARCHAR2(50), "PIPE_NO" VARCHAR2(100), "PIPE_VERSION" NUMBER, "IS_TOP_VERSION" VARCHAR2(10), "DRAW_NO" VARCHAR2(100), "ORIGIN_DRAW_NO" VARCHAR2(100), "INST_STAGE" VARCHAR2(50), "DRAW_FILE_PATH" VARCHAR2(500), "SYSTEM_NO" VARCHAR2(50), "SYSTEM_NAME" VARCHAR2(50), "PAGE_NO" VARCHAR2(50), "PIPE_CLASS" VARCHAR2(50), "TEST_PRESSURE" VARCHAR2(50), "PIPE_DIA" NUMBER, "THICKNESS" NUMBER, "LENGTH" NUMBER, "WEIGHT" NUMBER, "TREATMENT" VARCHAR2(50), "IS_THROUGH_CABIN" VARCHAR2(10), "IN_SURFACE" NUMBER, "OUT_SURFACE" NUMBER, "CABIN_NO" VARCHAR2(50), "BLOCK" VARCHAR2(50), "MODIFY_DRAW_NO" VARCHAR2(100), "MODIFY_TYPE" VARCHAR2(50), "MODIFY_DRAW_PAGE_NO" VARCHAR2(10), "IN_PAINT_NO" VARCHAR2(50), "OUT_PAINT_NO" VARCHAR2(50), "IS_BARE_PIPE" VARCHAR2(50), "PIPELINE_NO" VARCHAR2(100), "PIPE_RUN" VARCHAR2(100), "PIPE_RUN_SHORT" VARCHAR2(50), "INCH" NUMBER, "IN_INCH" NUMBER, "OUT_INCH" NUMBER, "LARGE_AREA" VARCHAR2(50), "AREA" VARCHAR2(50), "ROOM_NO" VARCHAR2(50), "ROOM_DESP" VARCHAR2(100), "SHEET" VARCHAR2(50), "LINK_ROOM_NO" VARCHAR2(50), "LINK_BLOCK" VARCHAR2(50), "INST_TYPE" VARCHAR2(50), "INSULATION" VARCHAR2(50), "FLUID_TYPE" VARCHAR2(50), "CLEANING_METHOD" VARCHAR2(50), "ELEVATION" VARCHAR2(50), "IS_CHEMICAL_CLEANING" VARCHAR2(10), "NR13" VARCHAR2(50), "OPERATION_TEMPERATURE" VARCHAR2(50), "MATERIAL_DESP" VARCHAR2(200), "INSULATION_TYPE" VARCHAR2(50), "INSULATION_THICK" VARCHAR2(50), "PID_DRAW_NO" VARCHAR2(100), "PIPING_CLASS" VARCHAR2(50), "INSTLOCATIONX" VARCHAR2(50), "INSTLOCATIONY" VARCHAR2(50), "INSTLOCATIONZ" VARCHAR2(50), "CREATE_USER_NO" VARCHAR2(32), "CREATE_USER_NAME" VARCHAR2(50), "CREATE_DATE" DATE, "UPDATE_USER_NO" VARCHAR2(32), "UPDATE_USER_NAME" VARCHAR2(50), "UPDATE_DATE" DATE, "IS_DELETE" VARCHAR2(10), "MAT_DEFINITION" VARCHAR2(50), "SHOP_FIELD_FLAG" VARCHAR2(10), "DRAW_DESP" VARCHAR2(240), "INSPECTION_CLASS" VARCHAR2(30), "ID" NUMBER NOT NULL ENABLE, "LAST_DRAW_NO" VARCHAR2(100), "IS_PAUSE" VARCHAR2(10), "PAUSE_REASON" VARCHAR2(100), "PRE_RESUME_DATE" DATE, "RESUME_USER_NO" VARCHAR2(32), "RESUME_DATE" DATE, "PAUSE_REMARK" VARCHAR2(500), "PAUSE_DATE" DATE, "PAUSE_USER_NO" VARCHAR2(32), "DELETE_DATE" DATE, "DESIGN_REMARK" VARCHAR2(1000), "PAINTING_AREA_IMPACT" VARCHAR2(200), "FITTING_LEG_COORDINATE" VARCHAR2(200), "FITTING_WELDED_STIFF" VARCHAR2(50), "FITTING_LEG_QTY" NUMBER(10,0), "INST_LOCATIONX" VARCHAR2(100), "INST_LOCATIONY" VARCHAR2(100), "INST_LOCATIONZ" VARCHAR2(100), "HULL_SHEET" VARCHAR2(100), "FIELD_INCH_QTY" NUMBER(10,4), "SHOP_INCH_QTY" NUMBER(10,4), "INCH_QTY" NUMBER(10,4), "PIPE_POSITION" VARCHAR2(10), "PIPE_DIA_THICKNESS" VARCHAR2(50), "PIPE_GRADE" VARCHAR2(200), "SPACE_NO" VARCHAR2(50), "PAUSE_USER_NAME" VARCHAR2(50), "RESUME_USER_NAME" VARCHAR2(50), CONSTRAINT "CP_PIPE_DESIGN_INFO_PK" PRIMARY KEY ("ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE UNIQUE INDEX "ECIMS_AIO"."CP_PIPE_DESIGN_INFO_PK" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CP_PIPE_DESIGN_4COLS" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("PROJECT_NO", "PIPE_NO", "PIPE_VERSION", "IS_TOP_VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."CP_PIPE_DESIGN_INFO_PIPE_NO_IDX" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("PIPE_NO", "PROJECT_NO", "PIPE_VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_T3_MAIN" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("PIPE_NO", "PIPE_VERSION", "PROJECT_NO", "IS_DELETE", "IS_TOP_VERSION", "INSPECTION_CLASS") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_T3_FILTER" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("PROJECT_NO", "PIPE_NO", "PIPE_VERSION", "IS_DELETE", "IS_TOP_VERSION", "INSPECTION_CLASS", "FLUID_TYPE") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CPPDI_PIPE_VERSION_PROJ" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("PIPE_NO", "PIPE_VERSION", "PROJECT_NO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CPPDI_IS_DELETE_TOP_VERSION" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("IS_DELETE", "IS_TOP_VERSION") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; CREATE INDEX "ECIMS_AIO"."IDX_CPPDI_DRAW_NO_PIPELINE" ON "ECIMS_AIO"."CP_PIPE_DESIGN_INFO" ("DRAW_NO", "PIPELINE_NO") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "ECIMS_AIO" ; COMMENT ON TABLE ECIMS_AIO.CP_PIPE_DESIGN_INFO IS '管道数据信息表'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PROJECT_NO IS '项目名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_NO IS '小票号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_VERSION IS '版本号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_TOP_VERSION IS '最新版本（Y/N）'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.DRAW_NO IS '图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.ORIGIN_DRAW_NO IS '原图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INST_STAGE IS '技术施工阶段'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.DRAW_FILE_PATH IS '图纸路径'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SYSTEM_NO IS '系统代码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SYSTEM_NAME IS '系统名称'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAGE_NO IS '页号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_CLASS IS '管路等级'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.TEST_PRESSURE IS '测试压力'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_DIA IS '管径'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.THICKNESS IS '壁厚'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO."LENGTH" IS '长度'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.WEIGHT IS '重量'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.TREATMENT IS '技术处理方式'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_THROUGH_CABIN IS '是否通舱件（Y/N）'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IN_SURFACE IS '内表面积'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.OUT_SURFACE IS '外表面积'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.CABIN_NO IS '舱室代码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.BLOCK IS '分段'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.MODIFY_DRAW_NO IS '修改图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.MODIFY_TYPE IS '修改方式'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.MODIFY_DRAW_PAGE_NO IS '修改图页号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IN_PAINT_NO IS '管内涂装'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.OUT_PAINT_NO IS '管外涂装'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_BARE_PIPE IS '是否裸管（Y/N）'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPELINE_NO IS '模型管线号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_RUN IS '管线号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_RUN_SHORT IS '管线短号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INCH IS '寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IN_INCH IS '内场寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.OUT_INCH IS '外场寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.LARGE_AREA IS '设计大区域'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.AREA IS '设计中区域'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.ROOM_NO IS '设计房间号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.ROOM_DESP IS '房间描述'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SHEET IS '舾装片体'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.LINK_ROOM_NO IS '邻壁房间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.LINK_BLOCK IS '邻壁分段'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INST_TYPE IS '安装类型'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSULATION IS '绝缘属性'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.FLUID_TYPE IS '流体类型'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.CLEANING_METHOD IS '清洁方式'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.ELEVATION IS '高度值'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_CHEMICAL_CLEANING IS '是否化学清洗'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.NR13 IS 'Nr13'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.OPERATION_TEMPERATURE IS '操作温度'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.MATERIAL_DESP IS '材质描述'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSULATION_TYPE IS '绝缘类型'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSULATION_THICK IS '绝缘厚度'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PID_DRAW_NO IS 'PID图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPING_CLASS IS '船东规格书'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSTLOCATIONX IS '安装三维坐标X'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSTLOCATIONY IS '安装三维坐标Y'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSTLOCATIONZ IS '安装三维坐标Z'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.CREATE_USER_NO IS '创建人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.CREATE_USER_NAME IS '创建人姓名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.CREATE_DATE IS '创建时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.UPDATE_USER_NO IS '修改人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.UPDATE_USER_NAME IS '修改人姓名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.UPDATE_DATE IS '修改时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_DELETE IS '删除标志 (Y/N)'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.MAT_DEFINITION IS '材质属性'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SHOP_FIELD_FLAG IS '内外场标识'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.DRAW_DESP IS '图纸名称'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INSPECTION_CLASS IS '检验等级'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.ID IS '主键id'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.LAST_DRAW_NO IS '最新图号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.IS_PAUSE IS '是否暂停（Y/N)'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAUSE_REASON IS '暂停原因'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PRE_RESUME_DATE IS '预计解除暂停时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.RESUME_USER_NO IS '取消暂停人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.RESUME_DATE IS '恢复日期'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAUSE_REMARK IS '暂停备注'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAUSE_DATE IS '暂停日期'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAUSE_USER_NO IS '暂停人工号'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.DELETE_DATE IS '删除时间'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.DESIGN_REMARK IS '设计备注'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAINTING_AREA_IMPACT IS '油漆面积影响'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.FITTING_LEG_COORDINATE IS '舾装件腿坐标'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.FITTING_WELDED_STIFF IS '舾装件焊接点型材'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.FITTING_LEG_QTY IS '舾装件腿数量'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INST_LOCATIONX IS '安装三维坐标X'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INST_LOCATIONY IS '安装三维坐标Y'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INST_LOCATIONZ IS '安装三维坐标Z'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.HULL_SHEET IS '舾装片体'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.FIELD_INCH_QTY IS '外场寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SHOP_INCH_QTY IS '内场寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.INCH_QTY IS '寸口数'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_POSITION IS '内外场管'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_DIA_THICKNESS IS '管径X壁厚'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PIPE_GRADE IS '材质'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.SPACE_NO IS '空间代码'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.PAUSE_USER_NAME IS '暂停人姓名'; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_DESIGN_INFO.RESUME_USER_NAME IS '取消暂停人姓名';
09-27
fieldNames: { label: "projId", value: "projId" } }, decorator: { rules: [{ required: true, message: "请选择项目！" }] } }, { title: "小票号", dataIndex: "pipeNo", condition: true, width: 150 ...
columns: [ { title: "项目", dataIndex: "projectNo", width: 50, type: "project", condition: true, options: { options: [], fieldNames: { label: "projId", value: "projId" } }, decorator: { rules: [{ required: true, message: "请选择项目！" }] } }, { title: "小票号", dataIndex: "pipeNo", condition: true, width: 150 }, { title: "版本号", condition: true, dataIndex: "pipeVersion", width: 60 }, – ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO definition CREATE TABLE “ECIMS_AIO”.“CP_PIPE_WELD_DESIGN_INFO” ( “PROJECT_NO” VARCHAR2(50), “PIPE_NO” VARCHAR2(100), “PIPE_VERSION” NUMBER, “WELD_NO” VARCHAR2(100), “SYS_NO” VARCHAR2(50), “SYS_NAME” VARCHAR2(50), “WELD_LENGTH” NUMBER, “P1_PIPE_NO” VARCHAR2(100), “P1_PART_NO” VARCHAR2(50), “P2_PIPE_NO” VARCHAR2(100), “P2_PART_NO” VARCHAR2(50), “WELD_CONN_TYPE_SHORT” VARCHAR2(10), “PWELD_FLAG” VARCHAR2(10), “SHOP_FIELD_FLAG” VARCHAR2(10), “BRANCH_TYPE” VARCHAR2(10), “PAGE_NO” VARCHAR2(10), “CALIBER” NUMBER, “THICKNESS” NUMBER, “WELD_INCH_QTY” NUMBER, “IS_DELETE” VARCHAR2(10), “WELD_CONN_TYPE” VARCHAR2(10), “P1_MATERIAL” VARCHAR2(100), “P2_MATERIAL” VARCHAR2(100), “IS_PIPE_WELD” VARCHAR2(10), “HULL_CLASS” VARCHAR2(10), “CREATE_USER_NO” VARCHAR2(32), “CREATE_USER_NAME” VARCHAR2(50), “CREATE_DATE” DATE, “UPDATE_USER_NO” VARCHAR2(32), “UPDATE_USER_NAME” VARCHAR2(50), “UPDATE_DATE” DATE, “ID” NUMBER NOT NULL ENABLE, “DELETE_DATE” DATE, “SPOOL_WELD_FLAG” VARCHAR2(100), CONSTRAINT “CP_PIPE_WELD_DESIGN_INFO_PK” PRIMARY KEY (“ID”) USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “ECIMS_AIO” ENABLE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “ECIMS_AIO” ; CREATE UNIQUE INDEX “ECIMS_AIO”.“CP_PIPE_WELD_DESIGN_INFO_PK” ON “ECIMS_AIO”.“CP_PIPE_WELD_DESIGN_INFO” (“ID”) PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “ECIMS_AIO” ; CREATE INDEX “ECIMS_AIO”.“IDX_CP_PART_DESIGN_4COLS” ON “ECIMS_AIO”.“CP_PIPE_WELD_DESIGN_INFO” (“PROJECT_NO”, “PIPE_NO”, “PIPE_VERSION”, “WELD_NO”) PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “ECIMS_AIO” ; CREATE INDEX “ECIMS_AIO”.“IDX_A_MAIN” ON “ECIMS_AIO”.“CP_PIPE_WELD_DESIGN_INFO” (“PROJECT_NO”, “PIPE_NO”, “PIPE_VERSION”, “WELD_NO”, “IS_DELETE”, “WELD_CONN_TYPE_SHORT”, “ID”, “SHOP_FIELD_FLAG”) PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE “ECIMS_AIO” ; COMMENT ON TABLE ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO IS ‘管道焊缝设计信息表’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.PROJECT_NO IS ‘项目名’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.PIPE_NO IS ‘小票号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.PIPE_VERSION IS ‘版本号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.WELD_NO IS ‘焊缝号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.SYS_NO IS ‘系统代码’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.SYS_NAME IS ‘系统名称’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.WELD_LENGTH IS ‘长度’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P1_PIPE_NO IS ‘端头1管号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P1_PART_NO IS ‘端头1零件编号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P2_PIPE_NO IS ‘端头2管号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P2_PART_NO IS ‘端头2零件编号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.WELD_CONN_TYPE_SHORT IS ‘焊缝形式’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.PWELD_FLAG IS ‘焊接方式D为点焊’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.SHOP_FIELD_FLAG IS ‘焊缝阶段’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.BRANCH_TYPE IS ‘支管类型B是支管,O焊接座支管类型’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.PAGE_NO IS ‘页码’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.CALIBER IS ‘外径’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.THICKNESS IS ‘壁厚’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.WELD_INCH_QTY IS ‘寸口数’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.IS_DELETE IS ‘删除标志（Y/N）’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.WELD_CONN_TYPE IS ‘焊缝形式全称’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P1_MATERIAL IS ‘端头1材质’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.P2_MATERIAL IS ‘端头2材质’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.IS_PIPE_WELD IS ‘属于小票焊缝标识Y/N’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.HULL_CLASS IS ‘结构等级’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.CREATE_USER_NO IS ‘创建人工号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.CREATE_USER_NAME IS ‘创建人姓名’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.CREATE_DATE IS ‘创建时间’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.UPDATE_USER_NO IS ‘修改人工号’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.UPDATE_USER_NAME IS ‘修改人姓名’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.UPDATE_DATE IS ‘修改时间’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.ID IS ‘主键id’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.DELETE_DATE IS ‘删除时间’; COMMENT ON COLUMN ECIMS_AIO.CP_PIPE_WELD_DESIGN_INFO.SPOOL_WELD_FLAG IS ‘属于小票焊缝标识Y/N’; 将columns的字段根据sql语句的字段补齐
最新发布
09-27
fieldNames: { label: "projId", value: "projId" } }, decorator: { rules: [{ required: true, message: "请选择项目！" }] } }, { title: "小票号", dataIndex: "pipeNo", condition: true, width: 150 ...
ftok()函数深度解析
qq_44848795的博客
12-18 2310
在使用ftok()函数时，里面有两个参数，即fname和id，fname为指定的文件名，而id为子序列号，这个函数的返回值就是key，它与指定的文件的索引节点号和子序列号id有关，这样就会给我们一个误解，即只要文件的路径，名称和子序列号不变，那么得到的key值永远就不会变。在一般的UNIX中，通常是将文件的索引节点取出，然后在前面加上子序号就得到key_t的值。通过执行结果可看出，ftok获取的键值是由ftok()函数的第二个参数的后8个bit，st_dev的后两位，st_ino的后四位构成的。
消息队列的进程间通信
m0_57678852的博客
10-28 326
消息队列的结构读取消息队列中的某个消息，要知道消息队列的msqid和msg_type。
深入简出的掌握BitMap
布道
10-10 3214
Bitmap作为被各种框架广泛引用的一门技术，它的原理其实很简单。bit即比特，而Bitmap则是通过bit位来标识某个元素对应的值（支持 0、1 两种状态），简单而言，Bitmap 本身就是一个 bit 数组。 目录 1.特性 高性能 存储空间小 2.适用场景 3.局限性 4.实现一个吧 开源利器组件-RoaringBitmap 5.发展需要 6.相关开源应用 Redis ...
Linux详解 --- 进程间通信2 (共享内存、信号量)
wuqiongjin的博客
02-06 2057
共享内存：共享内存的查看及删除、共享内存建立的过程、申请共享内存、将共享存、挂接到进程地址空间中、'去'关联共享内存、释放共享内存、如何使用共享内存 信号量
进程间通信
suyu1804849643的博客
03-10 168
1.创建进程 原型：pid_t fork(void); 返回值：如果成功，子进程的PID将在父进程中返回，并且在子进程中返回0。失败时，在父进程中返回-1，没有创建子进程，并且适当地设置errno。 ...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值