CREATE TABLE FORM_HISTORY_INFO_GW_TEST ( ID NUMBER(19,0) DEFAULT 0, PROCESSID VARCHAR2(20), FORMID VARCHAR2(32) COMMENT '表单类型', TASKID VARCHAR2(64) COMMENT '任务ID', TASKNAME VARCHAR2(50) COMMENT '流程taskname', APPROVEID VARCHAR2(20) COMMENT '签核人工号', APPROVENAME VARCHAR2(50) COMMENT '签核人姓名', APPROVEPOSID VARCHAR2(20) COMMENT '签核人岗位', APPROVEJOBNAME VARCHAR2(50) COMMENT '签核人职务', APPROVEORGID VARCHAR2(20) COMMENT '签核人组织代码', APPROVEORGNAME VARCHAR2(200) COMMENT '签核人组织', APPROVEDESC VARCHAR2(4000) COMMENT '签核意见', APPROVESTATE VARCHAR2(20) COMMENT '签核状态', NEXTAPPROVEID VARCHAR2(60) COMMENT '下一关签核人工号', NEXTAPPROVENAME VARCHAR2(60) COMMENT '下一关签核人姓名', APPROVETIME TIMESTAMP, ARRIVALTIME TIMESTAMP, ROLEID VARCHAR2(20) COMMENT '流程角色', AGENCYID VARCHAR2(20) COMMENT '被代理人工号', AGENCYNAME VARCHAR2(20) COMMENT '被代理人姓名', AGENCYPOSID VARCHAR2(20) COMMENT '被代理人岗位', AGENCYSTATE VARCHAR2(20) COMMENT '代理状态', CLIENTIP VARCHAR2(30) COMMENT '签核方式', APPROVESTATUS VARCHAR2(50) COMMENT '会办单位标记', APPROVELEVEL VARCHAR2(3) COMMENT '签核层级', PROCINSTID VARCHAR2(100) COMMENT '流程实例ID', INTERVALTIME NUMBER(10,2) COMMENT '签核时效', FORMTYPEID VARCHAR2(8) COMMENT '表单内型ID' );去掉注释内容
时间: 2023-08-20 07:05:44 浏览: 74
以下是去除注释内容后的建表语句:
```sql
CREATE TABLE FORM_HISTORY_INFO_GW_TEST (
ID NUMBER(19,0) DEFAULT 0,
PROCESSID VARCHAR2(20),
FORMID VARCHAR2(32),
TASKID VARCHAR2(64),
TASKNAME VARCHAR2(50),
APPROVEID VARCHAR2(20),
APPROVENAME VARCHAR2(50),
APPROVEPOSID VARCHAR2(20),
APPROVEJOBNAME VARCHAR2(50),
APPROVEORGID VARCHAR2(20),
APPROVEORGNAME VARCHAR2(200),
APPROVEDESC VARCHAR2(4000),
APPROVESTATE VARCHAR2(20),
NEXTAPPROVEID VARCHAR2(60),
NEXTAPPROVENAME VARCHAR2(60),
APPROVETIME TIMESTAMP,
ARRIVALTIME TIMESTAMP,
ROLEID VARCHAR2(20),
AGENCYID VARCHAR2(20),
AGENCYNAME VARCHAR2(20),
AGENCYPOSID VARCHAR2(20),
AGENCYSTATE VARCHAR2(20),
CLIENTIP VARCHAR2(30),
APPROVESTATUS VARCHAR2(50),
APPROVELEVEL VARCHAR2(3),
PROCINSTID VARCHAR2(100),
INTERVALTIME NUMBER(10,2),
FORMTYPEID VARCHAR2(8)
);
```
注意,上述建表语句已经去除了每个列的注释内容。
阅读全文