|
楼主 |
发表于 2018-10-10 10:14:24
|
显示全部楼层
因为这是系统自带的表,我这边没有新建。 SA_TASK_HISTROY这个表数据库中存在,查看建表语句如下:
create table SA_TASK_HISTROY
(
sid VARCHAR2(32) not null,
scode VARCHAR2(128),
sparentid VARCHAR2(32),
sname VARCHAR2(255),
scontent CLOB,
sremark CLOB,
ssummary CLOB,
sflowid VARCHAR2(32),
ssourceid VARCHAR2(32),
sfrontid VARCHAR2(32),
sexecutemode2 VARCHAR2(256),
sexecutemode VARCHAR2(32),
spreemptmode VARCHAR2(32),
scatalogid VARCHAR2(32),
skindid VARCHAR2(32),
stypeid VARCHAR2(32),
stypename VARCHAR2(64),
simportanceid VARCHAR2(32),
simportancename VARCHAR2(64),
semergencyid VARCHAR2(32),
semergencyname VARCHAR2(64),
sprocess VARCHAR2(127),
sactivity VARCHAR2(128),
scurl CLOB,
seurl CLOB,
screatetime DATE,
sdistributetime DATE,
slastmodifytime DATE,
swarningtime DATE,
slimittime DATE,
sexpectstarttime DATE,
sexpectfinishtime DATE,
sactualstarttime DATE,
sactualfinishtime DATE,
sexecutetime DATE,
screatorpersonid VARCHAR2(32),
screatorpersonname VARCHAR2(128),
screatorposid VARCHAR2(32),
screatorposname VARCHAR2(128),
screatordeptid VARCHAR2(32),
screatordeptname VARCHAR2(128),
screatorognid VARCHAR2(32),
screatorognname VARCHAR2(128),
screatorfid VARCHAR2(212),
screatorfname VARCHAR2(1024),
sexecutorpersonid VARCHAR2(32),
sexecutorpersonname VARCHAR2(128),
sexecutorposid VARCHAR2(32),
sexecutorposname VARCHAR2(128),
sexecutordeptid VARCHAR2(32),
sexecutordeptname VARCHAR2(128),
sexecutorognid VARCHAR2(32),
sexecutorognname VARCHAR2(128),
sexecutorfid VARCHAR2(212),
sexecutorfname VARCHAR2(1024),
sexecutornames CLOB,
sactivitynames CLOB,
sresponsible VARCHAR2(8),
scustomerid VARCHAR2(64),
scustomercode VARCHAR2(64),
scustomername VARCHAR2(256),
sprojectid VARCHAR2(64),
sprojectcode VARCHAR2(64),
sprojectname VARCHAR2(256),
splanid VARCHAR2(64),
splancode VARCHAR2(64),
splanname VARCHAR2(256),
sdata1 VARCHAR2(32),
sdata2 VARCHAR2(32),
sdata3 VARCHAR2(32),
sdata4 VARCHAR2(32),
sfake VARCHAR2(8),
sactive VARCHAR2(8),
sstatusid VARCHAR2(32),
sstatusname VARCHAR2(64),
saiid VARCHAR2(32),
saistatusid VARCHAR2(256),
saistatusname VARCHAR2(256),
saiactive VARCHAR2(8),
sworktime INTEGER,
sversionnumber VARCHAR2(64),
ssequence INTEGER,
slock VARCHAR2(32),
shints CLOB,
sshortcut CLOB,
sremindmode VARCHAR2(32),
version INTEGER,
swithdraw INTEGER,
svariable CLOB,
sprocessname VARCHAR2(128),
sactivityname VARCHAR2(128),
sprocesstemplateid VARCHAR2(32),
sprocesstemplateitemsequence VARCHAR2(128),
stemppermissionid VARCHAR2(32),
sactivityintemplate VARCHAR2(128),
sprocesstemplateid2 VARCHAR2(32),
sesfield01 VARCHAR2(128),
sesfield02 VARCHAR2(128),
sesfield03 VARCHAR2(128),
sesfield04 VARCHAR2(128),
sesfield05 VARCHAR2(128),
sesfield06 VARCHAR2(128),
sesfield07 VARCHAR2(128),
sesfield08 VARCHAR2(128),
senfield11 NUMBER,
senfield12 NUMBER,
senfield13 NUMBER,
senfield14 NUMBER,
sedfield21 DATE,
sedfield22 DATE,
sedfield23 DATE,
sedfield24 DATE,
setfield31 CLOB,
setfield32 CLOB,
setfield33 CLOB,
setfield34 CLOB,
seifield41 INTEGER,
seifield42 INTEGER,
seifield43 INTEGER,
seifield44 INTEGER,
sebfield51 BLOB,
sebfield52 BLOB,
sebfield53 BLOB,
sebfield54 BLOB
)
|
|