CREATE TABLE BPM_AGENT_CONDITION ( ID NUMBER(18) NOT NULL, SETTINGID NUMBER(18), CON VARCHAR2(1000), MEMO VARCHAR2(200), AGENTID NUMBER(18), AGENT VARCHAR2(100), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_AGENT_CONDITION IS '条件代理的配置'; /*==============================================================*/ /* TABLE: BPM_AGENT_DEF */ /*==============================================================*/ CREATE TABLE BPM_AGENT_DEF ( ID NUMBER(18) NOT NULL, SETTINGID NUMBER(18), FLOWKEY VARCHAR2(50), FLOWNAME VARCHAR2(200), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_AGENT_DEF IS '代理的流程列表'; /*==============================================================*/ /* TABLE: BPM_AGENT_SETTING */ /*==============================================================*/ CREATE TABLE BPM_AGENT_SETTING ( ID NUMBER(18) NOT NULL, AUTHID NUMBER(18), AUTHNAME VARCHAR2(100), CREATETIME TIMESTAMP, STARTDATE TIMESTAMP, ENDDATE TIMESTAMP null, ENABLED SMALLINT, AUTHTYPE SMALLINT, AGENTID NUMBER(18), AGENT VARCHAR2(100), FLOWKEY VARCHAR2(100), FLOWNAME VARCHAR2(100), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_AGENT_SETTING IS '代理设定'; /*==============================================================*/ /* TABLE: BPM_APPROVAL_ITEM */ /*==============================================================*/ CREATE TABLE BPM_APPROVAL_ITEM ( ITEMID NUMBER(18) NOT NULL, USERID NUMBER(18), DEFKEY VARCHAR2(128), TYPEID NUMBER(18), TYPE SMALLINT, EXPRESSION VARCHAR2(3000), PRIMARY KEY (ITEMID) ); COMMENT ON TABLE BPM_APPROVAL_ITEM IS '任务审批常用语设置'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.ITEMID IS '常用语主键'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.USERID IS '用户ID'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.DEFKEY IS '流程定义Key'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.TYPEID IS '流程分类ID'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.TYPE IS '常用语类型'; COMMENT ON COLUMN BPM_APPROVAL_ITEM.EXPRESSION IS '常用语内容'; /*==============================================================*/ /* TABLE: BPM_BUS_LINK */ /*==============================================================*/ CREATE TABLE BPM_BUS_LINK ( BUS_ID NUMBER(18) NOT NULL, BUS_FORM_TABLE VARCHAR2(255), BUS_PK NUMBER(18), BUS_PKSTR VARCHAR2(50), BUS_DEF_ID NUMBER(18), BUS_FLOW_RUNID NUMBER(18), BUS_CREATOR_ID NUMBER(18), BUS_CREATOR NVARCHAR2(50), BUS_ORG_ID NUMBER(18), BUS_ORG_NAME NVARCHAR2(200), BUS_CREATETIME TIMESTAMP(6), BUS_UPDID NUMBER(18), BUS_UPD NVARCHAR2(50), BUS_STATUS NUMBER(1), BUS_UPDTIME TIMESTAMP(6), BUS_PROC_INST_ID NUMBER(18) ) PARTITION BY LIST(BUS_FORM_TABLE)( PARTITION P_TABLE_UNCREATED VALUES ('TABLE_UNCREATED') ) ; comment on table BPM_BUS_LINK is '业务数据关联表'; comment on column BPM_BUS_LINK.bus_id is '主键'; comment on column BPM_BUS_LINK.bus_form_table is '对应关联表名'; comment on column BPM_BUS_LINK.bus_pk is '对应关联表主键'; comment on column BPM_BUS_LINK.bus_pkstr is '对应关联表主键(字符串)'; comment on column BPM_BUS_LINK.bus_def_id is '流程定义ID'; comment on column BPM_BUS_LINK.bus_flow_runid is '流程运行ID'; comment on column BPM_BUS_LINK.bus_creator_id is '发起人ID'; comment on column BPM_BUS_LINK.bus_creator is '发起人'; comment on column BPM_BUS_LINK.bus_org_id is '发起组织'; comment on column BPM_BUS_LINK.bus_org_name is '组织名称'; comment on column BPM_BUS_LINK.bus_createtime is '发起时间'; comment on column BPM_BUS_LINK.bus_updid is '最后更新人'; comment on column BPM_BUS_LINK.bus_upd is '最后更新人'; comment on column BPM_BUS_LINK.bus_updtime is '最后更新时间'; alter table BPM_BUS_LINK add constraint PK_BUS_LINK primary key (BUS_ID); /*==============================================================*/ /* TABLE: BPM_COMMU_RECEIVER */ /*==============================================================*/ CREATE TABLE BPM_COMMU_RECEIVER ( ID NUMBER(18) NOT NULL, OPINIONID NUMBER(18), RECEVIERID NUMBER(18), RECEIVERNAME VARCHAR2(100), STATUS SMALLINT, CREATETIME TIMESTAMP, RECEIVETIME TIMESTAMP, FEEDBACKTIME TIMESTAMP, TASKID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_COMMU_RECEIVER IS '通知任务接收人'; /*==============================================================*/ /* TABLE: BPM_DEFINITION */ /*==============================================================*/ CREATE TABLE BPM_DEFINITION ( DEFID NUMBER(18) NOT NULL, TYPEID NUMBER(18), SUBJECT VARCHAR2(256) NOT NULL, DEFKEY VARCHAR2(128) NOT NULL, TASKNAMERULE VARCHAR2(512), DESCP VARCHAR2(1024), STATUS SMALLINT, DEFXML CLOB, ACTDEPLOYID NUMBER(18), ACTDEFKEY VARCHAR2(255), ACTDEFID VARCHAR2(128), CREATETIME DATE, UPDATETIME DATE, CREATEBY NUMBER(18), UPDATEBY NUMBER(18), REASON VARCHAR2(512), VERSIONNO NUMBER(18), PARENTDEFID NUMBER(18), ISMAIN SMALLINT, TOFIRSTNODE NUMBER(18), SHOWFIRSTASSIGNEE SMALLINT, CANCHOICEPATH VARCHAR2(500), ISUSEOUTFORM SMALLINT, FORMDETAILURL VARCHAR2(200), ALLOWFINISHEDCC SMALLINT, SUBMITCONFIRM SMALLINT, ALLOWDIVERT SMALLINT, INFORMSTART VARCHAR2(20), INFORMTYPE VARCHAR2(20), ATTACHMENT NUMBER(18), SAMEEXECUTORJUMP SMALLINT, ALLOWREFER SMALLINT, INSTANCEAMOUNT SMALLINT, ALLOWFINISHEDDIVERT SMALLINT, ISPRINTFORM SMALLINT, DIRECTSTART SMALLINT, CCMESSAGETYPE VARCHAR2(100), TESTSTATUSTAG VARCHAR2(100), ALLOWDELDRAF SMALLINT, ALLOWMOBILE INTEGER DEFAULT 1, SKIPSETTING VARCHAR2(50), PRIMARY KEY (DEFID) ); COMMENT ON TABLE BPM_DEFINITION IS '流程定义扩展CODE:DEFTN'; /*==============================================================*/ /* TABLE: BPM_DEF_VARS */ /*==============================================================*/ CREATE TABLE BPM_DEF_VARS ( VARID NUMBER(18) NOT NULL, DEFID NUMBER(18), VARNAME VARCHAR2(128) NOT NULL, VARKEY VARCHAR2(128), VARDATATYPE VARCHAR2(64), DEFVALUE VARCHAR2(256), NODENAME VARCHAR2(256), NODEID VARCHAR2(256), ACTDEPLOYID NUMBER(18), VARSCOPE VARCHAR2(64), PRIMARY KEY (VARID) ); COMMENT ON TABLE BPM_DEF_VARS IS '流程变量定义'; /*==============================================================*/ /* TABLE: BPM_EXE_STACK */ /*==============================================================*/ CREATE TABLE BPM_EXE_STACK ( STACKID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(64), NODEID VARCHAR2(128) NOT NULL, NODENAME VARCHAR2(256), STARTTIME TIMESTAMP, ENDTIME TIMESTAMP, ASSIGNEES VARCHAR2(1024), ISMULTITASK SMALLINT, PARENTID NUMBER(18), ACTINSTID NUMBER(18), TASKIDS VARCHAR2(512), NODEPATH VARCHAR2(1024), DEPTH NUMBER(18), TASKTOKEN VARCHAR2(128), PRIMARY KEY (STACKID) ); COMMENT ON TABLE BPM_EXE_STACK IS '流程执行堆栈树'; /*==============================================================*/ /* TABLE: BPM_FORM_DEF */ /*==============================================================*/ CREATE TABLE BPM_FORM_DEF ( FORMDEFID NUMBER(18) NOT NULL, CATEGORYID NUMBER(18), FORMKEY VARCHAR2(128), SUBJECT VARCHAR2(128), FORMDESC VARCHAR2(200), HTML CLOB, TEMPLATE CLOB, ISDEFAULT SMALLINT, VERSIONNO NUMBER(18), TABLEID NUMBER(18), ISPUBLISHED SMALLINT, PUBLISHEDBY VARCHAR2(20), PUBLISHTIME DATE, TABTITLE VARCHAR2(500), DESIGNTYPE SMALLINT, TEMPLATESID VARCHAR2(300), CREATEBY NUMBER(18), CREATOR VARCHAR2(50), CREATETIME TIMESTAMP, PRIMARY KEY (FORMDEFID) ); /*==============================================================*/ /* TABLE: BPM_FORM_DIALOG */ /*==============================================================*/ CREATE TABLE BPM_FORM_DIALOG ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), ALIAS VARCHAR2(50), STYLE SMALLINT, WIDTH NUMBER(18), HEIGHT NUMBER(18), ISSINGLE SMALLINT, NEEDPAGE SMALLINT, ISTABLE SMALLINT, OBJNAME VARCHAR2(50), DISPLAYFIELD VARCHAR2(2000), CONDITIONFIELD VARCHAR2(2000), RESULTFIELD VARCHAR2(1000), DSNAME VARCHAR2(50), DSALIAS VARCHAR2(50), PAGESIZE SMALLINT, SORTFIELD VARCHAR2(200), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_FORM_DIALOG IS '通用表单对话框'; /*==============================================================*/ /* TABLE: BPM_FORM_FIELD */ /*==============================================================*/ CREATE TABLE BPM_FORM_FIELD ( FIELDID NUMBER(18) NOT NULL, TABLEID NUMBER(18), FIELDNAME VARCHAR2(128) NOT NULL, FIELDTYPE VARCHAR2(128) NOT NULL, ISREQUIRED SMALLINT, ISLIST SMALLINT DEFAULT 1, ISQUERY SMALLINT DEFAULT 1, FIELDDESC VARCHAR2(128), CHARLEN NUMBER(18), INTLEN NUMBER(18), DECIMALLEN NUMBER(18), DICTTYPE VARCHAR2(100), ISDELETED SMALLINT, VALIDRULE VARCHAR2(64), ORIGINALNAME VARCHAR2(128), SN NUMBER(18), VALUEFROM SMALLINT, SCRIPT VARCHAR2(1000), CONTROLTYPE SMALLINT, ISHIDDEN SMALLINT, ISFLOWVAR SMALLINT, SERIALNUM VARCHAR2(20), OPTIONS VARCHAR2(1000), CTLPROPERTY VARCHAR2(2000), ISALLOWMOBILE SMALLINT, ISWEBSIGN SMALLINT, ISREFERENCE SMALLINT, PRIMARY KEY (FIELDID) ); COMMENT ON TABLE BPM_FORM_FIELD IS '表单字段'; /*==============================================================*/ /* TABLE: BPM_FORM_QUERY */ /*==============================================================*/ CREATE TABLE BPM_FORM_QUERY ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), ALIAS VARCHAR2(50), OBJ_NAME VARCHAR2(50), NEEDPAGE NUMBER(18), CONDITIONFIELD VARCHAR2(2000), RESULTFIELD VARCHAR2(2000), DSNAME VARCHAR2(50), DSALIAS VARCHAR2(50), PAGESIZE NUMBER(18) DEFAULT 10, ISTABLE NUMBER(18), SORTFIELD VARCHAR2(2000), PRIMARY KEY (ID) ); /*==============================================================*/ /* TABLE: BPM_FORM_RIGHTS */ /*==============================================================*/ CREATE TABLE BPM_FORM_RIGHTS ( ID NUMBER(18) NOT NULL, FORMKEY VARCHAR(50), NAME VARCHAR2(128), PERMISSION VARCHAR2(2000), TYPE SMALLINT, NODEID VARCHAR2(60), ACTDEFID VARCHAR2(60), PARENTACTDEFID VARCHAR2(128), PLATFORM NUMBER(18) DEFAULT 1, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_FORM_RIGHTS IS '表单权限'; /*==============================================================*/ /* TABLE: BPM_FORM_RULE */ /*==============================================================*/ CREATE TABLE BPM_FORM_RULE ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), REGULATION VARCHAR2(100), MEMO VARCHAR2(100), TIPINFO VARCHAR2(100), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_FORM_RULE IS '表单认证规则'; /*==============================================================*/ /* TABLE: BPM_FORM_RUN */ /*==============================================================*/ CREATE TABLE BPM_FORM_RUN ( ID NUMBER(18) NOT NULL, FORMDEFID NUMBER(18), FORMDEFKEY VARCHAR2(50), ACTINSTANCEID VARCHAR2(64), ACTDEFID VARCHAR2(64), ACTNODEID VARCHAR2(64), RUNID NUMBER(18), SETTYPE SMALLINT, FORMTYPE SMALLINT, FORMURL VARCHAR2(255), MOBILEFORMID NUMBER(18), MOBILEFORMKEY VARCHAR2(50), MOBILEFORMURL VARCHAR2(255), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_FORM_RUN IS '流程表单运行情况'; /*==============================================================*/ /* TABLE: BPM_FORM_TABLE */ /*==============================================================*/ CREATE TABLE BPM_FORM_TABLE ( TABLEID NUMBER(18) NOT NULL, TABLENAME VARCHAR2(128) NOT NULL, TABLEDESC VARCHAR2(128), ISMAIN SMALLINT, MAINTABLEID NUMBER(18), VERSIONNO NUMBER(18), ISDEFAULT SMALLINT, ISPUBLISHED SMALLINT, PUBLISHEDBY VARCHAR2(100), PUBLISHTIME DATE, ISEXTERNAL SMALLINT, DSALIAS VARCHAR2(50), DSNAME VARCHAR2(50), RELATION VARCHAR2(500), KEYTYPE SMALLINT, KEYVALUE VARCHAR2(20), PKFIELD VARCHAR2(20), LISTTEMPLATE CLOB, DETAILTEMPLATE CLOB, GENBYFORM SMALLINT, CREATETIME TIMESTAMP, CREATOR VARCHAR2(50), CREATEBY NUMBER(18), TEAM CLOB, KEYDATATYPE SMALLINT, CATEGORYID NUMBER(18), PRIMARY KEY (TABLEID) ); COMMENT ON TABLE BPM_FORM_TABLE IS '表单数据库表'; /*==============================================================*/ /* TABLE: BPM_FORM_TEMPLATE */ /*==============================================================*/ CREATE TABLE BPM_FORM_TEMPLATE ( TEMPLATEID NUMBER(18) NOT NULL, TEMPLATENAME VARCHAR2(200), TEMPLATETYPE VARCHAR2(20), MACROTEMPLATEALIAS VARCHAR2(50), HTML CLOB, TEMPLATEDESC VARCHAR2(400), CANEDIT SMALLINT, ALIAS VARCHAR2(50), PRIMARY KEY (TEMPLATEID) ); COMMENT ON TABLE BPM_FORM_TEMPLATE IS '表单模版'; /*==============================================================*/ /* TABLE: BPM_GANGED_SET */ /*==============================================================*/ CREATE TABLE BPM_GANGED_SET ( ID NUMBER(18) NOT NULL, DEFID NUMBER(18), NODEID VARCHAR2(100), NODENAME VARCHAR2(200), CHOISEFIELD CLOB, CHANGEFIELD CLOB, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_GANGED_SET IS '表单联动设置'; /*==============================================================*/ /* TABLE: BPM_MON_GROUP */ /*==============================================================*/ CREATE TABLE BPM_MON_GROUP ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(200), GRADE SMALLINT, ENABLED SMALLINT, CREATORID NUMBER(18), CREATOR VARCHAR2(50), CREATETIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_MON_GROUP IS '流程监控分组'; /*==============================================================*/ /* TABLE: BPM_MON_GROUPITEM */ /*==============================================================*/ CREATE TABLE BPM_MON_GROUPITEM ( ID NUMBER(18) NOT NULL, GROUPID NUMBER(18), FLOWKEY VARCHAR2(50), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_MON_GROUPITEM IS '分组流程定义'; /*==============================================================*/ /* TABLE: BPM_MON_ORGROLE */ /*==============================================================*/ CREATE TABLE BPM_MON_ORGROLE ( ID NUMBER(18) NOT NULL, GROUPID NUMBER(18), ROLEID NUMBER(18), ORGID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_MON_ORGROLE IS '分组角色组织授权'; /*==============================================================*/ /* TABLE: BPM_NODE_BTN */ /*==============================================================*/ CREATE TABLE BPM_NODE_BTN ( ID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(64), ISSTARTFORM SMALLINT, NODEID VARCHAR2(50), BTNNAME VARCHAR2(50), ICONCLSNAME VARCHAR2(50), OPERATORTYPE SMALLINT, PREVSCRIPT VARCHAR2(2000), AFTERSCRIPT VARCHAR2(2000), NODETYPE SMALLINT, SN NUMBER(18), DEFID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_NODE_BTN IS '自定义工具条'; /*==============================================================*/ /* TABLE: BPM_NODE_MESSAGE */ /*==============================================================*/ CREATE TABLE BPM_NODE_MESSAGE ( ID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(64), NODEID VARCHAR2(50), MESSAGETYPE SMALLINT, SUBJECT VARCHAR2(200), TEMPLATE CLOB, ISSEND SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_NODE_MESSAGE IS '流程消息节点'; /*==============================================================*/ /* TABLE: BPM_NODE_PRIVILEGE */ /*==============================================================*/ CREATE TABLE BPM_NODE_PRIVILEGE ( PRIVILEGEID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(128), NODEID VARCHAR2(128), PRIVILEGEMODE SMALLINT, USERTYPE SMALLINT, CMPNAMES CLOB, CMPIDS CLOB, PRIMARY KEY (PRIVILEGEID) ); COMMENT ON TABLE BPM_NODE_PRIVILEGE IS '节点特权'; /*==============================================================*/ /* TABLE: BPM_NODE_RULE */ /*==============================================================*/ CREATE TABLE BPM_NODE_RULE ( RULEID NUMBER(18) NOT NULL, RULENAME VARCHAR2(128) NOT NULL, CONDITIONCODE CLOB, ACTDEFID VARCHAR2(127), NODEID VARCHAR2(50), PRIORITY NUMBER(18), TARGETNODE VARCHAR2(20), TARGETNODENAME VARCHAR2(255), MEMO VARCHAR2(200), PRIMARY KEY (RULEID) ); COMMENT ON TABLE BPM_NODE_RULE IS '流程节点规则流程节点规则 是用于设计根据表单或其他流程变量来进行计算，以实现其规则的跳转CODE: NODE_RULE'; /*==============================================================*/ /* TABLE: BPM_NODE_SCRIPT */ /*==============================================================*/ CREATE TABLE BPM_NODE_SCRIPT ( ID NUMBER(18) NOT NULL, MEMO VARCHAR2(50), NODEID VARCHAR2(20), ACTDEFID VARCHAR2(64), SCRIPT CLOB, SCRIPTTYPE NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_NODE_SCRIPT IS '流程节点事件脚本'; /*==============================================================*/ /* TABLE: BPM_NODE_SET */ /*==============================================================*/ CREATE TABLE BPM_NODE_SET ( SETID NUMBER(18) NOT NULL, DEFID NUMBER(18), NODENAME VARCHAR2(256), NODEORDER SMALLINT, NODEID VARCHAR2(128), FORMTYPE SMALLINT DEFAULT 0, FORMURL VARCHAR2(255), FORMKEY VARCHAR(50), ACTDEFID VARCHAR2(127), FORMDEFNAME VARCHAR2(255), NODETYPE SMALLINT, JOINTASKKEY VARCHAR2(128), JOINTASKNAME VARCHAR2(256), BEFOREHANDLER VARCHAR2(100), AFTERHANDLER VARCHAR2(100), JUMPTYPE VARCHAR2(32), SETTYPE SMALLINT, ISJUMPFORDEF SMALLINT, ISHIDEOPTION SMALLINT, ISHIDEPATH SMALLINT, DETAILURL VARCHAR2(256), ISALLOWMOBILE SMALLINT, INFORMTYPE VARCHAR(50), PARENTACTDEFID VARCHAR2(128), MOBILEFORMKEY VARCHAR2(50), SCOPE VARCHAR(256), ISREQUIRED SMALLINT DEFAULT 0, ISPOPUP SMALLINT DEFAULT 1, OPINIONFIELD VARCHAR2(64), OPINIONHTML SMALLINT DEFAULT 1, SENDMSGTOCREATOR SMALLINT, MOBILEFORMNAME VARCHAR2(64), ENABLEMOBILE SMALLINT, PRIMARY KEY (SETID) ); COMMENT ON TABLE BPM_NODE_SET IS '流程节点设置'; COMMENT ON COLUMN BPM_NODE_SET.ENABLEMOBILE IS '是否允许手机表单'; /*==============================================================*/ /* TABLE: BPM_NODE_SIGN */ /*==============================================================*/ CREATE TABLE BPM_NODE_SIGN ( SIGNID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(127), NODEID VARCHAR2(128), VOTEAMOUNT NUMBER(18), DECIDETYPE SMALLINT NOT NULL, VOTETYPE SMALLINT, FLOWMODE SMALLINT, PRIMARY KEY (SIGNID) ); COMMENT ON TABLE BPM_NODE_SIGN IS '任务会签设置'; /*==============================================================*/ /* TABLE: BPM_NODE_USER */ /*==============================================================*/ CREATE TABLE BPM_NODE_USER ( NODEUSERID NUMBER(18) NOT NULL, CMPIDS CLOB, CMPNAMES CLOB, ASSIGNTYPE VARCHAR2(20) , SN NUMBER(18), COMPTYPE SMALLINT, CONDITIONID NUMBER(18), EXTRACTUSER SMALLINT, PRIMARY KEY (NODEUSERID) ); COMMENT ON TABLE BPM_NODE_USER IS '流程节点人员'; /*==============================================================*/ /* TABLE: BPM_NODE_WEBSERVICE */ /*==============================================================*/ CREATE TABLE BPM_NODE_WEBSERVICE ( ID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(128), NODEID VARCHAR2(128), DOCUMENT clob, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_NODE_WEBSERVICE IS '流程WEBSERVICE节点'; /*==============================================================*/ /* TABLE: BPM_NODE_WS_PARAMS */ /*==============================================================*/ CREATE TABLE BPM_NODE_WS_PARAMS ( ID NUMBER(18) NOT NULL, WEBSERVICEID NUMBER(18), PARATYPE NUMBER(18), VARID NUMBER(18), WSNAME VARCHAR2(256), TYPE VARCHAR2(128), PRIMARY KEY (ID) ); /*==============================================================*/ /* TABLE: BPM_PRINT_TEMPLATE */ /*==============================================================*/ CREATE TABLE BPM_PRINT_TEMPLATE ( ID NUMBER(18) NOT NULL, FORM_KEY VARCHAR2(50), TEMAPALTE_NAME VARCHAR2(200), IS_DEFAULT SMALLINT, TABLEID NUMBER(18), HTML CLOB, TEMPLATE CLOB, ALIAS VARCHAR2(200), IS_PRINT_IN_FINISH NUMBER(2), IS_PRINT_IN_FORM NUMBER(2), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_PRINT_TEMPLATE IS '打印模版'; /*==============================================================*/ /* TABLE: BPM_PRO_RUN */ /*==============================================================*/ CREATE TABLE BPM_PRO_RUN ( RUNID NUMBER(18) NOT NULL, DEFID NUMBER(18), BUSINESSKEY_NUM NUMBER(18), PROCESSNAME VARCHAR2(256), SUBJECT VARCHAR2(600), CREATORID NUMBER(18), CREATOR VARCHAR2(128), CREATETIME DATE, BUSDESCP VARCHAR2(3000), ACTINSTID NUMBER(18), STATUS SMALLINT, ACTDEFID VARCHAR2(256), BUSINESSKEY VARCHAR2(255), BUSINESSURL VARCHAR2(255), ENDTIME DATE, DURATION NUMBER(18), PKNAME VARCHAR2(50), TABLENAME VARCHAR2(50), PARENTID NUMBER(18), STARTORGID NUMBER(18), STARTORGNAME VARCHAR2(200), FORMDEFID NUMBER(18), TYPEID NUMBER(18), DSALIAS VARCHAR2(50), FLOWKEY VARCHAR2(50), FORMTYPE NUMBER(1), FORMKEYURL VARCHAR2(50), LASTSUBMITDURATION NUMBER(18), ISFORMAL SMALLINT, STARTNODE VARCHAR2(50), RELRUNID NUMBER(18), GLOBALFLOWNO VARCHAR2(256), STARTFROMMOBILE SMALLINT, PRIMARY KEY (RUNID) ); COMMENT ON TABLE BPM_PRO_RUN IS '流程实例扩展CODE:PRO_RUN'; /*==============================================================*/ /* TABLE: BPM_PRO_RUN_HIS */ /*==============================================================*/ CREATE TABLE BPM_PRO_RUN_HIS ( RUNID NUMBER(18) NOT NULL, DEFID NUMBER(18), BUSINESSKEY_NUM NUMBER(18), PROCESSNAME VARCHAR2(256), SUBJECT VARCHAR2(600), CREATORID NUMBER(18), CREATOR VARCHAR2(128), CREATETIME DATE, BUSDESCP VARCHAR2(3000), ACTINSTID NUMBER(18), STATUS SMALLINT, ACTDEFID VARCHAR2(256), BUSINESSKEY VARCHAR2(255), BUSINESSURL VARCHAR2(255), ENDTIME DATE, DURATION NUMBER(18), PKNAME VARCHAR2(50), TABLENAME VARCHAR2(50), PARENTID NUMBER(18), STARTORGID NUMBER(18), STARTORGNAME VARCHAR2(200), FORMDEFID NUMBER(18), TYPEID NUMBER(18), DSALIAS VARCHAR2(50), FLOWKEY VARCHAR2(50), FORMTYPE NUMBER(1), FORMKEYURL VARCHAR2(50), LASTSUBMITDURATION NUMBER(18), ISFORMAL SMALLINT, STARTNODE VARCHAR2(50), RELRUNID NUMBER(18), GLOBALFLOWNO VARCHAR2(256), STARTFROMMOBILE SMALLINT, PRIMARY KEY (RUNID) ); COMMENT ON TABLE BPM_PRO_RUN_HIS IS '流程实例扩展CODE:PRO_RUN'; /*==============================================================*/ /* TABLE: BPM_PRO_STATUS */ /*==============================================================*/ CREATE TABLE BPM_PRO_STATUS ( ID NUMBER(18), ACTINSTID NUMBER(18), NODEID VARCHAR2(64), NODENAME VARCHAR2(255), STATUS SMALLINT, LASTUPDATETIME DATE, ACTDEFID VARCHAR2(64), DEFID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_PRO_STATUS IS '流程节点状态'; /*==============================================================*/ /* TABLE: BPM_REFER_DEFINITION */ /*==============================================================*/ CREATE TABLE BPM_REFER_DEFINITION ( ID NUMBER(18) NOT NULL, DEFID VARCHAR2(200), REFER_DEFKEY VARCHAR2(128), CREATETIME TIMESTAMP, CREATEID NUMBER(18), UPDATETIME TIMESTAMP, STATE SMALLINT, REMARK VARCHAR2(200), SUBJECT VARCHAR2(200), UPDATEID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_REFER_DEFINITION IS '流程引用定义'; /*==============================================================*/ /* TABLE: BPM_RUN_LOG */ /*==============================================================*/ CREATE TABLE BPM_RUN_LOG ( ID NUMBER(18), USERID NUMBER(18), USERNAME VARCHAR2(50), CREATETIME DATE, OPERATORTYPE SMALLINT, MEMO VARCHAR2(300), RUNID NUMBER(18), PROCESSSUBJECT VARCHAR2(300), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_RUN_LOG IS '工作流运行日志'; /*==============================================================*/ /* TABLE: BPM_SUBTABLE_RIGHTS */ /*==============================================================*/ CREATE TABLE BPM_SUBTABLE_RIGHTS ( ID NUMBER(18), ACTDEFID VARCHAR2(100), NODEID VARCHAR2(50), TABLEID NUMBER(18), PERMISSIONTYPE SMALLINT, PERMISSIONSETING VARCHAR2(2000), PARENTACTDEFID VARCHAR2(128), PRIMARY KEY (ID) ); /*==============================================================*/ /* TABLE: BPM_TASK_DUE */ /*==============================================================*/ CREATE TABLE BPM_TASK_DUE ( TASKDUEID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(127), NODEID VARCHAR2(50), REMINDERSTART NUMBER(18) NOT NULL, REMINDEREND NUMBER(18), TIMES NUMBER(18), MAILCONTENT CLOB, MSGCONTENT CLOB, SMSCONTENT CLOB, ACTION NUMBER(18), SCRIPT VARCHAR2(2000), COMPLETETIME NUMBER(18), CONDEXP CLOB, NAME VARCHAR2(50), RELATIVENODEID VARCHAR2(100), RELATIVENODETYPE NUMBER(18), RELATIVETIMETYPE NUMBER(18), ASSIGNERID NUMBER(18), ASSIGNERNAME VARCHAR2(50), WARNINGSETJSON VARCHAR2(2000), PRIMARY KEY (TASKDUEID) ); COMMENT ON TABLE BPM_TASK_DUE IS '任务节点催办时间设置'; /*==============================================================*/ /* TABLE: BPM_TASK_EXE */ /*==============================================================*/ CREATE TABLE BPM_TASK_EXE ( ID NUMBER(18) NOT NULL, TASKID NUMBER(18), ASSIGNEE_ID NUMBER(18), ASSIGNEE_NAME VARCHAR2(50), OWNER_ID NUMBER(18), OWNER_NAME VARCHAR2(200), SUBJECT VARCHAR2(400), STATUS SMALLINT, MEMO VARCHAR2(4000), CRATETIME DATE, ACT_INST_ID NUMBER(18), TASK_NAME VARCHAR2(400), TASK_DEF_KEY VARCHAR2(64), EXE_TIME DATE, EXE_USER_ID NUMBER(18), EXE_USER_NAME VARCHAR2(256), ASSIGN_TYPE SMALLINT, RUNID NUMBER(18), TYPE_ID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_TASK_EXE IS '任务转办代理'; /*==============================================================*/ /* TABLE: BPM_TASK_FORK */ /*==============================================================*/ CREATE TABLE BPM_TASK_FORK ( TASKFORKID NUMBER(18) NOT NULL, ACTINSTID NUMBER(18), FORKTASKNAME VARCHAR2(256), FORKTASKKEY VARCHAR2(256), FORKSN NUMBER(18), FORKCOUNT NUMBER(18), FININSHCOUNT NUMBER(18), FORKTIME DATE, JOINTASKNAME VARCHAR2(256), JOINTASKKEY VARCHAR2(256), FORKTOKENS VARCHAR2(512), FORKTOKENPRE VARCHAR2(64), PRIMARY KEY (TASKFORKID) ); COMMENT ON TABLE BPM_TASK_FORK IS '流程任务分发汇总'; /*==============================================================*/ /* TABLE: BPM_TASK_OPINION */ /*==============================================================*/ CREATE TABLE BPM_TASK_OPINION ( OPINIONID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(127), TASKNAME VARCHAR2(255), TASKKEY VARCHAR2(64), TASKID NUMBER(18), TASKTOKEN VARCHAR2(50), ACTINSTID NUMBER(18), STARTTIME TIMESTAMP, ENDTIME TIMESTAMP null, DURTIME NUMBER(18), EXEUSERID NUMBER(18), EXEFULLNAME VARCHAR2(127), OPINION CLOB, CHECKSTATUS SMALLINT, FORMDEFID NUMBER(18), FIELDNAME VARCHAR2(50), SUPEREXECUTION NUMBER(18), PRIMARY KEY (OPINIONID) ); COMMENT ON TABLE BPM_TASK_OPINION IS '流程任务审批意见'; /*==============================================================*/ /* TABLE: BPM_TASK_READ */ /*==============================================================*/ CREATE TABLE BPM_TASK_READ ( ID NUMBER(18) NOT NULL, ACTINSTID NUMBER(18), TASKID NUMBER(18), USERID NUMBER(18), USERNAME VARCHAR2(100), CREATETIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_TASK_READ IS '任务已读'; /*==============================================================*/ /* TABLE: BPM_TASK_REMINDERSTATE */ /*==============================================================*/ CREATE TABLE BPM_TASK_REMINDERSTATE ( ID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(127), TASKID NUMBER(18), REMINDERTIME DATE, USERID NUMBER(18), ACTINSTANCEID NUMBER(18), REMINDTYPE SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_TASK_REMINDERSTATE IS '任务催办执行情况'; /*==============================================================*/ /* TABLE: BPM_TKSIGN_DATA */ /*==============================================================*/ CREATE TABLE BPM_TKSIGN_DATA ( DATAID NUMBER(18) NOT NULL, ACTDEFID VARCHAR2(127), ACTINSTID NUMBER(18) NOT NULL, NODENAME VARCHAR2(128), NODEID VARCHAR2(127) NOT NULL, TASKID NUMBER(18), VOTEUSERID VARCHAR2(1000) NOT NULL, VOTEUSERNAME VARCHAR2(1000), VOTETIME DATE, ISAGREE SMALLINT, CONTENT VARCHAR2(200), SIGNNUMS NUMBER(18) DEFAULT 1, ISCOMPLETED SMALLINT DEFAULT 0, BATCH SMALLINT, PRIMARY KEY (DATAID) ); COMMENT ON TABLE BPM_TKSIGN_DATA IS '任务会签数据'; /*==============================================================*/ /* TABLE: BPM_USER_CONDITION */ /*==============================================================*/ CREATE TABLE BPM_USER_CONDITION ( ID NUMBER(18), SETID NUMBER(18), CONDITIONNAME VARCHAR2(127), ACTDEFID VARCHAR2(127), NODEID VARCHAR2(128), CONDITIONCODE CLOB, SN NUMBER(38,0), CONDITIONSHOW CLOB, CONDITIONTYPE SMALLINT, GROUPNO SMALLINT, FORMIDENTITY VARCHAR2(30), PARENTACTDEFID VARCHAR2(128), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_USER_CONDITION IS '用户选择条件'; /*==============================================================*/ /* TABLE: OUT_MAIL */ /*==============================================================*/ CREATE TABLE OUT_MAIL ( MAILID NUMBER(18) NOT NULL, TITLE VARCHAR2(512), CONTENT CLOB, SENDERADDRESSES VARCHAR2(128), SENDERNAME VARCHAR2(128), RECEIVERADDRESSES VARCHAR2(4000), RECEIVERNAMES VARCHAR2(4000), CCADDRESSES VARCHAR2(4000), BCCANAMES VARCHAR2(4000), BCCADDRESSES VARCHAR2(4000), CCNAMES VARCHAR2(4000), EMAILID VARCHAR2(128), TYPES NUMBER(18), USERID NUMBER(18), ISREPLY NUMBER(18), MAILDATE DATE, FILEIDS VARCHAR2(512), ISREAD NUMBER(18), SETID NUMBER(18), PRIMARY KEY (MAILID) ); COMMENT ON TABLE OUT_MAIL IS '外部邮件'; /*==============================================================*/ /* TABLE: OUT_MAIL_LINKMAN */ /*==============================================================*/ CREATE TABLE OUT_MAIL_LINKMAN ( LINKID NUMBER(18) NOT NULL, USERID NUMBER(18), MAILID NUMBER(18), SENDTIME DATE, LINKNAME VARCHAR2(20), LINKADDRESS VARCHAR2(2000), SENDTIMES NUMBER(18), PRIMARY KEY (LINKID) ); COMMENT ON TABLE OUT_MAIL_LINKMAN IS '外部邮件最近联系'; /*==============================================================*/ /* TABLE: OUT_MAIL_USER_SETING */ /*==============================================================*/ CREATE TABLE OUT_MAIL_USER_SETING ( ID NUMBER(18) NOT NULL, USERID NUMBER(18), USERNAME VARCHAR2(128), MAILADDRESS VARCHAR2(128), MAILPASS VARCHAR2(128), SMTPHOST VARCHAR2(128), SMTPPORT VARCHAR2(64), POPHOST VARCHAR2(128), POPPORT VARCHAR2(64), IMAPHOST VARCHAR2(128), IMAPPORT VARCHAR2(128), ISDEFAULT SMALLINT, MAILTYPE VARCHAR2(50), USESSL SMALLINT DEFAULT 0, ISVALIDATE SMALLINT DEFAULT 1, ISDELETEREMOTE SMALLINT DEFAULT 0, ISHANDLEATTACH SMALLINT DEFAULT 1, PRIMARY KEY (ID) ); COMMENT ON TABLE OUT_MAIL_USER_SETING IS '外部邮件用户设置'; /*==============================================================*/ /* TABLE: SYS_ACCEPT_IP */ /*==============================================================*/ CREATE TABLE SYS_ACCEPT_IP ( ACCEPTID NUMBER(18) NOT NULL, TITLE VARCHAR2(128), STARTIP VARCHAR2(20), ENDIP VARCHAR2(20), REMARK VARCHAR2(200), PRIMARY KEY (ACCEPTID) ); /*==============================================================*/ /* TABLE: SYS_AUDIT */ /*==============================================================*/ CREATE TABLE SYS_AUDIT ( AUDITID NUMBER(18) NOT NULL, OPNAME VARCHAR2(128), EXETIME DATE, EXECUTORID NUMBER(18), EXECUTOR VARCHAR2(64), FROMIP VARCHAR2(64), EXEMETHOD VARCHAR2(128), REQUESTURI VARCHAR2(256), REQPARAMS CLOB, OWNERMODEL VARCHAR2(200), EXECTYPE VARCHAR2(200), ORGID NUMBER(18), DETAIL CLOB, PRIMARY KEY (AUDITID) ); COMMENT ON TABLE SYS_AUDIT IS '系统审计'; /*==============================================================*/ /* TABLE: SYS_CALENDAR */ /*==============================================================*/ CREATE TABLE SYS_CALENDAR ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), MEMO VARCHAR2(400), ISDEFAULT NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_CALENDAR IS '系统日历'; /*==============================================================*/ /* TABLE: SYS_CALENDAR_ASSIGN */ /*==============================================================*/ CREATE TABLE SYS_CALENDAR_ASSIGN ( ID NUMBER(18) NOT NULL, CANLENDARID NUMBER(18), ASSIGNTYPE SMALLINT, ASSIGNID NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_CALENDAR_ASSIGN IS '日历分配'; /*==============================================================*/ /* TABLE: SYS_CALENDAR_SETTING */ /*==============================================================*/ CREATE TABLE SYS_CALENDAR_SETTING ( ID NUMBER(18) NOT NULL, CALENDARID NUMBER(18), YEARS SMALLINT, MONTHS SMALLINT, DAYS SMALLINT, TYPE SMALLINT, WORKTIMEID NUMBER(18) NOT NULL, CALDAY VARCHAR2(20), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_CALENDAR_SETTING IS '日历设置'; /*==============================================================*/ /* TABLE: SYS_CODE_TEMPLATE */ /*==============================================================*/ CREATE TABLE SYS_CODE_TEMPLATE ( ID NUMBER(18) NOT NULL, TEMPLATE_NAME VARCHAR2(200), HTML CLOB, MEMO VARCHAR2(200), TEMPLATE_ALIAS VARCHAR2(200), TEMPLATE_TYPE SMALLINT, ISSUBNEED SMALLINT, FILENAME VARCHAR2(200), FILEDIR VARCHAR2(200), formEdit SMALLINT, formDetail SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_CODE_TEMPLATE IS '基于自定义表的代码模版管理表'; /*==============================================================*/ /* TABLE: SYS_CONDITION_SCRIPT */ /*==============================================================*/ CREATE TABLE SYS_CONDITION_SCRIPT ( ID NUMBER(18) NOT NULL, CLASS_NAME VARCHAR2(400), CLASS_INS_NAME VARCHAR2(200), METHOD_NAME VARCHAR2(200), METHOD_DESC VARCHAR2(400), RETURN_TYPE VARCHAR2(50), ARGUMENT CLOB, ENABLE SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_CONDITION_SCRIPT IS '条件脚本'; CREATE TABLE SYS_ALIAS_SCRIPT ( ID NUMBER(18,0) NOT NULL, ALIAS_NAME VARCHAR2(100), ALIAS_DESC VARCHAR2(100), CLASS_NAME VARCHAR2(400), CLASS_INS_NAME VARCHAR2(200), METHOD_NAME VARCHAR2(200), METHOD_DESC VARCHAR2(400), RETURN_TYPE VARCHAR2(50), SCRIPT_TYPE VARCHAR2(50), SCRIPT_COMTEN CLOB, ARGUMENT CLOB, ENABLE NUMBER(2), IS_RETURN_VALUE NUMBER(2), RETURN_PARAM_JSON VARCHAR2(2000), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ALIAS_SCRIPT IS '自定义别名脚本表'; /*==============================================================*/ /* TABLE: SYS_DATASOURCE */ /*==============================================================*/ CREATE TABLE SYS_DATASOURCE ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), ALIAS VARCHAR2(20), DRIVERNAME VARCHAR2(100), URL VARCHAR2(100), USERNAME VARCHAR2(20), PASSWORD VARCHAR2(20), DBTYPE VARCHAR2(20), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_DATASOURCE IS '系统数据源管理'; /*==============================================================*/ /* TABLE: SYS_DEMENSION */ /*==============================================================*/ CREATE TABLE SYS_DEMENSION ( DEMID NUMBER(18) NOT NULL, DEMNAME VARCHAR2(128) NOT NULL, DEMDESC VARCHAR2(1024), PRIMARY KEY (DEMID) ); COMMENT ON TABLE SYS_DEMENSION IS '人员维度表'; /*==============================================================*/ /* TABLE: SYS_DIC */ /*==============================================================*/ CREATE TABLE SYS_DIC ( DICID NUMBER(18) NOT NULL, TYPEID NUMBER(18), ITEMKEY VARCHAR2(64), ITEMNAME VARCHAR2(64) NOT NULL, ITEMVALUE VARCHAR2(128) NOT NULL, DESCP VARCHAR2(256), SN NUMBER(18), NODEPATH VARCHAR2(100), PARENTID NUMBER(18), PRIMARY KEY (DICID) ); COMMENT ON TABLE SYS_DIC IS '数据字典'; /*==============================================================*/ /* TABLE: SYS_ERROR_LOG */ /*==============================================================*/ CREATE TABLE SYS_ERROR_LOG ( ID NUMBER(18) NOT NULL, HASHCODE VARCHAR2(40), ACCOUNT VARCHAR2(50), IP VARCHAR2(30), ERRORURL VARCHAR2(2000), ERROR CLOB, ERRORDATE DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ERROR_LOG IS '错误日志表'; /*==============================================================*/ /* TABLE: SYS_EXCEL_IMPRULE */ /*==============================================================*/ CREATE TABLE SYS_EXCEL_IMPRULE ( ID NUMBER(18) NOT NULL, TABLE_NAME VARCHAR2(30), COLUMN_STR VARCHAR2(200), MARK VARCHAR2(200), IMP_TYPE SMALLINT, BUSI_DATE DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_EXCEL_IMPRULE IS 'EXCEL导入规则表'; /*==============================================================*/ /* TABLE: SYS_FILE */ /*==============================================================*/ CREATE TABLE SYS_FILE ( FILEID NUMBER(18) NOT NULL, TYPEID NUMBER(18), FILENAME VARCHAR2(128) NOT NULL, FILEPATH VARCHAR2(128) NOT NULL, CREATETIME DATE NOT NULL, EXT VARCHAR2(32), FILETYPE VARCHAR2(32) NOT NULL, NOTE VARCHAR2(1024), CREATORID NUMBER(18), CREATOR VARCHAR2(32) NOT NULL, TOTALBYTES NUMBER(18) DEFAULT 0, DELFLAG SMALLINT, FILEBLOB BLOB, PRIMARY KEY (FILEID) ); COMMENT ON TABLE SYS_FILE IS '附件'; COMMENT ON COLUMN SYS_FILE.FILEBLOB IS '附件内容'; /*==============================================================*/ /* TABLE: SYS_GL_TYPE */ /*==============================================================*/ CREATE TABLE SYS_GL_TYPE ( TYPEID NUMBER(18) NOT NULL, TYPENAME VARCHAR2(128) NOT NULL, NODEPATH VARCHAR2(200), DEPTH NUMBER(18) NOT NULL, PARENTID NUMBER(18), CATKEY VARCHAR2(64), NODEKEY VARCHAR2(64) NOT NULL, SN NUMBER(18) NOT NULL, USERID NUMBER(18), DEPID NUMBER(18), TYPE NUMBER(18), ISLEAF SMALLINT, NODECODE VARCHAR2(20), NODECODETYPE SMALLINT, PRIMARY KEY (TYPEID) ); COMMENT ON TABLE SYS_GL_TYPE IS '总分类表 用于显示树层次结构的分类 可以允许任何层次结构'; /*==============================================================*/ /* TABLE: SYS_IDENTITY */ /*==============================================================*/ CREATE TABLE SYS_IDENTITY ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), ALIAS VARCHAR2(20), REGULATION VARCHAR2(100), GENTYPE SMALLINT, NOLENGTH NUMBER(18), CURDATE VARCHAR2(10), INITVALUE NUMBER(18), CURVALUE NUMBER(18), STEP SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_IDENTITY IS '流水号生成'; /*==============================================================*/ /* TABLE: SYS_JOBLOG */ /*==============================================================*/ CREATE TABLE SYS_JOBLOG ( LOGID NUMBER(18) NOT NULL, JOBNAME VARCHAR2(50), TRIGNAME VARCHAR2(50), STARTTIME DATE, ENDTIME DATE, CONTENT CLOB, STATE NUMBER(18), RUNTIME NUMBER(18), PRIMARY KEY (LOGID) ); COMMENT ON TABLE SYS_JOBLOG IS '后台任务执行日志'; /*==============================================================*/ /* TABLE: SYS_LOG_SWITCH */ /*==============================================================*/ CREATE TABLE SYS_LOG_SWITCH ( ID NUMBER(18) NOT NULL, MODEL VARCHAR2(50), STATUS SMALLINT, CREATETIME TIMESTAMP, CREATOR VARCHAR2(20), CREATORID NUMBER(18), UPDBY VARCHAR2(20), UPDBYID NUMBER(18), MEMO VARCHAR2(300), LASTUPTIME TIMESTAMP, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_LOG_SWITCH IS '日志开关'; /*==============================================================*/ /* TABLE: SYS_MESSAGE_LOG */ /*==============================================================*/ CREATE TABLE SYS_MESSAGE_LOG ( ID NUMBER(18) NOT NULL, SUBJECT VARCHAR2(100), SENDTIME DATE, RECEIVER VARCHAR2(1000), MESSAGETYPE NUMBER(18), STATE NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_MESSAGE_LOG IS '消息日志'; /*==============================================================*/ /* TABLE: SYS_MSG_READ */ /*==============================================================*/ CREATE TABLE SYS_MSG_READ ( ID NUMBER(18) NOT NULL, MESSAGEID NUMBER(18), RECEIVERID NUMBER(18), RECEIVER VARCHAR2(20), RECEIVETIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_MSG_READ IS '接收状态'; /*==============================================================*/ /* TABLE: SYS_MSG_RECEIVER */ /*==============================================================*/ CREATE TABLE SYS_MSG_RECEIVER ( ID NUMBER(18) NOT NULL, MESSAGEID NUMBER(18), RECEIVETYPE SMALLINT, RECEIVERID NUMBER(18), RECEIVER VARCHAR2(20), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_MSG_RECEIVER IS '消息接收者'; /*==============================================================*/ /* TABLE: SYS_MSG_REPLY */ /*==============================================================*/ CREATE TABLE SYS_MSG_REPLY ( ID NUMBER(18) NOT NULL, MESSAGEID NUMBER(18), CONTENT CLOB, REPLYID NUMBER(18), REPLY VARCHAR2(20), REPLYTIME DATE, ISPRIVATE SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_MSG_REPLY IS '消息回复'; /*==============================================================*/ /* TABLE: SYS_MSG_SEND */ /*==============================================================*/ CREATE TABLE SYS_MSG_SEND ( ID NUMBER(18) NOT NULL, SUBJECT VARCHAR2(400), USERID NUMBER(18), USERNAME VARCHAR2(20), MESSAGETYPE VARCHAR2(50), CONTENT CLOB, SENDTIME DATE, CANREPLY SMALLINT, RECEIVERNAME CLOB, ATTACHMENT VARCHAR2(2000), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_MSG_SEND IS '发送消息'; /*==============================================================*/ /* TABLE: SYS_OFFICE_TEMPLATE */ /*==============================================================*/ CREATE TABLE SYS_OFFICE_TEMPLATE ( ID NUMBER(18) NOT NULL, SUBJECT VARCHAR2(20), TEMPLATETYPE NUMBER(18), MEMO VARCHAR2(200), CREATORID NUMBER(18), CREATOR VARCHAR2(20), CREATETIME DATE, PATH VARCHAR2(200), TEMPLATEBLOB BLOB, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_OFFICE_TEMPLATE IS 'OFFICE模版'; COMMENT ON COLUMN SYS_OFFICE_TEMPLATE.TEMPLATEBLOB IS '模板内容'; /*==============================================================*/ /* TABLE: SYS_ORG */ /*==============================================================*/ CREATE TABLE SYS_ORG ( ORGID NUMBER(18) NOT NULL, DEMID NUMBER(18), ORGNAME VARCHAR2(128) NOT NULL, ORGDESC VARCHAR2(500), ORGSUPID NUMBER(18), PATH VARCHAR2(128), DEPTH NUMBER(18), ORGTYPE NUMBER(18), CREATORID NUMBER(18), CREATETIME DATE, UPDATEID NUMBER(18), UPDATETIME DATE, SN NUMBER(18), FROMTYPE SMALLINT, ORGPATHNAME VARCHAR2(2000), isdelete integer DEFAULT 0, code VARCHAR2(128) NOT NULL, COMPANYID NUMBER(18,0), COMPANY VARCHAR2(20), ORGSTAFF SMALLINT, ORGCODE VARCHAR2(200), PRIMARY KEY (ORGID) ); COMMENT ON TABLE SYS_ORG IS '组织架构SYS_ORG'; /*==============================================================*/ /* TABLE: SYS_ORG_PARAM */ /*==============================================================*/ CREATE TABLE SYS_ORG_PARAM ( VALUEID NUMBER(18), ORGID NUMBER(18), PARAMID NUMBER(18), PARAMVALUE VARCHAR2(200), PARAMDATEVALUE DATE, PARAMINTVALUE NUMBER(18,2), PRIMARY KEY (VALUEID) ); COMMENT ON TABLE SYS_ORG_PARAM IS '组织参数值'; /*==============================================================*/ /* TABLE: SYS_ORG_ROLE */ /*==============================================================*/ CREATE TABLE SYS_ORG_ROLE ( ID NUMBER(18) NOT NULL, ORGID NUMBER(18), ROLEID NUMBER(18), CANDEL SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ORG_ROLE IS '组织和角色授权'; /*==============================================================*/ /* TABLE: SYS_ORG_ROLEMANAGE */ /*==============================================================*/ CREATE TABLE SYS_ORG_ROLEMANAGE ( ID NUMBER(18) NOT NULL, ORGID NUMBER(18), ROLEID NUMBER(18), CANDEL SMALLINT, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ORG_ROLEMANAGE IS '组织可以授权的角色范围(用于分级授权)'; /*==============================================================*/ /* TABLE: SYS_ORG_TYPE */ /*==============================================================*/ CREATE TABLE SYS_ORG_TYPE ( ID NUMBER(18) NOT NULL, DEMID NUMBER(18), NAME VARCHAR2(50), LEVELS SMALLINT, MEMO VARCHAR2(100), ICON VARCHAR2(100), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ORG_TYPE IS '组织结构类型'; /*==============================================================*/ /* TABLE: SYS_OVERTIME */ /*==============================================================*/ CREATE TABLE SYS_OVERTIME ( ID NUMBER(18) NOT NULL, SUBJECT VARCHAR2(50), USERID NUMBER(18), STARTTIME DATE, ENDTIME DATE, WORKTYPE SMALLINT, MEMO VARCHAR2(200), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_OVERTIME IS '加班情况'; /*==============================================================*/ /* TABLE: SYS_PARAM */ /*==============================================================*/ CREATE TABLE SYS_PARAM ( PARAMID NUMBER(18) NOT NULL, PARAMKEY VARCHAR2(32), PARAMNAME VARCHAR2(50), DATATYPE VARCHAR2(20), EFFECT SMALLINT, BELONGDEM NUMBER(20), SOURCETYPE VARCHAR(20), SOURCEKEY VARCHAR(100), DESCRIPTION VARCHAR(256), STATUS_ SMALLINT, CATEGORY VARCHAR2(256), PRIMARY KEY (PARAMID) ); COMMENT ON TABLE SYS_PARAM IS 'SYS_PARAM【用户或组织自定义属性】'; /*==============================================================*/ /* TABLE: SYS_PAUR */ /*==============================================================*/ CREATE TABLE SYS_PAUR ( PAURID NUMBER(18) NOT NULL, PAURNAME VARCHAR2(30), ALIASNAME VARCHAR2(30), PAURVALUE VARCHAR2(50), USERID NUMBER(18), PRIMARY KEY (PAURID) ); /*==============================================================*/ /* Table: SYS_POS */ /*==============================================================*/ CREATE TABLE SYS_POS ( POSID NUMBER(18) NOT NULL, POSCODE VARCHAR(200) NOT NULL, POSNAME VARCHAR2(128) NOT NULL, POSDESC VARCHAR2(1024), ORGID NUMBER(18), JOBID NUMBER(18), ISDELETE SMALLINT DEFAULT 0 ); COMMENT ON TABLE SYS_POS IS '系统岗位表，实际是部门和职务的对应关系表'; ALTER TABLE SYS_POS ADD CONSTRAINT PK_SYS_POS PRIMARY KEY ("POSID"); /*==============================================================*/ /* Table: SYS_JOB */ /*==============================================================*/ CREATE TABLE SYS_JOB ( JOBID NUMBER(18) NOT NULL, JOBNAME VARCHAR(100), JOBCODE VARCHAR(100), JOBDESC VARCHAR(1000), SETID NUMBER(18) DEFAULT 0, GRADE NUMBER(10,0) DEFAULT 0, ISDELETE SMALLINT DEFAULT 0 ); COMMENT ON TABLE SYS_JOB IS '职务表'; ALTER TABLE SYS_JOB ADD CONSTRAINT PK_SYS_JOB PRIMARY KEY ("JOBID"); /*==============================================================*/ /* Table: _POS */ /*==============================================================*/ CREATE TABLE SYS_USER_POS ( USERPOSID NUMBER(18) NOT NULL, ORGID NUMBER(18), POSID NUMBER(18), JOBID NUMBER(18), USERID NUMBER(18), ISPRIMARY SMALLINT, ISCHARGE SMALLINT, ISDELETE SMALLINT DEFAULT 0 ); COMMENT ON TABLE SYS_USER_POS IS '用户岗位表'; ALTER TABLE SYS_USER_POS ADD CONSTRAINT PK_SYS_USER_POS PRIMARY KEY ("USERPOSID"); /*==============================================================*/ /* TABLE: SYS_PROFILE */ /*==============================================================*/ CREATE TABLE SYS_PROFILE ( ID NUMBER(18) NOT NULL, USERID NUMBER(18), HOMEPAGE VARCHAR2(50), SKIN VARCHAR2(20), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PROFILE IS '个人个性化信息'; /*==============================================================*/ /* TABLE: SYS_REPORT_TEMPLATE */ /*==============================================================*/ CREATE TABLE SYS_REPORT_TEMPLATE ( REPORTID NUMBER(18) NOT NULL, TITLE VARCHAR2(128) NOT NULL, DESCP VARCHAR2(500) NOT NULL, REPORTLOCATION VARCHAR2(128) NOT NULL, CREATETIME DATE NOT NULL, UPDATETIME DATE NOT NULL, REPORTKEY VARCHAR2(128), ISDEFAULTIN SMALLINT, TYPEID NUMBER(18), PRIMARY KEY (REPORTID) ); COMMENT ON TABLE SYS_REPORT_TEMPLATE IS '报表模板REPORT_TEMPLATE'; /*==============================================================*/ /* TABLE: SYS_RES */ /*==============================================================*/ CREATE TABLE SYS_RES ( RESID NUMBER(18) NOT NULL, RESNAME VARCHAR2(128) NOT NULL, ALIAS VARCHAR2(128), SN NUMBER(18), ICON VARCHAR2(100), PARENTID NUMBER(18), DEFAULTURL VARCHAR2(256), ISFOLDER SMALLINT, ISDISPLAYINMENU SMALLINT, ISOPEN SMALLINT, SYSTEMID NUMBER(18), ISNEWOPEN SMALLINT, PATH VARCHAR2(500), PRIMARY KEY (RESID) ); COMMENT ON TABLE SYS_RES IS '子系统资源'; /*==============================================================*/ /* TABLE: SYS_RESURL */ /*==============================================================*/ CREATE TABLE SYS_RESURL ( RESURLID NUMBER(18) NOT NULL, RESID NUMBER(18), NAME VARCHAR2(100), URL VARCHAR2(200), PRIMARY KEY (RESURLID) ); COMMENT ON TABLE SYS_RESURL IS '资源URL'; /*==============================================================*/ /* TABLE: SYS_ROLE */ /*==============================================================*/ CREATE TABLE SYS_ROLE ( ROLEID NUMBER(18) NOT NULL, SYSTEMID NUMBER(18), ALIAS VARCHAR2(128), ROLENAME VARCHAR2(128) NOT NULL, MEMO VARCHAR2(256), ALLOWDEL SMALLINT, ALLOWEDIT SMALLINT, ENABLED SMALLINT, CATEGORY VARCHAR2(50), PRIMARY KEY (ROLEID) ); COMMENT ON TABLE SYS_ROLE IS '系统角色表'; /*==============================================================*/ /* TABLE: SYS_ROLE_RES */ /*==============================================================*/ CREATE TABLE SYS_ROLE_RES ( ROLERESID NUMBER(18) NOT NULL, ROLEID NUMBER(18), RESID NUMBER(18), SYSTEMID NUMBER(18), PRIMARY KEY (ROLERESID) ); COMMENT ON TABLE SYS_ROLE_RES IS '角色资源映射'; /*==============================================================*/ /* TABLE: SYS_SCRIPT */ /*==============================================================*/ CREATE TABLE SYS_SCRIPT ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), SCRIPT CLOB, CATEGORY VARCHAR2(50), MEMO VARCHAR2(300), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_SCRIPT IS '系统脚本节点'; /*==============================================================*/ /* TABLE: SYS_SEAL */ /*==============================================================*/ CREATE TABLE SYS_SEAL ( SEALID NUMBER(18) NOT NULL, SEALNAME VARCHAR2(128), SEALPATH VARCHAR2(128), BELONGID NUMBER(18), BELONGNAME VARCHAR2(128), ATTACHMENTID NUMBER(18), SHOWIMAGEID NUMBER(18), PRIMARY KEY (SEALID) ); COMMENT ON TABLE SYS_SEAL IS '电子印章'; /*==============================================================*/ /* TABLE: SYS_SUBSYSTEM */ /*==============================================================*/ CREATE TABLE SYS_SUBSYSTEM ( SYSTEMID NUMBER(18) NOT NULL, SYSNAME VARCHAR2(50) NOT NULL, ALIAS VARCHAR2(20), LOGO VARCHAR2(100), DEFAULTURL VARCHAR2(50), MEMO VARCHAR2(200), CREATETIME DATE, CREATOR VARCHAR2(20), ALLOWDEL SMALLINT, NEEDORG SMALLINT, ISACTIVE SMALLINT, ISLOCAL SMALLINT, HOMEPAGE VARCHAR2(256), PRIMARY KEY (SYSTEMID) ); COMMENT ON TABLE SYS_SUBSYSTEM IS '子系统管理'; /*==============================================================*/ /* TABLE: SYS_TEMPLATE */ /*==============================================================*/ CREATE TABLE SYS_TEMPLATE ( TEMPLATEID NUMBER(18) NOT NULL, NAME VARCHAR2(50), HTMLCONTENT VARCHAR2(500), PLAINCONTENT VARCHAR2(500), ISDEFAULT SMALLINT, USETYPE SMALLINT, TITLE VARCHAR2(200), PRIMARY KEY (TEMPLATEID) ); COMMENT ON TABLE SYS_TEMPLATE IS '系统模版管理'; /*==============================================================*/ /* TABLE: SYS_TYPE_KEY */ /*==============================================================*/ CREATE TABLE SYS_TYPE_KEY ( TYPEID NUMBER(18) NOT NULL, TYPEKEY VARCHAR2(64) NOT NULL, TYPENAME VARCHAR2(128), FLAG NUMBER(18), SN NUMBER(18), TYPE NUMBER(18), PRIMARY KEY (TYPEID) ); COMMENT ON TABLE SYS_TYPE_KEY IS '系统分类键'; /*==============================================================*/ /* TABLE: SYS_USER */ /*==============================================================*/ CREATE TABLE SYS_USER ( USERID NUMBER(18) NOT NULL, FULLNAME VARCHAR2(127), ACCOUNT VARCHAR2(20) NOT NULL, PASSWORD VARCHAR2(50) NOT NULL, ISEXPIRED SMALLINT, ISLOCK SMALLINT, CREATETIME DATE, STATUS SMALLINT, EMAIL VARCHAR2(128), MOBILE VARCHAR2(32), PHONE VARCHAR2(32), SEX VARCHAR2(2), PICTURE VARCHAR2(300), FROMTYPE SMALLINT, ENTRYDATE DATE, USERSTATUS VARCHAR2(32), pwdUpdTime DATE, WEIXINID VARCHAR2(20), HASSYNCTOWX NUMBER(2) DEFAULT 0, RESPONSIBILITYDETAIL VARCHAR2(4000), PRIMARY KEY (USERID) ); COMMENT ON TABLE SYS_USER IS '用户表'; /*==============================================================*/ /* TABLE: SYS_USER_PARAM */ /*==============================================================*/ CREATE TABLE SYS_USER_PARAM ( VALUEID NUMBER(18) NOT NULL, USERID NUMBER(18), PARAMID NUMBER(18), PARAMVALUE VARCHAR2(200), PARAMDATEVALUE DATE, PARAMINTVALUE NUMBER(18,2), PRIMARY KEY (VALUEID) ); COMMENT ON TABLE SYS_USER_PARAM IS '用户自定义参数'; /*==============================================================*/ /* TABLE: SYS_USER_ROLE */ /*==============================================================*/ CREATE TABLE SYS_USER_ROLE ( USERROLEID NUMBER(18) NOT NULL, ROLEID NUMBER(18), USERID NUMBER(18), PRIMARY KEY (USERROLEID) ); COMMENT ON TABLE SYS_USER_ROLE IS '用户角色映射表'; /*==============================================================*/ /* TABLE: SYS_USER_UNDER */ /*==============================================================*/ CREATE TABLE SYS_USER_UNDER ( ID NUMBER(18) NOT NULL, USERID NUMBER(18), UNDERUSERID NUMBER(18), UNDERUSERNAME VARCHAR2(50), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_USER_UNDER IS '下属管理'; /*==============================================================*/ /* TABLE: SYS_VACATION */ /*==============================================================*/ CREATE TABLE SYS_VACATION ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), YEARS SMALLINT, STATTIME DATE, ENDTIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_VACATION IS '法定假期设置'; /*==============================================================*/ /* TABLE: SYS_WORKTIME */ /*==============================================================*/ CREATE TABLE SYS_WORKTIME ( ID NUMBER(18) NOT NULL, SETTINGID NUMBER(18), STARTTIME VARCHAR2(10), ENDTIME VARCHAR2(10), MEMO VARCHAR2(200), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_WORKTIME IS '班次时间'; /*==============================================================*/ /* TABLE: SYS_WORKTIME_SETTING */ /*==============================================================*/ CREATE TABLE SYS_WORKTIME_SETTING ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), MEMO VARCHAR2(200), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_WORKTIME_SETTING IS '班次设置'; /*==============================================================*/ /* TABLE: SYS_DB_ID */ /*==============================================================*/ CREATE TABLE SYS_DB_ID ( ID SMALLINT NOT NULL, INCREMENTAL NUMBER(18), BOUND NUMBER(18), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_DB_ID IS '系统ID记录表'; -- CREATE TABLE CREATE TABLE BPM_PRO_CPTO ( COPY_ID NUMBER(18) NOT NULL, ACT_INST_ID NUMBER(18) NOT NULL, RUN_ID NUMBER(18) NOT NULL, NODE_KEY VARCHAR2(64), NODE_NAME VARCHAR2(256), CC_UID NUMBER(18), CC_UNAME VARCHAR2(128), CC_TIME DATE, IS_READED NUMBER, FILL_OPINION VARCHAR2(2000), SUBJECT VARCHAR2(256), READ_TIME DATE, CP_TYPE NUMBER, CREATE_ID NUMBER(18), CREATOR VARCHAR2(128), DEF_TYPEID NUMBER(18), PRIMARY KEY (COPY_ID) ); CREATE TABLE BPM_PRO_TRANSTO ( ID NUMBER(18), ACTINSTID NUMBER(18), TASKID NUMBER(18), TRANSTYPE NUMBER(1), ACTION NUMBER(1), CREATEUSERID NUMBER(18), CREATETIME TIMESTAMP, TRANSRESULT SMALLINT, ASSIGNEE VARCHAR2(256), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_PRO_TRANSTO IS '流程流转表'; create table SYS_SEAL_RIGHT ( ID NUMBER(18) not null, SEALID NUMBER(18), RIGHTTYPE VARCHAR2(20), RIGHTID NUMBER(18), RIGHTNAME VARCHAR2(100), CREATEUSER NUMBER(18), CREATETIME DATE, CONTROLTYPE SMALLINT DEFAULT '0', primary key (id) ); COMMENT ON TABLE SYS_SEAL_RIGHT IS '印章授权表'; CREATE TABLE BPM_DATA_TEMPLATE( ID NUMBER(18) NOT NULL, TABLEID NUMBER(18), FORMKEY VARCHAR(50), NAME VARCHAR2(300), ALIAS VARCHAR2(50), STYLE INTEGER DEFAULT 0, NEEDPAGE INTEGER DEFAULT 1, PAGESIZE NUMBER(18), TEMPLATEALIAS VARCHAR2(256), TEMPLATEHTML CLOB, DISPLAYFIELD CLOB, CONDITIONFIELD CLOB, SORTFIELD VARCHAR2(2000), MANAGEFIELD VARCHAR2(2000), FILTERFIELD CLOB, VARFIELD VARCHAR2(2000), FILTERTYPE INTEGER DEFAULT 1, SOURCE VARCHAR2(256) DEFAULT '1', DEFID NUMBER(18), ISQUERY SMALLINT DEFAULT 1, ISFILTER INTEGER DEFAULT 1, EXPORTFIELD CLOB, PRINTFIELD CLOB, CONSTRAINT PK_BPM_DATA_TEMPLATE PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_DATA_TEMPLATE IS '业务数据模板'; CREATE TABLE SYS_PERSON_SCRIPT ( ID NUMBER(18) NOT NULL, CLASS_NAME VARCHAR2(400), CLASS_INS_NAME VARCHAR2(200), METHOD_NAME VARCHAR2(200), METHOD_DESC VARCHAR2(400), RETURN_TYPE VARCHAR2(50), ARGUMENT CLOB, ENABLE NUMBER, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PERSON_SCRIPT IS '人员脚本管理'; CREATE TABLE BPM_COMMON_WS_SET ( ID NUMBER(18) NOT NULL, ALIAS VARCHAR2(200) NOT NULL, WSDL_URL VARCHAR2(400), DOCUMENT CLOB, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_COMMON_WS_SET IS '通用WEBSERVICE调用设置'; CREATE TABLE BPM_COMMON_WS_PARAMS ( ID NUMBER(18) NOT NULL, SETID NUMBER(18) NOT NULL, NAME VARCHAR2(200), PARAM_TYPE INTEGER, DESCRIPTION VARCHAR2(400), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_COMMON_WS_PARAMS IS '通用WEBSERVICE调用参数'; /*==============================================================*/ /* Table: SYS_REPORT */ /*==============================================================*/ CREATE TABLE SYS_REPORT ( REPORTID NUMBER(18,0), TYPEID NUMBER(18,0), TITLE VARCHAR2(128), DESCP VARCHAR2(200), FILEPATH VARCHAR2(128), FILENAME VARCHAR2(128), CREATETIME TIMESTAMP (6), STATUS NUMBER(1,0) DEFAULT 0, DSNAME VARCHAR2(50), PARAMS VARCHAR2(500) DEFAULT '[]', EXT VARCHAR2(20) DEFAULT 'jrxml', REALSQL CLOB ); COMMENT ON TABLE SYS_REPORT IS 'Jasperreport报表'; /*==============================================================*/ /* Table: BPM_TABLE_TEMPLATE */ /*==============================================================*/ CREATE TABLE BPM_TABLE_TEMPLATE ( ID NUMBER(18,0) NOT NULL, TABLE_ID NUMBER(18,0), CATEGORY_ID NUMBER(18,0), HTML_LIST CLOB, HTML_DETAIL CLOB, TEMPLATE_NAME VARCHAR2(128 BYTE), AUTHOR_TYPE NUMBER, FORMKEY NUMBER(18,0), MEMO VARCHAR2(100 BYTE), LISTTEMPLATE VARCHAR2(50 BYTE), DETAILTEMPLATE VARCHAR2(50 BYTE), CONSTRAINT PK_TABLE_TEMPLATE PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_TABLE_TEMPLATE IS '查看表格业务数据的模板'; create table BUS_QUERY_RULE ( id NUMBER(18) not null, tablename VARCHAR2(128), needpage INTEGER default 1, pagesize NUMBER(18), isquery INTEGER default 0, isFilter INTEGER default 0, displayfield CLOB, filterfield CLOB, sortfield CLOB, exportfield CLOB, printfield CLOB, createtime TIMESTAMP(6), createby NUMBER(18), updatetime TIMESTAMP(6), updateby NUMBER(18), PRIMARY KEY (ID) ); comment on table BUS_QUERY_RULE is '高级查询规则'; create table BUS_QUERY_FILTER ( id NUMBER(18) not null, ruleid NUMBER(18), tablename VARCHAR2(256), filtername VARCHAR2(256), filterdesc CLOB, filterkey VARCHAR2(256), queryparameter CLOB, sortparameter CLOB, isshare INTEGER default 0, createtime TIMESTAMP(6), createby NUMBER(18), PRIMARY KEY (ID) ); comment on table BUS_QUERY_FILTER is '查询过滤'; create table BUS_QUERY_SHARE ( id NUMBER(18) not null, filterid NUMBER(18), shareright CLOB, sharerid NUMBER(18), createtime TIMESTAMP(6), PRIMARY KEY (ID) ); comment on table BUS_QUERY_SHARE is '查询过滤共享'; CREATE TABLE SYS_WS_DATA_TEMPLATE ( ID NUMBER(18) NOT NULL , NAME VARCHAR2(500 BYTE) NULL , SERVICEID NUMBER(18) NULL , TEMPLATE CLOB NULL , SCRIPT CLOB NULL, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_WS_DATA_TEMPLATE IS 'webservice数据模板展示'; CREATE TABLE OUT_MAIL_ATTACHMENT ( FILEID NUMBER(18) NOT NULL , FILENAME VARCHAR2(128) NULL , FILEPATH VARCHAR2(128) NULL , MAILID NUMBER(18) NULL, PRIMARY KEY (FILEID) ); COMMENT ON TABLE OUT_MAIL_ATTACHMENT IS '外部邮件附件表'; CREATE TABLE BPM_DEF_AUTHORIZE ( ID NUMBER(18) not null, AUTHORIZE_DESC VARCHAR2(512), PRIMARY KEY (ID) ); COMMIT; comment on table BPM_DEF_AUTHORIZE is '流程授权主表'; CREATE TABLE BPM_DEF_USER ( ID NUMBER(18) not null, AUTHORIZE_ID NUMBER(18) not null, OWNER_ID NUMBER(18) not null, OWNER_NAME VARCHAR2(256), RIGHT_TYPE VARCHAR2(40), PRIMARY KEY (ID) ); COMMIT; comment on table BPM_DEF_USER is '流程授权中的用户子表'; CREATE TABLE BPM_DEF_ACT ( ID NUMBER(18) not null, AUTHORIZE_ID NUMBER(18) not null, DEF_KEY VARCHAR2(68) not null, DEF_NAME VARCHAR2(256), RIGHT_CONTENT VARCHAR2(512), PRIMARY KEY (ID) ); COMMIT; comment on table BPM_DEF_ACT is '流程授权中流程子表'; create table SYS_PERSONAL_CALENDAR ( id NUMBER(18) not null, title VARCHAR2(512), description CLOB, starttime DATE, endtime DATE, createby NUMBER(18), createtime DATE, remindmode INTEGER default 0, remindtime DATE, remindtype VARCHAR2(512), CONSTRAINT PK_SYS_PERSONAL_CALENDAR PRIMARY KEY (ID) ); comment on table SYS_PERSONAL_CALENDAR is '个人日历'; CREATE TABLE SYS_URL_PERMISSION ( ID_ NUMBER(18) NOT NULL , DESCP_ VARCHAR2(500) , URL_ VARCHAR2(2000) , PARAMS_ VARCHAR2(500), ENABLE_ SMALLINT default '1' , PRIMARY KEY (ID_) ); COMMENT ON TABLE SYS_URL_PERMISSION IS 'URL地址拦截管理'; CREATE TABLE SYS_URL_RULES ( ID_ NUMBER(18) NOT NULL , SCRIPT_ CLOB , ENABLE_ SMALLINT DEFAULT '1' , SYS_URL_ID_ NUMBER(18) , DESCP_ VARCHAR2(500) , SORT_ SMALLINT DEFAULT '1' , PRIMARY KEY (ID_) ); COMMENT ON TABLE SYS_URL_RULES IS 'URL地址拦截脚本管理'; create table BPM_MOBILE_FORM ( id NUMBER(18) not null, formid NUMBER(18), formkey VARCHAR2(64), html CLOB, template CLOB, formJson CLOB, isdefault INTEGER, guid VARCHAR2(128), constraint PK_BPM_MOBILE_FORM primary key (ID) ); comment on table BPM_MOBILE_FORM is '手机表单设置'; CREATE TABLE SYS_ORG_AUTH ( ID NUMBER(18) NOT NULL , USER_ID NUMBER(18) NOT NULL , ORG_ID NUMBER(18) NOT NULL , DIM_ID NUMBER(18) NOT NULL , ORG_PERMS VARCHAR2(255), USER_PERMS VARCHAR2(255), POS_PERMS VARCHAR2(255), ORGAUTH_PERMS VARCHAR2(255), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_ORG_AUTH IS '组织授权'; CREATE TABLE SYS_AUTH_ROLE ( ID NUMBER(18,0) NOT NULL , AUTH_ID NUMBER(18,0) NOT NULL , ROLE_ID NUMBER(18,0) NOT NULL , PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_AUTH_ROLE IS '授权角色'; /*==============================================================*/ /* 可配置数据源:SYS_DATA_SOURCE ,SYS_DATA_SOURCE_DEF */ /*==============================================================*/ CREATE TABLE SYS_DATA_SOURCE ( ID_ NUMBER(18) NOT NULL, NAME_ VARCHAR2(64), ALIAS_ VARCHAR2(64), DB_TYPE_ VARCHAR2(64), SETTING_JSON_ CLOB, INIT_ON_START_ NUMBER, ENABLED_ NUMBER, CLASS_PATH_ VARCHAR2(128), INIT_METHOD_ VARCHAR2(128), CLOSE_METHOD_ VARCHAR2(128) ); ALTER TABLE SYS_DATA_SOURCE ADD CONSTRAINT ID_PRIMAR PRIMARY KEY (ID_); ALTER TABLE SYS_DATA_SOURCE ADD CONSTRAINT UNIQUE_COLUMN UNIQUE (NAME_, ALIAS_); CREATE TABLE SYS_DATA_SOURCE_DEF ( ID_ NUMBER(18) NOT NULL, NAME_ VARCHAR2(64) NOT NULL, CLASS_PATH_ VARCHAR2(128) NOT NULL, SETTING_JSON_ CLOB, INIT_METHOD_ VARCHAR2(64), IS_SYSTEM_ NUMBER, CLOSE_METHOD_ VARCHAR2(64) ); ALTER TABLE SYS_DATA_SOURCE_DEF ADD CONSTRAINT ID_PRIMARY PRIMARY KEY (ID_) USING INDEX; ALTER TABLE SYS_DATA_SOURCE_DEF ADD CONSTRAINT UNIQUE_COLUMNS UNIQUE (NAME_, CLASS_PATH_) USING INDEX; CREATE TABLE BPM_DEF_AUTH_TYPE ( ID NUMBER(18) not null, AUTHORIZE_ID NUMBER(18) not null, AUTHORIZE_TYPE VARCHAR2(64), PRIMARY KEY (ID) ); COMMIT; comment on table BPM_DEF_AUTH_TYPE is '流程授权类型表'; CREATE TABLE BPM_FORM_DEF_HI ( HISID NUMBER(18) NOT NULL, FORMDEFID NUMBER(18) NOT NULL, CATEGORYID NUMBER(18), FORMKEY VARCHAR2(128), SUBJECT VARCHAR2(128), FORMDESC VARCHAR2(200), HTML CLOB, TEMPLATE CLOB, ISDEFAULT SMALLINT, VERSIONNO NUMBER(18), TABLEID NUMBER(18), ISPUBLISHED SMALLINT, PUBLISHEDBY VARCHAR2(20), PUBLISHTIME DATE, TABTITLE VARCHAR2(500), DESIGNTYPE SMALLINT, TEMPLATESID VARCHAR2(300), CREATEBY NUMBER(18,0), CREATOR VARCHAR2(50), CREATETIME DATE ); ALTER TABLE BPM_FORM_DEF_HI ADD CONSTRAINT PK_BPM_FORM_DEF_HI PRIMARY KEY (HISID); CREATE TABLE BPM_ASSIGN_USERS ( ID NUMBER(18) NOT NULL, RUNID NUMBER(18), DEFKEY VARCHAR2(128), NODEID VARCHAR2(128), NODENAME VARCHAR2(256), USERID VARCHAR2(20), USERNAME VARCHAR2(127), STARTTIME DATE, ENDTIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_ASSIGN_USERS IS '发起人设置流程执行人表'; CREATE TABLE BPM_NODE_SQL ( ID NUMBER(18) DEFAULT 0 NOT NULL, NAME VARCHAR2(100), DSALIAS VARCHAR2(100), ACTDEFID VARCHAR2(100), NODEID VARCHAR2(50), ACTION_ VARCHAR2(50), SQL_ VARCHAR2(4000), DESC_ VARCHAR2(400), PRIMARY KEY (ID) ); COMMENT ON TABLE BPM_NODE_SQL IS '字段的备注'; CREATE TABLE BPM_SUBTABLE_SORT ( ID NUMBER(20) NOT NULL, ACTDEFKEY VARCHAR2(120), TABLENAME VARCHAR2(120), FIELDSORT VARCHAR2(500), CONSTRAINT PK_BPM_SUBTABLE_SORT PRIMARY KEY (ID) ); COMMENT ON COLUMN BPM_SUBTABLE_SORT.ID IS '主键'; COMMENT ON COLUMN BPM_SUBTABLE_SORT.ACTDEFKEY IS '流程定义key'; COMMENT ON COLUMN BPM_SUBTABLE_SORT.TABLENAME IS '子表名称'; COMMENT ON COLUMN BPM_SUBTABLE_SORT.FIELDSORT IS '字段名，json数据'; CREATE TABLE SYS_WORD_TEMPLATE ( ID_ NUMBER(18) NOT NULL, NAME_ VARCHAR2(200), ALIAS_ VARCHAR2(100), FILE_ID_ NUMBER(18), CREATETIME_ DATE, TYPE_ VARCHAR2(20), TABLE_ID_ NUMBER(18), TABLE_NAME_ VARCHAR2(128), DS_ALIAS_ VARCHAR2(50), SQL_ CLOB, PRIMARY KEY (ID_) ); COMMENT ON COLUMN SYS_WORD_TEMPLATE.ID_ IS '主键'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.NAME_ IS '报表名称'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.ALIAS_ IS '报表别名'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.FILE_ID_ IS 'word模板附件ID'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.CREATETIME_ IS '创建时间'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.TYPE_ IS '类型\r\nSQL\r\n自定义表单\r\n1.如果类型为sql则根据数据源，sql语句获取数据。\r\n2.为表单则根据表定义和主键获取数据。'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.TABLE_ID_ IS '表ID'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.TABLE_NAME_ IS '表名'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.DS_ALIAS_ IS '数据源别名'; COMMENT ON COLUMN SYS_WORD_TEMPLATE.SQL_ IS 'Sql语句'; /*==============================================================*/ /* Table: SYS_INDEX_LAYOUT */ /*==============================================================*/ CREATE TABLE SYS_INDEX_LAYOUT ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), MEMO VARCHAR2(256), TEMPLATE_HTML CLOB, SN NUMBER(18), CONSTRAINT PK_SYS_INDEX_LAYOUT PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_INDEX_LAYOUT.ID IS '主键'; COMMENT ON COLUMN SYS_INDEX_LAYOUT.NAME IS '布局名称'; COMMENT ON COLUMN SYS_INDEX_LAYOUT.MEMO IS '布局描述'; COMMENT ON COLUMN SYS_INDEX_LAYOUT.TEMPLATE_HTML IS '模版内容'; COMMENT ON COLUMN SYS_INDEX_LAYOUT.SN IS '排序'; /*==============================================================*/ /* Table: SYS_INDEX_LAYOUT_MANAGE */ /*==============================================================*/ CREATE TABLE SYS_INDEX_LAYOUT_MANAGE ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), MEMO VARCHAR2(256), ORG_ID NUMBER(18), TEMPLATE_HTML CLOB, DESIGN_HTML CLOB, IS_DEF NUMBER(18), CONSTRAINT PK_SYS_INDEX_LAYOUT_MANAGE PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.ID IS '主键'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.NAME IS '布局名称'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.MEMO IS '布局描述'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.ORG_ID IS '组织ID'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.TEMPLATE_HTML IS '模版内容'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.DESIGN_HTML IS '设计模版'; COMMENT ON COLUMN SYS_INDEX_LAYOUT_MANAGE.IS_DEF IS '是否是默认'; /*==============================================================*/ /* Table: SYS_INDEX_MY_LAYOUT */ /*==============================================================*/ CREATE TABLE SYS_INDEX_MY_LAYOUT ( ID NUMBER(18) NOT NULL, USER_ID NUMBER(18), TEMPLATE_HTML CLOB, DESIGN_HTML CLOB, LAYOUT_ID NUMBER(18), CONSTRAINT PK_SYS_INDEX_MY_LAYOUT PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_INDEX_MY_LAYOUT.ID IS '主键'; COMMENT ON COLUMN SYS_INDEX_MY_LAYOUT.USER_ID IS '用户ID'; COMMENT ON COLUMN SYS_INDEX_MY_LAYOUT.TEMPLATE_HTML IS '模版内容'; COMMENT ON COLUMN SYS_INDEX_MY_LAYOUT.DESIGN_HTML IS '设计模版'; COMMENT ON COLUMN SYS_INDEX_MY_LAYOUT.LAYOUT_ID IS '布局管理ID'; /*==============================================================*/ /* Table: SYS_ORG_TACTIC */ /*==============================================================*/ CREATE TABLE SYS_ORG_TACTIC ( ID NUMBER(18) NOT NULL, ORG_TACTIC NUMBER(18), DEM_ID NUMBER(18), ORG_TYPE NUMBER(18), ORG_SELECT_ID CLOB, CONSTRAINT PK_SYS_ORG_TACTIC PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_ORG_TACTIC.ID IS '主键'; COMMENT ON COLUMN SYS_ORG_TACTIC.ORG_TACTIC IS '策略（0、无策略1、按照级别 2、手工选择，3、按照级别+手工选择）'; COMMENT ON COLUMN SYS_ORG_TACTIC.DEM_ID IS '维度ID'; COMMENT ON COLUMN SYS_ORG_TACTIC.ORG_TYPE IS '组织级别'; COMMENT ON COLUMN SYS_ORG_TACTIC.ORG_SELECT_ID IS '组织选择ID'; /*==============================================================*/ /* Table: SYS_INDEX_COLUMN */ /*==============================================================*/ CREATE TABLE SYS_INDEX_COLUMN ( ID INTEGER NOT NULL, NAME VARCHAR2(100), ALIAS VARCHAR2(100), CATALOG INTEGER, COL_TYPE SMALLINT, DATA_MODE SMALLINT, DATA_FROM VARCHAR2(100), DS_ALIAS VARCHAR2(100), DS_NAME VARCHAR2(100), COL_HEIGHT INTEGER, COL_URL VARCHAR2(100), TEMPLATE_HTML CLOB, IS_PUBLIC SMALLINT, ORG_ID INTEGER, SUPPORT_REFESH SMALLINT, REFESH_TIME INTEGER, SHOW_EFFECT SMALLINT, MEMO VARCHAR2(256), DATA_PARAM VARCHAR2(2000), NEEDPAGE SMALLINT, CONSTRAINT PK_SYS_INDEX_COLUMN PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_INDEX_COLUMN.ID IS '主键'; COMMENT ON COLUMN SYS_INDEX_COLUMN.NAME IS '栏目名称'; COMMENT ON COLUMN SYS_INDEX_COLUMN.ALIAS IS '栏目别名'; COMMENT ON COLUMN SYS_INDEX_COLUMN.CATALOG IS '栏目分类'; COMMENT ON COLUMN SYS_INDEX_COLUMN.COL_TYPE IS '栏目类型（0：一般栏目、1：图表栏目、2、滚动栏目）'; COMMENT ON COLUMN SYS_INDEX_COLUMN.DATA_MODE IS '数据加载方式(0:服务方法;1:自定义查询)'; COMMENT ON COLUMN SYS_INDEX_COLUMN.DATA_FROM IS '数据来源'; COMMENT ON COLUMN SYS_INDEX_COLUMN.DS_ALIAS IS '数据别名'; COMMENT ON COLUMN SYS_INDEX_COLUMN.DS_NAME IS '数据源名称'; COMMENT ON COLUMN SYS_INDEX_COLUMN.COL_HEIGHT IS '栏目高度'; COMMENT ON COLUMN SYS_INDEX_COLUMN.COL_URL IS '栏目URL'; COMMENT ON COLUMN SYS_INDEX_COLUMN.TEMPLATE_HTML IS '栏目模版'; COMMENT ON COLUMN SYS_INDEX_COLUMN.IS_PUBLIC IS '是否公共栏目'; COMMENT ON COLUMN SYS_INDEX_COLUMN.ORG_ID IS '所属组织ID'; COMMENT ON COLUMN SYS_INDEX_COLUMN.SUPPORT_REFESH IS '是否支持刷新'; COMMENT ON COLUMN SYS_INDEX_COLUMN.REFESH_TIME IS '刷新时间'; COMMENT ON COLUMN SYS_INDEX_COLUMN.SHOW_EFFECT IS '展示效果'; COMMENT ON COLUMN SYS_INDEX_COLUMN.MEMO IS '描述'; /*==============================================================*/ /* Table: SYS_POPUP_REMIND */ /*==============================================================*/ CREATE TABLE sys_popup_remind ( ID NUMBER(18) NOT NULL, SUBJECT varchar2(200) , URL varchar2(200) , SQL_ varchar2(2000) , DSALIAS varchar2(20) , SN INTEGER, ENABLED INTEGER, CREATETIME DATE, CREATOR varchar2(50) , DESC_ varchar2(300), POPUP_TYPE varchar2(200), RESERVE varchar2(1000), CONSTRAINT PK_SYS_POPUP_REMIND PRIMARY KEY (ID) ); /*==============================================================*/ /* Table: SYS_OBJ_RIGHTS */ /*==============================================================*/ CREATE TABLE sys_obj_rights ( ID NUMBER(18) NOT NULL , OBJ_TYPE varchar(20) , OBJECT_ID NUMBER(18) , OWNER_ID NUMBER(18) , OWNER varchar(50) , RIGHT_TYPE varchar(10) , CONSTRAINT PK_SYS_OBJ_RIGHTS PRIMARY KEY (ID) ); /*==============================================================*/ /* Table: SYS_PROPERTY */ /*==============================================================*/ CREATE TABLE SYS_PROPERTY ( ID NUMBER(18) NOT NULL, NAME_ VARCHAR2(128), ALIAS_ VARCHAR2(128), VALUE_ VARCHAR2(256), GROUP_ VARCHAR2(128), SN_ SMALLINT, MEMO VARCHAR2(200), CONSTRAINT PK_SYS_PROPERTY PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_PROPERTY.ID IS '主键'; COMMENT ON COLUMN SYS_PROPERTY.NAME_ IS '名字'; COMMENT ON COLUMN SYS_PROPERTY.ALIAS_ IS '别名'; COMMENT ON COLUMN SYS_PROPERTY.VALUE_ IS '值'; COMMENT ON COLUMN SYS_PROPERTY.GROUP_ IS '分组'; COMMENT ON COLUMN SYS_PROPERTY.MEMO IS '参数描述'; /*==============================================================*/ /* Table: BPM_BATCH_APPROVAL */ /*==============================================================*/ CREATE TABLE BPM_BATCH_APPROVAL ( ID NUMBER(18) NOT NULL, DEF_KEY VARCHAR2(128), NODE_ID VARCHAR2(128), TABLE_ID NUMBER(18), FIELD_JSON CLOB, CONSTRAINT PK_BPM_BATCH_APPROVAL PRIMARY KEY (ID) ); COMMENT ON COLUMN BPM_BATCH_APPROVAL.ID IS '主键'; COMMENT ON COLUMN BPM_BATCH_APPROVAL.DEF_KEY IS '流程定义Key'; COMMENT ON COLUMN BPM_BATCH_APPROVAL.NODE_ID IS '节点ID'; COMMENT ON COLUMN BPM_BATCH_APPROVAL.TABLE_ID IS '自定义表ID'; COMMENT ON COLUMN BPM_BATCH_APPROVAL.FIELD_JSON IS '字段设置'; /*==============================================================*/ /* Table: SYS_BULLETIN */ /*==============================================================*/ CREATE TABLE SYS_BULLETIN ( ID NUMBER(18) NOT NULL, SUBJECT VARCHAR2(200), COLUMNID NUMBER(18), CONTENT CLOB, CREATORID NUMBER(18), CREATOR VARCHAR2(50), CREATETIME DATE, ATTACHMENT VARCHAR2(400), STATUS SMALLINT, IMGURL VARCHAR2(50), CONSTRAINT PK_SYS_BULLETIN PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_BULLETIN.ID IS '主键'; COMMENT ON COLUMN SYS_BULLETIN.SUBJECT IS '主题'; COMMENT ON COLUMN SYS_BULLETIN.COLUMNID IS '栏目id'; COMMENT ON COLUMN SYS_BULLETIN.CONTENT IS '内容'; COMMENT ON COLUMN SYS_BULLETIN.CREATORID IS '创建人id'; COMMENT ON COLUMN SYS_BULLETIN.CREATOR IS '创建人'; COMMENT ON COLUMN SYS_BULLETIN.CREATETIME IS '创建时间'; COMMENT ON COLUMN SYS_BULLETIN.ATTACHMENT IS '附件'; COMMENT ON COLUMN SYS_BULLETIN.STATUS IS '状态'; /*==============================================================*/ /* Table: SYS_BULLETIN_COLUMN */ /*==============================================================*/ CREATE TABLE SYS_BULLETIN_COLUMN ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), ALIAS VARCHAR2(20), ISPUBLIC SMALLINT, TENANTID NUMBER(18), CREATORID NUMBER(18), CREATOR VARCHAR2(50), CREATETIME DATE, STATUS SMALLINT, IMGURL VARCHAR2(50), CONSTRAINT PK_SYS_BULLETIN_COLUMN PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_BULLETIN_COLUMN.ID IS '主键'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.NAME IS '栏目名'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.ALIAS IS '别名'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.ISPUBLIC IS '是否是集团栏目'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.TENANTID IS '组织id'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.CREATORID IS '创建人id'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.CREATOR IS '创建人'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.CREATETIME IS '创建时间'; COMMENT ON COLUMN SYS_BULLETIN_COLUMN.STATUS IS '状态'; /*==============================================================*/ /* Table: SYS_PLAN 日程表 */ /*==============================================================*/ CREATE TABLE SYS_PLAN ( ID NUMBER(18) NOT NULL, TASKNAME VARCHAR2(200), SUBMITID NUMBER(18), SUBMITOR VARCHAR2(50), CHARGEID NUMBER(18), CHARGE VARCHAR2(50), STARTTIME DATE, ENDTIME DATE, PROJECTNAME VARCHAR2(200), DOC VARCHAR2(400), CUSTOMERID NUMBER(18), CUSTOMER VARCHAR2(200), RUNID NUMBER(18), RUNNAME VARCHAR2(200), RATE NUMBER(18), CREATETIME DATE, DESCRIPTION VARCHAR2(2000), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PLAN IS '日程表'; COMMENT ON COLUMN SYS_PLAN.ID IS '日程表主键'; COMMENT ON COLUMN SYS_PLAN.TASKNAME IS '任务名称'; COMMENT ON COLUMN SYS_PLAN.SUBMITID IS '提交人ID'; COMMENT ON COLUMN SYS_PLAN.SUBMITOR IS '提交人'; COMMENT ON COLUMN SYS_PLAN.CHARGEID IS '负责人ID'; COMMENT ON COLUMN SYS_PLAN.CHARGE IS '负责人'; COMMENT ON COLUMN SYS_PLAN.STARTTIME IS '开始时间'; COMMENT ON COLUMN SYS_PLAN.ENDTIME IS '结束时间'; COMMENT ON COLUMN SYS_PLAN.PROJECTNAME IS '项目名称'; COMMENT ON COLUMN SYS_PLAN.DOC IS '相关文档'; COMMENT ON COLUMN SYS_PLAN.CUSTOMERID IS '相关客户ID'; COMMENT ON COLUMN SYS_PLAN.CUSTOMER IS '相关客户'; COMMENT ON COLUMN SYS_PLAN.RUNID IS '相关工单ID'; COMMENT ON COLUMN SYS_PLAN.RUNNAME IS '工单名称'; COMMENT ON COLUMN SYS_PLAN.RATE IS '完成进度'; COMMENT ON COLUMN SYS_PLAN.CREATETIME IS '创建时间'; COMMENT ON COLUMN SYS_PLAN.DESCRIPTION IS '任务内容'; /*==============================================================*/ /* Table: SYS_PLAN_PARTICIPANTS 日程参与表 */ /*==============================================================*/ CREATE TABLE SYS_PLAN_PARTICIPANTS ( ID NUMBER(18) NOT NULL, PLANID NUMBER(18), PARTICIPANTID NUMBER(18), PARTICIPANT VARCHAR2(50), PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PLAN_PARTICIPANTS IS '日程参与表 '; COMMENT ON COLUMN SYS_PLAN_PARTICIPANTS.ID IS '日程参与表主键'; COMMENT ON COLUMN SYS_PLAN_PARTICIPANTS.PLANID IS '日程ID'; COMMENT ON COLUMN SYS_PLAN_PARTICIPANTS.PARTICIPANTID IS '参与者ID'; COMMENT ON COLUMN SYS_PLAN_PARTICIPANTS.PARTICIPANT IS '参与者'; /*==============================================================*/ /* Table: SYS_PLAN_SUBSCRIBE 日程订阅表 */ /*==============================================================*/ CREATE TABLE SYS_PLAN_SUBSCRIBE ( ID NUMBER(18) NOT NULL, PLANID NUMBER(18), SUBSCRIBEID NUMBER(18), SUBSCRIBE VARCHAR2(50), SUBSCRIBETIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PLAN_SUBSCRIBE IS '日程订阅表 '; COMMENT ON COLUMN SYS_PLAN_SUBSCRIBE.ID IS '日程订阅表主键'; COMMENT ON COLUMN SYS_PLAN_SUBSCRIBE.PLANID IS '日程ID'; COMMENT ON COLUMN SYS_PLAN_SUBSCRIBE.SUBSCRIBEID IS '订阅者ID'; COMMENT ON COLUMN SYS_PLAN_SUBSCRIBE.SUBSCRIBE IS '订阅者'; COMMENT ON COLUMN SYS_PLAN_SUBSCRIBE.SUBSCRIBETIME IS '订阅时间'; /*==============================================================*/ /* Table: SYS_PLAN_EXCHANGE 日程交流表 */ /*==============================================================*/ CREATE TABLE SYS_PLAN_EXCHANGE ( ID NUMBER(18) NOT NULL, PLANID NUMBER(18), SUBMITID NUMBER(18), SUBMITOR VARCHAR2(50), DOC VARCHAR2(400), CONTENT VARCHAR2(1000), CREATETIME DATE, PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_PLAN_EXCHANGE IS '日程交流表 '; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.ID IS '日程交流表主键'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.PLANID IS '日程ID'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.SUBMITID IS '提交人ID'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.SUBMITOR IS '提交人'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.DOC IS '相关文档'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.CONTENT IS '交流内容'; COMMENT ON COLUMN SYS_PLAN_EXCHANGE.CREATETIME IS '提交时间'; /*==============================================================*/ /* Table: SYS_TRANS_DEF */ /*==============================================================*/ CREATE TABLE SYS_TRANS_DEF ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), SELECTSQL CLOB, UPDATESQL CLOB, STATE SMALLINT, CREATORID NUMBER(18), CREATOR VARCHAR2(50), CREATETIME DATE, LOGCONTENT VARCHAR2(500), CONSTRAINT PK_SYS_TRANS_DEF PRIMARY KEY (ID) ); /*==============================================================*/ /* Table: SYS_OBJ_LOG */ /*==============================================================*/ CREATE TABLE SYS_OBJ_LOG ( ID NUMBER(18) NOT NULL, OPERATOR_ID NUMBER(18), OPERATOR VARCHAR2(255), CREATE_TIME DATE, NAME VARCHAR2(255), CONTENT CLOB, OBJ_TYPE VARCHAR2(255), PARAM VARCHAR2(255), CONSTRAINT PK_SYS_OBJ_LOG PRIMARY KEY (ID) ); CREATE TABLE BPM_FORM_DIALOG_COMBINATE ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(200), ALIAS VARCHAR2(200), WIDTH INT, HEIGHT INT, TREE_DIALOG_ID NUMBER(18), TREE_DIALOG_NAME VARCHAR2(200), LIST_DIALOG_ID NUMBER(18), LIST_DIALOG_NAME VARCHAR2(200), FIELD VARCHAR2(1000), CONSTRAINT PK_BPM_FORM_DIALOG_COMBINATE PRIMARY KEY (ID) ); ALTER TABLE BPM_FORM_DIALOG_COMBINATE ADD CONSTRAINT AK_KEY_3_BPM_FORM UNIQUE (ALIAS); CREATE TABLE FORM_DEF_TREE ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(100), ALIAS VARCHAR2(50), TREE_ID VARCHAR2(100), PARENT_ID VARCHAR2(100), DISPLAY_FIELD VARCHAR2(100), LOAD_TYPE SMALLINT, ROOT_ID VARCHAR2(255), FORM_KEY VARCHAR2(50), CONSTRAINT PK_FORM_DEF_TREE PRIMARY KEY (ID) ); ALTER TABLE FORM_DEF_TREE ADD CONSTRAINT AK_KEY_3_FORM_DEF UNIQUE (ALIAS); CREATE TABLE FORM_DEF_COMBINATE ( ID INTEGER DEFAULT 0 NOT NULL, NAME VARCHAR2(200), ALIAS VARCHAR2(100), TREE_DIALOG_ID INTEGER, TREE_DIALOG_NAME VARCHAR2(200), FORM_DEF_ID INTEGER, FORM_DEF_NAME VARCHAR2(200), FIELD CLOB, CONSTRAINT PK_FORM_DEF_COMBINATE PRIMARY KEY (ID) ); COMMENT ON COLUMN FORM_DEF_COMBINATE.TREE_DIALOG_ID IS '树对话框ID'; COMMENT ON COLUMN FORM_DEF_COMBINATE.FORM_DEF_ID IS '表单ID 注意 表单需要有业务数据模板才行'; COMMENT ON COLUMN FORM_DEF_COMBINATE.FIELD IS '树数据返回数据对应列表数据的查询条件'; ALTER TABLE FORM_DEF_COMBINATE ADD CONSTRAINT "ALIAS_UNIQUE" UNIQUE (ALIAS); CREATE TABLE SYS_BUS_EVENT ( ID INTEGER DEFAULT 0 NOT NULL, FORMKEY VARCHAR2(50) DEFAULT NULL, JS_PRE_SCRIPT VARCHAR2(4000) DEFAULT '', JS_AFTER_SCRIPT VARCHAR2(2000) DEFAULT '', PRE_SCRIPT VARCHAR2(2000) DEFAULT NULL, AFTER_SCRIPT VARCHAR2(2000) DEFAULT NULL, CONSTRAINT PK_SYS_BUS_EVENT PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_BUS_EVENT.ID IS '主键'; COMMENT ON COLUMN SYS_BUS_EVENT.FORMKEY IS '表单key'; COMMENT ON COLUMN SYS_BUS_EVENT.JS_PRE_SCRIPT IS 'JS前置脚本'; COMMENT ON COLUMN SYS_BUS_EVENT.JS_AFTER_SCRIPT IS 'js后置脚本'; COMMENT ON COLUMN SYS_BUS_EVENT.PRE_SCRIPT IS 'JAVA前置脚本'; COMMENT ON COLUMN SYS_BUS_EVENT.AFTER_SCRIPT IS 'java后置脚本'; CREATE TABLE BPM_NEWFLOW_TRIGGER ( ID NUMBER(20) NOT NULL , NAME VARCHAR2(255 BYTE) NULL , NODEID VARCHAR2(255 BYTE) NULL , ACTION VARCHAR2(50 BYTE) NULL , FLOWKEY VARCHAR2(255 BYTE) NULL , TRIGGERFLOWKEY VARCHAR2(255 BYTE) NULL , TRIGGERFLOWNAME VARCHAR2(500 BYTE) NULL , JSONMAPING CLOB NULL , TRIGGERJSON CLOB NULL, NOTE VARCHAR2(2000 BYTE) NULL ); ALTER TABLE BPM_NEWFLOW_TRIGGER ADD PRIMARY KEY (ID); CREATE TABLE BPM_NODEMSG_TEMPLATE ( ID NUMBER(20) NOT NULL, DEFID NUMBER(20), PARENTDEFID NUMBER(20), NODEID VARCHAR2(20), TITLE VARCHAR2(200), HTML CLOB, TEXT CLOB, CONSTRAINT PK_BPM_NODEMSG_TEMPLATE PRIMARY KEY (ID) ); CREATE TABLE SYS_EXCEL_TEMP ( ID NUMBER(20) NOT NULL, TEMP_CODE VARCHAR2(100) NOT NULL, TEMP_NAME VARCHAR2(100), TEMP_DES VARCHAR2(500), TEMP_DES_HEIGHT NUMBER(4), MEMO VARCHAR2(500), TEMP_DATA_SAMPLE CLOB, CONSTRAINT PK_SYS_EXCEL_TEMP PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_EXCEL_TEMP IS 'Excel模板'; COMMENT ON COLUMN SYS_EXCEL_TEMP.ID IS '主键'; COMMENT ON COLUMN SYS_EXCEL_TEMP.TEMP_CODE IS '模板代码'; COMMENT ON COLUMN SYS_EXCEL_TEMP.TEMP_NAME IS '模板名称'; COMMENT ON COLUMN SYS_EXCEL_TEMP.TEMP_DES IS '模板填写说明'; COMMENT ON COLUMN SYS_EXCEL_TEMP.TEMP_DES_HEIGHT IS '填写说明行高'; COMMENT ON COLUMN SYS_EXCEL_TEMP.MEMO IS '备注'; COMMENT ON COLUMN SYS_EXCEL_TEMP.TEMP_DATA_SAMPLE IS '模板样例数据'; CREATE TABLE SYS_EXCEL_TEMP_DETAIL ( ID NUMBER(20) NOT NULL, TEMP_ID NUMBER(20), COLUMN_NAME VARCHAR2(100), COLUMN_TYPE NUMBER(4), COLUMN_LEN NUMBER(4), SHOW_INDEX NUMBER(4), CONSTRAINT PK_SYS_EXCEL_TEMP_DETAIL PRIMARY KEY (ID) ); COMMENT ON TABLE SYS_EXCEL_TEMP_DETAIL IS 'Excel模板明细'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.ID IS '主键'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.TEMP_ID IS '模板ID'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.COLUMN_NAME IS '列名称'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.COLUMN_TYPE IS '数据类型'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.COLUMN_LEN IS '列长'; COMMENT ON COLUMN SYS_EXCEL_TEMP_DETAIL.SHOW_INDEX IS '显示顺序'; CREATE TABLE SYS_QUERY_SQLDEF ( ID NUMBER(18) NOT NULL, NAME VARCHAR2(50), SQL_ VARCHAR2(2000), DSNAME VARCHAR2(50), BUTTON_DEF VARCHAR2(1000), ALIAS VARCHAR2(50), CATEGORYID NUMBER(18), SUPPORT_TAB SMALLINT, CONSTRAINT PK_SYS_QUERY_SQLDEF PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_QUERY_SQLDEF.ID IS '主键'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.NAME IS '名称'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.SQL_ IS 'SQL定义'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.DSNAME IS '数据源名称'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.BUTTON_DEF IS '按纽定义'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.ALIAS IS '别名'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.CATEGORYID IS '分类ID'; COMMENT ON COLUMN SYS_QUERY_SQLDEF.SUPPORT_TAB IS'是否支持tab'; CREATE TABLE SYS_QUERY_METAFIELD ( ID NUMBER(18) NOT NULL, SQL_ID NUMBER(18), NAME VARCHAR2(50), FIELD_NAME VARCHAR2(50), FIELD_DESC VARCHAR2(100), IS_SHOW SMALLINT, IS_SEARCH SMALLINT, CONTROL_TYPE SMALLINT, DATA_TYPE VARCHAR2(10), IS_VIRTUAL SMALLINT, VIRTUAL_FROM SMALLINT, RESULT_FROM_TYPE VARCHAR2(10), RESULT_FROM VARCHAR2(400), ALARM_SETTING VARCHAR2(400), DATE_FORMAT VARCHAR2(40), URL VARCHAR2(200), FORMATER VARCHAR2(1000), CONTROL_CONTENT VARCHAR2(400), SN NUMBER(4), WIDTH NUMBER(4), CONSTRAINT PK_SYS_QUERY_METAFIELD PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_QUERY_METAFIELD.ID IS '主键'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.SQL_ID IS 'SQL_ID'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.NAME IS '字段名'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.FIELD_NAME IS '实际字段名'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.FIELD_DESC IS '字段备注'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.IS_SHOW IS '是否可见'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.IS_SEARCH IS '是否搜索'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.CONTROL_TYPE IS '控件类型'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.DATA_TYPE IS '数据类型'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.IS_VIRTUAL IS '是否衍生列'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.VIRTUAL_FROM IS '衍生列来自列'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.RESULT_FROM_TYPE IS '来自类型'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.RESULT_FROM IS '衍生列配置'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.ALARM_SETTING IS '报警设定'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.DATE_FORMAT IS '日期格式'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.URL IS '连接地址'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.FORMATER IS '格式化函数'; COMMENT ON COLUMN SYS_QUERY_METAFIELD.CONTROL_CONTENT IS '控件内容'; CREATE TABLE SYS_QUERY_VIEW ( ID NUMBER(18) NOT NULL, SQL_ALIAS VARCHAR2(50), NAME VARCHAR2(50), ALIAS VARCHAR2(50), CONDITIONS CLOB, FILTER_TYPE SMALLINT, FILTER CLOB, BUTTONS VARCHAR2(1000), INIT_QUERY SMALLINT, TEMPLATE CLOB, SUPPORT_GROUP SMALLINT, GROUP_SETTING VARCHAR2(400), PAGE_SIZE SMALLINT, SHOW_ROWS_NUM SMALLINT, SN NUMBER(18), NEED_PAGE SMALLINT, TEMPLATEALIAS VARCHAR2(50), CONSTRAINT PK_SYS_QUERY_VIEW PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_QUERY_VIEW.ID IS '主键'; COMMENT ON COLUMN SYS_QUERY_VIEW.SQL_ALIAS IS 'sql别名'; COMMENT ON COLUMN SYS_QUERY_VIEW.NAME IS '视图名称'; COMMENT ON COLUMN SYS_QUERY_VIEW.ALIAS IS '视图别名'; COMMENT ON COLUMN SYS_QUERY_VIEW.CONDITIONS IS '查询条件定义'; COMMENT ON COLUMN SYS_QUERY_VIEW.FILTER_TYPE IS '过滤器类型'; COMMENT ON COLUMN SYS_QUERY_VIEW.FILTER IS '过滤器'; COMMENT ON COLUMN SYS_QUERY_VIEW.BUTTONS IS '按纽定义'; COMMENT ON COLUMN SYS_QUERY_VIEW.INIT_QUERY IS '是否初始化查询'; COMMENT ON COLUMN SYS_QUERY_VIEW.TEMPLATE IS '模版定义'; COMMENT ON COLUMN SYS_QUERY_VIEW.SUPPORT_GROUP IS '是否支持分组'; COMMENT ON COLUMN SYS_QUERY_VIEW.GROUP_SETTING IS '分组设定'; COMMENT ON COLUMN SYS_QUERY_VIEW.PAGE_SIZE IS '分页大小'; COMMENT ON COLUMN SYS_QUERY_VIEW.SHOW_ROWS_NUM IS '显示行号'; COMMENT ON COLUMN SYS_QUERY_VIEW.SN IS '排序'; COMMENT ON COLUMN SYS_QUERY_VIEW.NEED_PAGE IS '是否分页'; COMMENT ON COLUMN SYS_QUERY_VIEW.TEMPLATEALIAS IS '摸版别名'; CREATE TABLE SYS_QUERY_FIELDSETTING ( ID NUMBER(18) NOT NULL, VIEW_ID NUMBER(18), FIELD_NAME VARCHAR2(50), SORT_ABLE SMALLINT, DEFAULT_SORT SMALLINT, SORT_SEQ VARCHAR2(10), ALIGN VARCHAR2(10), FROZEN SMALLINT, SUMMARY_TYPE VARCHAR2(50), SUMMARY_TEMPLATE VARCHAR2(200), HIDDEN SMALLINT, SN NUMBER(4), WIDTH NUMBER(4), CONSTRAINT PK_SYS_QUERY_FIELDSETTING PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.ID IS '主键'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.VIEW_ID IS '视图ID'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.FIELD_NAME IS '字段名称'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.SORT_ABLE IS '允许排序'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.DEFAULT_SORT IS '默认排序'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.SORT_SEQ IS '默认排序方向'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.ALIGN IS '对齐方式'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.FROZEN IS '是否冻结'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.SUMMARY_TYPE IS '计算类型'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.SUMMARY_TEMPLATE IS '计算模版'; COMMENT ON COLUMN SYS_QUERY_FIELDSETTING.HIDDEN IS '是否隐藏'; /*==============================================================*/ /* Table: SYS_HISTORY_DATA */ /*==============================================================*/ CREATE TABLE SYS_HISTORY_DATA ( ID NUMBER(18,0) NOT NULL, TYPE_ VARCHAR2(50), OBJ_ID NUMBER(18,0), CONTENT CLOB, CREATOR VARCHAR2(50), SUBJECT VARCHAR2(200), CREATETIME DATE, CONSTRAINT PK_SYS_HISTORY_DATA PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_HISTORY_DATA.ID IS '主键'; COMMENT ON COLUMN SYS_HISTORY_DATA.TYPE_ IS '数据类型'; COMMENT ON COLUMN SYS_HISTORY_DATA.OBJ_ID IS '关联对象ID'; COMMENT ON COLUMN SYS_HISTORY_DATA.CONTENT IS '存储内容'; COMMENT ON COLUMN SYS_HISTORY_DATA.CREATOR IS '创建人'; COMMENT ON COLUMN SYS_HISTORY_DATA.CREATETIME IS '创建时间'; CREATE TABLE SYS_BULLETIN_TEMPLATE ( ID NUMBER(20) NOT NULL, NAME VARCHAR2(50) DEFAULT NULL, ALIAS VARCHAR2(20) DEFAULT NULL, TEMPLATE CLOB ); COMMENT ON COLUMN SYS_BULLETIN_TEMPLATE.ID IS '主键'; COMMENT ON COLUMN SYS_BULLETIN_TEMPLATE.NAME IS '名称'; COMMENT ON COLUMN SYS_BULLETIN_TEMPLATE.ALIAS IS '别名'; COMMENT ON COLUMN SYS_BULLETIN_TEMPLATE.TEMPLATE IS 'html内容'; ALTER TABLE SYS_BULLETIN_TEMPLATE ADD CONSTRAINT BULLETIN_TEMPLETE_UNIQUE UNIQUE (ALIAS); CREATE TABLE SYS_READ_RECORD ( ID NUMBER(20) NOT NULL, SOURCE VARCHAR2(50), GROUPID NUMBER(20), OBJECTID NUMBER(20) NOT NULL, USERID NUMBER(20) NOT NULL, CREATETIME DATE NOT NULL, CONSTRAINT PK_SYS_READ_RECORD PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_READ_RECORD.SOURCE IS '来源；eg:公告：BULLETINID'; COMMENT ON COLUMN SYS_READ_RECORD.GROUPID IS '分组ID；删除时可以删除一组，如任务存放流程实例id,栏目ID'; COMMENT ON COLUMN SYS_READ_RECORD.OBJECTID IS '对象ID'; COMMENT ON COLUMN SYS_READ_RECORD.USERID IS '用户ID'; COMMENT ON COLUMN SYS_READ_RECORD.CREATETIME IS '阅读时间'; CREATE TABLE SYS_PWD_STRATEGY ( ID INTEGER DEFAULT 0 NOT NULL, INIT_PWD VARCHAR2(50) DEFAULT NULL, FORCE_CHANGE_INIT_PWD SMALLINT DEFAULT NULL, PWD_RULE SMALLINT DEFAULT NULL, PWD_LENGTH SMALLINT DEFAULT NULL, VALIDITY SMALLINT DEFAULT NULL, HANDLE_OVERDUE SMALLINT DEFAULT NULL, OVERDUE_REMIND SMALLINT DEFAULT NULL, VERIFY_CODE_APPEAR SMALLINT DEFAULT NULL, ERR_LOCK_ACCOUNT SMALLINT DEFAULT NULL, ENABLE_ SMALLINT DEFAULT NULL, DESC_ CLOB, CONSTRAINT PK_SYS_PWD_STRATEGY PRIMARY KEY (ID) ); CREATE TABLE SYS_LOGIN_LOG ( ID INTEGER DEFAULT 0 NOT NULL, ACCOUNT VARCHAR2(200) DEFAULT NULL, LOGINTIME DATE DEFAULT NULL, IP VARCHAR2(200) DEFAULT NULL, STATUS SMALLINT DEFAULT NULL, DESC_ CLOB, CONSTRAINT PK_SYS_LOGIN_LOG PRIMARY KEY (ID) ); /*==============================================================*/ /* Table: OA_LINKMAN */ /*==============================================================*/ CREATE TABLE OA_LINKMAN ( ID INTEGER NOT NULL, NAME VARCHAR2(50) DEFAULT NULL, SEX VARCHAR2(8) DEFAULT NULL, PHONE VARCHAR2(50) DEFAULT NULL, EMAIL VARCHAR2(50) DEFAULT NULL, COMPANY VARCHAR2(50) DEFAULT NULL, JOB VARCHAR2(20) DEFAULT NULL, ADDRESS VARCHAR2(50) DEFAULT NULL, CREATETIME DATE DEFAULT NULL, STATUS SMALLINT DEFAULT 1, USERID INTEGER DEFAULT NULL, CONSTRAINT PK_OA_LINKMAN PRIMARY KEY (ID) ); COMMENT ON COLUMN OA_LINKMAN.SEX IS '性别'; COMMENT ON COLUMN OA_LINKMAN.PHONE IS '电话'; COMMENT ON COLUMN OA_LINKMAN.EMAIL IS '邮箱'; COMMENT ON COLUMN OA_LINKMAN.COMPANY IS '公司'; COMMENT ON COLUMN OA_LINKMAN.JOB IS '工作'; COMMENT ON COLUMN OA_LINKMAN.ADDRESS IS '地址'; COMMENT ON COLUMN OA_LINKMAN.CREATETIME IS '创建时间'; COMMENT ON COLUMN OA_LINKMAN.STATUS IS '状态,1为启用，0为禁用'; /*==============================================================*/ /* Table: SYS_MSG_LINKMAN_GROUP */ /*==============================================================*/ CREATE TABLE SYS_MSG_LINKMAN_GROUP ( ID NUMBER(20) NOT NULL, GROUP_NAME VARCHAR2(200), USER_IDS VARCHAR2(2000), USERS VARCHAR2(2000), CREATOR_ID NUMBER(20), CREATE_TIME DATE, CONSTRAINT PK_SYS_MSG_LINKMAN_GROUP PRIMARY KEY (ID) ); COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.ID IS '主键'; COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.GROUP_NAME IS '组名'; COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.USER_IDS IS '常用联系人ID'; COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.USERS IS '常用联系人'; COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.CREATOR_ID IS '创建人'; COMMENT ON COLUMN SYS_MSG_LINKMAN_GROUP.CREATE_TIME IS '创建时间'; /*==============================================================*/ /* Table: BPM_MOBILE_FORM_DEF */ /*==============================================================*/ CREATE TABLE BPM_MOBILE_FORM_DEF ( ID NUMBER(18) NOT NULL, VERSION NUMBER DEFAULT 1, FORM_KEY VARCHAR2(50 BYTE), FORM_HTML CLOB, TABLE_ID NUMBER(18), TABLE_NAME VARCHAR2(50 BYTE), SUBJECT VARCHAR2(255 BYTE), CREATE_BY NUMBER(18), CREATOR VARCHAR2(50 BYTE), CREATE_TIME DATE, IS_DEFAULT NUMBER, IS_PUBLISHED NUMBER DEFAULT 0, PUBLISHER VARCHAR2(50 BYTE), PUBLISH_BY NUMBER(18), PUBLISH_TIME DATE, UPDATOR VARCHAR2(50 BYTE), UPDATE_BY NUMBER(18), UPDATE_TIME DATE, CATEGORY_ID NUMBER(18), TEMPLATE CLOB , CONSTRAINT PK_BPM_MOBILE_FORM_DEF PRIMARY KEY (ID) ); COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.VERSION IS '版本'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.FORM_KEY IS '表单KEY'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.FORM_HTML IS '表单HTML'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.TABLE_ID IS '表ID'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.TABLE_NAME IS '表名'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.SUBJECT IS '表单主题'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.CREATE_BY IS '创建人ID'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.CREATOR IS '创建人'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.CREATE_TIME IS '创建时间'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.IS_DEFAULT IS '是否默认版本'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.IS_PUBLISHED IS '是否发布'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.PUBLISHER IS '发布人'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.PUBLISH_BY IS '发布人ID'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.PUBLISH_TIME IS '发布时间'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.UPDATOR IS '更新人'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.UPDATE_BY IS '更新人ID'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.UPDATE_TIME IS '最后更新时间'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.CATEGORY_ID IS '分类'; COMMENT ON COLUMN BPM_MOBILE_FORM_DEF.TEMPLATE IS '表单模板';