--------------------------------------------------------
--  文件已创建 - 星期一-九月-23-2019   
--------------------------------------------------------
DROP SEQUENCE "VERSION_SEQ";
DROP TABLE "ACT_GE_BYTEARRAY" cascade constraints;
DROP TABLE "ACT_GE_PROPERTY" cascade constraints;
DROP TABLE "ACT_HI_ACTINST" cascade constraints;
DROP TABLE "ACT_HI_COMMENT" cascade constraints;
DROP TABLE "ACT_HI_IDENTITYLINK" cascade constraints;
DROP TABLE "ACT_HI_PROCINST" cascade constraints;
DROP TABLE "ACT_HI_PROCINST_EXTENSION" cascade constraints;
DROP TABLE "ACT_HI_TASKINST" cascade constraints;
DROP TABLE "ACT_HI_TASKINST_EXTENSION" cascade constraints;
DROP TABLE "ACT_HI_TASKINST_RELATION" cascade constraints;
DROP TABLE "ACT_HI_VARINST" cascade constraints;
DROP TABLE "ACT_RE_DEPLOYMENT" cascade constraints;
DROP TABLE "ACT_RE_PROCDEF" cascade constraints;
DROP TABLE "ACT_RE_PROCDEF_TREE_DEL" cascade constraints;
DROP TABLE "ACT_RU_EVENT_SUBSCR" cascade constraints;
DROP TABLE "ACT_RU_EXECUTION" cascade constraints;
DROP TABLE "ACT_RU_IDENTITYLINK" cascade constraints;
DROP TABLE "ACT_RU_JOB" cascade constraints;
DROP TABLE "ACT_RU_TASK" cascade constraints;
DROP TABLE "ACT_RU_TASK_EXTENSION" cascade constraints;
DROP TABLE "ACT_RU_VARIABLE" cascade constraints;
DROP TABLE "SA_APPLICATIONSYSTEM" cascade constraints;
DROP TABLE "SA_APPROVAL_REJECTED_REASON" cascade constraints;
DROP TABLE "SA_ATTACHMENT" cascade constraints;
DROP TABLE "SA_ATTACHMENTCONFIG" cascade constraints;
DROP TABLE "SA_ATTACHMENTCONFIGDETAIL" cascade constraints;
DROP TABLE "SA_BIZCLASSIFICATION" cascade constraints;
DROP TABLE "SA_BIZCLASSIFICATIONDETAIL" cascade constraints;
DROP TABLE "SA_CODEBUILDRULE" cascade constraints;
DROP TABLE "SA_COMMONHANDLER" cascade constraints;
DROP TABLE "SA_COMMONTREE" cascade constraints;
DROP TABLE "SA_DICTIONARY" cascade constraints;
DROP TABLE "SA_DICTIONARYDETAIL" cascade constraints;
DROP TABLE "SA_EXCELIMPORTLOG" cascade constraints;
DROP TABLE "SA_EXCELIMPORTTEMPLATE" cascade constraints;
DROP TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" cascade constraints;
DROP TABLE "SA_FLEXFIELDBIZGROUP" cascade constraints;
DROP TABLE "SA_FLEXFIELDBIZGROUPFIELD" cascade constraints;
DROP TABLE "SA_FLEXFIELDDEFINITION" cascade constraints;
DROP TABLE "SA_FLEXFIELDSTORAGE" cascade constraints;
DROP TABLE "SA_HISTORICSESSION" cascade constraints;
DROP TABLE "SA_I18NPROPERTIES" cascade constraints;
DROP TABLE "SA_MACHINE" cascade constraints;
DROP TABLE "SA_MESSAGE_REMIND" cascade constraints;
DROP TABLE "SA_ONLINESESSION" cascade constraints;
DROP TABLE "SA_OPAGENT" cascade constraints;
DROP TABLE "SA_OPAGENTPROC" cascade constraints;
DROP TABLE "SA_OPAUTHORIZE" cascade constraints;
DROP TABLE "SA_OPBASEFUNCTIONTYPE" cascade constraints;
DROP TABLE "SA_OPBASEMANAGEMENTTYPE" cascade constraints;
DROP TABLE "SA_OPBIZFUNCTION" cascade constraints;
DROP TABLE "SA_OPBIZFUNCTIONOWNBASE" cascade constraints;
DROP TABLE "SA_OPBIZMANAGEMENT" cascade constraints;
DROP TABLE "SA_OPBIZMANAGEMENTTYPE" cascade constraints;
DROP TABLE "SA_OPDATAKIND" cascade constraints;
DROP TABLE "SA_OPDATAMANAGEBUSINESS" cascade constraints;
DROP TABLE "SA_OPDATAMANAGEBUSINESS_FIELD" cascade constraints;
DROP TABLE "SA_OPDATAMANAGEDETAIL" cascade constraints;
DROP TABLE "SA_OPDATAMANAGEDETAILRESOURCE" cascade constraints;
DROP TABLE "SA_OPDATAMANAGEMENT" cascade constraints;
DROP TABLE "SA_OPDATAMANAGETYPE" cascade constraints;
DROP TABLE "SA_OPDATAMANAGETYPEKIND" cascade constraints;
DROP TABLE "SA_OPERATIONLOG" cascade constraints;
DROP TABLE "SA_OPERATIONLOGDETAIL" cascade constraints;
DROP TABLE "SA_OPERATIONLOG_BAK" cascade constraints;
DROP TABLE "SA_OPFUNCTION" cascade constraints;
DROP TABLE "SA_OPFUNCTION_FIELD_GROUP" cascade constraints;
DROP TABLE "SA_OPFUNCTION_PERMISSIONFIELD" cascade constraints;
DROP TABLE "SA_OPOPERATION" cascade constraints;
DROP TABLE "SA_OPORG" cascade constraints;
DROP TABLE "SA_OPORGPROPERTY" cascade constraints;
DROP TABLE "SA_OPORGPROPERTYDEFINITION" cascade constraints;
DROP TABLE "SA_OPORGROLEAUTHORIZE" cascade constraints;
DROP TABLE "SA_OPORGTEMPLATE" cascade constraints;
DROP TABLE "SA_OPORGTYPE" cascade constraints;
DROP TABLE "SA_OPPERMISSION" cascade constraints;
DROP TABLE "SA_OPPERSON" cascade constraints;
DROP TABLE "SA_OPREMIND" cascade constraints;
DROP TABLE "SA_OPROLE" cascade constraints;
DROP TABLE "SA_OPROLEPERMISSION" cascade constraints;
DROP TABLE "SA_OPTENANT" cascade constraints;
DROP TABLE "SA_OPUIELEMENT" cascade constraints;
DROP TABLE "SA_OPUIELEMENTPERMISSION" cascade constraints;
DROP TABLE "SA_ORGFUN" cascade constraints;
DROP TABLE "SA_PARAMETER" cascade constraints;
DROP TABLE "SA_PDSCREEN" cascade constraints;
DROP TABLE "SA_PDSCREENFUNCTION" cascade constraints;
DROP TABLE "SA_PERSONACCOUNTMANAGEMENT" cascade constraints;
DROP TABLE "SA_PERSONCALENDAR" cascade constraints;
DROP TABLE "SA_PERSONLOGINLIMIT" cascade constraints;
DROP TABLE "SA_PERSONQUERYSCHEME" cascade constraints;
DROP TABLE "SA_SCHEDULING_JOB" cascade constraints;
DROP TABLE "SA_SCHEDULING_JOB_LOG" cascade constraints;
DROP TABLE "SA_SECURITYPOLICY" cascade constraints;
DROP TABLE "SA_SYNBASEDATAVERSION" cascade constraints;
DROP TABLE "SA_TMAUTHORIZE" cascade constraints;
DROP TABLE "SA_USERGROUP" cascade constraints;
DROP TABLE "SA_USERGROUPDETAIL" cascade constraints;
DROP TABLE "WF_APPROVALELEMENT" cascade constraints;
DROP TABLE "WF_APPROVALHANDLERKIND" cascade constraints;
DROP TABLE "WF_APPROVALRULE" cascade constraints;
DROP TABLE "WF_APPROVALRULEELEMENT" cascade constraints;
DROP TABLE "WF_APPROVALRULEHANDLER" cascade constraints;
DROP TABLE "WF_APPROVALRULEHANDLERASSIST" cascade constraints;
DROP TABLE "WF_APPROVALRULEHANDLERGROUP" cascade constraints;
DROP TABLE "WF_APPROVALRULEHANDLERUIPERM" cascade constraints;
DROP TABLE "WF_APPROVALRULEHANDLER_AUTH" cascade constraints;
DROP TABLE "WF_APPROVALRULESCOPE" cascade constraints;
DROP TABLE "WF_BASESEGMENTATIONTYPE" cascade constraints;
DROP TABLE "WF_BIZSEGMENTATION" cascade constraints;
DROP TABLE "WF_BIZSEGMENTATIONAUTHORIZE" cascade constraints;
DROP TABLE "WF_HI_PROCUNITHANDLER" cascade constraints;
DROP TABLE "WF_HI_PROCUNITHANDLERINST" cascade constraints;
DROP TABLE "WF_ID_LOG" cascade constraints;
DROP TABLE "WF_PROCAPPROVALELEMENT" cascade constraints;
DROP TABLE "WF_PROCDEF" cascade constraints;
DROP TABLE "WF_PROCUNITHANDLER" cascade constraints;
DROP TABLE "WF_PROCUNITHANDLERMANUSCRIPT" cascade constraints;
DROP TABLE "WF_PROCUNITHANDLER_CACHE" cascade constraints;
DROP TABLE "WF_SEGMENTATIONHANDLER" cascade constraints;
DROP TABLE "WF_TASKCOLLECTION" cascade constraints;
DROP VIEW "SYS_USERS_VIEW";
DROP VIEW "V_ACT_HI_PROCINST";
DROP VIEW "V_ACT_HI_TASK";
DROP VIEW "V_ACT_HI_TASK_FOR_DELETE";
DROP VIEW "V_ACT_RU_TASK";
DROP VIEW "V_SA_OPORG_EXCLUDE_POS";
DROP PROCEDURE "P_UPDATE_COMMONTREE_FULLINFO";
DROP PROCEDURE "P_UPDATE_MANAGETYPE_FULLINFO";
DROP PROCEDURE "P_UPDATE_OPFUNCTION_FULLINFO";
DROP PROCEDURE "P_UPDATE_ROLE_FULLINFO";
--------------------------------------------------------
--  DDL for Sequence VERSION_SEQ
--------------------------------------------------------

   CREATE SEQUENCE  "VERSION_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 3559476 CACHE 20 NOORDER  NOCYCLE ;
--------------------------------------------------------
--  DDL for Table ACT_GE_BYTEARRAY
--------------------------------------------------------

  CREATE TABLE "ACT_GE_BYTEARRAY" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "NAME_" NVARCHAR2(1020), "DEPLOYMENT_ID_" NVARCHAR2(64), "BYTES_" BLOB, "GENERATED_" NUMBER(1,0)) ;
--------------------------------------------------------
--  DDL for Table ACT_GE_PROPERTY
--------------------------------------------------------

  CREATE TABLE "ACT_GE_PROPERTY" ("NAME_" NVARCHAR2(256), "VALUE_" NVARCHAR2(1200), "REV_" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table ACT_HI_ACTINST
--------------------------------------------------------

  CREATE TABLE "ACT_HI_ACTINST" ("ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "ACT_ID_" NVARCHAR2(255), "TASK_ID_" NVARCHAR2(64), "CALL_PROC_INST_ID_" NVARCHAR2(64), "ACT_NAME_" NVARCHAR2(1020), "ACT_TYPE_" NVARCHAR2(1020), "ASSIGNEE_" NVARCHAR2(1024), "START_TIME_" TIMESTAMP (6), "END_TIME_" TIMESTAMP (6), "DURATION_" NUMBER(19,0), "TENANT_ID_" NVARCHAR2(255) DEFAULT '') ;
--------------------------------------------------------
--  DDL for Table ACT_HI_COMMENT
--------------------------------------------------------

  CREATE TABLE "ACT_HI_COMMENT" ("ID_" NVARCHAR2(64), "TYPE_" NVARCHAR2(1020), "TIME_" TIMESTAMP (6), "USER_ID_" NVARCHAR2(1024), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "ACTION_" NVARCHAR2(1020), "MESSAGE_" NVARCHAR2(2000), "FULL_MSG_" BLOB) ;
--------------------------------------------------------
--  DDL for Table ACT_HI_IDENTITYLINK
--------------------------------------------------------

  CREATE TABLE "ACT_HI_IDENTITYLINK" ("ID_" NVARCHAR2(64), "GROUP_ID_" NVARCHAR2(255), "TYPE_" NVARCHAR2(1020), "USER_ID_" NVARCHAR2(1024), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64)) ;
--------------------------------------------------------
--  DDL for Table ACT_HI_PROCINST
--------------------------------------------------------

  CREATE TABLE "ACT_HI_PROCINST" ("ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "BUSINESS_KEY_" NVARCHAR2(1020), "PROC_DEF_ID_" NVARCHAR2(64), "START_TIME_" TIMESTAMP (6), "END_TIME_" TIMESTAMP (6), "DURATION_" NUMBER(19,0), "START_USER_ID_" NVARCHAR2(255), "START_ACT_ID_" NVARCHAR2(255), "END_ACT_ID_" NVARCHAR2(255), "SUPER_PROCESS_INSTANCE_ID_" NVARCHAR2(64), "DELETE_REASON_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "NAME_" NVARCHAR2(1020)) ;
--------------------------------------------------------
--  DDL for Table ACT_HI_PROCINST_EXTENSION
--------------------------------------------------------

  CREATE TABLE "ACT_HI_PROCINST_EXTENSION" ("ID_" NVARCHAR2(64), "BUSINESS_KEY_" NVARCHAR2(1020), "APPLICANT_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "APPLICANT_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "APPLICANT_POS_ID_" VARCHAR2(65 BYTE), "APPLICANT_POS_NAME_" VARCHAR2(256 BYTE), "APPLICANT_DEPT_ID_" VARCHAR2(65 BYTE), "APPLICANT_DEPT_NAME_" VARCHAR2(256 BYTE), "APPLICANT_ORG_ID_" VARCHAR2(65 BYTE), "APPLICANT_ORG_NAME_" VARCHAR2(256 BYTE), "APPLICANT_FULL_ID_" VARCHAR2(1024 BYTE), "APPLICANT_FULL_NAME_" VARCHAR2(2048 BYTE), "VERSION_" NUMBER(*,0), "DESCRIPTION_" VARCHAR2(1024 BYTE), "STATUS_ID_" VARCHAR2(32 BYTE), "STATUS_NAME_" VARCHAR2(64 BYTE), "PROC_DEF_ID_" NVARCHAR2(64), "START_TIME_" TIMESTAMP (6), "END_TIME_" TIMESTAMP (6), "DURATION_" NUMBER(19,0), "START_USER_ID_" NVARCHAR2(255), "START_ACT_ID_" NVARCHAR2(255), "END_ACT_ID_" NVARCHAR2(255), "SUPER_PROCESS_INSTANCE_ID_" NVARCHAR2(64), "DELETE_REASON_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "NAME_" NVARCHAR2(1020), "KEY_" NVARCHAR2(1020), "PROC_INST_ID_" NVARCHAR2(64)) ;
--------------------------------------------------------
--  DDL for Table ACT_HI_TASKINST
--------------------------------------------------------

  CREATE TABLE "ACT_HI_TASKINST" ("ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "TASK_DEF_KEY_" NVARCHAR2(1020), "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "PARENT_TASK_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "DESCRIPTION_" NVARCHAR2(2000), "OWNER_" NVARCHAR2(1024), "ASSIGNEE_" NVARCHAR2(1024), "START_TIME_" TIMESTAMP (6), "CLAIM_TIME_" TIMESTAMP (6), "END_TIME_" TIMESTAMP (6), "DURATION_" NUMBER(19,0), "DELETE_REASON_" NVARCHAR2(2000), "PRIORITY_" NUMBER(*,0), "DUE_DATE_" TIMESTAMP (6), "FORM_KEY_" NVARCHAR2(1020), "CATEGORY_" NVARCHAR2(1020), "TENANT_ID_" NVARCHAR2(255) DEFAULT '') ;
--------------------------------------------------------
--  DDL for Table ACT_HI_TASKINST_EXTENSION
--------------------------------------------------------

  CREATE TABLE "ACT_HI_TASKINST_EXTENSION" ("ID_" NVARCHAR2(64), "CATALOG_ID_" VARCHAR2(32 BYTE), "KIND_ID_" VARCHAR2(32 BYTE), "CREATOR_URL_" VARCHAR2(512 BYTE), "EXECUTOR_URL_" VARCHAR2(512 BYTE), "CREATOR_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "CREATOR_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "CREATOR_POS_ID_" VARCHAR2(65 BYTE), "CREATOR_POS_NAME_" VARCHAR2(256 BYTE), "CREATOR_DEPT_ID_" VARCHAR2(65 BYTE), "CREATOR_DEPT_NAME_" VARCHAR2(256 BYTE), "CREATOR_OGN_ID_" VARCHAR2(65 BYTE), "CREATOR_OGN_NAME_" VARCHAR2(256 BYTE), "CREATOR_FULL_ID_" VARCHAR2(1024 BYTE), "CREATOR_FULL_NAME_" VARCHAR2(2048 BYTE), "EXECUTOR_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "EXECUTOR_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_POS_ID_" VARCHAR2(65 BYTE), "EXECUTOR_POS_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_DEPT_ID_" VARCHAR2(65 BYTE), "EXECUTOR_DEPT_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_OGN_ID_" VARCHAR2(65 BYTE), "EXECUTOR_OGN_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_FULL_ID_" VARCHAR2(1024 BYTE), "EXECUTOR_FULL_NAME_" VARCHAR2(2048 BYTE), "STATUS_ID_" VARCHAR2(32 BYTE), "STATUS_NAME_" VARCHAR2(128 BYTE), "EXECUTOR_NAMES_" VARCHAR2(2048 BYTE), "OWNER_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "OWNER_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "OWNER_POS_ID_" VARCHAR2(65 BYTE), "OWNER_POS_NAME_" VARCHAR2(256 BYTE), "OWNER_DEPT_ID_" VARCHAR2(65 BYTE), "OWNER_DEPT_NAME_" VARCHAR2(256 BYTE), "OWNER_OGN_ID_" VARCHAR2(65 BYTE), "OWNER_OGN_NAME_" VARCHAR2(256 BYTE), "OWNER_FULL_ID_" VARCHAR2(1024 BYTE), "OWNER_FULL_NAME_" VARCHAR2(2048 BYTE), "PREVIOUS_ID_" VARCHAR2(64 BYTE), "PROC_UNIT_HANDLER_ID_" VARCHAR2(32 BYTE), "BUSINESS_KEY_" NVARCHAR2(1020), "BUSINESS_CODE_" NVARCHAR2(256), "NEED_TIMING_" NUMBER(*,0), "OPINION_" VARCHAR2(2048 BYTE), "RESULT_" NUMBER(*,0), "SLEEPED_DATE_" DATE, "SIGN_PUNISH_" NUMBER(*,0), "SIGN_NEED_TIMING_" NUMBER(*,0), "VERSION_" NUMBER(*,0), "PROC_INST_ID_" NVARCHAR2(64), "COOPERATION_MODEL_ID_" VARCHAR2(32 BYTE), "LIMIT_TIME_" NUMBER(*,0), "APPLICANT_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "APPLICANT_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "PROCESS_DEFINITION_KEY_" VARCHAR2(510 BYTE), "CREATOR_PERSON_ID_" VARCHAR2(32 BYTE), "EXECUTOR_PERSON_ID_" VARCHAR2(32 BYTE), "PROC_DEF_ID_" NVARCHAR2(64), "TASK_DEF_KEY_" NVARCHAR2(1020), "EXECUTION_ID_" NVARCHAR2(64), "PARENT_TASK_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "DESCRIPTION_" NVARCHAR2(2000), "START_TIME_" TIMESTAMP (6), "CLAIM_TIME_" TIMESTAMP (6), "END_TIME_" TIMESTAMP (6), "DURATION_" NUMBER(19,0), "DELETE_REASON_" NVARCHAR2(2000), "PRIORITY_" NUMBER(*,0), "DUE_DATE_" TIMESTAMP (6), "FORM_KEY_" NVARCHAR2(1020), "CATEGORY_" NVARCHAR2(1020), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "GENERATE_REASON_" NVARCHAR2(1020), "SUB_PROC_UNIT_NAME_" NVARCHAR2(1020)) ;
 

   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CATALOG_ID_" IS '任务的大类标识 process为流程任务，task为协同任务';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."KIND_ID_" IS '任务的类型细分标识，processInstance为流程实例，task为任务，executor为执行者';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_URL_" IS '创建此任务的activity的URL';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_URL_" IS '处理此任务的activity的URL';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_PERSON_MEMBER_ID_" IS '创建人ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_PERSON_MEMBER_NAME_" IS '创建人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_POS_ID_" IS '创建人岗位ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_POS_NAME_" IS '创建人岗位';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_DEPT_ID_" IS '创建人部门ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_DEPT_NAME_" IS '创建人部门';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_OGN_ID_" IS '创建人机构ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_OGN_NAME_" IS '创建人机构';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_FULL_ID_" IS '创建人ID全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_FULL_NAME_" IS '创建人名称全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_PERSON_MEMBER_ID_" IS '执行人ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_PERSON_MEMBER_NAME_" IS '执行人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_POS_ID_" IS '执行人岗位ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_POS_NAME_" IS '执行人岗位';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_DEPT_ID_" IS '执行人部门ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_DEPT_NAME_" IS '执行人部门';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_OGN_ID_" IS '执行人机构ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_OGN_NAME_" IS '执行人机构';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_FULL_ID_" IS '执行人ID全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_FULL_NAME_" IS '执行人名称全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."STATUS_ID_" IS '任务状态ID ，取值范围是ready(尚未处理)，executing(正在处理)，sleeping(暂缓处理)，canceled(已取消)，aborted(已终止)，completed(已完成)，returned(已回退)，trainsmited(已转发)，paused(已暂停)';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."STATUS_NAME_" IS '任务状态';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_NAMES_" IS '执行人名称';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_PERSON_MEMBER_ID_" IS '责任人ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_PERSON_MEMBER_NAME_" IS '责任人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_POS_ID_" IS '责任人岗位ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_POS_NAME_" IS '责任人岗位';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_DEPT_ID_" IS '责任人部门ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_DEPT_NAME_" IS '责任人部门';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_OGN_ID_" IS '责任人机构ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_OGN_NAME_" IS '责任人机构';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_FULL_ID_" IS '责任人ID全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OWNER_FULL_NAME_" IS '责任人名称全路径';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."PREVIOUS_ID_" IS '前任务ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."PROC_UNIT_HANDLER_ID_" IS '环节处理人ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."BUSINESS_KEY_" IS '业务组件ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."BUSINESS_CODE_" IS '业务组件编码';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."NEED_TIMING_" IS '需要计时';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."OPINION_" IS '处理意见';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."RESULT_" IS '处理结果';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."SLEEPED_DATE_" IS '暂缓时间';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."SIGN_PUNISH_" IS '人为标记是否处罚';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."SIGN_NEED_TIMING_" IS '人为标记是否计时';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."PROC_INST_ID_" IS '流程实例ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."COOPERATION_MODEL_ID_" IS '协助模式';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."LIMIT_TIME_" IS '限制时间';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."APPLICANT_PERSON_MEMBER_ID_" IS '申请人员成员ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."APPLICANT_PERSON_MEMBER_NAME_" IS '申请人员成员';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."PROCESS_DEFINITION_KEY_" IS '流程定义ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."CREATOR_PERSON_ID_" IS '创建人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."EXECUTOR_PERSON_ID_" IS '执行人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_EXTENSION"."GENERATE_REASON_" IS '产生原因';
--------------------------------------------------------
--  DDL for Table ACT_HI_TASKINST_RELATION
--------------------------------------------------------

  CREATE TABLE "ACT_HI_TASKINST_RELATION" ("ID" VARCHAR2(32 BYTE), "CREATED_DATE" DATE, "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(64 BYTE), "BUSINESS_KEY" VARCHAR2(64 BYTE), "PROC_INST_ID" VARCHAR2(36 BYTE), "TASK_ID" NVARCHAR2(64), "RELATED_TASK_ID" NVARCHAR2(64), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."ID" IS 'ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."BUSINESS_KEY" IS '业务ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."PROC_INST_ID" IS '流程实例ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."TASK_ID" IS '任务ID';
 
   COMMENT ON COLUMN "ACT_HI_TASKINST_RELATION"."RELATED_TASK_ID" IS '关联任务ID';
 
   COMMENT ON TABLE "ACT_HI_TASKINST_RELATION"  IS '任务关联';
--------------------------------------------------------
--  DDL for Table ACT_HI_VARINST
--------------------------------------------------------

  CREATE TABLE "ACT_HI_VARINST" ("ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "EXECUTION_ID_" NVARCHAR2(64), "TASK_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "VAR_TYPE_" NVARCHAR2(400), "REV_" NUMBER(*,0), "BYTEARRAY_ID_" NVARCHAR2(64), "DOUBLE_" NUMBER(*,10), "LONG_" NUMBER(19,0), "TEXT_" NVARCHAR2(2000), "TEXT2_" NVARCHAR2(2000), "CREATE_TIME_" TIMESTAMP (6), "LAST_UPDATED_TIME_" TIMESTAMP (6)) ;
--------------------------------------------------------
--  DDL for Table ACT_RE_DEPLOYMENT
--------------------------------------------------------

  CREATE TABLE "ACT_RE_DEPLOYMENT" ("ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "CATEGORY_" NVARCHAR2(1020), "DEPLOY_TIME_" TIMESTAMP (6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '') ;
--------------------------------------------------------
--  DDL for Table ACT_RE_PROCDEF
--------------------------------------------------------

  CREATE TABLE "ACT_RE_PROCDEF" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "CATEGORY_" NVARCHAR2(1020), "NAME_" NVARCHAR2(1020), "KEY_" NVARCHAR2(1020), "VERSION_" NUMBER(*,0), "DEPLOYMENT_ID_" NVARCHAR2(64), "RESOURCE_NAME_" NVARCHAR2(2000), "DGRM_RESOURCE_NAME_" VARCHAR2(4000 BYTE), "DESCRIPTION_" NVARCHAR2(2000), "HAS_START_FORM_KEY_" NUMBER(1,0), "SUSPENSION_STATE_" NUMBER(*,0), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "HAS_GRAPHICAL_NOTATION_" NUMBER(1,0)) ;
--------------------------------------------------------
--  DDL for Table ACT_RE_PROCDEF_TREE_DEL
--------------------------------------------------------

  CREATE TABLE "ACT_RE_PROCDEF_TREE_DEL" ("RE_PROCDEF_TREE_ID" NUMBER(*,0), "CODE" VARCHAR2(256 BYTE), "NAME" VARCHAR2(512 BYTE), "PATH" VARCHAR2(2048 BYTE), "PARENT_ID" NUMBER(*,0), "STATUS" NUMBER(*,0), "DESCRIPTION" VARCHAR2(1200 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "KEY" VARCHAR2(128 BYTE), "APPROVAL_RULE_PROC_DEF_KEY" VARCHAR2(128 BYTE), "NODE_KIND_ID" VARCHAR2(32 BYTE), "NEED_TIMING" NUMBER(*,0), "APP_MODEL_ID" NUMBER(*,0), "FULL_NAME" VARCHAR2(2048 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "SHOW_QUERY_HANDLERS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."RE_PROCDEF_TREE_ID" IS '主键';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."CODE" IS '编码';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."NAME" IS '名称';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."PATH" IS 'ID全路径';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."STATUS" IS '状态';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."KEY" IS '流程KEY';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."APPROVAL_RULE_PROC_DEF_KEY" IS '审批规则流程ID';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."NODE_KIND_ID" IS '节点类型 folder 文件夹 proc 流程 procUnit 流程环节';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."NEED_TIMING" IS '需要计时';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."APP_MODEL_ID" IS 'APP模型ID';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."FULL_NAME" IS '名称全路径';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "ACT_RE_PROCDEF_TREE_DEL"."SHOW_QUERY_HANDLERS" IS '显示询问处理人对话框 1 是 0 否';
 
   COMMENT ON TABLE "ACT_RE_PROCDEF_TREE_DEL"  IS '流程定义树';
--------------------------------------------------------
--  DDL for Table ACT_RU_EVENT_SUBSCR
--------------------------------------------------------

  CREATE TABLE "ACT_RU_EVENT_SUBSCR" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "EVENT_TYPE_" NVARCHAR2(1020), "EVENT_NAME_" NVARCHAR2(1020), "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "ACTIVITY_ID_" NVARCHAR2(64), "CONFIGURATION_" NVARCHAR2(1020), "CREATED_" TIMESTAMP (6), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "PROC_DEF_ID_" NVARCHAR2(64)) ;
--------------------------------------------------------
--  DDL for Table ACT_RU_EXECUTION
--------------------------------------------------------

  CREATE TABLE "ACT_RU_EXECUTION" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "PROC_INST_ID_" NVARCHAR2(64), "BUSINESS_KEY_" NVARCHAR2(1020), "PARENT_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "SUPER_EXEC_" NVARCHAR2(256), "ACT_ID_" NVARCHAR2(255), "IS_ACTIVE_" NUMBER(1,0), "IS_CONCURRENT_" NUMBER(1,0), "IS_SCOPE_" NUMBER(1,0), "IS_EVENT_SCOPE_" NUMBER(1,0), "SUSPENSION_STATE_" NUMBER(*,0), "CACHED_ENT_STATE_" NUMBER(*,0), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "NAME_" NVARCHAR2(1020), "LOCK_TIME_" TIMESTAMP (6)) ;
--------------------------------------------------------
--  DDL for Table ACT_RU_IDENTITYLINK
--------------------------------------------------------

  CREATE TABLE "ACT_RU_IDENTITYLINK" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "GROUP_ID_" NVARCHAR2(255), "TYPE_" NVARCHAR2(1020), "USER_ID_" NVARCHAR2(1024), "TASK_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64)) ;
--------------------------------------------------------
--  DDL for Table ACT_RU_JOB
--------------------------------------------------------

  CREATE TABLE "ACT_RU_JOB" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "TYPE_" NVARCHAR2(1020), "LOCK_EXP_TIME_" TIMESTAMP (6), "LOCK_OWNER_" NVARCHAR2(1020), "EXCLUSIVE_" NUMBER(1,0), "EXECUTION_ID_" NVARCHAR2(64), "PROCESS_INSTANCE_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "RETRIES_" NUMBER(*,0), "EXCEPTION_STACK_ID_" NVARCHAR2(64), "EXCEPTION_MSG_" NVARCHAR2(2000), "DUEDATE_" TIMESTAMP (6), "REPEAT_" NVARCHAR2(1020), "HANDLER_TYPE_" NVARCHAR2(1020), "HANDLER_CFG_" NVARCHAR2(2000), "TENANT_ID_" NVARCHAR2(255) DEFAULT '') ;
--------------------------------------------------------
--  DDL for Table ACT_RU_TASK
--------------------------------------------------------

  CREATE TABLE "ACT_RU_TASK" ("ID_" NVARCHAR2(64), "REV_" NUMBER(*,0), "EXECUTION_ID_" NVARCHAR2(64), "PROC_INST_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "PARENT_TASK_ID_" NVARCHAR2(64), "DESCRIPTION_" NVARCHAR2(2000), "TASK_DEF_KEY_" NVARCHAR2(1020), "OWNER_" NVARCHAR2(1024), "ASSIGNEE_" NVARCHAR2(1024), "DELEGATION_" NVARCHAR2(256), "PRIORITY_" NUMBER(*,0), "CREATE_TIME_" TIMESTAMP (6), "DUE_DATE_" TIMESTAMP (6), "SUSPENSION_STATE_" NUMBER(*,0), "CATEGORY_" NVARCHAR2(1020), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "FORM_KEY_" NVARCHAR2(1020)) ;
 

   COMMENT ON COLUMN "ACT_RU_TASK"."ID_" IS '主键';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."REV_" IS '版本号';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."EXECUTION_ID_" IS '执行实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."PROC_INST_ID_" IS '流程实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."PROC_DEF_ID_" IS '流程定义ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."NAME_" IS '节点定义名称';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."PARENT_TASK_ID_" IS '父节点实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."DESCRIPTION_" IS '节点定义描述';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."TASK_DEF_KEY_" IS '节点定义的KEY';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."OWNER_" IS '实际签收人';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."ASSIGNEE_" IS '签收人或委托人';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."DELEGATION_" IS '委托类型';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."PRIORITY_" IS '优先级别';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."CREATE_TIME_" IS '创建时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."DUE_DATE_" IS '过期时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK"."SUSPENSION_STATE_" IS '是否挂起';
--------------------------------------------------------
--  DDL for Table ACT_RU_TASK_EXTENSION
--------------------------------------------------------

  CREATE TABLE "ACT_RU_TASK_EXTENSION" ("ID_" VARCHAR2(64 BYTE), "CATALOG_ID_" VARCHAR2(32 BYTE), "KIND_ID_" VARCHAR2(32 BYTE), "CREATOR_URL_" VARCHAR2(512 BYTE), "EXECUTOR_URL_" VARCHAR2(512 BYTE), "CREATOR_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "CREATOR_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "CREATOR_POS_ID_" VARCHAR2(65 BYTE), "CREATOR_POS_NAME_" VARCHAR2(256 BYTE), "CREATOR_DEPT_ID_" VARCHAR2(65 BYTE), "CREATOR_DEPT_NAME_" VARCHAR2(256 BYTE), "CREATOR_OGN_ID_" VARCHAR2(65 BYTE), "CREATOR_OGN_NAME_" VARCHAR2(256 BYTE), "CREATOR_FULL_ID_" VARCHAR2(1024 BYTE), "CREATOR_FULL_NAME_" VARCHAR2(2048 BYTE), "EXECUTOR_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "EXECUTOR_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_POS_ID_" VARCHAR2(65 BYTE), "EXECUTOR_POS_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_DEPT_ID_" VARCHAR2(65 BYTE), "EXECUTOR_DEPT_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_OGN_ID_" VARCHAR2(65 BYTE), "EXECUTOR_OGN_NAME_" VARCHAR2(256 BYTE), "EXECUTOR_FULL_ID_" VARCHAR2(1024 BYTE), "EXECUTOR_FULL_NAME_" VARCHAR2(2048 BYTE), "STATUS_ID_" VARCHAR2(32 BYTE), "STATUS_NAME_" VARCHAR2(128 BYTE), "EXECUTOR_NAMES_" VARCHAR2(2048 BYTE), "OWNER_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "OWNER_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "OWNER_POS_ID_" VARCHAR2(65 BYTE), "OWNER_POS_NAME_" VARCHAR2(256 BYTE), "OWNER_DEPT_ID_" VARCHAR2(65 BYTE), "OWNER_DEPT_NAME_" VARCHAR2(256 BYTE), "OWNER_OGN_ID_" VARCHAR2(65 BYTE), "OWNER_OGN_NAME_" VARCHAR2(256 BYTE), "OWNER_FULL_ID_" VARCHAR2(1024 BYTE), "OWNER_FULL_NAME_" VARCHAR2(2048 BYTE), "PREVIOUS_ID_" VARCHAR2(64 BYTE), "PROC_UNIT_HANDLER_ID_" VARCHAR2(32 BYTE), "BUSINESS_KEY_" NVARCHAR2(1020), "BUSINESS_CODE_" NVARCHAR2(256), "NEED_TIMING_" NUMBER(*,0), "OPINION_" VARCHAR2(2048 BYTE), "RESULT_" NUMBER(*,0), "SLEEPED_DATE_" DATE, "VERSION_" NUMBER(*,0), "PROC_INST_ID_" VARCHAR2(64 BYTE), "COOPERATION_MODEL_ID_" VARCHAR2(32 BYTE), "LIMIT_TIME_" NUMBER(*,0), "APPLICANT_PERSON_MEMBER_ID_" VARCHAR2(65 BYTE), "APPLICANT_PERSON_MEMBER_NAME_" VARCHAR2(256 BYTE), "PROCESS_DEFINITION_KEY_" VARCHAR2(510 BYTE), "CREATOR_PERSON_ID_" VARCHAR2(32 BYTE), "EXECUTOR_PERSON_ID_" VARCHAR2(32 BYTE), "EXECUTION_ID_" NVARCHAR2(64), "PROC_DEF_ID_" NVARCHAR2(64), "NAME_" NVARCHAR2(1020), "PARENT_TASK_ID_" NVARCHAR2(64), "DESCRIPTION_" NVARCHAR2(2000), "TASK_DEF_KEY_" NVARCHAR2(1020), "DELEGATION_" NVARCHAR2(256), "PRIORITY_" NUMBER(*,0), "START_TIME_" TIMESTAMP (6), "DUE_DATE_" TIMESTAMP (6), "SUSPENSION_STATE_" NUMBER(*,0), "CATEGORY_" NVARCHAR2(1020), "TENANT_ID_" NVARCHAR2(255) DEFAULT '', "FORM_KEY_" NVARCHAR2(1020), "GENERATE_REASON_" NVARCHAR2(1020), "SUB_PROC_UNIT_NAME_" NVARCHAR2(1020)) ;
 

   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CATALOG_ID_" IS '任务的大类标识 process为流程任务，task为协同任务';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."KIND_ID_" IS '任务的类型细分标识，task为任务，notice 任务抄送';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_URL_" IS '创建此任务的activity的URL';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_URL_" IS '处理此任务的activity的URL';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_PERSON_MEMBER_ID_" IS '创建人ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_PERSON_MEMBER_NAME_" IS '创建人';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_POS_ID_" IS '创建人岗位ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_POS_NAME_" IS '创建人岗位';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_DEPT_ID_" IS '创建人部门ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_DEPT_NAME_" IS '创建人部门';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_OGN_ID_" IS '创建人机构ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_OGN_NAME_" IS '创建人机构';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_FULL_ID_" IS '创建人ID全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_FULL_NAME_" IS '创建人名称全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_PERSON_MEMBER_ID_" IS '执行人ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_PERSON_MEMBER_NAME_" IS '执行人';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_POS_ID_" IS '执行人岗位ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_POS_NAME_" IS '执行人岗位';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_DEPT_ID_" IS '执行人部门ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_DEPT_NAME_" IS '执行人部门';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_OGN_ID_" IS '执行人机构ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_OGN_NAME_" IS '执行人机构';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_FULL_ID_" IS '执行人ID全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_FULL_NAME_" IS '执行人名称全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."STATUS_ID_" IS '任务状态ID ，取值范围是ready(尚未处理)，executing(正在处理)，sleeping(暂缓处理)，canceled(已取消)，aborted(已终止)，completed(已完成)，returned(已回退)，trainsmited(已转发)，paused(已暂停)';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."STATUS_NAME_" IS '任务状态';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_NAMES_" IS '执行人名称';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_PERSON_MEMBER_ID_" IS '责任人ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_PERSON_MEMBER_NAME_" IS '责任人';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_POS_ID_" IS '责任人岗位ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_POS_NAME_" IS '责任人岗位';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_DEPT_ID_" IS '责任人部门ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_DEPT_NAME_" IS '责任人部门';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_OGN_ID_" IS '责任人机构ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_OGN_NAME_" IS '责任人机构';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_FULL_ID_" IS '责任人ID全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OWNER_FULL_NAME_" IS '责任人名称全路径';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PREVIOUS_ID_" IS '前任务ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PROC_UNIT_HANDLER_ID_" IS '环节处理人ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."BUSINESS_KEY_" IS '业务组件ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."BUSINESS_CODE_" IS '业务组件编码';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."NEED_TIMING_" IS '需要计时';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."OPINION_" IS '处理意见';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."RESULT_" IS '处理结果';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."SLEEPED_DATE_" IS '暂缓时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PROC_INST_ID_" IS '流程实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."COOPERATION_MODEL_ID_" IS '协助模式';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."LIMIT_TIME_" IS '限制时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."APPLICANT_PERSON_MEMBER_ID_" IS '申请人员成员ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."APPLICANT_PERSON_MEMBER_NAME_" IS '申请人员成员';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PROCESS_DEFINITION_KEY_" IS '流程定义ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."CREATOR_PERSON_ID_" IS '创建人';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTOR_PERSON_ID_" IS '执行人';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."EXECUTION_ID_" IS '执行实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PROC_DEF_ID_" IS '流程定义ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."NAME_" IS '节点定义名称';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PARENT_TASK_ID_" IS '父节点实例ID';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."DESCRIPTION_" IS '节点定义描述';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."TASK_DEF_KEY_" IS '节点定义的KEY';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."DELEGATION_" IS '委托类型';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."PRIORITY_" IS '优先级别';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."START_TIME_" IS '创建时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."DUE_DATE_" IS '过期时间';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."SUSPENSION_STATE_" IS '是否挂起';
 
   COMMENT ON COLUMN "ACT_RU_TASK_EXTENSION"."GENERATE_REASON_" IS '产生原因';
--------------------------------------------------------
--  DDL for Table ACT_RU_VARIABLE
--------------------------------------------------------

--------------------------------------------------------
--  DDL for Table SA_APPLICATIONSYSTEM
--------------------------------------------------------

  CREATE TABLE "SA_APPLICATIONSYSTEM" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "CLASS_PREFIX" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_APPROVAL_REJECTED_REASON
--------------------------------------------------------

  CREATE TABLE "SA_APPROVAL_REJECTED_REASON" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CONTENT" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER(*,0), "STATUS" NUMBER(*,0), "VERSION" NUMBER, "REJECTED_REASON_KIND" VARCHAR2(64 BYTE)) ;
 

   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."FOLDER_ID" IS '分类ID';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."CONTENT" IS 'content';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."SEQUENCE" IS 'sequence';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."STATUS" IS 'status';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."VERSION" IS 'version';
 
   COMMENT ON COLUMN "SA_APPROVAL_REJECTED_REASON"."REJECTED_REASON_KIND" IS '类型';
 
   COMMENT ON TABLE "SA_APPROVAL_REJECTED_REASON"  IS '审批驳回理由维护';
--------------------------------------------------------
--  DDL for Table SA_ATTACHMENT
--------------------------------------------------------

  CREATE TABLE "SA_ATTACHMENT" ("ID" VARCHAR2(32 BYTE), "BIZ_KIND_ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "BIZ_SUB_KIND_ID" VARCHAR2(32 BYTE), "PATH" VARCHAR2(1024 BYTE), "FILE_NAME" VARCHAR2(512 BYTE), "FILE_SIZE" VARCHAR2(32 BYTE), "FILE_KIND" VARCHAR2(32 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_DATE" TIMESTAMP (6), "CREATED_BY_NAME" VARCHAR2(128 BYTE), "CLEAR_CACHE" NUMBER(*,0), "UPLOAD_KIND" VARCHAR2(32 BYTE), "REMARK" VARCHAR2(512 BYTE), "STATUS" NUMBER(*,0), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_ATTACHMENT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."BIZ_KIND_ID" IS '业务类别ID';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."BIZ_ID" IS '业务ID';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."BIZ_SUB_KIND_ID" IS '业务子类别ID';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."PATH" IS '路径';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."FILE_NAME" IS '文件名称';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."FILE_SIZE" IS '文件大小';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."FILE_KIND" IS '文件类别';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."CREATED_DATE" IS '创建日期';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."CLEAR_CACHE" IS '清楚缓存';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."UPLOAD_KIND" IS '上传类型';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."STATUS" IS '状态';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."VERSION" IS '版本';
 
   COMMENT ON COLUMN "SA_ATTACHMENT"."SEQUENCE" IS '排序号';
--------------------------------------------------------
--  DDL for Table SA_ATTACHMENTCONFIG
--------------------------------------------------------

  CREATE TABLE "SA_ATTACHMENTCONFIG" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "ALLOW_DELETE" NUMBER(*,0), "REMARK" VARCHAR2(512 BYTE), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_ATTACHMENTCONFIGDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_ATTACHMENTCONFIGDETAIL" ("ID" VARCHAR2(32 BYTE), "ATTACHMENTCONFIG_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "ALLOW_MULTIPLE" NUMBER(*,0), "FILE_KIND" VARCHAR2(256 BYTE), "SEQUENCE" NUMBER(*,0), "COL_SPAN" NUMBER(*,0), "IS_REQUIRED" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_BIZCLASSIFICATION
--------------------------------------------------------

  CREATE TABLE "SA_BIZCLASSIFICATION" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "DESCRIPTION" VARCHAR2(2048 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."PARENT_ID" IS '父ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."FULL_ID" IS '全路径ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."FULL_NAME" IS '全路径';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."VERSION" IS '版本';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATION"."STATUS" IS '状态';
 
   COMMENT ON TABLE "SA_BIZCLASSIFICATION"  IS '业务分类配置';
--------------------------------------------------------
--  DDL for Table SA_BIZCLASSIFICATIONDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_BIZCLASSIFICATIONDETAIL" ("ID" VARCHAR2(32 BYTE), "BIZ_CLASSIFICATION_ID" VARCHAR2(32 BYTE), "BIZ_TYPE" VARCHAR2(64 BYTE), "BIZ_PROPERTY_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "ENTITY_CLASS_NAME" VARCHAR2(256 BYTE), "BIZ_NAME" VARCHAR2(128 BYTE), "DIALOG_WIDTH" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."BIZ_CLASSIFICATION_ID" IS '业务属性配置ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."BIZ_TYPE" IS '业务参数;业务数据';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."BIZ_PROPERTY_ID" IS '业务属性ID';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."VERSION" IS '版本';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."ENTITY_CLASS_NAME" IS '对应实体资源类名';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."BIZ_NAME" IS '业务名称';
 
   COMMENT ON COLUMN "SA_BIZCLASSIFICATIONDETAIL"."DIALOG_WIDTH" IS '对话框宽度';
 
   COMMENT ON TABLE "SA_BIZCLASSIFICATIONDETAIL"  IS '业务分类配置明细';
--------------------------------------------------------
--  DDL for Table SA_CODEBUILDRULE
--------------------------------------------------------

  CREATE TABLE "SA_CODEBUILDRULE" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "RULE" VARCHAR2(256 BYTE), "CURRENT_VALUE" NUMBER(*,0), "FOLDER_ID" VARCHAR2(32 BYTE), "STATUS" NUMBER(*,0), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "LAST_MODIFIED_DATE" DATE) ;
--------------------------------------------------------
--  DDL for Table SA_COMMONHANDLER
--------------------------------------------------------

  CREATE TABLE "SA_COMMONHANDLER" ("ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "KIND_ID" VARCHAR2(32 BYTE), "ORG_UNIT_ID" VARCHAR2(65 BYTE), "ORG_UNIT_NAME" VARCHAR2(256 BYTE), "ORG_KIND_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "GROUP_ID" NUMBER(*,0), "SUB_PROC_UNIT_NAME" VARCHAR2(256 BYTE)) ;
 

   COMMENT ON COLUMN "SA_COMMONHANDLER"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."BIZ_ID" IS '业务ID';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."KIND_ID" IS 'receiver 接收人 feedbacker 反馈人 feedbackViewer 反馈查看人';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."ORG_UNIT_ID" IS '机构ID';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."ORG_UNIT_NAME" IS '组织单元名称';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."ORG_KIND_ID" IS '组织单元类别';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."SEQUENCE" IS '序号';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."GROUP_ID" IS '分组ID';
 
   COMMENT ON COLUMN "SA_COMMONHANDLER"."SUB_PROC_UNIT_NAME" IS '环节描述';
 
   COMMENT ON TABLE "SA_COMMONHANDLER"  IS '通用处理人设置';
--------------------------------------------------------
--  DDL for Table SA_COMMONTREE
--------------------------------------------------------

  CREATE TABLE "SA_COMMONTREE" ("KIND_ID" NUMBER(*,0), "CODE" VARCHAR2(128 BYTE), "SHORT_CODE" VARCHAR2(64 BYTE), "NODE_KIND_ID" VARCHAR2(6 BYTE), "NAME" VARCHAR2(256 BYTE), "REMARK" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0), "FULL_ID" VARCHAR2(256 BYTE), "FULL_NAME" VARCHAR2(1024 BYTE), "ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON COLUMN "SA_COMMONTREE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."SHORT_CODE" IS '简码';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."NODE_KIND_ID" IS 'floder文件夹 2 left';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."FULL_NAME" IS '名称全路径';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_COMMONTREE"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON TABLE "SA_COMMONTREE"  IS '通用树';
--------------------------------------------------------
--  DDL for Table SA_DICTIONARY
--------------------------------------------------------

  CREATE TABLE "SA_DICTIONARY" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "KIND_ID" NUMBER(*,0), "STATUS" NUMBER(*,0), "REMARK" VARCHAR2(512 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_DICTIONARYDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_DICTIONARYDETAIL" ("DICTIONARY_ID" VARCHAR2(32 BYTE), "ID" VARCHAR2(32 BYTE), "NAME" VARCHAR2(512 BYTE), "VALUE" VARCHAR2(256 BYTE), "STATUS" NUMBER(*,0), "TYPE_ID" VARCHAR2(128 BYTE), "REMARK" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_EXCELIMPORTLOG
--------------------------------------------------------

  CREATE TABLE "SA_EXCELIMPORTLOG" ("ID" VARCHAR2(32 BYTE), "TEMPLATE_ID" VARCHAR2(32 BYTE), "BATCH_NUMBER" VARCHAR2(64 BYTE), "FILE_NAME" VARCHAR2(400 BYTE), "ERROR_CODE" NUMBER(10,0), "ERROR_MESSAGE" VARCHAR2(4000 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "ORGAN_ID" VARCHAR2(32 BYTE), "ORGAN_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(64 BYTE), "CREATED_DATE" DATE, "ERROR_COUNT" NUMBER(*,0), "SUCCESS_COUNT" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_EXCELIMPORTTEMPLATE
--------------------------------------------------------

  CREATE TABLE "SA_EXCELIMPORTTEMPLATE" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "TABLE_NAME" VARCHAR2(512 BYTE), "PROCEDURE_NAME" VARCHAR2(128 BYTE), "CREATED_DATE" DATE, "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(64 BYTE), "STATUS" NUMBER(*,0), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "REMARK" VARCHAR2(1024 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_EXCELIMPORTTEMPLATEDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" ("TEMPLATE_ID" VARCHAR2(32 BYTE), "ID" VARCHAR2(32 BYTE), "EXCEL_COLUMN_NUMBER" NUMBER(*,0), "EXCEL_COLUMN_NAME" VARCHAR2(128 BYTE), "COLUMN_NAME" VARCHAR2(60 BYTE), "COLUMN_DESCRIPTION" VARCHAR2(128 BYTE), "DESCRIPTION" VARCHAR2(512 BYTE), "LENGTH" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_FLEXFIELDBIZGROUP
--------------------------------------------------------

  CREATE TABLE "SA_FLEXFIELDBIZGROUP" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "VISIBLE" NUMBER(*,0), "BIZ_CODE" VARCHAR2(60 BYTE), "IS_DETAIL_TABLE" NUMBER(*,0), "UI_STYLE" NUMBER(*,0), "COLS" NUMBER(*,0), "REMARK" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "MODEL_FILE_PATH" VARCHAR2(256 BYTE), "ENTITY_NAME" VARCHAR2(128 BYTE), "SHOW_MODEL" NUMBER(*,0), "TABLE_LAYOUT" VARCHAR2(256 BYTE), "STATUS" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_FLEXFIELDBIZGROUPFIELD
--------------------------------------------------------

  CREATE TABLE "SA_FLEXFIELDBIZGROUPFIELD" ("ID" VARCHAR2(32 BYTE), "FLEXFIELDBIZGROUP_ID" VARCHAR2(32 BYTE), "FLEXFIELDDEFINITION_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "NULLABLE" NUMBER(*,0), "CONTROL_WIDTH" NUMBER(*,0), "CONTROL_HEIGHT" NUMBER(*,0), "READ_ONLY" NUMBER(*,0), "VISIBLE" NUMBER(*,0), "NEW_LINE" NUMBER(*,0), "LABEL_WIDTH" NUMBER(*,0), "COL_SPAN" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_FLEXFIELDDEFINITION
--------------------------------------------------------

  CREATE TABLE "SA_FLEXFIELDDEFINITION" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "FIELD_NAME" VARCHAR2(60 BYTE), "DESCRIPTION" VARCHAR2(128 BYTE), "FIELD_TYPE" VARCHAR2(40 BYTE), "FIELD_LENGTH" NUMBER(*,0), "FIELD_PRECISION" NUMBER(*,0), "NULLABLE" NUMBER(*,0), "DEFAULT_VALUE" VARCHAR2(100 BYTE), "MIN_VALUE" NUMBER(18,2), "MAX_VALUE" NUMBER(18,2), "REMARK" VARCHAR2(2400 BYTE), "CONTROL_TYPE" NUMBER(*,0), "CONTROL_WIDTH" NUMBER(*,0), "CONTROL_HEIGHT" NUMBER(*,0), "DATA_SOURCE_KIND_ID" VARCHAR2(32 BYTE), "DATA_SOURCE" VARCHAR2(4000 BYTE), "READ_ONLY" NUMBER(*,0), "VISIBLE" NUMBER(*,0), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "NEW_LINE" NUMBER(*,0), "LABEL_WIDTH" NUMBER(*,0), "COL_SPAN" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_FLEXFIELDSTORAGE
--------------------------------------------------------

  CREATE TABLE "SA_FLEXFIELDSTORAGE" ("ID" VARCHAR2(32 BYTE), "BIZ_KIND_ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "DETAIL_ID" VARCHAR2(32 BYTE), "FLEXFIELDDEFINITION_ID" VARCHAR2(32 BYTE), "FIELD_VALUE" VARCHAR2(2048 BYTE), "FLEXFIELDGROUP_ID" VARCHAR2(32 BYTE), "LOOK_UP_VALUE" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FIELD_NAME" VARCHAR2(64 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_HISTORICSESSION
--------------------------------------------------------

  CREATE TABLE "SA_HISTORICSESSION" ("ID" VARCHAR2(36 BYTE), "ORGAN_ID" VARCHAR2(32 BYTE), "ORGAN_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(128 BYTE), "CLIENT_IP" VARCHAR2(64 BYTE), "SERVER_IP" VARCHAR2(64 BYTE), "LOGIN_DATE" DATE, "LOGOUT_DATE" DATE, "LOGOUT_KIND_ID" VARCHAR2(32 BYTE), "LOGOUT_PERSON_MEMEBER_ID" VARCHAR2(65 BYTE), "LOGOUT_PERSON_MEMEBER_NAME" VARCHAR2(128 BYTE), "VERSION" NUMBER(*,0), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "SESSION_ID" VARCHAR2(36 BYTE), "LOGIN_NAME" VARCHAR2(64 BYTE), "ERROR_MESSAGE" VARCHAR2(1024 BYTE), "STATUS" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_I18NPROPERTIES
--------------------------------------------------------

  CREATE TABLE "SA_I18NPROPERTIES" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(256 BYTE), "VALUE1" VARCHAR2(512 BYTE), "VALUE2" VARCHAR2(512 BYTE), "VALUE3" VARCHAR2(512 BYTE), "VALUE4" VARCHAR2(512 BYTE), "VALUE5" VARCHAR2(512 BYTE), "REMARK" VARCHAR2(1024 BYTE), "VERSION" NUMBER(*,0), "FOLDER_ID" VARCHAR2(32 BYTE), "RESOURCE_KIND" VARCHAR2(128 BYTE)) ;
 

   COMMENT ON COLUMN "SA_I18NPROPERTIES"."CODE" IS 'i18n 编码';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."VALUE1" IS '语言值1(如中文显示数据)';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."VALUE2" IS '语言值2(如英文显示数据)';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."VALUE3" IS '语言值3';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."VALUE4" IS '语言值4';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."VALUE5" IS '语言值5';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."FOLDER_ID" IS '类别';
 
   COMMENT ON COLUMN "SA_I18NPROPERTIES"."RESOURCE_KIND" IS '资源类型  数据字典i18nResourceKind';
 
   COMMENT ON TABLE "SA_I18NPROPERTIES"  IS '数据库数据国际化支持';
--------------------------------------------------------
--  DDL for Table SA_MACHINE
--------------------------------------------------------

  CREATE TABLE "SA_MACHINE" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(64 BYTE), "IP" VARCHAR2(64 BYTE), "MAC" VARCHAR2(64 BYTE), "SECURITY_GRADE" VARCHAR2(64 BYTE), "REMARK" VARCHAR2(256 BYTE), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_MESSAGE_REMIND
--------------------------------------------------------

  CREATE TABLE "SA_MESSAGE_REMIND" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "REMIND_TITLE" VARCHAR2(1024 BYTE), "REMIND_URL" VARCHAR2(1024 BYTE), "EXECUTE_FUNC" VARCHAR2(256 BYTE), "REPLACE_KIND" NUMBER(*,0), "OPEN_KIND" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."FOLDER_ID" IS '文件夹ID';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."REMIND_TITLE" IS '提示文本';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."REMIND_URL" IS '连接地址';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."EXECUTE_FUNC" IS '函数';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."REPLACE_KIND" IS '替换类别  0 顺序替换 1名称替换 2存在则显示';
 
   COMMENT ON COLUMN "SA_MESSAGE_REMIND"."OPEN_KIND" IS '页面打开方式 0 新窗口 1 弹出';
 
   COMMENT ON TABLE "SA_MESSAGE_REMIND"  IS '系统消息提醒配置表';
--------------------------------------------------------
--  DDL for Table SA_ONLINESESSION
--------------------------------------------------------

  CREATE TABLE "SA_ONLINESESSION" ("ID" VARCHAR2(36 BYTE), "ORGAN_ID" VARCHAR2(32 BYTE), "ORGAN_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(128 BYTE), "CLIENT_IP" VARCHAR2(64 BYTE), "SERVER_IP" VARCHAR2(64 BYTE), "LOGIN_DATE" DATE, "VERSION" NUMBER(*,0), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "SESSION_ID" VARCHAR2(36 BYTE), "LOGIN_NAME" VARCHAR2(64 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_OPAGENT
--------------------------------------------------------

  CREATE TABLE "SA_OPAGENT" ("ID" VARCHAR2(32 BYTE), "CLIENT_ID" VARCHAR2(65 BYTE), "AGENT_ID" VARCHAR2(65 BYTE), "START_DATE" DATE, "END_DATE" DATE, "STATUS" NUMBER(*,0), "PROC_AGENT_KIND_ID" NUMBER(*,0), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(256 BYTE), "CREATED_DATE" DATE, "CAN_TRAN_AGENT" NUMBER(*,0), "VERSION" NUMBER(*,0), "REMARK" VARCHAR2(1024 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPAGENT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPAGENT"."CLIENT_ID" IS '委托人ID';
 
   COMMENT ON COLUMN "SA_OPAGENT"."AGENT_ID" IS '代理人ID';
 
   COMMENT ON COLUMN "SA_OPAGENT"."START_DATE" IS '开始时间';
 
   COMMENT ON COLUMN "SA_OPAGENT"."END_DATE" IS '结束时间';
 
   COMMENT ON COLUMN "SA_OPAGENT"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPAGENT"."PROC_AGENT_KIND_ID" IS '代理方式ID';
 
   COMMENT ON COLUMN "SA_OPAGENT"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "SA_OPAGENT"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "SA_OPAGENT"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "SA_OPAGENT"."CAN_TRAN_AGENT" IS '是否允许把代理工作转交给其他人';
 
   COMMENT ON COLUMN "SA_OPAGENT"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPAGENT"."REMARK" IS '备注';
 
   COMMENT ON TABLE "SA_OPAGENT"  IS '代理';
--------------------------------------------------------
--  DDL for Table SA_OPAGENTPROC
--------------------------------------------------------

  CREATE TABLE "SA_OPAGENTPROC" ("ID" VARCHAR2(32 BYTE), "AGENT_ID" VARCHAR2(32 BYTE), "PROC_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_OPAUTHORIZE
--------------------------------------------------------

  CREATE TABLE "SA_OPAUTHORIZE" ("ORG_ID" VARCHAR2(65 BYTE), "ROLE_ID" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPAUTHORIZE"."ORG_ID" IS '组织机构ID';
 
   COMMENT ON COLUMN "SA_OPAUTHORIZE"."ROLE_ID" IS '角色ID';
 
   COMMENT ON TABLE "SA_OPAUTHORIZE"  IS '授权';
--------------------------------------------------------
--  DDL for Table SA_OPBASEFUNCTIONTYPE
--------------------------------------------------------

  CREATE TABLE "SA_OPBASEFUNCTIONTYPE" ("ID" NUMBER(*,0), "FOLDER_ID" NUMBER(*,0), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."ID" IS 'BaseFunctionTypeID';
 
   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."FOLDER_ID" IS '文件夹ID';
 
   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPBASEFUNCTIONTYPE"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPBASEFUNCTIONTYPE"  IS '基础职能角色
';
--------------------------------------------------------
--  DDL for Table SA_OPBASEMANAGEMENTTYPE
--------------------------------------------------------

  CREATE TABLE "SA_OPBASEMANAGEMENTTYPE" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "BIZ_MANAGEMENT_TYPE_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FOLDER_ID" VARCHAR2(32 BYTE), "REMARK" VARCHAR2(256 BYTE), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."BIZ_MANAGEMENT_TYPE_ID" IS '业务权限ID';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."FOLDER_ID" IS '目录ID';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_OPBASEMANAGEMENTTYPE"."STATUS" IS '状态';
 
   COMMENT ON TABLE "SA_OPBASEMANAGEMENTTYPE"  IS '管理权限类别';
--------------------------------------------------------
--  DDL for Table SA_OPBIZFUNCTION
--------------------------------------------------------

  CREATE TABLE "SA_OPBIZFUNCTION" ("ID" NUMBER(*,0), "ORG_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."ID" IS 'BizFunctionTypeId';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."ORG_ID" IS '组织ID';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTION"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPBIZFUNCTION"  IS '业务职能角色
';
--------------------------------------------------------
--  DDL for Table SA_OPBIZFUNCTIONOWNBASE
--------------------------------------------------------

  CREATE TABLE "SA_OPBIZFUNCTIONOWNBASE" ("ID" NUMBER(*,0), "BIZ_FUNCTION_ID" NUMBER(*,0), "BASE_FUNCTION_TYPE_ID" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBIZFUNCTIONOWNBASE"."ID" IS 'BizFunctionOwnBaseID';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTIONOWNBASE"."BIZ_FUNCTION_ID" IS 'BizFunctionTypeId';
 
   COMMENT ON COLUMN "SA_OPBIZFUNCTIONOWNBASE"."BASE_FUNCTION_TYPE_ID" IS 'BaseFunctionTypeID';
 
   COMMENT ON TABLE "SA_OPBIZFUNCTIONOWNBASE"  IS '业务职能角色对应基础职能';
--------------------------------------------------------
--  DDL for Table SA_OPBIZMANAGEMENT
--------------------------------------------------------

  CREATE TABLE "SA_OPBIZMANAGEMENT" ("ID" VARCHAR2(32 BYTE), "MANAGER_ID" VARCHAR2(65 BYTE), "MANAGE_TYPE_ID" VARCHAR2(32 BYTE), "SUBORDINATION_ID" VARCHAR2(65 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(64 BYTE), "CREATED_DATE" DATE, "LAST_MODIFIED_BY_ID" VARCHAR2(65 BYTE), "LAST_MODIFIED_BY_NAME" VARCHAR2(64 BYTE), "LAST_MODIFIED_DATE" DATE, "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."MANAGER_ID" IS '管理者ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."MANAGE_TYPE_ID" IS '业务权限类型ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."SUBORDINATION_ID" IS '下属ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENT"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPBIZMANAGEMENT"  IS '管理权限';
--------------------------------------------------------
--  DDL for Table SA_OPBIZMANAGEMENTTYPE
--------------------------------------------------------

  CREATE TABLE "SA_OPBIZMANAGEMENTTYPE" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "MANAGE_ORG_KIND_ID" VARCHAR2(64 BYTE), "MANAGE_ORG_KIND_NAME" VARCHAR2(512 BYTE), "KIND_ID" VARCHAR2(6 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "PARENT_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(512 BYTE), "NODE_KIND_ID" NUMBER(*,0), "REMARK" VARCHAR2(256 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."MANAGE_ORG_KIND_ID" IS '管理组织类别';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."MANAGE_ORG_KIND_NAME" IS '管理组织类别名称';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."KIND_ID" IS 'sys 系统 def 自定义';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."NODE_KIND_ID" IS '节点类别ID';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_OPBIZMANAGEMENTTYPE"."FULL_NAME" IS '名称全路径';
 
   COMMENT ON TABLE "SA_OPBIZMANAGEMENTTYPE"  IS '业务权限类别';
--------------------------------------------------------
--  DDL for Table SA_OPDATAKIND
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAKIND" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(32 BYTE), "NAME" VARCHAR2(64 BYTE), "DATA_KIND" VARCHAR2(32 BYTE), "DATA_SOURCE" VARCHAR2(256 BYTE), "REMARK" VARCHAR2(256 BYTE), "SEQUENCE" NUMBER, "STATUS" NUMBER, "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAKIND"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."DATA_KIND" IS '类型';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."DATA_SOURCE" IS '数据源';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."SEQUENCE" IS 'SEQUENCE';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."STATUS" IS 'status';
 
   COMMENT ON COLUMN "SA_OPDATAKIND"."VERSION" IS 'VERSION';
 
   COMMENT ON TABLE "SA_OPDATAKIND"  IS '数据管理权限维度定义';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGEBUSINESS
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGEBUSINESS" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(32 BYTE), "NAME" VARCHAR2(128 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "NODE_KIND_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER, "STATUS" NUMBER, "REMARK" VARCHAR2(256 BYTE), "DATA_MANAGE_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."PARENT_ID" IS '父ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."NODE_KIND_ID" IS '节点类型(分类，类型)';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."FULL_ID" IS 'full_id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."FULL_NAME" IS 'full_name';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."SEQUENCE" IS 'SEQUENCE';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."STATUS" IS 'status';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."REMARK" IS 'REMARK';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."DATA_MANAGE_ID" IS '数据管理权限ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS"."VERSION" IS 'version';
 
   COMMENT ON TABLE "SA_OPDATAMANAGEBUSINESS"  IS '数据管理权限业务类型';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGEBUSINESS_FIELD
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGEBUSINESS_FIELD" ("ID" VARCHAR2(32 BYTE), "DATAMANAGEBUSINESS_ID" VARCHAR2(32 BYTE), "IS_ORG_CONDITION" NUMBER(*,0), "DATA_KIND_NAME" VARCHAR2(32 BYTE), "DATA_KIND_CODE" VARCHAR2(128 BYTE), "TABLE_COLUMN" VARCHAR2(32 BYTE), "COLUMN_DATA_TYPE" VARCHAR2(64 BYTE), "COLUMN_SYMBOL" VARCHAR2(32 BYTE), "TABLE_ALIAS" VARCHAR2(32 BYTE), "FORMULA" VARCHAR2(256 BYTE), "DATA_KIND" VARCHAR2(32 BYTE), "MANAGE_TYPE" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER, "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."DATAMANAGEBUSINESS_ID" IS '数据管理权限业务类型ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."IS_ORG_CONDITION" IS '特殊组织条件';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."DATA_KIND_NAME" IS '资源维度名称';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."DATA_KIND_CODE" IS '资源维度编码';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."TABLE_COLUMN" IS 'column';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."COLUMN_DATA_TYPE" IS 'type';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."COLUMN_SYMBOL" IS 'symbol';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."TABLE_ALIAS" IS 'alias';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."FORMULA" IS 'Formula';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."DATA_KIND" IS '类型';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."MANAGE_TYPE" IS '数据管理权限编码';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."SEQUENCE" IS 'SEQUENCE';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEBUSINESS_FIELD"."VERSION" IS 'version';
 
   COMMENT ON TABLE "SA_OPDATAMANAGEBUSINESS_FIELD"  IS '数据管理权限业务过滤字段定义';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGEDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGEDETAIL" ("ID" VARCHAR2(32 BYTE), "DATA_MANAGE_ID" VARCHAR2(32 BYTE), "NAME" VARCHAR2(128 BYTE), "REMARK" VARCHAR2(256 BYTE), "SEQUENCE" NUMBER, "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."DATA_MANAGE_ID" IS '数据管理权限类别';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."SEQUENCE" IS 'SEQUENCE';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAIL"."VERSION" IS 'version';
 
   COMMENT ON TABLE "SA_OPDATAMANAGEDETAIL"  IS '数据管理权限取值定义';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGEDETAILRESOURCE
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGEDETAILRESOURCE" ("ID" VARCHAR2(32 BYTE), "DATA_MANAGEDETAL_ID" VARCHAR2(32 BYTE), "DATA_KIND_ID" VARCHAR2(32 BYTE), "DATA_KIND" VARCHAR2(32 BYTE), "RESOURCE_KEY" VARCHAR2(128 BYTE), "RESOURCE_VALUE" VARCHAR2(128 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(1024 BYTE), "VERSION" NUMBER, "ORG_DATA_KIND" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."DATA_MANAGEDETAL_ID" IS '数据取值定义ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."DATA_KIND_ID" IS '资源维度ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."DATA_KIND" IS '资源类型';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."RESOURCE_KEY" IS '资源KEY';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."RESOURCE_VALUE" IS '资源值';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."FULL_ID" IS 'full_id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."FULL_NAME" IS 'full_name';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."VERSION" IS 'version';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEDETAILRESOURCE"."ORG_DATA_KIND" IS '组织权限类型';
 
   COMMENT ON TABLE "SA_OPDATAMANAGEDETAILRESOURCE"  IS '数据管理权限包含维度资源';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGEMENT
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGEMENT" ("ID" VARCHAR2(32 BYTE), "DATA_MANAGE_ID" VARCHAR2(32 BYTE), "DATA_MANAGEDETAL_ID" VARCHAR2(32 BYTE), "MANAGER_ID" VARCHAR2(65 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(64 BYTE), "CREATED_DATE" DATE, "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."DATA_MANAGE_ID" IS '数据管理权限类别';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."DATA_MANAGEDETAL_ID" IS '数据取值定义ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."MANAGER_ID" IS '管理者ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGEMENT"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPDATAMANAGEMENT"  IS '数据管理权限授权';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGETYPE
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGETYPE" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(32 BYTE), "NAME" VARCHAR2(64 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "NODE_KIND_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER, "VERSION" NUMBER, "REMARK" VARCHAR2(256 BYTE), "STATUS" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."PARENT_ID" IS '父ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."NODE_KIND_ID" IS '节点类型(分类，数据权限)';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."FULL_ID" IS 'full_id';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."FULL_NAME" IS 'full_name';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."SEQUENCE" IS 'SEQUENCE';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."VERSION" IS 'version';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."REMARK" IS 'REMARK';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPE"."STATUS" IS 'status';
 
   COMMENT ON TABLE "SA_OPDATAMANAGETYPE"  IS '数据管理权限类型';
--------------------------------------------------------
--  DDL for Table SA_OPDATAMANAGETYPEKIND
--------------------------------------------------------

  CREATE TABLE "SA_OPDATAMANAGETYPEKIND" ("ID" VARCHAR2(32 BYTE), "DATA_MANAGE_ID" VARCHAR2(32 BYTE), "DATA_KIND_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_OPDATAMANAGETYPEKIND"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPEKIND"."DATA_MANAGE_ID" IS '数据管理权限类别';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPEKIND"."DATA_KIND_ID" IS '资源维度ID';
 
   COMMENT ON COLUMN "SA_OPDATAMANAGETYPEKIND"."VERSION" IS 'version';
 
   COMMENT ON TABLE "SA_OPDATAMANAGETYPEKIND"  IS '数据管理权限包含维度明细';
--------------------------------------------------------
--  DDL for Table SA_OPERATIONLOG
--------------------------------------------------------

  CREATE TABLE "SA_OPERATIONLOG" ("ID" VARCHAR2(32 BYTE), "APP_ID" VARCHAR2(32 BYTE), "APP_CODE" VARCHAR2(64 BYTE), "APP_NAME" VARCHAR2(256 BYTE), "ORGAN_ID" VARCHAR2(32 BYTE), "ORGAN_NAME" VARCHAR2(128 BYTE), "ROLE_KIND_ID" VARCHAR2(32 BYTE), "ROLE_KIND_NAME" VARCHAR2(64 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(128 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "BEGIN_DATE" DATE, "END_DATE" DATE, "IP" VARCHAR2(64 BYTE), "MAC" VARCHAR2(64 BYTE), "CLASS_NAME" VARCHAR2(256 BYTE), "METHOD_NAME" VARCHAR2(256 BYTE), "LOG_TYPE" VARCHAR2(64 BYTE), "OPERATE_NAME" VARCHAR2(512 BYTE), "STATUS_ID" NUMBER(*,0), "STATUS_NAME" VARCHAR2(64 BYTE), "PERSON_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "RESOURCE_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "MACHINE_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "PERSON_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "RESOURCE_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "MACHINE_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0), "DESCRIPTION" VARCHAR2(2048 BYTE))  PARTITION BY RANGE ("BEGIN_DATE") INTERVAL (NUMTODSINTERVAL(5,'DAY')) (PARTITION "TEST_P_P1"  VALUES LESS THAN (TO_DATE(' 2017-10-08 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) ) ;
 

   COMMENT ON TABLE "SA_OPERATIONLOG"  IS '操作日志';
--------------------------------------------------------
--  DDL for Table SA_OPERATIONLOGDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_OPERATIONLOGDETAIL" ("ID" VARCHAR2(32 BYTE), "OPERATIONLOG_ID" VARCHAR2(32 BYTE), "PARAMS" CLOB, "ERROR_MESSAGE" CLOB, "DESCRIPTION" CLOB, "BEFORE_IMAGE" CLOB, "AFTER_IMAGE" CLOB, "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON TABLE "SA_OPERATIONLOGDETAIL"  IS '日志明细';
--------------------------------------------------------
--  DDL for Table SA_OPERATIONLOG_BAK
--------------------------------------------------------

  CREATE TABLE "SA_OPERATIONLOG_BAK" ("ID" VARCHAR2(32 BYTE), "APP_ID" VARCHAR2(32 BYTE), "APP_CODE" VARCHAR2(64 BYTE), "APP_NAME" VARCHAR2(256 BYTE), "ORGAN_ID" VARCHAR2(32 BYTE), "ORGAN_NAME" VARCHAR2(128 BYTE), "ROLE_KIND_ID" VARCHAR2(32 BYTE), "ROLE_KIND_NAME" VARCHAR2(64 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(128 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "BEGIN_DATE" DATE, "END_DATE" DATE, "IP" VARCHAR2(64 BYTE), "MAC" VARCHAR2(64 BYTE), "CLASS_NAME" VARCHAR2(256 BYTE), "METHOD_NAME" VARCHAR2(256 BYTE), "LOG_TYPE" VARCHAR2(64 BYTE), "OPERATE_NAME" VARCHAR2(512 BYTE), "STATUS_ID" NUMBER(*,0), "STATUS_NAME" VARCHAR2(64 BYTE), "PERSON_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "RESOURCE_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "MACHINE_SECURITY_LEVEL_NAME" VARCHAR2(64 BYTE), "PERSON_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "RESOURCE_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "MACHINE_SECURITY_LEVEL_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON TABLE "SA_OPERATIONLOG_BAK"  IS '操作日志';
--------------------------------------------------------
--  DDL for Table SA_OPFUNCTION
--------------------------------------------------------

  CREATE TABLE "SA_OPFUNCTION" ("ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "NODE_KIND_ID" VARCHAR2(6 BYTE), "KEY_CODE" NUMBER(*,0), "URL" VARCHAR2(256 BYTE), "ICON" VARCHAR2(512 BYTE), "REMARK" VARCHAR2(512 BYTE), "DEPTH" NUMBER(*,0), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "DESCRIPTION" VARCHAR2(256 BYTE), "OPERATION_MAP_ID" NUMBER(*,0), "FULL_ID" VARCHAR2(1024 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPFUNCTION"."ID" IS '功能ID';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."FULL_NAME" IS '全名称';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."NODE_KIND_ID" IS 'node 节点 left 叶子 ';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."KEY_CODE" IS '快捷键码';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."URL" IS '路径';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."ICON" IS '图标';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."DEPTH" IS '深度';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "SA_OPFUNCTION"."OPERATION_MAP_ID" IS '管理业务导图ID';
 
   COMMENT ON TABLE "SA_OPFUNCTION"  IS '功能';
--------------------------------------------------------
--  DDL for Table SA_OPFUNCTION_FIELD_GROUP
--------------------------------------------------------

  CREATE TABLE "SA_OPFUNCTION_FIELD_GROUP" ("FUNCTION_FIELD_GROUP_ID" NUMBER(*,0), "FUNCTION_ID" NUMBER(*,0), "NAME" VARCHAR2(64 BYTE), "CODE" VARCHAR2(64 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPFUNCTION_FIELD_GROUP"."FUNCTION_FIELD_GROUP_ID" IS 'function_field_group_id';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_FIELD_GROUP"."FUNCTION_ID" IS '功能ID';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_FIELD_GROUP"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_FIELD_GROUP"."CODE" IS '编码';
 
   COMMENT ON TABLE "SA_OPFUNCTION_FIELD_GROUP"  IS '功能字段权限设置表';
--------------------------------------------------------
--  DDL for Table SA_OPFUNCTION_PERMISSIONFIELD
--------------------------------------------------------

  CREATE TABLE "SA_OPFUNCTION_PERMISSIONFIELD" ("PERMISSION_FIELD_ID" NUMBER(*,0), "FUNCTION_FIELD_GROUP_ID" NUMBER(*,0), "FIELD_NAME" VARCHAR2(128 BYTE), "FIELD_CODE" VARCHAR2(128 BYTE), "FIELD_TYPE" NUMBER(1,0), "FIELD_AUTHORITY" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."PERMISSION_FIELD_ID" IS 'Permission_field_id';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."FUNCTION_FIELD_GROUP_ID" IS 'function_field_group_id';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."FIELD_NAME" IS '字段名称';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."FIELD_CODE" IS '字段编码';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."FIELD_TYPE" IS '字段类型';
 
   COMMENT ON COLUMN "SA_OPFUNCTION_PERMISSIONFIELD"."FIELD_AUTHORITY" IS '权限';
 
   COMMENT ON TABLE "SA_OPFUNCTION_PERMISSIONFIELD"  IS '功能字段权限对应表';
--------------------------------------------------------
--  DDL for Table SA_OPOPERATION
--------------------------------------------------------

  CREATE TABLE "SA_OPOPERATION" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "IS_COMMON" NUMBER(*,0), "RESOURCE_KIND_ID" VARCHAR2(32 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_OPORG
--------------------------------------------------------

  CREATE TABLE "SA_OPORG" ("ID" VARCHAR2(65 BYTE), "TYPE_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(360 BYTE), "NAME" VARCHAR2(360 BYTE), "LONG_NAME" VARCHAR2(2048 BYTE), "PARENT_ID" VARCHAR2(65 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_CODE" VARCHAR2(2048 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "ORG_KIND_ID" VARCHAR2(5 BYTE), "DEPTH" NUMBER(*,0), "PERSON_ID" VARCHAR2(32 BYTE), "NODE_KIND_ID" VARCHAR2(6 BYTE), "DESCRIPTION" VARCHAR2(512 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "ORG_CODE" VARCHAR2(360 BYTE), "DEPT_CODE" VARCHAR2(360 BYTE), "POSITION_CODE" VARCHAR2(360 BYTE), "PERSON_MEMBER_CODE" VARCHAR2(360 BYTE), "IS_CENTER" NUMBER(*,0), "CENTER_CODE" VARCHAR2(64 BYTE), "ORG_ID" VARCHAR2(32 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "PERSON_MEMBER_ID" VARCHAR2(65 BYTE), "CENTER_ID" VARCHAR2(32 BYTE), "ORG_NAME" VARCHAR2(128 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "PERSON_MEMBER_NAME" VARCHAR2(128 BYTE), "CENTER_NAME" VARCHAR2(128 BYTE), "FULL_SEQUENCE" VARCHAR2(256 BYTE), "FULL_ORG_KIND_ID" VARCHAR2(128 BYTE), "IS_VIRTUAL" NUMBER(*,0), "DEPT_LEVEL" VARCHAR2(64 BYTE), "TENANT_ID" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPORG"."ID" IS '组织ID';
 
   COMMENT ON COLUMN "SA_OPORG"."TYPE_ID" IS '组织类型ID';
 
   COMMENT ON COLUMN "SA_OPORG"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPORG"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPORG"."LONG_NAME" IS '长名称';
 
   COMMENT ON COLUMN "SA_OPORG"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "SA_OPORG"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_OPORG"."FULL_CODE" IS '编码全路径';
 
   COMMENT ON COLUMN "SA_OPORG"."FULL_NAME" IS '全名称';
 
   COMMENT ON COLUMN "SA_OPORG"."ORG_KIND_ID" IS 'ogn 机构 dpt 部门 pos 岗位 psm 人员成员';
 
   COMMENT ON COLUMN "SA_OPORG"."DEPTH" IS '深度';
 
   COMMENT ON COLUMN "SA_OPORG"."PERSON_ID" IS '人员ID';
 
   COMMENT ON COLUMN "SA_OPORG"."NODE_KIND_ID" IS 'node 节点 leaf 叶子 ';
 
   COMMENT ON COLUMN "SA_OPORG"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "SA_OPORG"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPORG"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPORG"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPORG"."ORG_CODE" IS '公司编码';
 
   COMMENT ON COLUMN "SA_OPORG"."DEPT_CODE" IS '部门编码';
 
   COMMENT ON COLUMN "SA_OPORG"."POSITION_CODE" IS '岗位编码';
 
   COMMENT ON COLUMN "SA_OPORG"."PERSON_MEMBER_CODE" IS '人员成员编码';
 
   COMMENT ON COLUMN "SA_OPORG"."IS_CENTER" IS '是否中心';
 
   COMMENT ON COLUMN "SA_OPORG"."CENTER_CODE" IS '中心编码';
 
   COMMENT ON COLUMN "SA_OPORG"."ORG_ID" IS '公司名称';
 
   COMMENT ON COLUMN "SA_OPORG"."DEPT_ID" IS '部门名称';
 
   COMMENT ON COLUMN "SA_OPORG"."POSITION_ID" IS '岗位ID';
 
   COMMENT ON COLUMN "SA_OPORG"."PERSON_MEMBER_ID" IS '人员成员ID';
 
   COMMENT ON COLUMN "SA_OPORG"."CENTER_ID" IS '中心ID';
 
   COMMENT ON COLUMN "SA_OPORG"."ORG_NAME" IS '公司名称';
 
   COMMENT ON COLUMN "SA_OPORG"."DEPT_NAME" IS '部门名称';
 
   COMMENT ON COLUMN "SA_OPORG"."POSITION_NAME" IS '岗位名称';
 
   COMMENT ON COLUMN "SA_OPORG"."PERSON_MEMBER_NAME" IS '人员成员名称';
 
   COMMENT ON COLUMN "SA_OPORG"."CENTER_NAME" IS '中心名称';
 
   COMMENT ON COLUMN "SA_OPORG"."FULL_SEQUENCE" IS '排序号全路径';
 
   COMMENT ON COLUMN "SA_OPORG"."IS_VIRTUAL" IS '是否虚拟组织';
 
   COMMENT ON COLUMN "SA_OPORG"."DEPT_LEVEL" IS '部门级别';
 
   COMMENT ON COLUMN "SA_OPORG"."TENANT_ID" IS '租户ID';
 
   COMMENT ON TABLE "SA_OPORG"  IS '组织';
--------------------------------------------------------
--  DDL for Table SA_OPORGPROPERTY
--------------------------------------------------------

  CREATE TABLE "SA_OPORGPROPERTY" ("ID" VARCHAR2(32 BYTE), "ORG_ID" VARCHAR2(65 BYTE), "PROPERTY_DEFINITION_ID" VARCHAR2(32 BYTE), "PROPERTY_VALUE" VARCHAR2(64 BYTE), "PROPERTY_DISPLAY" VARCHAR2(128 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPORGPROPERTY"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPORGPROPERTY"."ORG_ID" IS '机构ID';
 
   COMMENT ON COLUMN "SA_OPORGPROPERTY"."PROPERTY_DEFINITION_ID" IS '属性定义ID';
 
   COMMENT ON COLUMN "SA_OPORGPROPERTY"."PROPERTY_VALUE" IS '属性值';
 
   COMMENT ON COLUMN "SA_OPORGPROPERTY"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPORGPROPERTY"  IS '组织机构属性';
--------------------------------------------------------
--  DDL for Table SA_OPORGPROPERTYDEFINITION
--------------------------------------------------------

  CREATE TABLE "SA_OPORGPROPERTYDEFINITION" ("ID" VARCHAR2(32 BYTE), "ORG_KIND_ID" VARCHAR2(6 BYTE), "NAME" VARCHAR2(64 BYTE), "DESCRIPTION" VARCHAR2(128 BYTE), "DATA_SOURCE" VARCHAR2(1024 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_OPORGROLEAUTHORIZE
--------------------------------------------------------

  CREATE TABLE "SA_OPORGROLEAUTHORIZE" ("ID" NUMBER(*,0), "ORG_ID" VARCHAR2(65 BYTE), "ROLE_KIND_ID" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPORGROLEAUTHORIZE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPORGROLEAUTHORIZE"."ORG_ID" IS '组织ID';
 
   COMMENT ON COLUMN "SA_OPORGROLEAUTHORIZE"."ROLE_KIND_ID" IS '角色类别ID';
 
   COMMENT ON COLUMN "SA_OPORGROLEAUTHORIZE"."VERSION" IS '版本号';
--------------------------------------------------------
--  DDL for Table SA_OPORGTEMPLATE
--------------------------------------------------------

  CREATE TABLE "SA_OPORGTEMPLATE" ("ID" VARCHAR2(32 BYTE), "TYPE_ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."TYPE_ID" IS '组织类型ID';
 
   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPORGTEMPLATE"."STATUS" IS '状态';
 
   COMMENT ON TABLE "SA_OPORGTEMPLATE"  IS '组织机构模板';
--------------------------------------------------------
--  DDL for Table SA_OPORGTYPE
--------------------------------------------------------

  CREATE TABLE "SA_OPORGTYPE" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "ORG_KIND_ID" VARCHAR2(5 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPORGTYPE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."FOLDER_ID" IS '文件夹ID';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."ORG_KIND_ID" IS 'ogn 机构 dpt 部门 pos 岗位';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPORGTYPE"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPORGTYPE"  IS '组织机构类型';
--------------------------------------------------------
--  DDL for Table SA_OPPERMISSION
--------------------------------------------------------

  CREATE TABLE "SA_OPPERMISSION" ("ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "RESOURCE_KIND_ID" VARCHAR2(32 BYTE), "RESOURCE_ID" VARCHAR2(32 BYTE), "OPERATION_ID" VARCHAR2(32 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "NODE_KIND_ID" VARCHAR2(32 BYTE), "REMARK" VARCHAR2(256 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPPERMISSION"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."PARENT_ID" IS '父ID';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."FULL_NAME" IS '名称全路径';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."RESOURCE_KIND_ID" IS '资源类型ID';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."RESOURCE_ID" IS '资源ID';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."OPERATION_ID" IS '操作ID';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."STATUS" IS '状态';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPPERMISSION"."REMARK" IS '备注';
--------------------------------------------------------
--  DDL for Table SA_OPPERSON
--------------------------------------------------------

  CREATE TABLE "SA_OPPERSON" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "LOGIN_NAME" VARCHAR2(64 BYTE), "PASSWORD" VARCHAR2(128 BYTE), "PASSWORD_TIME_LIMIT" NUMBER(*,0), "PASSWORD_MODIFY_TIME" DATE, "MAIN_ORG_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "STATUS" NUMBER(*,0), "DESCRIPTION" VARCHAR2(512 BYTE), "SEX" VARCHAR2(12 BYTE), "BIRTHDAY" DATE, "JOIN_DATE" DATE, "HOME_PLACE" VARCHAR2(128 BYTE), "DEGREE" VARCHAR2(64 BYTE), "GRADUATE_SCHOOL" VARCHAR2(256 BYTE), "SPECIALITY" VARCHAR2(256 BYTE), "SCHOOL_LENGTH" VARCHAR2(64 BYTE), "TITLE" VARCHAR2(128 BYTE), "MARRIAGE" VARCHAR2(12 BYTE), "CERTIFICATE_NO" VARCHAR2(128 BYTE), "CERTIFICATE_KIND_ID" VARCHAR2(64 BYTE), "FAMILY_ADDRESS" VARCHAR2(512 BYTE), "ZIP" VARCHAR2(32 BYTE), "MSN" VARCHAR2(64 BYTE), "QQ" VARCHAR2(64 BYTE), "EMAIL" VARCHAR2(128 BYTE), "MOBILE_PHONE" VARCHAR2(128 BYTE), "FAMILY_PHONE" VARCHAR2(64 BYTE), "OFFICE_PHONE" VARCHAR2(128 BYTE), "VERSION" NUMBER(*,0), "PHOTO_FILE_ID" NUMBER(*,0), "COUNTRY" VARCHAR2(128 BYTE), "PROVINCE" VARCHAR2(128 BYTE), "CITY" VARCHAR2(128 BYTE), "ENGLISH_NAME" VARCHAR2(256 BYTE), "PAY_PASSWORD" VARCHAR2(128 BYTE), "IS_OPERATOR" NUMBER(*,0), "IS_HIDDEN" NUMBER(*,0), "WEIXIN" VARCHAR2(64 BYTE), "NUM" NUMBER(*,0), "SECURITY_GRADE_ID" VARCHAR2(32 BYTE), "PERSON_SECURITY_GRADE_ID" VARCHAR2(32 BYTE), "CA_STATUS" NUMBER(*,0), "CA_NO" VARCHAR2(64 BYTE), "TENANT_ID" VARCHAR2(32 BYTE), "PERSON_KIND" VARCHAR2(64 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPPERSON"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPPERSON"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPPERSON"."LOGIN_NAME" IS '登录名';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PASSWORD" IS '密码';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PASSWORD_TIME_LIMIT" IS '密码时限';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PASSWORD_MODIFY_TIME" IS '密码修改时间';
 
   COMMENT ON COLUMN "SA_OPPERSON"."MAIN_ORG_ID" IS '所属部门';
 
   COMMENT ON COLUMN "SA_OPPERSON"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPPERSON"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPPERSON"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "SA_OPPERSON"."SEX" IS '性别';
 
   COMMENT ON COLUMN "SA_OPPERSON"."BIRTHDAY" IS '出生日期';
 
   COMMENT ON COLUMN "SA_OPPERSON"."JOIN_DATE" IS '参加工作日期';
 
   COMMENT ON COLUMN "SA_OPPERSON"."HOME_PLACE" IS '出生地';
 
   COMMENT ON COLUMN "SA_OPPERSON"."DEGREE" IS '学历';
 
   COMMENT ON COLUMN "SA_OPPERSON"."GRADUATE_SCHOOL" IS '毕业院校';
 
   COMMENT ON COLUMN "SA_OPPERSON"."SPECIALITY" IS '专业';
 
   COMMENT ON COLUMN "SA_OPPERSON"."SCHOOL_LENGTH" IS '学年制';
 
   COMMENT ON COLUMN "SA_OPPERSON"."TITLE" IS '职称';
 
   COMMENT ON COLUMN "SA_OPPERSON"."MARRIAGE" IS '婚姻状况';
 
   COMMENT ON COLUMN "SA_OPPERSON"."CERTIFICATE_NO" IS '证件号码';
 
   COMMENT ON COLUMN "SA_OPPERSON"."CERTIFICATE_KIND_ID" IS '证件类型';
 
   COMMENT ON COLUMN "SA_OPPERSON"."FAMILY_ADDRESS" IS '家庭住址';
 
   COMMENT ON COLUMN "SA_OPPERSON"."ZIP" IS '邮编';
 
   COMMENT ON COLUMN "SA_OPPERSON"."MSN" IS 'Msn';
 
   COMMENT ON COLUMN "SA_OPPERSON"."QQ" IS 'QQ';
 
   COMMENT ON COLUMN "SA_OPPERSON"."EMAIL" IS '电子邮件';
 
   COMMENT ON COLUMN "SA_OPPERSON"."MOBILE_PHONE" IS '移动电话';
 
   COMMENT ON COLUMN "SA_OPPERSON"."FAMILY_PHONE" IS '家庭电话';
 
   COMMENT ON COLUMN "SA_OPPERSON"."OFFICE_PHONE" IS '办公电话';
 
   COMMENT ON COLUMN "SA_OPPERSON"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PHOTO_FILE_ID" IS '照片';
 
   COMMENT ON COLUMN "SA_OPPERSON"."COUNTRY" IS '国家';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PROVINCE" IS '省';
 
   COMMENT ON COLUMN "SA_OPPERSON"."CITY" IS '市';
 
   COMMENT ON COLUMN "SA_OPPERSON"."ENGLISH_NAME" IS '英文名称';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PAY_PASSWORD" IS '薪资密码';
 
   COMMENT ON COLUMN "SA_OPPERSON"."IS_OPERATOR" IS '是否操作员';
 
   COMMENT ON COLUMN "SA_OPPERSON"."IS_HIDDEN" IS '是否隐藏';
 
   COMMENT ON COLUMN "SA_OPPERSON"."WEIXIN" IS '微信';
 
   COMMENT ON COLUMN "SA_OPPERSON"."SECURITY_GRADE_ID" IS '密级';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PERSON_SECURITY_GRADE_ID" IS '人员涉密登记';
 
   COMMENT ON COLUMN "SA_OPPERSON"."TENANT_ID" IS '租户ID';
 
   COMMENT ON COLUMN "SA_OPPERSON"."PERSON_KIND" IS '人员类别';
 
   COMMENT ON TABLE "SA_OPPERSON"  IS '人员';
--------------------------------------------------------
--  DDL for Table SA_OPREMIND
--------------------------------------------------------

  CREATE TABLE "SA_OPREMIND" ("ID" VARCHAR2(32 BYTE), "ROLE_ID" VARCHAR2(32 BYTE), "REMIND_ID" VARCHAR2(32 BYTE)) ;
 

   COMMENT ON TABLE "SA_OPREMIND"  IS '角色提醒授权';
--------------------------------------------------------
--  DDL for Table SA_OPROLE
--------------------------------------------------------

  CREATE TABLE "SA_OPROLE" ("ID" VARCHAR2(32 BYTE), "ROLE_KIND_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "DESCRIPTION" VARCHAR2(512 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "TENANT_ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "NODE_KIND_ID" NUMBER(*,0), "FOLDER_ID" VARCHAR2(32 BYTE), "ROLE_PERSON_KIND" VARCHAR2(64 BYTE)) ;
 

   COMMENT ON COLUMN "SA_OPROLE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_OPROLE"."ROLE_KIND_ID" IS 'fn 功能 data 数据';
 
   COMMENT ON COLUMN "SA_OPROLE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPROLE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPROLE"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "SA_OPROLE"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "SA_OPROLE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "SA_OPROLE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPROLE"."TENANT_ID" IS '租户ID';
 
   COMMENT ON COLUMN "SA_OPROLE"."PARENT_ID" IS '父ID';
 
   COMMENT ON COLUMN "SA_OPROLE"."FULL_ID" IS 'ID全路径';
 
   COMMENT ON COLUMN "SA_OPROLE"."FULL_NAME" IS '名称全路径';
 
   COMMENT ON COLUMN "SA_OPROLE"."NODE_KIND_ID" IS '节点类型';
 
   COMMENT ON COLUMN "SA_OPROLE"."ROLE_PERSON_KIND" IS '人员类别';
 
   COMMENT ON TABLE "SA_OPROLE"  IS '角色';
--------------------------------------------------------
--  DDL for Table SA_OPROLEPERMISSION
--------------------------------------------------------

  CREATE TABLE "SA_OPROLEPERMISSION" ("ID" VARCHAR2(32 BYTE), "ROLE_ID" VARCHAR2(32 BYTE), "PERMISSION_ID" VARCHAR2(32 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_DATE" DATE, "CREATED_BY_NAME" VARCHAR2(64 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPROLEPERMISSION"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "SA_OPROLEPERMISSION"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "SA_OPROLEPERMISSION"."CREATED_BY_NAME" IS '创建人';
 
   COMMENT ON COLUMN "SA_OPROLEPERMISSION"."VERSION" IS '版本号';
--------------------------------------------------------
--  DDL for Table SA_OPTENANT
--------------------------------------------------------

  CREATE TABLE "SA_OPTENANT" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(256 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "INDUSTRY_ORG_ID" VARCHAR2(32 BYTE), "DESCRIPTION" VARCHAR2(1024 BYTE), "CONTACTS" VARCHAR2(256 BYTE), "CONTACT_NUMBER" VARCHAR2(512 BYTE), "STATUS" NUMBER(*,0), "ORG_ID" VARCHAR2(32 BYTE), "ROOT_FULL_ID" VARCHAR2(1024 BYTE), "VERSION" NUMBER, "IS_INDUSTRY" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_OPUIELEMENT
--------------------------------------------------------

  CREATE TABLE "SA_OPUIELEMENT" ("ID" VARCHAR2(32 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "KIND_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(128 BYTE), "DEFAULT_OPERATION_ID" VARCHAR2(32 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPUIELEMENT"."FOLDER_ID" IS '文件夹ID';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."DEFAULT_OPERATION_ID" IS '默认操作';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."STATUS" IS '状态';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."SEQUENCE" IS '序列号';
 
   COMMENT ON COLUMN "SA_OPUIELEMENT"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_OPUIELEMENT"  IS '界面元素';
--------------------------------------------------------
--  DDL for Table SA_OPUIELEMENTPERMISSION
--------------------------------------------------------

  CREATE TABLE "SA_OPUIELEMENTPERMISSION" ("ID" VARCHAR2(32 BYTE), "PERMISSION_ID" VARCHAR2(32 BYTE), "RESOURCE_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(128 BYTE), "KIND_ID" VARCHAR2(32 BYTE), "OPERATION_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."PERMISSION_ID" IS '权限ID';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."RESOURCE_ID" IS '资源ID';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."KIND_ID" IS '类别';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."OPERATION_ID" IS '操作ID';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_OPUIELEMENTPERMISSION"."SEQUENCE" IS '排序号';
 
   COMMENT ON TABLE "SA_OPUIELEMENTPERMISSION"  IS '界面元素权限';
--------------------------------------------------------
--  DDL for Table SA_ORGFUN
--------------------------------------------------------

  CREATE TABLE "SA_ORGFUN" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(128 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "IS_LAST" NUMBER, "REMARK" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER(*,0), "STATUS" NUMBER(*,0), "VERSION" NUMBER) ;
 

   COMMENT ON COLUMN "SA_ORGFUN"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_ORGFUN"."CODE" IS 'code';
 
   COMMENT ON COLUMN "SA_ORGFUN"."NAME" IS 'name';
 
   COMMENT ON COLUMN "SA_ORGFUN"."PARENT_ID" IS 'parent_id';
 
   COMMENT ON COLUMN "SA_ORGFUN"."IS_LAST" IS 'is_last';
 
   COMMENT ON COLUMN "SA_ORGFUN"."REMARK" IS 'remark';
 
   COMMENT ON COLUMN "SA_ORGFUN"."SEQUENCE" IS 'sequence';
 
   COMMENT ON COLUMN "SA_ORGFUN"."STATUS" IS 'status';
 
   COMMENT ON COLUMN "SA_ORGFUN"."VERSION" IS 'version';
 
   COMMENT ON TABLE "SA_ORGFUN"  IS '系统可用组织机构函数';
--------------------------------------------------------
--  DDL for Table SA_PARAMETER
--------------------------------------------------------

  CREATE TABLE "SA_PARAMETER" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(128 BYTE), "VALUE" VARCHAR2(2048 BYTE), "REMARK" VARCHAR2(1024 BYTE), "VERSION" NUMBER(*,0), "FOLDER_ID" VARCHAR2(32 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_PARAMETER"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_PARAMETER"."CODE" IS '参数编码';
 
   COMMENT ON COLUMN "SA_PARAMETER"."NAME" IS '参数名称';
 
   COMMENT ON COLUMN "SA_PARAMETER"."VALUE" IS '参数值';
 
   COMMENT ON COLUMN "SA_PARAMETER"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_PARAMETER"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_PARAMETER"."FOLDER_ID" IS '父编码';
 
   COMMENT ON COLUMN "SA_PARAMETER"."STATUS" IS '状态';
 
   COMMENT ON TABLE "SA_PARAMETER"  IS '系统参数';
--------------------------------------------------------
--  DDL for Table SA_PDSCREEN
--------------------------------------------------------

  CREATE TABLE "SA_PDSCREEN" ("ID" VARCHAR2(32 BYTE), "PERSON_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON TABLE "SA_PDSCREEN"  IS '用户桌面分屏设置';
--------------------------------------------------------
--  DDL for Table SA_PDSCREENFUNCTION
--------------------------------------------------------

  CREATE TABLE "SA_PDSCREENFUNCTION" ("ID" VARCHAR2(32 BYTE), "SCREEN_ID" VARCHAR2(32 BYTE), "FUNCTION_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_PDSCREENFUNCTION"."ID" IS 'id';
 
   COMMENT ON COLUMN "SA_PDSCREENFUNCTION"."SCREEN_ID" IS '分屏ID';
 
   COMMENT ON COLUMN "SA_PDSCREENFUNCTION"."FUNCTION_ID" IS '功能ID';
 
   COMMENT ON COLUMN "SA_PDSCREENFUNCTION"."SEQUENCE" IS '排序号';
 
   COMMENT ON TABLE "SA_PDSCREENFUNCTION"  IS '用户分屏应用记录表';
--------------------------------------------------------
--  DDL for Table SA_PERSONACCOUNTMANAGEMENT
--------------------------------------------------------

  CREATE TABLE "SA_PERSONACCOUNTMANAGEMENT" ("ID" VARCHAR2(32 BYTE), "LOGIN_NAME" VARCHAR2(64 BYTE), "STATUS" NUMBER(*,0), "LOCKED_DATE" DATE, "LAST_LOGIN_DATE" DATE, "LAST_MODIFIED_PASSWORD_DATE" DATE, "VERSION" NUMBER(*,0), "FULL_ID" VARCHAR2(1024 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_PERSONCALENDAR
--------------------------------------------------------

  CREATE TABLE "SA_PERSONCALENDAR" ("ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0), "SUBJECT" VARCHAR2(256 BYTE), "START_TIME" DATE, "END_TIME" DATE, "IS_ALLDAYEVENT" NUMBER(*,0), "PERSON_ID" VARCHAR2(32 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(128 BYTE), "CREATED_DATE" DATE, "LAST_MODIFIED_BY_ID" VARCHAR2(65 BYTE), "LAST_MODIFIED_BY_NAME" VARCHAR2(128 BYTE), "LAST_MODIFIED_DATE" DATE, "BUSINESS_ID" VARCHAR2(32 BYTE), "LINK_BILL_URL" VARCHAR2(256 BYTE)) ;
 

   COMMENT ON COLUMN "SA_PERSONCALENDAR"."ID" IS '主键';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."SUBJECT" IS '标题';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."START_TIME" IS '开始时间';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."END_TIME" IS '结束时间';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."IS_ALLDAYEVENT" IS '是否全天';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."PERSON_ID" IS '用户ID';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."BUSINESS_ID" IS '业务单据ID';
 
   COMMENT ON COLUMN "SA_PERSONCALENDAR"."LINK_BILL_URL" IS '业务单据链接';
 
   COMMENT ON TABLE "SA_PERSONCALENDAR"  IS '日程安排';
--------------------------------------------------------
--  DDL for Table SA_PERSONLOGINLIMIT
--------------------------------------------------------

  CREATE TABLE "SA_PERSONLOGINLIMIT" ("ID" VARCHAR2(32 BYTE), "MACHINE_ID" VARCHAR2(32 BYTE), "PERSON_ID" VARCHAR2(32 BYTE), "LOGIN_NAME" VARCHAR2(64 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FULL_ID" VARCHAR2(1024 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_PERSONQUERYSCHEME
--------------------------------------------------------

  CREATE TABLE "SA_PERSONQUERYSCHEME" ("ID" VARCHAR2(32 BYTE), "PERSON_ID" VARCHAR2(32 BYTE), "KIND_ID" VARCHAR2(32 BYTE), "NAME" VARCHAR2(128 BYTE), "PARAM" VARCHAR2(4000 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."PERSON_ID" IS '人员ID';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."KIND_ID" IS '类别';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."NAME" IS '名称';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."PARAM" IS '参数';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."SEQUENCE" IS '序号';
 
   COMMENT ON COLUMN "SA_PERSONQUERYSCHEME"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_PERSONQUERYSCHEME"  IS '用户查询方案';
--------------------------------------------------------
--  DDL for Table SA_SCHEDULING_JOB
--------------------------------------------------------

  CREATE TABLE "SA_SCHEDULING_JOB" ("JOB_ID" VARCHAR2(32 BYTE), "JOB_NAME" VARCHAR2(64 BYTE), "JOB_GROUP" VARCHAR2(128 BYTE), "JOB_STATUS" VARCHAR2(64 BYTE), "CRON_EXPRESSION" VARCHAR2(64 BYTE), "JOB_CLASS_NAME" VARCHAR2(512 BYTE), "JOB_DESC" VARCHAR2(512 BYTE), "JOB_PARAM" VARCHAR2(512 BYTE), "BEAN_NAME" VARCHAR2(512 BYTE), "LAST_EXECUTE_TIME" DATE) ;
--------------------------------------------------------
--  DDL for Table SA_SCHEDULING_JOB_LOG
--------------------------------------------------------

  CREATE TABLE "SA_SCHEDULING_JOB_LOG" ("ID" VARCHAR2(32 BYTE), "JOB_ID" VARCHAR2(32 BYTE), "EXECUTE_TIME" DATE, "MESSAGE" VARCHAR2(2048 BYTE), "STATUS" NUMBER) ;
--------------------------------------------------------
--  DDL for Table SA_SECURITYPOLICY
--------------------------------------------------------

  CREATE TABLE "SA_SECURITYPOLICY" ("ID" VARCHAR2(32 BYTE), "ENABLE_INTERNET_LOGIN" NUMBER(*,0), "INTRANET_SEGMENT" VARCHAR2(128 BYTE), "PASSWORD_VALIDITY_INTERVAL" NUMBER(*,0), "PASSWORD_EXPIRE_GIVE_DAYS" NUMBER(*,0), "PASSWORD_MINIMUM_LENGTH" NUMBER(*,0), "LOCK_USER_PASSWORD_ERROR_TIME" NUMBER(*,0), "ENABLE_COMPLEXITY" NUMBER(*,0), "AUTO_UNLOCK_TIME" NUMBER(*,0), "SECURITY_GRADE" VARCHAR2(64 BYTE), "NUMBER_COUNT" NUMBER(*,0), "UPPERCASE_COUNT" NUMBER(*,0), "LOWERCASE_COUNT" NUMBER(*,0), "SPECIAL_CHARACTER_COUNT" NUMBER(*,0), "INIT_PASSWORD" VARCHAR2(64 BYTE), "STATUS" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table SA_SYNBASEDATAVERSION
--------------------------------------------------------

  CREATE TABLE "SA_SYNBASEDATAVERSION" ("CODE" VARCHAR2(64 BYTE), "MAX_VERSION" NUMBER, "REMARK" VARCHAR2(512 BYTE), "VERSION" NUMBER, "MAX_TIMESTAMP" DATE, "ID" VARCHAR2(32 BYTE), "NAME" VARCHAR2(128 BYTE), "STATUS" NUMBER) ;
 

   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."CODE" IS '类别编码';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."MAX_VERSION" IS '最大版本号';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."MAX_TIMESTAMP" IS '修改时间';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."ID" IS '主键ID';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."NAME" IS '类别名称';
 
   COMMENT ON COLUMN "SA_SYNBASEDATAVERSION"."STATUS" IS '状态';
 
   COMMENT ON TABLE "SA_SYNBASEDATAVERSION"  IS '系统新信息同步';
--------------------------------------------------------
--  DDL for Table SA_TMAUTHORIZE
--------------------------------------------------------

  CREATE TABLE "SA_TMAUTHORIZE" ("ID" VARCHAR2(32 BYTE), "SUBORDINATION_ID" VARCHAR2(65 BYTE), "SUBORDINATION_FULL_ID" VARCHAR2(255 BYTE), "SYSTEM_ID" VARCHAR2(32 BYTE), "ROLE_KIND_ID" VARCHAR2(32 BYTE), "MANAGER_ID" VARCHAR2(65 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(64 BYTE), "CREATED_DATE" DATE, "VERSION" VARCHAR2(64 BYTE)) ;
--------------------------------------------------------
--  DDL for Table SA_USERGROUP
--------------------------------------------------------

  CREATE TABLE "SA_USERGROUP" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "FOLDER_ID" VARCHAR2(32 BYTE), "KIND_ID" VARCHAR2(8 BYTE), "STATUS" NUMBER(*,0), "FUNCTION_NAME" VARCHAR2(512 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "CREATED_BY_NAME" VARCHAR2(128 BYTE), "CREATED_DATE" DATE, "REMARK" VARCHAR2(512 BYTE), "SEQUENCE" NUMBER, "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "SA_USERGROUP"."ID" IS 'ID';
 
   COMMENT ON COLUMN "SA_USERGROUP"."CODE" IS '分组编码';
 
   COMMENT ON COLUMN "SA_USERGROUP"."NAME" IS '分组名称';
 
   COMMENT ON COLUMN "SA_USERGROUP"."KIND_ID" IS '分组类别(系统,个人)';
 
   COMMENT ON COLUMN "SA_USERGROUP"."STATUS" IS '状态';
 
   COMMENT ON COLUMN "SA_USERGROUP"."FUNCTION_NAME" IS '函数名';
 
   COMMENT ON COLUMN "SA_USERGROUP"."CREATED_BY_ID" IS 'CREATEd_BY_ID';
 
   COMMENT ON COLUMN "SA_USERGROUP"."CREATED_BY_NAME" IS 'CREATEd_BY_name';
 
   COMMENT ON COLUMN "SA_USERGROUP"."CREATED_DATE" IS 'created_date';
 
   COMMENT ON COLUMN "SA_USERGROUP"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "SA_USERGROUP"."SEQUENCE" IS '序号';
 
   COMMENT ON COLUMN "SA_USERGROUP"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "SA_USERGROUP"  IS '用户分组';
--------------------------------------------------------
--  DDL for Table SA_USERGROUPDETAIL
--------------------------------------------------------

  CREATE TABLE "SA_USERGROUPDETAIL" ("ID" VARCHAR2(32 BYTE), "GROUP_ID" VARCHAR2(32 BYTE), "ORG_ID" VARCHAR2(65 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER, "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table WF_APPROVALELEMENT
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALELEMENT" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "KIND_ID" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "DATA_SOURCE_CONFIG" VARCHAR2(1024 BYTE), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALELEMENT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_APPROVALELEMENT"."CODE" IS '编码';
 
   COMMENT ON COLUMN "WF_APPROVALELEMENT"."NAME" IS '名称';
 
   COMMENT ON COLUMN "WF_APPROVALELEMENT"."KIND_ID" IS '1系统 2业务';
 
   COMMENT ON COLUMN "WF_APPROVALELEMENT"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_APPROVALELEMENT"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "WF_APPROVALELEMENT"  IS '审批要素';
--------------------------------------------------------
--  DDL for Table WF_APPROVALHANDLERKIND
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALHANDLERKIND" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(256 BYTE), "DATA_SOURCE_ID" NUMBER(*,0), "DATA_SOURCE_CONFIG" VARCHAR2(1024 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "STATUS" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."CODE" IS '编码';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."NAME" IS '名称';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."DATA_SOURCE_ID" IS '数据源';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."DATA_SOURCE_CONFIG" IS '数据源配置';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_APPROVALHANDLERKIND"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "WF_APPROVALHANDLERKIND"  IS '审批人类别';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULE
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULE" ("ID" VARCHAR2(32 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "PROC_ID" VARCHAR2(64 BYTE), "PROC_NAME" VARCHAR2(256 BYTE), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "PROC_UNIT_NAME" VARCHAR2(256 BYTE), "NODE_KIND_ID" NUMBER(*,0), "NAME" VARCHAR2(256 BYTE), "PRIORITY" NUMBER(*,0), "STATUS" NUMBER(*,0), "REMARK" VARCHAR2(512 BYTE), "CREATED_DATE" DATE, "CREATED_BY_NAME" VARCHAR2(64 BYTE), "CREATED_BY_ID" VARCHAR2(65 BYTE), "LAST_MODIFIED_DATE" DATE, "LAST_MODIFIED_BY_NAME" VARCHAR2(100 BYTE), "LAST_MODIFIED_BY_ID" VARCHAR2(65 BYTE), "VERSION" NUMBER(*,0), "ORG_ID" VARCHAR2(32 BYTE), "FULL_ID" VARCHAR2(512 BYTE), "FULL_NAME" VARCHAR2(2048 BYTE), "SCOPE_KIND_ID" NUMBER(*,0) DEFAULT 1, "CODE" VARCHAR2(64 BYTE), "SEQUENCE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULE"."ID" IS '规则ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PARENT_ID" IS '父节点ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PROC_ID" IS '流程ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PROC_NAME" IS '流程名称';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PROC_UNIT_ID" IS '环节ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PROC_UNIT_NAME" IS '环节名称';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."NODE_KIND_ID" IS '节点类别 1 分类 2 规则 ';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."PRIORITY" IS '优先级';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."STATUS" IS '状态 1 启用 0 禁用';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."REMARK" IS '备注';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."CREATED_BY_NAME" IS '创建人姓名';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."CREATED_BY_ID" IS '创建人ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."LAST_MODIFIED_DATE" IS '最后修改时间';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."LAST_MODIFIED_BY_NAME" IS '最后修改人姓名';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."LAST_MODIFIED_BY_ID" IS '最后修改人ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."ORG_ID" IS '组织ID（公司ID：organ_id，以后可扩展为组织ID）';
 
   COMMENT ON COLUMN "WF_APPROVALRULE"."SCOPE_KIND_ID" IS '适用范围';
 
   COMMENT ON TABLE "WF_APPROVALRULE"  IS '审批规则';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEELEMENT
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEELEMENT" ("APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "ID" VARCHAR2(32 BYTE), "ELEMENT_CODE" NVARCHAR2(128), "FOPERATOR" VARCHAR2(20 BYTE), "FVALUE_ID" VARCHAR2(1024 BYTE), "FVALUE" VARCHAR2(1000 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "ELEMENT_ID" NVARCHAR2(32)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."APPROVAL_RULE_ID" IS 'ApprovalRule';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."ELEMENT_CODE" IS '审批要素编码';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."FOPERATOR" IS '操作符';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."FVALUE_ID" IS '值ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."FVALUE" IS '值';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_APPROVALRULEELEMENT"."ELEMENT_ID" IS '审批要素ID';
 
   COMMENT ON TABLE "WF_APPROVALRULEELEMENT"  IS '审批规则要素';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEHANDLER
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEHANDLER" ("APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "ID" VARCHAR2(32 BYTE), "DESCRIPTION" VARCHAR2(512 BYTE), "HANDLER_KIND_CODE" NVARCHAR2(128), "HANDLER_ID" VARCHAR2(128 BYTE), "HANDLER_NAME" VARCHAR2(128 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "KIND_ID" VARCHAR2(32 BYTE), "ALLOW_ADD" NUMBER(*,0), "ALLOW_SUBTRACT" NUMBER(*,0), "ALLOW_TRANSFER" NUMBER(*,0), "ALLOW_ABORT" NUMBER(*,0), "NEED_TIMING" NUMBER(*,0), "HELP_SECTION" VARCHAR2(256 BYTE), "CHIEF_ID" NUMBER(*,0), "GROUP_ID" NUMBER(*,0), "BIZ_HANDLER_PARAM" VARCHAR2(60 BYTE), "HANDLER_KIND_ID" VARCHAR2(64 BYTE), "MUST_PASS" NUMBER(*,0), "APPROVAL_HANDLER_KIND_ID" VARCHAR2(32 BYTE), "LIMIT_TIME" NUMBER(*,0), "SEND_MESSAGE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."APPROVAL_RULE_ID" IS 'ApprovalRuleID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."HANDLER_KIND_CODE" IS '管理权限、部门、岗位、人员成员、函数';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."HANDLER_ID" IS '审批人ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."HANDLER_NAME" IS '审批人';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."KIND_ID" IS ' chief 主审 assistant 协审 cc抄送';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."ALLOW_ADD" IS '允许加签';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."ALLOW_SUBTRACT" IS '允许被减签';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."ALLOW_TRANSFER" IS '允许转交';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."ALLOW_ABORT" IS '允许终止';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."NEED_TIMING" IS '需要计时';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."HELP_SECTION" IS '审批要点';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."CHIEF_ID" IS '主审环节ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."GROUP_ID" IS '分组ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."BIZ_HANDLER_PARAM" IS '业务处理人参数';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."HANDLER_KIND_ID" IS '环节ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."MUST_PASS" IS '是否必经节点';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."LIMIT_TIME" IS '限制时间';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER"."SEND_MESSAGE" IS '发送消息';
 
   COMMENT ON TABLE "WF_APPROVALRULEHANDLER"  IS '审批规则审批人';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEHANDLERASSIST
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEHANDLERASSIST" ("APPROVAL_RULE_HANDLER_ID" VARCHAR2(32 BYTE), "ID" VARCHAR2(32 BYTE), "DESCRIPTION" VARCHAR2(512 BYTE), "HANDLER_ID" VARCHAR2(128 BYTE), "HANDLER_NAME" VARCHAR2(128 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "KIND_ID" VARCHAR2(32 BYTE), "HANDLER_KIND_CODE" NVARCHAR2(128)) ;
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEHANDLERGROUP
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEHANDLERGROUP" ("ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "TASK_EXECUTE_MODE_ID" VARCHAR2(32 BYTE), "GROUP_ID" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEHANDLERUIPERM
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEHANDLERUIPERM" ("ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_HANDLER_ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(128 BYTE), "NAME" VARCHAR2(128 BYTE), "KIND_ID" VARCHAR2(64 BYTE), "OPERATION_ID" VARCHAR2(64 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."ID" IS '审批人字段权限主键';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."APPROVAL_RULE_HANDLER_ID" IS '审批人ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."CODE" IS '字段编码';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."NAME" IS '字段名称';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."KIND_ID" IS '字段类型';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLERUIPERM"."OPERATION_ID" IS '字段权限';
 
   COMMENT ON TABLE "WF_APPROVALRULEHANDLERUIPERM"  IS '审批人字段权限表';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULEHANDLER_AUTH
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULEHANDLER_AUTH" ("HANDLER_AUTH_ID" NUMBER(*,0), "APPROVAL_RULE_ID" NUMBER(*,0), "HANDLER_ID" NUMBER(*,0), "FIELD_CODE" VARCHAR2(128 BYTE), "FIELD_NAME" VARCHAR2(128 BYTE), "FIELD_TYPE" VARCHAR2(128 BYTE), "FIELD_AUTHORITY" VARCHAR2(128 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."HANDLER_AUTH_ID" IS '审批人字段权限主键';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."APPROVAL_RULE_ID" IS '审批规则ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."HANDLER_ID" IS '审批人ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."FIELD_CODE" IS '字段编码';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."FIELD_NAME" IS '字段名称';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."FIELD_TYPE" IS '字段类型';
 
   COMMENT ON COLUMN "WF_APPROVALRULEHANDLER_AUTH"."FIELD_AUTHORITY" IS '字段权限';
 
   COMMENT ON TABLE "WF_APPROVALRULEHANDLER_AUTH"  IS '审批人字段权限表';
--------------------------------------------------------
--  DDL for Table WF_APPROVALRULESCOPE
--------------------------------------------------------

  CREATE TABLE "WF_APPROVALRULESCOPE" ("ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "ORG_ID" VARCHAR2(32 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_APPROVALRULESCOPE"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULESCOPE"."APPROVAL_RULE_ID" IS '审批规则ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULESCOPE"."ORG_ID" IS '组织机构ID';
 
   COMMENT ON COLUMN "WF_APPROVALRULESCOPE"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "WF_APPROVALRULESCOPE"  IS '审批规则适用范围';
--------------------------------------------------------
--  DDL for Table WF_BASESEGMENTATIONTYPE
--------------------------------------------------------

  CREATE TABLE "WF_BASESEGMENTATIONTYPE" ("BASE_SEGMENTATION_TYPE_ID" NUMBER(*,0), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FOLDER_ID" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."BASE_SEGMENTATION_TYPE_ID" IS 'BaseSegmentationTypeID';
 
   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."CODE" IS '编码';
 
   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."NAME" IS '名称';
 
   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_BASESEGMENTATIONTYPE"."FOLDER_ID" IS '文件夹ID';
 
   COMMENT ON TABLE "WF_BASESEGMENTATIONTYPE"  IS '基础分段类';
--------------------------------------------------------
--  DDL for Table WF_BIZSEGMENTATION
--------------------------------------------------------

  CREATE TABLE "WF_BIZSEGMENTATION" ("BIZ_SEGMENTATION_ID" NUMBER(*,0), "ORG_ID" VARCHAR2(65 BYTE), "CODE" VARCHAR2(64 BYTE), "NAME" VARCHAR2(128 BYTE), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "KIND_ID" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."BIZ_SEGMENTATION_ID" IS 'BizSegmentationID';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."ORG_ID" IS 'Org_ID';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."CODE" IS '编码';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."NAME" IS '名称';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATION"."KIND_ID" IS '1 私有段 2 公开段 3 私有公开段';
 
   COMMENT ON TABLE "WF_BIZSEGMENTATION"  IS '组织业务段';
--------------------------------------------------------
--  DDL for Table WF_BIZSEGMENTATIONAUTHORIZE
--------------------------------------------------------

  CREATE TABLE "WF_BIZSEGMENTATIONAUTHORIZE" ("BIZ_SEGMENTATION_AUTHORIZE_ID" NUMBER(*,0), "BIZ_SEGMENTATION_ID" NUMBER(*,0), "BASE_SEGMENTATION_TYPE_ID" NUMBER(*,0), "ORG_ID" VARCHAR2(65 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."BIZ_SEGMENTATION_AUTHORIZE_ID" IS 'SegmentationAuthorizeID';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."BIZ_SEGMENTATION_ID" IS 'BizSegmentationTypeID';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."BASE_SEGMENTATION_TYPE_ID" IS 'BaseSegmentationTypeID';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."ORG_ID" IS '组织Id';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_BIZSEGMENTATIONAUTHORIZE"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "WF_BIZSEGMENTATIONAUTHORIZE"  IS '组织分段授权';
--------------------------------------------------------
--  DDL for Table WF_HI_PROCUNITHANDLER
--------------------------------------------------------

  CREATE TABLE "WF_HI_PROCUNITHANDLER" ("ID" NUMBER(*,0), "BIZ_ID" NUMBER(*,0), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "PROC_UNIT_NAME" VARCHAR2(128 BYTE), "HANDLE_KIND_ID" VARCHAR2(64 BYTE), "HANDLE_KIND_NAME" VARCHAR2(256 BYTE), "HANDLER_ID" VARCHAR2(65 BYTE), "HANDLER_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "ORG_ID" VARCHAR2(32 BYTE), "ORG_NAME" VARCHAR2(128 BYTE), "HANDLE_TIME" DATE, "RESULT" NUMBER(*,0), "OPINION" VARCHAR2(1024 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FULL_NAME" VARCHAR2(2048 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "COOPERATION_MODEL_ID" VARCHAR2(32 BYTE), "TASK_EXECUTE_MODE_ID" VARCHAR2(32 BYTE), "GROUP_ID" NUMBER(*,0), "CHIEF_ID" NUMBER(*,0), "APPROVAL_RULE_HANDLER_ID" NUMBER(*,0), "APPROVAL_RULE_ID" NUMBER(*,0), "ASSISTANT_SEQUENCE" NUMBER(*,0), "BIZ_CODE" VARCHAR2(64 BYTE), "OPERATE_KIND_ID" VARCHAR2(32 BYTE), "OPERATOR_ID" VARCHAR2(65 BYTE), "VERS" NUMBER(*,0), "OPERATOR_NAME" VARCHAR2(256 BYTE)) ;
 

   COMMENT ON COLUMN "WF_HI_PROCUNITHANDLER"."VERSION" IS '数据版本';
 
   COMMENT ON COLUMN "WF_HI_PROCUNITHANDLER"."OPERATE_KIND_ID" IS '操作类型 add delete ';
 
   COMMENT ON COLUMN "WF_HI_PROCUNITHANDLER"."VERS" IS '版本';
 
   COMMENT ON COLUMN "WF_HI_PROCUNITHANDLER"."OPERATOR_NAME" IS '处理人';
--------------------------------------------------------
--  DDL for Table WF_HI_PROCUNITHANDLERINST
--------------------------------------------------------

  CREATE TABLE "WF_HI_PROCUNITHANDLERINST" ("ID" NUMBER(*,0), "BIZ_ID" NUMBER(*,0), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "VERSION" NUMBER(*,0), "VERS" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table WF_ID_LOG
--------------------------------------------------------

  CREATE TABLE "WF_ID_LOG" ("OLD_ID" NUMBER(*,0), "NEW_ID" NUMBER(*,0)) ;
--------------------------------------------------------
--  DDL for Table WF_PROCAPPROVALELEMENT
--------------------------------------------------------

  CREATE TABLE "WF_PROCAPPROVALELEMENT" ("ID" VARCHAR2(32 BYTE), "PROC_ID" VARCHAR2(32 BYTE), "PROC_NAME" VARCHAR2(256 BYTE), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "PROC_UNIT_NAME" VARCHAR2(256 BYTE), "ELEMENT_ID" VARCHAR2(32 BYTE), "SEQUENCE" NUMBER(*,0), "PROC_KEY" VARCHAR2(510 BYTE), "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."ID" IS '流程审批要素ID';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."PROC_ID" IS '流程ID';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."PROC_NAME" IS '流程名称';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."PROC_UNIT_ID" IS '环节ID';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."PROC_UNIT_NAME" IS '环节名称';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."ELEMENT_ID" IS '审批要素ID';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."SEQUENCE" IS '排序号';
 
   COMMENT ON COLUMN "WF_PROCAPPROVALELEMENT"."PROC_KEY" IS '流程Key';
 
   COMMENT ON TABLE "WF_PROCAPPROVALELEMENT"  IS '流程审批要素';
--------------------------------------------------------
--  DDL for Table WF_PROCDEF
--------------------------------------------------------

  CREATE TABLE "WF_PROCDEF" ("ID" VARCHAR2(32 BYTE), "CODE" VARCHAR2(256 BYTE), "NAME" VARCHAR2(512 BYTE), "PARENT_ID" VARCHAR2(32 BYTE), "STATUS" NUMBER(*,0), "DESCRIPTION" VARCHAR2(1200 BYTE), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "APPROVAL_BRIDGE_PROC_ID" VARCHAR2(64 BYTE), "NODE_KIND_ID" VARCHAR2(32 BYTE), "NEED_TIMING" NUMBER(*,0), "FULL_NAME" VARCHAR2(2048 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "SHOW_QUERY_HANDLERS" NUMBER(*,0), "PROC_ID" VARCHAR2(128 BYTE), "PROC_NAME" VARCHAR2(256 BYTE), "LIMIT_TIME" NUMBER(*,0), "ASSISTANT_MUST_APPROVE" NUMBER(*,0), "MERGE_HANDLER_KIND" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_PROCDEF"."LIMIT_TIME" IS '限制时间';
 
   COMMENT ON COLUMN "WF_PROCDEF"."MERGE_HANDLER_KIND" IS '处理人合并类型 0 不合并  1 相邻合并  2 向后合并';
--------------------------------------------------------
--  DDL for Table WF_PROCUNITHANDLER
--------------------------------------------------------

  CREATE TABLE "WF_PROCUNITHANDLER" ("ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "PROC_UNIT_NAME" VARCHAR2(128 BYTE), "SUB_PROC_UNIT_ID" VARCHAR2(64 BYTE), "SUB_PROC_UNIT_NAME" VARCHAR2(256 BYTE), "HANDLER_ID" VARCHAR2(65 BYTE), "HANDLER_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "ORG_ID" VARCHAR2(32 BYTE), "ORG_NAME" VARCHAR2(128 BYTE), "HANDLED_DATE" DATE, "RESULT" NUMBER(*,0), "OPINION" VARCHAR2(2048 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FULL_NAME" VARCHAR2(2048 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "COOPERATION_MODEL_ID" VARCHAR2(32 BYTE), "TASK_EXECUTE_MODE_ID" VARCHAR2(32 BYTE), "GROUP_ID" NUMBER(*,0), "CHIEF_ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_HANDLER_ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "ASSISTANT_SEQUENCE" NUMBER(*,0), "BIZ_CODE" VARCHAR2(64 BYTE), "PRINCIPAL_ID" VARCHAR2(65 BYTE), "PRINCIPAL_NAME" VARCHAR2(128 BYTE), "EXECUTION_TIMES" NUMBER(*,0), "SEND_MESSAGE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."BIZ_ID" IS '业务ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."PROC_UNIT_ID" IS '环节ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."PROC_UNIT_NAME" IS '环节名称';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."SUB_PROC_UNIT_ID" IS '子环节ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."SUB_PROC_UNIT_NAME" IS '子环节名称';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."HANDLER_ID" IS '处理人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."HANDLER_NAME" IS '处理人姓名';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."POSITION_ID" IS '岗位ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."POSITION_NAME" IS '岗位';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."DEPT_ID" IS '部门ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."DEPT_NAME" IS '部门';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."ORG_ID" IS '机构ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."ORG_NAME" IS '机构';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."HANDLED_DATE" IS '处理时间';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."RESULT" IS '处理结果';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."OPINION" IS '处理意见';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."STATUS" IS '1 启用 0 禁用';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."SEQUENCE" IS '主审序号';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."COOPERATION_MODEL_ID" IS '协作模式 chief 主审 assistant 协审';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."TASK_EXECUTE_MODE_ID" IS '任务执行模式 preempt 抢占模式 sequential 顺序执行 simultaneous 并行执行';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."GROUP_ID" IS '分组ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."CHIEF_ID" IS '主审人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."APPROVAL_RULE_HANDLER_ID" IS '审批规则处理人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."APPROVAL_RULE_ID" IS '审批规则ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."ASSISTANT_SEQUENCE" IS '协审序号';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."BIZ_CODE" IS '业务编码';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."PRINCIPAL_ID" IS '委托人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."PRINCIPAL_NAME" IS '委托人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."EXECUTION_TIMES" IS '执行次数';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLER"."SEND_MESSAGE" IS '发送消息';
 
   COMMENT ON TABLE "WF_PROCUNITHANDLER"  IS '环节处理人';
--------------------------------------------------------
--  DDL for Table WF_PROCUNITHANDLERMANUSCRIPT
--------------------------------------------------------

  CREATE TABLE "WF_PROCUNITHANDLERMANUSCRIPT" ("ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "PROC_UNIT_HANDLER_ID" VARCHAR2(32 BYTE), "HEIGHT" NUMBER(*,0), "OPINION_30" CLOB, "OPINION_64" CLOB, "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."BIZ_ID" IS '业务ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."PROC_UNIT_HANDLER_ID" IS '环节处理人ID';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."HEIGHT" IS '高度';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."OPINION_30" IS '处理意见';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."OPINION_64" IS '处理意见';
 
   COMMENT ON COLUMN "WF_PROCUNITHANDLERMANUSCRIPT"."VERSION" IS '版本号';
--------------------------------------------------------
--  DDL for Table WF_PROCUNITHANDLER_CACHE
--------------------------------------------------------

  CREATE TABLE "WF_PROCUNITHANDLER_CACHE" ("ID" VARCHAR2(32 BYTE), "BIZ_ID" VARCHAR2(32 BYTE), "PROC_UNIT_ID" VARCHAR2(64 BYTE), "PROC_UNIT_NAME" VARCHAR2(128 BYTE), "SUB_PROC_UNIT_ID" VARCHAR2(64 BYTE), "SUB_PROC_UNIT_NAME" VARCHAR2(256 BYTE), "HANDLER_ID" VARCHAR2(65 BYTE), "HANDLER_NAME" VARCHAR2(128 BYTE), "POSITION_ID" VARCHAR2(32 BYTE), "POSITION_NAME" VARCHAR2(128 BYTE), "DEPT_ID" VARCHAR2(32 BYTE), "DEPT_NAME" VARCHAR2(128 BYTE), "ORG_ID" VARCHAR2(32 BYTE), "ORG_NAME" VARCHAR2(128 BYTE), "HANDLED_DATE" DATE, "RESULT" NUMBER(*,0), "OPINION" VARCHAR2(2048 BYTE), "STATUS" NUMBER(*,0), "SEQUENCE" NUMBER(*,0), "VERSION" NUMBER(*,0), "FULL_NAME" VARCHAR2(2048 BYTE), "FULL_ID" VARCHAR2(1024 BYTE), "COOPERATION_MODEL_ID" VARCHAR2(32 BYTE), "TASK_EXECUTE_MODE_ID" VARCHAR2(32 BYTE), "GROUP_ID" NUMBER(*,0), "CHIEF_ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_HANDLER_ID" VARCHAR2(32 BYTE), "APPROVAL_RULE_ID" VARCHAR2(32 BYTE), "ASSISTANT_SEQUENCE" NUMBER(*,0), "BIZ_CODE" VARCHAR2(64 BYTE), "PRINCIPAL_ID" VARCHAR2(65 BYTE), "PRINCIPAL_NAME" VARCHAR2(128 BYTE)) ;
--------------------------------------------------------
--  DDL for Table WF_SEGMENTATIONHANDLER
--------------------------------------------------------

  CREATE TABLE "WF_SEGMENTATIONHANDLER" ("SEGMENTATION_HANDLER_ID" NUMBER(*,0), "SEGMENTATION_ID" NUMBER(*,0), "DESCRIPTION" VARCHAR2(512 BYTE), "HANDLER_KIND_CODE" VARCHAR2(64 BYTE), "HANDLER_ID" VARCHAR2(256 BYTE), "HANDLER_NAME" VARCHAR2(256 BYTE), "GROUP_ID" NUMBER(*,0), "VERSION" NUMBER(*,0), "SEQUENCE" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."SEGMENTATION_HANDLER_ID" IS 'SegmentationHandlerID';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."SEGMENTATION_ID" IS 'SegmentationID';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."DESCRIPTION" IS '描述';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."HANDLER_KIND_CODE" IS '管理权限、部门、岗位、人员成员、函数';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."HANDLER_ID" IS '处理人ID';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."HANDLER_NAME" IS '处理人名称';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."GROUP_ID" IS '分组ID';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."VERSION" IS '版本号';
 
   COMMENT ON COLUMN "WF_SEGMENTATIONHANDLER"."SEQUENCE" IS '排序号';
 
   COMMENT ON TABLE "WF_SEGMENTATIONHANDLER"  IS '组织业务段处理人';
--------------------------------------------------------
--  DDL for Table WF_TASKCOLLECTION
--------------------------------------------------------

  CREATE TABLE "WF_TASKCOLLECTION" ("ID" VARCHAR2(32 BYTE), "TASK_ID" VARCHAR2(64 BYTE), "PERSON_ID" VARCHAR2(32 BYTE), "CREATED_DATE" DATE, "VERSION" NUMBER(*,0)) ;
 

   COMMENT ON COLUMN "WF_TASKCOLLECTION"."ID" IS 'ID';
 
   COMMENT ON COLUMN "WF_TASKCOLLECTION"."TASK_ID" IS '任务ID';
 
   COMMENT ON COLUMN "WF_TASKCOLLECTION"."PERSON_ID" IS '人员ID';
 
   COMMENT ON COLUMN "WF_TASKCOLLECTION"."CREATED_DATE" IS '创建时间';
 
   COMMENT ON COLUMN "WF_TASKCOLLECTION"."VERSION" IS '版本号';
 
   COMMENT ON TABLE "WF_TASKCOLLECTION"  IS '用户收藏任务';
--------------------------------------------------------
--  DDL for View SYS_USERS_VIEW
--------------------------------------------------------

  CREATE OR REPLACE VIEW "SYS_USERS_VIEW" ("EMPID", "EMPNAME", "USERID", "STATUS", "PASSWORD", "ORGID_ID") AS select p.id EMPID,
       p.name EMPNAME,
       p.login_name USERID,
       o.status,
       p.password,
       listagg(o.dept_id, ',') within group(order by o.sequence) as ORGID_ID
  from sa_oporg o, sa_opperson p
 where o.person_id = p.id
   and o.org_kind_id = 'psm'
   and o.status=1
 group by p.id, p.name, p.login_name, p.password,o.status

 
 
 
;
--------------------------------------------------------
--  DDL for View V_ACT_HI_PROCINST
--------------------------------------------------------

  CREATE OR REPLACE VIEW "V_ACT_HI_PROCINST" ("PROC_INST_ID_", "BUSINESS_KEY_", "PROC_DEF_ID_", "PROCESS_DEFINITION_KEY_", "PROC_FULL_ID", "PROC_FULL_NAME", "PROC_NAME", "PROC_SYS_NAME", "START_TIME_", "END_TIME_", "APPLICANT_PERSON_MEMBER_ID_", "APPLICANT_PERSON_MEMBER_NAME_", "APPLICANT_DEPT_NAME_", "APPLICANT_ORG_NAME_", "PROC_STATUS_ID_") AS select pe.id_ as proc_inst_id_, pe.business_key_, pe.proc_def_id_,
       pe.key_ as process_definition_key_, pdf.full_id proc_full_id,
       pdf.full_name proc_full_name, pdf.name proc_name,
       substr(pdf.full_name, 2, instr(pdf.full_name, '/', 2) - 2) proc_sys_name,
       pe.start_time_, pe.end_time_, pe.applicant_person_member_id_,
       pe.applicant_person_member_name_, pe.applicant_dept_name_,
       pe.applicant_org_name_, pe.status_id_ proc_status_id_
  from act_hi_procinst_extension pe, act_re_procdef pd,
       wf_procdef pdf
 where pe.proc_def_id_ = pd.id_
   and pd.key_ = pdf.proc_id (+)
   and pdf.node_kind_id (+) = 'proc'

 
 
 
;
--------------------------------------------------------
--  DDL for View V_ACT_HI_TASK
--------------------------------------------------------

  CREATE OR REPLACE VIEW "V_ACT_HI_TASK" ("ID_", "PROC_INST_ID_", "PROC_DEF_ID_", "NAME_", "PARENT_TASK_ID_", "DESCRIPTION_", "CREATOR_OGN_NAME_", "CREATOR_DEPT_NAME_", "TASK_DEF_KEY_", "PROCESS_DEFINITION_KEY_", "PRIORITY_", "START_TIME_", "END_TIME_", "DUE_DATE_", "KIND_ID_", "CREATOR_URL_", "EXECUTOR_URL_", "CREATOR_PERSON_MEMBER_NAME_", "CREATOR_FULL_ID_", "EXECUTOR_FULL_ID_", "EXECUTOR_PERSON_MEMBER_NAME_", "EXECUTOR_NAMES_", "STATUS_ID_", "STATUS_NAME_", "CATALOG_ID_", "PREVIOUS_ID_", "BUSINESS_KEY_", "BUSINESS_CODE_", "PROC_UNIT_HANDLER_ID_", "EXECUTOR_PERSON_MEMBER_ID_", "CREATOR_PERSON_MEMBER_ID_", "NEED_TIMING_", "APPLICANT_PERSON_MEMBER_ID_", "APPLICANT_PERSON_MEMBER_NAME_") AS select te.id_, te.proc_inst_id_, te.proc_def_id_, te.name_, te.parent_task_id_, te.description_,
       te.creator_ogn_name_, te.creator_dept_name_, te.task_def_key_, te.process_definition_key_,
       te.priority_, te.start_time_,
       te.end_time_, te.due_date_,  te.kind_id_,
       te.creator_url_, te.executor_url_, te.creator_person_member_name_,
       te.creator_full_id_, te.executor_full_id_,
       te.executor_person_member_name_, te.executor_names_, te.status_id_,
       te.status_name_, te.catalog_id_, te.previous_id_, te.business_key_,
       te.business_code_, te.proc_unit_handler_id_,
       te.executor_person_member_id_, te.creator_person_member_id_,te.need_timing_,
       te.applicant_person_member_id_, te.applicant_person_member_name_
  from act_hi_taskinst_extension te

 
 
 
;
--------------------------------------------------------
--  DDL for View V_ACT_HI_TASK_FOR_DELETE
--------------------------------------------------------

  CREATE OR REPLACE VIEW "V_ACT_HI_TASK_FOR_DELETE" ("ID_", "PROC_INST_ID_", "PROC_DEF_ID_", "NAME_", "PARENT_TASK_ID_", "DESCRIPTION_", "CREATOR_OGN_NAME_", "CREATOR_DEPT_NAME_", "TASK_DEF_KEY_", "PROCESS_DEFINITION_KEY_", "PRIORITY_", "START_TIME_", "END_TIME_", "DUE_DATE_", "KIND_ID_", "CREATOR_URL_", "EXECUTOR_URL_", "CREATOR_PERSON_MEMBER_NAME_", "CREATOR_FULL_ID_", "EXECUTOR_FULL_ID_", "EXECUTOR_PERSON_MEMBER_NAME_", "EXECUTOR_NAMES_", "STATUS_ID_", "STATUS_NAME_", "CATALOG_ID_", "PREVIOUS_ID_", "BUSINESS_KEY_", "BUSINESS_CODE_", "PROC_UNIT_HANDLER_ID_", "EXECUTOR_PERSON_MEMBER_ID_", "CREATOR_PERSON_MEMBER_ID_", "NEED_TIMING_", "APPLICANT_PERSON_MEMBER_ID_", "APPLICANT_PERSON_MEMBER_NAME_") AS select te.id_, te.proc_inst_id_, te.proc_def_id_, te.name_, te.parent_task_id_, te.description_,
       te.creator_ogn_name_, te.creator_dept_name_, te.task_def_key_, te.process_definition_key_,
       te.priority_, te.start_time_,
       te.end_time_, te.due_date_,  te.kind_id_,
       te.creator_url_, te.executor_url_, te.creator_person_member_name_,
       te.creator_full_id_, te.executor_full_id_,
       te.executor_person_member_name_, te.executor_names_, te.status_id_,
       te.status_name_, te.catalog_id_, te.previous_id_, te.business_key_,
       te.business_code_, te.proc_unit_handler_id_,
       te.executor_person_member_id_, te.creator_person_member_id_,te.need_timing_,
       te.applicant_person_member_id_, te.applicant_person_member_name_
  from act_hi_taskinst_extension te

 
 
 
;
--------------------------------------------------------
--  DDL for View V_ACT_RU_TASK
--------------------------------------------------------

  CREATE OR REPLACE VIEW "V_ACT_RU_TASK" ("ID_", "PROC_INST_ID_", "PROC_DEF_ID_", "NAME_", "PARENT_TASK_ID_", "DESCRIPTION_", "CREATOR_OGN_NAME_", "CREATOR_DEPT_NAME_", "TASK_DEF_KEY_", "PROCESS_DEFINITION_KEY_", "DELEGATION_", "PRIORITY_", "START_TIME_", "END_TIME_", "DUE_DATE_", "SUSPENSION_STATE_", "KIND_ID_", "CREATOR_URL_", "EXECUTOR_URL_", "CREATOR_PERSON_MEMBER_NAME_", "CREATOR_FULL_ID_", "EXECUTOR_FULL_ID_", "EXECUTOR_PERSON_MEMBER_NAME_", "EXECUTOR_NAMES_", "STATUS_ID_", "STATUS_NAME_", "CATALOG_ID_", "PREVIOUS_ID_", "BUSINESS_KEY_", "BUSINESS_CODE_", "PROC_UNIT_HANDLER_ID_", "EXECUTOR_PERSON_MEMBER_ID_", "CREATOR_PERSON_MEMBER_ID_", "NEED_TIMING_", "APPLICANT_PERSON_MEMBER_ID_", "APPLICANT_PERSON_MEMBER_NAME_") AS select te.id_, te.proc_inst_id_, te.proc_def_id_, te.name_, te.parent_task_id_, te.description_,
       te.creator_ogn_name_, te.creator_dept_name_, te.task_def_key_, te.process_definition_key_,
       te.delegation_, te.priority_, te.start_time_,
       '' end_time_, te.due_date_, te.suspension_state_, te.kind_id_,
       te.creator_url_, te.executor_url_, te.creator_person_member_name_,
       te.creator_full_id_, te.executor_full_id_,
       te.executor_person_member_name_, te.executor_names_, te.status_id_,
       te.status_name_, te.catalog_id_, te.previous_id_, te.business_key_,
       te.business_code_, te.proc_unit_handler_id_,
       te.executor_person_member_id_, te.creator_person_member_id_,te.need_timing_,
       te.applicant_person_member_id_, te.applicant_person_member_name_
  from  act_ru_task_extension te

 
 
 
;
--------------------------------------------------------
--  DDL for View V_SA_OPORG_EXCLUDE_POS
--------------------------------------------------------

  CREATE OR REPLACE VIEW "V_SA_OPORG_EXCLUDE_POS" ("ID", "TYPE_ID", "CODE", "NAME", "LONG_NAME", "PARENT_ID", "FULL_ID", "FULL_CODE", "FULL_NAME", "ORG_KIND_ID", "DEPTH", "PERSON_ID", "NODE_KIND_ID", "DESCRIPTION", "STATUS", "SEQUENCE", "VERSION", "ORG_CODE", "DEPT_CODE", "POSITION_CODE", "PERSON_MEMBER_CODE", "IS_CENTER", "CENTER_CODE", "ORG_ID", "DEPT_ID", "POSITION_ID", "PERSON_MEMBER_ID", "CENTER_ID", "ORG_NAME", "DEPT_NAME", "POSITION_NAME", "PERSON_MEMBER_NAME", "CENTER_NAME", "FULL_SEQUENCE", "FULL_ORG_KIND_ID", "IS_VIRTUAL") AS select id, type_id, code, name, long_name,
       decode(org_kind_id, 'psm', dept_id, parent_id) parent_id, full_id,
       full_code, full_name, org_kind_id, depth, person_id, node_kind_id,
       description, status, sequence, version, org_code, dept_code,
       position_code, person_member_code, is_center, center_code, org_id,
       dept_id, position_id, person_member_id, center_id, org_name,
       dept_name, position_name, person_member_name, center_name,
       full_sequence, full_org_kind_id, is_virtual
  from sa_oporg
 where org_kind_id != 'pos'

 
 
 
;
--------------------------------------------------------
--  DDL for Index ACT_IDX_ATHRZ_PROCEDEF
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_ATHRZ_PROCEDEF" ON "ACT_RU_IDENTITYLINK" ("PROC_DEF_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_BYTEAR_DEPL
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_BYTEAR_DEPL" ON "ACT_GE_BYTEARRAY" ("DEPLOYMENT_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_EXEC_BUSKEY
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_EXEC_BUSKEY" ON "ACT_RU_EXECUTION" ("BUSINESS_KEY_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_EXE_PARENT
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_EXE_PARENT" ON "ACT_RU_EXECUTION" ("PARENT_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_EXE_PROCDEF
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_EXE_PROCDEF" ON "ACT_RU_EXECUTION" ("PROC_DEF_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_EXE_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_EXE_PROCINST" ON "ACT_RU_EXECUTION" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_EXE_SUPER
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_EXE_SUPER" ON "ACT_RU_EXECUTION" ("SUPER_EXEC_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_ACT_INST_END
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_ACT_INST_END" ON "ACT_HI_ACTINST" ("END_TIME_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_ACT_INST_EXEC
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_ACT_INST_EXEC" ON "ACT_HI_ACTINST" ("EXECUTION_ID_", "ACT_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_ACT_INST_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_ACT_INST_PROCINST" ON "ACT_HI_ACTINST" ("PROC_INST_ID_", "ACT_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_ACT_INST_START
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_ACT_INST_START" ON "ACT_HI_ACTINST" ("START_TIME_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_IDENT_LNK_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_IDENT_LNK_PROCINST" ON "ACT_HI_IDENTITYLINK" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_IDENT_LNK_TASK
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_IDENT_LNK_TASK" ON "ACT_HI_IDENTITYLINK" ("TASK_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_IDENT_LNK_USER
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_IDENT_LNK_USER" ON "ACT_HI_IDENTITYLINK" ("USER_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_PROCVAR_NAME_TYPE
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_PROCVAR_NAME_TYPE" ON "ACT_HI_VARINST" ("NAME_", "VAR_TYPE_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_PROCVAR_PROC_INST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_PROCVAR_PROC_INST" ON "ACT_HI_VARINST" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_PROCVAR_TASK_ID
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_PROCVAR_TASK_ID" ON "ACT_HI_VARINST" ("TASK_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_PRO_INST_END
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_PRO_INST_END" ON "ACT_HI_PROCINST" ("END_TIME_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_HI_PRO_I_BUSKEY
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_HI_PRO_I_BUSKEY" ON "ACT_HI_PROCINST" ("BUSINESS_KEY_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_IDENT_LNK_GROUP
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_IDENT_LNK_GROUP" ON "ACT_RU_IDENTITYLINK" ("GROUP_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_IDENT_LNK_USER
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_IDENT_LNK_USER" ON "ACT_RU_IDENTITYLINK" ("USER_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_IDL_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_IDL_PROCINST" ON "ACT_RU_IDENTITYLINK" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_JOB_EXCEPTION
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_JOB_EXCEPTION" ON "ACT_RU_JOB" ("EXCEPTION_STACK_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_TASK_CREATE
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_TASK_CREATE" ON "ACT_RU_TASK" ("CREATE_TIME_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_TASK_EXEC
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_TASK_EXEC" ON "ACT_RU_TASK" ("EXECUTION_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_TASK_PROCDEF
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_TASK_PROCDEF" ON "ACT_RU_TASK" ("PROC_DEF_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_TASK_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_TASK_PROCINST" ON "ACT_RU_TASK" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_TSKASS_TASK
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_TSKASS_TASK" ON "ACT_RU_IDENTITYLINK" ("TASK_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_VARIABLE_TASK_ID
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_VARIABLE_TASK_ID" ON "ACT_RU_VARIABLE" ("TASK_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_VAR_BYTEARRAY
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_VAR_BYTEARRAY" ON "ACT_RU_VARIABLE" ("BYTEARRAY_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_VAR_EXE
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_VAR_EXE" ON "ACT_RU_VARIABLE" ("EXECUTION_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_IDX_VAR_PROCINST
--------------------------------------------------------

  CREATE INDEX "ACT_IDX_VAR_PROCINST" ON "ACT_RU_VARIABLE" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index ACT_UNIQ_PROCDEF
--------------------------------------------------------

  CREATE UNIQUE INDEX "ACT_UNIQ_PROCDEF" ON "ACT_RE_PROCDEF" ("KEY_", "VERSION_", "TENANT_ID_") ;
--------------------------------------------------------
--  DDL for Index APPROVALRULEHANDLERGROUP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPROVALRULEHANDLERGROUP_PK" ON "WF_APPROVALRULEHANDLERGROUP" ("ID") ;
--------------------------------------------------------
--  DDL for Index APPROVALRULEHANDLERUIPERM_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "APPROVALRULEHANDLERUIPERM_PK" ON "WF_APPROVALRULEHANDLERUIPERM" ("ID") ;
--------------------------------------------------------
--  DDL for Index BASESEGMENTATIONTYPE_AUTHORIZE
--------------------------------------------------------

  CREATE INDEX "BASESEGMENTATIONTYPE_AUTHORIZE" ON "WF_BIZSEGMENTATIONAUTHORIZE" ("BASE_SEGMENTATION_TYPE_ID") ;
--------------------------------------------------------
--  DDL for Index BIZMANAGEMENT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "BIZMANAGEMENT_PK" ON "SA_OPBIZMANAGEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index BIZSEGMENTATION_HANDLER_FK
--------------------------------------------------------

  CREATE INDEX "BIZSEGMENTATION_HANDLER_FK" ON "WF_SEGMENTATIONHANDLER" ("SEGMENTATION_ID") ;
--------------------------------------------------------
--  DDL for Index CODEBUILDRULE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "CODEBUILDRULE_PK" ON "SA_CODEBUILDRULE" ("ID") ;
--------------------------------------------------------
--  DDL for Index DATAIMPORTLOG_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DATAIMPORTLOG_PK" ON "SA_EXCELIMPORTLOG" ("ID") ;
--------------------------------------------------------
--  DDL for Index DATAIMPORTTEMPLATEDETAIL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DATAIMPORTTEMPLATEDETAIL_PK" ON "SA_EXCELIMPORTTEMPLATEDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index DATAIMPORTTEMPLATE_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DATAIMPORTTEMPLATE_PK" ON "SA_EXCELIMPORTTEMPLATE" ("ID") ;
--------------------------------------------------------
--  DDL for Index DICTIONARYDETAIL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "DICTIONARYDETAIL_PK" ON "SA_DICTIONARYDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index FK_BASEFUNCTIONTYPE_BASE
--------------------------------------------------------

  CREATE INDEX "FK_BASEFUNCTIONTYPE_BASE" ON "SA_OPBIZFUNCTIONOWNBASE" ("BASE_FUNCTION_TYPE_ID") ;
--------------------------------------------------------
--  DDL for Index FK_BIZFUNCTION_BASE
--------------------------------------------------------

  CREATE INDEX "FK_BIZFUNCTION_BASE" ON "SA_OPBIZFUNCTIONOWNBASE" ("BIZ_FUNCTION_ID") ;
--------------------------------------------------------
--  DDL for Index FK_R_OPERATIONLOG_DETAIL
--------------------------------------------------------

  CREATE INDEX "FK_R_OPERATIONLOG_DETAIL" ON "SA_OPERATIONLOGDETAIL" ("OPERATIONLOG_ID") ;
--------------------------------------------------------
--  DDL for Index HISTORICSESSION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "HISTORICSESSION_PK" ON "SA_HISTORICSESSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index IDX1_SYS_COMMON_HANDLER
--------------------------------------------------------

  CREATE INDEX "IDX1_SYS_COMMON_HANDLER" ON "SA_COMMONHANDLER" ("BIZ_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_ATTACHMENTCONFIG_FID
--------------------------------------------------------

  CREATE INDEX "IDX_ATTACHMENTCONFIG_FID" ON "SA_ATTACHMENTCONFIG" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_BIZCLASSIFICATION_PID
--------------------------------------------------------

  CREATE INDEX "IDX_BIZCLASSIFICATION_PID" ON "SA_BIZCLASSIFICATION" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_CODEBUILDRULE_FID
--------------------------------------------------------

  CREATE INDEX "IDX_CODEBUILDRULE_FID" ON "SA_CODEBUILDRULE" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_COMMONTREE_KIND_ID
--------------------------------------------------------

  CREATE INDEX "IDX_COMMONTREE_KIND_ID" ON "SA_COMMONTREE" ("KIND_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_COMMONTREE_PID
--------------------------------------------------------

  CREATE INDEX "IDX_COMMONTREE_PID" ON "SA_COMMONTREE" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_DICTIONARY_FID
--------------------------------------------------------

  CREATE INDEX "IDX_DICTIONARY_FID" ON "SA_DICTIONARY" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_FLEXFIELDSTORAGE
--------------------------------------------------------

  CREATE INDEX "IDX_FLEXFIELDSTORAGE" ON "SA_FLEXFIELDSTORAGE" ("BIZ_KIND_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_FLEXFIELDSTORAGE_BIZ
--------------------------------------------------------

  CREATE INDEX "IDX_FLEXFIELDSTORAGE_BIZ" ON "SA_FLEXFIELDSTORAGE" ("BIZ_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_PROCUNITHANDLERINST_BP
--------------------------------------------------------

  CREATE INDEX "IDX_HI_PROCUNITHANDLERINST_BP" ON "WF_HI_PROCUNITHANDLERINST" ("BIZ_ID", "PROC_UNIT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_PROCUNITHANDLER_BIZCODE
--------------------------------------------------------

  CREATE INDEX "IDX_HI_PROCUNITHANDLER_BIZCODE" ON "WF_HI_PROCUNITHANDLER" ("BIZ_CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_PROCUNITHANDLER_BIZID
--------------------------------------------------------

  CREATE INDEX "IDX_HI_PROCUNITHANDLER_BIZID" ON "WF_HI_PROCUNITHANDLER" ("BIZ_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASKINST_ET
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASKINST_ET" ON "ACT_HI_TASKINST" ("END_TIME_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_BIZCODE
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_BIZCODE" ON "ACT_HI_TASKINST_EXTENSION" ("BUSINESS_CODE_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_BIZID
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_BIZID" ON "ACT_HI_TASKINST_EXTENSION" ("BUSINESS_KEY_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_CREATOR
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_CREATOR" ON "ACT_HI_TASKINST_EXTENSION" ("CREATOR_PERSON_MEMBER_ID_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_EXT_EPMID
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_EXT_EPMID" ON "ACT_HI_TASKINST_EXTENSION" ("EXECUTOR_PERSON_MEMBER_ID_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_START_TIME
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_START_TIME" ON "ACT_HI_TASKINST_EXTENSION" ("START_TIME_") ;
--------------------------------------------------------
--  DDL for Index IDX_HI_TASK_UHID
--------------------------------------------------------

  CREATE INDEX "IDX_HI_TASK_UHID" ON "ACT_HI_TASKINST_EXTENSION" ("PROC_UNIT_HANDLER_ID_") ;
--------------------------------------------------------
--  DDL for Index IDX_HPE_BUSINESS_KEY
--------------------------------------------------------

  CREATE INDEX "IDX_HPE_BUSINESS_KEY" ON "ACT_HI_PROCINST_EXTENSION" ("BUSINESS_KEY_") ;
--------------------------------------------------------
--  DDL for Index IDX_ONLINESESSION_SID
--------------------------------------------------------

  CREATE INDEX "IDX_ONLINESESSION_SID" ON "SA_ONLINESESSION" ("SESSION_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPBIZMANAGEMENTTYPE_PID
--------------------------------------------------------

  CREATE INDEX "IDX_OPBIZMANAGEMENTTYPE_PID" ON "SA_OPBIZMANAGEMENTTYPE" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPDATAMANAGEBUSINESS
--------------------------------------------------------

  CREATE INDEX "IDX_OPDATAMANAGEBUSINESS" ON "SA_OPDATAMANAGEBUSINESS" ("DATA_MANAGE_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPDATAMANAGEBUSINESS_FIELD
--------------------------------------------------------

  CREATE INDEX "IDX_OPDATAMANAGEBUSINESS_FIELD" ON "SA_OPDATAMANAGEBUSINESS_FIELD" ("DATAMANAGEBUSINESS_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPDATAMANAGEDETAILRESOURCE
--------------------------------------------------------

  CREATE INDEX "IDX_OPDATAMANAGEDETAILRESOURCE" ON "SA_OPDATAMANAGEDETAILRESOURCE" ("DATA_MANAGEDETAL_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPORGTEMPLATE_PID
--------------------------------------------------------

  CREATE INDEX "IDX_OPORGTEMPLATE_PID" ON "SA_OPORGTEMPLATE" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPORGTYPE_FID
--------------------------------------------------------

  CREATE INDEX "IDX_OPORGTYPE_FID" ON "SA_OPORGTYPE" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPORG_ORG_ID
--------------------------------------------------------

  CREATE INDEX "IDX_OPORG_ORG_ID" ON "SA_OPORG" ("ORG_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPPERMISSION_FID
--------------------------------------------------------

  CREATE INDEX "IDX_OPPERMISSION_FID" ON "SA_OPPERMISSION" ("FULL_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPPERMISSION_PID
--------------------------------------------------------

  CREATE INDEX "IDX_OPPERMISSION_PID" ON "SA_OPPERMISSION" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPPERMISSION_RID
--------------------------------------------------------

  CREATE INDEX "IDX_OPPERMISSION_RID" ON "SA_OPPERMISSION" ("RESOURCE_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPROLEPERMISSION_RPID
--------------------------------------------------------

  CREATE INDEX "IDX_OPROLEPERMISSION_RPID" ON "SA_OPROLEPERMISSION" ("ROLE_ID", "PERMISSION_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_OPUIELEMENT_FID
--------------------------------------------------------

  CREATE INDEX "IDX_OPUIELEMENT_FID" ON "SA_OPUIELEMENT" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_PARAMETER_FID
--------------------------------------------------------

  CREATE INDEX "IDX_PARAMETER_FID" ON "SA_PARAMETER" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_PROCDEF_CODE
--------------------------------------------------------

  CREATE INDEX "IDX_PROCDEF_CODE" ON "WF_PROCDEF" ("CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_PROCDEF_PID
--------------------------------------------------------

  CREATE INDEX "IDX_PROCDEF_PID" ON "WF_PROCDEF" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_PROCUNITHANDLER_BIZCODE
--------------------------------------------------------

  CREATE INDEX "IDX_PROCUNITHANDLER_BIZCODE" ON "WF_PROCUNITHANDLER" ("BIZ_CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_PROCUNITHANDLER_BIZID
--------------------------------------------------------

  CREATE INDEX "IDX_PROCUNITHANDLER_BIZID" ON "WF_PROCUNITHANDLER" ("BIZ_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_ROLE_CODE
--------------------------------------------------------

  CREATE INDEX "IDX_ROLE_CODE" ON "SA_OPROLE" ("CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_ROLE_PID
--------------------------------------------------------

  CREATE INDEX "IDX_ROLE_PID" ON "SA_OPROLE" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_RU_TASK_BIZCODE
--------------------------------------------------------

  CREATE INDEX "IDX_RU_TASK_BIZCODE" ON "ACT_RU_TASK_EXTENSION" ("BUSINESS_CODE_") ;
--------------------------------------------------------
--  DDL for Index IDX_RU_TASK_BIZKEY
--------------------------------------------------------

  CREATE INDEX "IDX_RU_TASK_BIZKEY" ON "ACT_RU_TASK_EXTENSION" ("BUSINESS_KEY_") ;
--------------------------------------------------------
--  DDL for Index IDX_RU_TASK_EXTENSION_EPMID
--------------------------------------------------------

  CREATE INDEX "IDX_RU_TASK_EXTENSION_EPMID" ON "ACT_RU_TASK_EXTENSION" ("EXECUTOR_PERSON_MEMBER_ID_") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_ATTACHMENT
--------------------------------------------------------

  CREATE INDEX "IDX_SA_ATTACHMENT" ON "SA_ATTACHMENT" ("BIZ_KIND_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_ATTACHMENT_BIZID
--------------------------------------------------------

  CREATE INDEX "IDX_SA_ATTACHMENT_BIZID" ON "SA_ATTACHMENT" ("BIZ_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGEBUSINESS
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGEBUSINESS" ON "SA_OPDATAMANAGEBUSINESS" ("CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGEDETAIL
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGEDETAIL" ON "SA_OPDATAMANAGEDETAIL" ("DATA_MANAGE_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGEMENT
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGEMENT" ON "SA_OPDATAMANAGEMENT" ("MANAGER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGEMENTDETAIL
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGEMENTDETAIL" ON "SA_OPDATAMANAGEMENT" ("DATA_MANAGEDETAL_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGENTID
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGENTID" ON "SA_OPDATAMANAGEMENT" ("DATA_MANAGE_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGETYPE
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGETYPE" ON "SA_OPDATAMANAGETYPE" ("CODE") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPDATAMANAGETYPEKIND
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPDATAMANAGETYPEKIND" ON "SA_OPDATAMANAGETYPEKIND" ("DATA_MANAGE_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_OPPERSON_LOGIN
--------------------------------------------------------

  CREATE INDEX "IDX_SA_OPPERSON_LOGIN" ON "SA_OPPERSON" (UPPER("LOGIN_NAME")) ;
--------------------------------------------------------
--  DDL for Index IDX_SA_PDSCREEN
--------------------------------------------------------

  CREATE INDEX "IDX_SA_PDSCREEN" ON "SA_PDSCREEN" ("PERSON_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_PDSCREENFUNCTION
--------------------------------------------------------

  CREATE INDEX "IDX_SA_PDSCREENFUNCTION" ON "SA_PDSCREENFUNCTION" ("SCREEN_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_PDSCREENFUNCTION_FUN
--------------------------------------------------------

  CREATE INDEX "IDX_SA_PDSCREENFUNCTION_FUN" ON "SA_PDSCREENFUNCTION" ("FUNCTION_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_PERSONCALENDAR
--------------------------------------------------------

  CREATE INDEX "IDX_SA_PERSONCALENDAR" ON "SA_PERSONCALENDAR" ("PERSON_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SA_SCHEDULING_JOB_LOG
--------------------------------------------------------

  CREATE INDEX "IDX_SA_SCHEDULING_JOB_LOG" ON "SA_SCHEDULING_JOB_LOG" ("JOB_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_SYS_COMMON_HANDLER
--------------------------------------------------------

  CREATE INDEX "IDX_SYS_COMMON_HANDLER" ON "SA_COMMONHANDLER" ("ORG_KIND_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_TASKINST_RELATION_BIZ_ID
--------------------------------------------------------

  CREATE INDEX "IDX_TASKINST_RELATION_BIZ_ID" ON "ACT_HI_TASKINST_RELATION" ("BUSINESS_KEY") ;
--------------------------------------------------------
--  DDL for Index IDX_UGD_GID
--------------------------------------------------------

  CREATE INDEX "IDX_UGD_GID" ON "SA_USERGROUPDETAIL" ("GROUP_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_USERGROUP_FID
--------------------------------------------------------

  CREATE INDEX "IDX_USERGROUP_FID" ON "SA_USERGROUP" ("FOLDER_ID") ;
--------------------------------------------------------
--  DDL for Index IDX_WF_PROCDEF
--------------------------------------------------------

  CREATE INDEX "IDX_WF_PROCDEF" ON "WF_PROCDEF" ("PROC_ID") ;
--------------------------------------------------------
--  DDL for Index IX_APPROVALELEMENT_CODE
--------------------------------------------------------

  CREATE INDEX "IX_APPROVALELEMENT_CODE" ON "WF_APPROVALELEMENT" ("CODE") ;
--------------------------------------------------------
--  DDL for Index IX_APPROVALRULEELEMENT_MID
--------------------------------------------------------

  CREATE INDEX "IX_APPROVALRULEELEMENT_MID" ON "WF_APPROVALRULEELEMENT" ("APPROVAL_RULE_ID") ;
--------------------------------------------------------
--  DDL for Index IX_APPROVALRULE_PARENT_ID
--------------------------------------------------------

  CREATE INDEX "IX_APPROVALRULE_PARENT_ID" ON "WF_APPROVALRULE" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IX_ARH_PARENT_ID1
--------------------------------------------------------

  CREATE INDEX "IX_ARH_PARENT_ID1" ON "WF_APPROVALRULEHANDLER" ("APPROVAL_RULE_ID") ;
--------------------------------------------------------
--  DDL for Index IX_HI_TASKINST_PIID
--------------------------------------------------------

  CREATE INDEX "IX_HI_TASKINST_PIID" ON "ACT_HI_TASKINST" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index IX_OPFFG_FUNCTION_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPFFG_FUNCTION_ID" ON "SA_OPFUNCTION_FIELD_GROUP" ("FUNCTION_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPFP_FFGID
--------------------------------------------------------

  CREATE INDEX "IX_OPFP_FFGID" ON "SA_OPFUNCTION_PERMISSIONFIELD" ("FUNCTION_FIELD_GROUP_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPFUNCTION_PID
--------------------------------------------------------

  CREATE INDEX "IX_OPFUNCTION_PID" ON "SA_OPFUNCTION" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORGPROPERTY_ORG_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORGPROPERTY_ORG_ID" ON "SA_OPORGPROPERTY" ("ORG_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORG_DEPT_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORG_DEPT_ID" ON "SA_OPORG" ("DEPT_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORG_FULL_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORG_FULL_ID" ON "SA_OPORG" ("FULL_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORG_KIND_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORG_KIND_ID" ON "SA_OPORG" ("ORG_KIND_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORG_PARENT_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORG_PARENT_ID" ON "SA_OPORG" ("PARENT_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPORG_PERSON_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPORG_PERSON_ID" ON "SA_OPORG" ("PERSON_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPREMIND_REMIND_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPREMIND_REMIND_ID" ON "SA_OPREMIND" ("REMIND_ID") ;
--------------------------------------------------------
--  DDL for Index IX_OPREMIND_ROLE_ID
--------------------------------------------------------

  CREATE INDEX "IX_OPREMIND_ROLE_ID" ON "SA_OPREMIND" ("ROLE_ID") ;
--------------------------------------------------------
--  DDL for Index IX_SA_PERSON_CODE
--------------------------------------------------------

  CREATE INDEX "IX_SA_PERSON_CODE" ON "SA_OPPERSON" ("CODE") ;
--------------------------------------------------------
--  DDL for Index ONLINESESSION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ONLINESESSION_PK" ON "SA_ONLINESESSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index OPOPERATION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OPOPERATION_PK" ON "SA_OPOPERATION" ("ID") ;
--------------------------------------------------------
--  DDL for Index OPORGPROPERTYDEFINITION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OPORGPROPERTYDEFINITION_PK" ON "SA_OPORGPROPERTYDEFINITION" ("ID") ;
--------------------------------------------------------
--  DDL for Index OPUIELEMENTPERMISSION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "OPUIELEMENTPERMISSION_PK" ON "SA_OPUIELEMENTPERMISSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PDSCREENFUNCTION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PDSCREENFUNCTION_PK" ON "SA_PDSCREENFUNCTION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PDSCREEN_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PDSCREEN_PK" ON "SA_PDSCREEN" ("ID") ;
--------------------------------------------------------
--  DDL for Index PKHI_TASKINST_EXTEND_ID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PKHI_TASKINST_EXTEND_ID" ON "ACT_HI_TASKINST_EXTENSION" ("ID_") ;
--------------------------------------------------------
--  DDL for Index PK_ACT_RE_PROCDEF_TREE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ACT_RE_PROCDEF_TREE" ON "ACT_RE_PROCDEF_TREE_DEL" ("RE_PROCDEF_TREE_ID") ;
--------------------------------------------------------
--  DDL for Index PK_ACT_RU_EVENT_SUBSCR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ACT_RU_EVENT_SUBSCR" ON "ACT_RU_EVENT_SUBSCR" ("ID_") ;
--------------------------------------------------------
--  DDL for Index PK_AGENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_AGENT" ON "SA_OPAGENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_APPROVALRULEHANDLERASSIST
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_APPROVALRULEHANDLERASSIST" ON "WF_APPROVALRULEHANDLERASSIST" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_ATTACHMENTCONFIG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ATTACHMENTCONFIG" ON "SA_ATTACHMENTCONFIG" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_ATTACHMENTCONFIGDETAIL
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_ATTACHMENTCONFIGDETAIL" ON "SA_ATTACHMENTCONFIGDETAIL" ("ID") ;

--------------------------------------------------------
--  DDL for Index PK_BIZCLASSIFICATION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_BIZCLASSIFICATION" ON "SA_BIZCLASSIFICATION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_BIZSEGMENTATIONAUTHORIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_BIZSEGMENTATIONAUTHORIZE" ON "WF_BIZSEGMENTATIONAUTHORIZE" ("BIZ_SEGMENTATION_AUTHORIZE_ID") ;
--------------------------------------------------------
--  DDL for Index PK_COMMONTREE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_COMMONTREE" ON "SA_COMMONTREE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_DICTIONARY
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_DICTIONARY" ON "SA_DICTIONARY" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_FLEXFIELDBIZGROUPFIELD
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_FLEXFIELDBIZGROUPFIELD" ON "SA_FLEXFIELDBIZGROUPFIELD" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_HANDLER_AUTH_ID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_HANDLER_AUTH_ID" ON "WF_APPROVALRULEHANDLER_AUTH" ("HANDLER_AUTH_ID") ;
--------------------------------------------------------
--  DDL for Index PK_HI_PROCINST_EXTENSION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_HI_PROCINST_EXTENSION" ON "ACT_HI_PROCINST_EXTENSION" ("ID_") ;
--------------------------------------------------------
--  DDL for Index PK_HI_PROCUNITHANDLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_HI_PROCUNITHANDLER" ON "WF_HI_PROCUNITHANDLER" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_HI_PROCUNITHANDLERINST
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_HI_PROCUNITHANDLERINST" ON "WF_HI_PROCUNITHANDLERINST" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_MESSAGE_REMIND
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_MESSAGE_REMIND" ON "SA_MESSAGE_REMIND" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPAUTHORIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPAUTHORIZE" ON "SA_OPAUTHORIZE" ("ORG_ID", "ROLE_ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPORGROLEAUTHORIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPORGROLEAUTHORIZE" ON "SA_OPORGROLEAUTHORIZE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPORGTEMPLATE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPORGTEMPLATE" ON "SA_OPORGTEMPLATE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPORGTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPORGTYPE" ON "SA_OPORGTYPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPPERMISSION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPPERMISSION" ON "SA_OPPERMISSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPTENANT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPTENANT" ON "SA_OPTENANT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_OPUIELEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_OPUIELEMENT" ON "SA_OPUIELEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_PARAMETER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_PARAMETER" ON "SA_PARAMETER" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_PK_SA_I18NPROPERTIES
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_PK_SA_I18NPROPERTIES" ON "SA_I18NPROPERTIES" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_PROCDEF
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_PROCDEF" ON "WF_PROCDEF" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_RU_TASK_EXTEND_ID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_RU_TASK_EXTEND_ID" ON "ACT_RU_TASK_EXTENSION" ("ID_") ;
--------------------------------------------------------
--  DDL for Index PK_SA_APPLICATIONSYSTEM
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_APPLICATIONSYSTEM" ON "SA_APPLICATIONSYSTEM" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_APPROVAL_REJECTED_REASON
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_APPROVAL_REJECTED_REASON" ON "SA_APPROVAL_REJECTED_REASON" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_ATTACHMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_ATTACHMENT" ON "SA_ATTACHMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_BIZCLASSIFICATIONDETAIL
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_BIZCLASSIFICATIONDETAIL" ON "SA_BIZCLASSIFICATIONDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_FLEXFIELDBIZGROUP
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_FLEXFIELDBIZGROUP" ON "SA_FLEXFIELDBIZGROUP" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_FLEXFIELDDEFINITION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_FLEXFIELDDEFINITION" ON "SA_FLEXFIELDDEFINITION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_FLEXFIELDSTORAGE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_FLEXFIELDSTORAGE" ON "SA_FLEXFIELDSTORAGE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_MACHINE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_MACHINE" ON "SA_MACHINE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPAGENTPROC
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPAGENTPROC" ON "SA_OPAGENTPROC" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPBASEFUNCTIONTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPBASEFUNCTIONTYPE" ON "SA_OPBASEFUNCTIONTYPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPBIZFUNCTION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPBIZFUNCTION" ON "SA_OPBIZFUNCTION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPBIZFUNCTIONOWNBASE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPBIZFUNCTIONOWNBASE" ON "SA_OPBIZFUNCTIONOWNBASE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPBIZMANAGEMENTTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPBIZMANAGEMENTTYPE" ON "SA_OPBIZMANAGEMENTTYPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAKIND
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAKIND" ON "SA_OPDATAKIND" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGDETAILRESOURC
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGDETAILRESOURC" ON "SA_OPDATAMANAGEDETAILRESOURCE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGEBUSINESS
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGEBUSINESS" ON "SA_OPDATAMANAGEBUSINESS" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGEBUSINESS_FIE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGEBUSINESS_FIE" ON "SA_OPDATAMANAGEBUSINESS_FIELD" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGEDETAIL
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGEDETAIL" ON "SA_OPDATAMANAGEDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGEMENT" ON "SA_OPDATAMANAGEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGETYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGETYPE" ON "SA_OPDATAMANAGETYPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPDATAMANAGETYPEKIND
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPDATAMANAGETYPEKIND" ON "SA_OPDATAMANAGETYPEKIND" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPERATIONLOG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPERATIONLOG" ON "SA_OPERATIONLOG_BAK" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPERATIONLOGDETAIL
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPERATIONLOGDETAIL" ON "SA_OPERATIONLOGDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPERATIONLOG_NEW
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPERATIONLOG_NEW" ON "SA_OPERATIONLOG" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPFUNCTION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPFUNCTION" ON "SA_OPFUNCTION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPFUNCTION_FIELD_GROUP
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPFUNCTION_FIELD_GROUP" ON "SA_OPFUNCTION_FIELD_GROUP" ("FUNCTION_FIELD_GROUP_ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPFUNCTION_PERMISSIONFIE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPFUNCTION_PERMISSIONFIE" ON "SA_OPFUNCTION_PERMISSIONFIELD" ("PERMISSION_FIELD_ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPMANAGEMENTTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPMANAGEMENTTYPE" ON "SA_OPBASEMANAGEMENTTYPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPORG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPORG" ON "SA_OPORG" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPPERSON
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPPERSON" ON "SA_OPPERSON" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPREMIND
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPREMIND" ON "SA_OPREMIND" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_OPROLE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_OPROLE" ON "SA_OPROLE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_ORGFUN
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_ORGFUN" ON "SA_ORGFUN" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_PERSONACCOUNTMANAGEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_PERSONACCOUNTMANAGEMENT" ON "SA_PERSONACCOUNTMANAGEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_PERSONCALENDAR
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_PERSONCALENDAR" ON "SA_PERSONCALENDAR" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_PERSONLOGINLIMIT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_PERSONLOGINLIMIT" ON "SA_PERSONLOGINLIMIT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_PERSONQUERYSCHEME
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_PERSONQUERYSCHEME" ON "SA_PERSONQUERYSCHEME" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_SCHEDULING_JOB
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_SCHEDULING_JOB" ON "SA_SCHEDULING_JOB" ("JOB_ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_SECURITYPOLICY
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_SECURITYPOLICY" ON "SA_SECURITYPOLICY" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_SYNBASEDATAVERSION_ID
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_SYNBASEDATAVERSION_ID" ON "SA_SYNBASEDATAVERSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SA_TSAUTHORIZE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SA_TSAUTHORIZE" ON "SA_TMAUTHORIZE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SCHEDULING_JOB_LOG
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SCHEDULING_JOB_LOG" ON "SA_SCHEDULING_JOB_LOG" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SYS_COMMON_HANDLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SYS_COMMON_HANDLER" ON "SA_COMMONHANDLER" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SYS_ORG_PROPERTY
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SYS_ORG_PROPERTY" ON "SA_OPORGPROPERTY" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_SYS_PERSON_TASK_COLLECT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_SYS_PERSON_TASK_COLLECT" ON "WF_TASKCOLLECTION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_TASKINST_RELATION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_TASKINST_RELATION" ON "ACT_HI_TASKINST_RELATION" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALELEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALELEMENT" ON "WF_APPROVALELEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALHANDLERKIND
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALHANDLERKIND" ON "WF_APPROVALHANDLERKIND" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALRULE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALRULE" ON "WF_APPROVALRULE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALRULEELEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALRULEELEMENT" ON "WF_APPROVALRULEELEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALRULEHANDLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALRULEHANDLER" ON "WF_APPROVALRULEHANDLER" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_APPROVALRULESCOPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_APPROVALRULESCOPE" ON "WF_APPROVALRULESCOPE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_BASESEGMENTATIONTYPE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_BASESEGMENTATIONTYPE" ON "WF_BASESEGMENTATIONTYPE" ("BASE_SEGMENTATION_TYPE_ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_BIZSEGMENTATION
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_BIZSEGMENTATION" ON "WF_BIZSEGMENTATION" ("BIZ_SEGMENTATION_ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_BIZSEGMENTATIONHANDLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_BIZSEGMENTATIONHANDLER" ON "WF_SEGMENTATIONHANDLER" ("SEGMENTATION_HANDLER_ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_PROCAPPROVALELEMENT
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_PROCAPPROVALELEMENT" ON "WF_PROCAPPROVALELEMENT" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_PROCUNITHANDLER
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_PROCUNITHANDLER" ON "WF_PROCUNITHANDLER" ("ID") ;
--------------------------------------------------------
--  DDL for Index PK_WF_PROCUNITHANDLER_CACHE
--------------------------------------------------------

  CREATE UNIQUE INDEX "PK_WF_PROCUNITHANDLER_CACHE" ON "WF_PROCUNITHANDLER_CACHE" ("ID") ;
--------------------------------------------------------
--  DDL for Index PROCUNITHANDLERMANUSCRIPT_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "PROCUNITHANDLERMANUSCRIPT_PK" ON "WF_PROCUNITHANDLERMANUSCRIPT" ("ID") ;
--------------------------------------------------------
--  DDL for Index ROLEPERMISSION_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "ROLEPERMISSION_PK" ON "SA_OPROLEPERMISSION" ("ID") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014686
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014686" ON "ACT_GE_PROPERTY" ("NAME_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014687
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014687" ON "ACT_HI_ACTINST" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014688
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014688" ON "ACT_HI_IDENTITYLINK" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014689
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014689" ON "ACT_HI_PROCINST" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014690
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014690" ON "ACT_HI_PROCINST" ("PROC_INST_ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014692
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014692" ON "ACT_HI_TASKINST" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014695
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014695" ON "ACT_HI_VARINST" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014696
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014696" ON "ACT_RE_DEPLOYMENT" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014703
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014703" ON "ACT_RE_PROCDEF" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014748
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014748" ON "ACT_RU_EXECUTION" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014774
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014774" ON "ACT_RU_IDENTITYLINK" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014779
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014779" ON "ACT_RU_JOB" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014780
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014780" ON "ACT_RU_TASK" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0014782
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0014782" ON "ACT_RU_VARIABLE" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0015195
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0015195" ON "ACT_GE_BYTEARRAY" ("ID_") ;
--------------------------------------------------------
--  DDL for Index SYS_C0015198
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0015198" ON "ACT_HI_COMMENT" ("ID_") ;
--------------------------------------------------------
--  DDL for Index USERGROUPDETAIL_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "USERGROUPDETAIL_PK" ON "SA_USERGROUPDETAIL" ("ID") ;
--------------------------------------------------------
--  DDL for Index USERGROUP_PK
--------------------------------------------------------

  CREATE UNIQUE INDEX "USERGROUP_PK" ON "SA_USERGROUP" ("ID") ;
--------------------------------------------------------
--  DDL for Procedure P_UPDATE_COMMONTREE_FULLINFO
--------------------------------------------------------
set define off;

  CREATE OR REPLACE PROCEDURE "P_UPDATE_COMMONTREE_FULLINFO" is
  procedure update_full_info(p_parent_id        varchar2,
                             p_parent_full_name varchar2) is
    cursor cur_commontree is
      select * from sa_commontree t where t.parent_id = p_parent_id;
  begin
    update sa_commontree t
       set t.full_name = p_parent_full_name || '/' || t.name
     where t.parent_id = p_parent_id;
  
    for commontree in cur_commontree loop
      update_full_info(commontree.id, commontree.full_name);
    end loop;
  end;
begin
  update_full_info('0', '');
end p_update_commontree_fullinfo;

 
 
 

/
--------------------------------------------------------
--  DDL for Procedure P_UPDATE_MANAGETYPE_FULLINFO
--------------------------------------------------------
set define off;

  CREATE OR REPLACE PROCEDURE "P_UPDATE_MANAGETYPE_FULLINFO" is
  procedure update_full_info(p_parent_id        varchar2,
                             p_parent_full_id varchar2,
                             p_parent_full_name varchar2) is
    cursor cur_managementtype is
      select * from sa_opbizmanagementtype t where t.parent_id = p_parent_id;
  begin
    update sa_opbizmanagementtype t
       set t.full_name = p_parent_full_name || '/' || t.name,
           t.full_id = p_parent_full_id  || '/' || t.id
     where t.parent_id = p_parent_id;
  
    for managementtype in cur_managementtype loop
      update_full_info(managementtype.id, managementtype.full_id, managementtype.full_name);
    end loop;
  end;
begin
  update_full_info('0', '', '');
end p_update_managetype_fullinfo;

 
 
 

/
--------------------------------------------------------
--  DDL for Procedure P_UPDATE_OPFUNCTION_FULLINFO
--------------------------------------------------------
set define off;

  CREATE OR REPLACE PROCEDURE "P_UPDATE_OPFUNCTION_FULLINFO" is
  procedure update_full_info(p_parent_id        varchar2,
                             p_parent_full_name varchar2) is
    cursor cur_function is
      select * from sa_opfunction t where t.parent_id = p_parent_id;
  begin
    update sa_opfunction t
       set t.full_name = p_parent_full_name || '/' || t.name
     where t.parent_id = p_parent_id;
  
    for opfunction in cur_function loop
      update_full_info(opfunction.id, opfunction.full_name);
    end loop;
  end;
begin
  update_full_info('0', '');
end p_update_opfunction_fullinfo;

 
 
 

/
--------------------------------------------------------
--  DDL for Procedure P_UPDATE_ROLE_FULLINFO
--------------------------------------------------------
set define off;

  CREATE OR REPLACE PROCEDURE "P_UPDATE_ROLE_FULLINFO" is
  procedure update_full_info(p_parent_id        varchar2,
                             p_parent_full_id   varchar2,
                             p_parent_full_name varchar2) is
    cursor cur_role is
      select * from sa_oprole t where t.parent_id = p_parent_id;
  begin
    update sa_oprole t
       set t.full_id = p_parent_full_id || '/' || t.id,
           t.full_name = p_parent_full_name || '/' || t.name
     where t.parent_id = p_parent_id;
  
    for oprole in cur_role loop
      update_full_info(oprole.id, oprole.full_id, oprole.full_name);
    end loop;
  end;
begin
  update_full_info('0', '', '');
end p_update_role_fullinfo;

 
 
 

/
--------------------------------------------------------
--  Constraints for Table ACT_GE_BYTEARRAY
--------------------------------------------------------

  ALTER TABLE "ACT_GE_BYTEARRAY" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_GE_BYTEARRAY" ADD PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_GE_BYTEARRAY" ADD CHECK (GENERATED_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_GE_BYTEARRAY" ADD CHECK (GENERATED_ IN (1,0)) ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_GE_PROPERTY
--------------------------------------------------------

  ALTER TABLE "ACT_GE_PROPERTY" MODIFY ("NAME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_GE_PROPERTY" ADD PRIMARY KEY ("NAME_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_ACTINST
--------------------------------------------------------

  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("PROC_DEF_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("PROC_INST_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("EXECUTION_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("ACT_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("ACT_TYPE_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" MODIFY ("START_TIME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_ACTINST" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_COMMENT
--------------------------------------------------------

  ALTER TABLE "ACT_HI_COMMENT" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_COMMENT" MODIFY ("TIME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_COMMENT" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_IDENTITYLINK
--------------------------------------------------------

  ALTER TABLE "ACT_HI_IDENTITYLINK" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_IDENTITYLINK" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_PROCINST
--------------------------------------------------------

  ALTER TABLE "ACT_HI_PROCINST" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_PROCINST" MODIFY ("PROC_INST_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_PROCINST" MODIFY ("PROC_DEF_ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_PROCINST" MODIFY ("START_TIME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_PROCINST" ADD PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_HI_PROCINST" ADD UNIQUE ("PROC_INST_ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_PROCINST_EXTENSION
--------------------------------------------------------

  ALTER TABLE "ACT_HI_PROCINST_EXTENSION" ADD CONSTRAINT "PK_HI_PROCINST_EXTENSION" PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_HI_PROCINST_EXTENSION" MODIFY ("ID_" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_HI_TASKINST
--------------------------------------------------------

  ALTER TABLE "ACT_HI_TASKINST" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_TASKINST" MODIFY ("START_TIME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_TASKINST" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_HI_TASKINST_EXTENSION
--------------------------------------------------------

  ALTER TABLE "ACT_HI_TASKINST_EXTENSION" ADD CONSTRAINT "PK_HI_TASKINST_EXTEND" PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_HI_TASKINST_EXTENSION" MODIFY ("ID_" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_HI_TASKINST_RELATION
--------------------------------------------------------

  ALTER TABLE "ACT_HI_TASKINST_RELATION" ADD CONSTRAINT "PK_TASKINST_RELATION" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "ACT_HI_TASKINST_RELATION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_HI_VARINST
--------------------------------------------------------

  ALTER TABLE "ACT_HI_VARINST" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_VARINST" MODIFY ("NAME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_HI_VARINST" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RE_DEPLOYMENT
--------------------------------------------------------

  ALTER TABLE "ACT_RE_DEPLOYMENT" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RE_DEPLOYMENT" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RE_PROCDEF
--------------------------------------------------------

  ALTER TABLE "ACT_RE_PROCDEF" ADD CONSTRAINT "ACT_UNIQ_PROCDEF" UNIQUE ("KEY_", "VERSION_", "TENANT_ID_") ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RE_PROCDEF" MODIFY ("KEY_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RE_PROCDEF" MODIFY ("VERSION_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_START_FORM_KEY_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_START_FORM_KEY_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_START_FORM_KEY_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_START_FORM_KEY_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF" ADD CHECK (HAS_GRAPHICAL_NOTATION_ IN (1,0)) ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RE_PROCDEF_TREE_DEL
--------------------------------------------------------

  ALTER TABLE "ACT_RE_PROCDEF_TREE_DEL" ADD CONSTRAINT "PK_ACT_RE_PROCDEF_TREE" PRIMARY KEY ("RE_PROCDEF_TREE_ID") ENABLE;
 
  ALTER TABLE "ACT_RE_PROCDEF_TREE_DEL" MODIFY ("RE_PROCDEF_TREE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_RU_EVENT_SUBSCR
--------------------------------------------------------

  ALTER TABLE "ACT_RU_EVENT_SUBSCR" ADD CONSTRAINT "PK_ACT_RU_EVENT_SUBSCR" PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_RU_EVENT_SUBSCR" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_EVENT_SUBSCR" MODIFY ("EVENT_TYPE_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_EVENT_SUBSCR" MODIFY ("CREATED_" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_RU_EXECUTION
--------------------------------------------------------

  ALTER TABLE "ACT_RU_EXECUTION" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_CONCURRENT_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_EVENT_SCOPE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_EXECUTION" ADD CHECK (IS_ACTIVE_ IN (1,0)) ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RU_IDENTITYLINK
--------------------------------------------------------

  ALTER TABLE "ACT_RU_IDENTITYLINK" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_IDENTITYLINK" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RU_JOB
--------------------------------------------------------

  ALTER TABLE "ACT_RU_JOB" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_JOB" MODIFY ("TYPE_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_JOB" ADD CHECK (EXCLUSIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_JOB" ADD CHECK (EXCLUSIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_JOB" ADD CHECK (EXCLUSIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_JOB" ADD CHECK (EXCLUSIVE_ IN (1,0)) ENABLE;
 
  ALTER TABLE "ACT_RU_JOB" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RU_TASK
--------------------------------------------------------

  ALTER TABLE "ACT_RU_TASK" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_TASK" ADD PRIMARY KEY ("ID_") ENABLE;
--------------------------------------------------------
--  Constraints for Table ACT_RU_TASK_EXTENSION
--------------------------------------------------------

  ALTER TABLE "ACT_RU_TASK_EXTENSION" ADD CONSTRAINT "PK_RU_TASK_EXTEND_ID" PRIMARY KEY ("ID_") ENABLE;
 
  ALTER TABLE "ACT_RU_TASK_EXTENSION" MODIFY ("ID_" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table ACT_RU_VARIABLE
--------------------------------------------------------

  ALTER TABLE "ACT_RU_VARIABLE" MODIFY ("ID_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_VARIABLE" MODIFY ("TYPE_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_VARIABLE" MODIFY ("NAME_" NOT NULL ENABLE);
 
  ALTER TABLE "ACT_RU_VARIABLE" ADD PRIMARY KEY ("ID_") ENABLE;

--------------------------------------------------------
--  Constraints for Table SA_APPLICATIONSYSTEM
--------------------------------------------------------

  ALTER TABLE "SA_APPLICATIONSYSTEM" ADD CONSTRAINT "PK_SA_APPLICATIONSYSTEM" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_APPROVAL_REJECTED_REASON
--------------------------------------------------------

  ALTER TABLE "SA_APPROVAL_REJECTED_REASON" ADD CONSTRAINT "PK_SA_APPROVAL_REJECTED_REASON" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_APPROVAL_REJECTED_REASON" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_ATTACHMENT
--------------------------------------------------------

  ALTER TABLE "SA_ATTACHMENT" ADD CONSTRAINT "PK_SA_ATTACHMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_ATTACHMENT" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_ATTACHMENT" MODIFY ("BIZ_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_ATTACHMENTCONFIG
--------------------------------------------------------

  ALTER TABLE "SA_ATTACHMENTCONFIG" ADD CONSTRAINT "PK_ATTACHMENTCONFIG" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_ATTACHMENTCONFIG" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_ATTACHMENTCONFIG" MODIFY ("CODE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_ATTACHMENTCONFIGDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_ATTACHMENTCONFIGDETAIL" ADD CONSTRAINT "PK_ATTACHMENTCONFIGDETAIL" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_ATTACHMENTCONFIGDETAIL" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_BIZCLASSIFICATION
--------------------------------------------------------

  ALTER TABLE "SA_BIZCLASSIFICATION" ADD CONSTRAINT "PK_BIZCLASSIFICATION" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_BIZCLASSIFICATION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_BIZCLASSIFICATIONDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_BIZCLASSIFICATIONDETAIL" ADD CONSTRAINT "PK_SA_BIZCLASSIFICATIONDETAIL" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_BIZCLASSIFICATIONDETAIL" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_CODEBUILDRULE
--------------------------------------------------------

  ALTER TABLE "SA_CODEBUILDRULE" ADD CONSTRAINT "PK_CODEBUILDRULE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_CODEBUILDRULE" MODIFY ("CODE" NOT NULL ENABLE);
 
  ALTER TABLE "SA_CODEBUILDRULE" MODIFY ("NAME" NOT NULL ENABLE);
 
  ALTER TABLE "SA_CODEBUILDRULE" MODIFY ("FOLDER_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_COMMONHANDLER
--------------------------------------------------------

  ALTER TABLE "SA_COMMONHANDLER" ADD CONSTRAINT "PK_SYS_COMMON_HANDLER" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_COMMONHANDLER" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_COMMONTREE
--------------------------------------------------------

  ALTER TABLE "SA_COMMONTREE" ADD CONSTRAINT "PK_COMMONTREE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_COMMONTREE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_DICTIONARY
--------------------------------------------------------

  ALTER TABLE "SA_DICTIONARY" ADD CONSTRAINT "PK_DICTIONARY" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_DICTIONARY" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_DICTIONARY" MODIFY ("CODE" NOT NULL ENABLE);
 
  ALTER TABLE "SA_DICTIONARY" MODIFY ("NAME" NOT NULL ENABLE);
 
  ALTER TABLE "SA_DICTIONARY" MODIFY ("FOLDER_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_DICTIONARYDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_DICTIONARYDETAIL" ADD CONSTRAINT "PK_SA_DICTIONARYDETAIL" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_DICTIONARYDETAIL" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_DICTIONARYDETAIL" MODIFY ("NAME" NOT NULL ENABLE);
 
  ALTER TABLE "SA_DICTIONARYDETAIL" MODIFY ("VALUE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_EXCELIMPORTLOG
--------------------------------------------------------

  ALTER TABLE "SA_EXCELIMPORTLOG" ADD CONSTRAINT "DATAIMPORTLOG_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_EXCELIMPORTLOG" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_EXCELIMPORTTEMPLATE
--------------------------------------------------------

  ALTER TABLE "SA_EXCELIMPORTTEMPLATE" ADD CONSTRAINT "DATAIMPORTTEMPLATE_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_EXCELIMPORTTEMPLATE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_EXCELIMPORTTEMPLATEDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" ADD CONSTRAINT "DATAIMPORTTEMPLATEDETAIL_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" MODIFY ("EXCEL_COLUMN_NUMBER" NOT NULL ENABLE);
 
  ALTER TABLE "SA_EXCELIMPORTTEMPLATEDETAIL" MODIFY ("EXCEL_COLUMN_NAME" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_FLEXFIELDBIZGROUP
--------------------------------------------------------

  ALTER TABLE "SA_FLEXFIELDBIZGROUP" ADD CONSTRAINT "PK_SA_FLEXFIELDBIZGROUP" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_FLEXFIELDBIZGROUPFIELD
--------------------------------------------------------

  ALTER TABLE "SA_FLEXFIELDBIZGROUPFIELD" ADD CONSTRAINT "PK_FLEXFIELDBIZGROUPFIELD" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_FLEXFIELDBIZGROUPFIELD" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_FLEXFIELDDEFINITION
--------------------------------------------------------

  ALTER TABLE "SA_FLEXFIELDDEFINITION" ADD CONSTRAINT "PK_SA_FLEXFIELDDEFINITION" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_FLEXFIELDSTORAGE
--------------------------------------------------------

  ALTER TABLE "SA_FLEXFIELDSTORAGE" ADD CONSTRAINT "PK_SA_FLEXFIELDSTORAGE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_FLEXFIELDSTORAGE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_HISTORICSESSION
--------------------------------------------------------

  ALTER TABLE "SA_HISTORICSESSION" ADD CONSTRAINT "HISTORICSESSION_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_HISTORICSESSION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_I18NPROPERTIES
--------------------------------------------------------

  ALTER TABLE "SA_I18NPROPERTIES" ADD CONSTRAINT "PK_PK_SA_I18NPROPERTIES" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_I18NPROPERTIES" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_MACHINE
--------------------------------------------------------

  ALTER TABLE "SA_MACHINE" ADD CONSTRAINT "PK_SA_MACHINE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_MACHINE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_MESSAGE_REMIND
--------------------------------------------------------

  ALTER TABLE "SA_MESSAGE_REMIND" ADD CONSTRAINT "PK_MESSAGE_REMIND" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_MESSAGE_REMIND" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_ONLINESESSION
--------------------------------------------------------

  ALTER TABLE "SA_ONLINESESSION" ADD CONSTRAINT "ONLINESESSION_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_ONLINESESSION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPAGENT
--------------------------------------------------------

  ALTER TABLE "SA_OPAGENT" ADD CONSTRAINT "PK_AGENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPAGENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPAGENTPROC
--------------------------------------------------------

  ALTER TABLE "SA_OPAGENTPROC" ADD CONSTRAINT "PK_SA_OPAGENTPROC" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPAUTHORIZE
--------------------------------------------------------

  ALTER TABLE "SA_OPAUTHORIZE" ADD CONSTRAINT "PK_OPAUTHORIZE" PRIMARY KEY ("ORG_ID", "ROLE_ID") ENABLE;
 
  ALTER TABLE "SA_OPAUTHORIZE" MODIFY ("ORG_ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPAUTHORIZE" MODIFY ("ROLE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPBASEFUNCTIONTYPE
--------------------------------------------------------

  ALTER TABLE "SA_OPBASEFUNCTIONTYPE" ADD CONSTRAINT "PK_SA_OPBASEFUNCTIONTYPE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPBASEFUNCTIONTYPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPBASEMANAGEMENTTYPE
--------------------------------------------------------

  ALTER TABLE "SA_OPBASEMANAGEMENTTYPE" ADD CONSTRAINT "BASEMANAGEMENTTYPE_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPBIZFUNCTION
--------------------------------------------------------

  ALTER TABLE "SA_OPBIZFUNCTION" ADD CONSTRAINT "PK_SA_OPBIZFUNCTION" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPBIZFUNCTION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPBIZFUNCTIONOWNBASE
--------------------------------------------------------

  ALTER TABLE "SA_OPBIZFUNCTIONOWNBASE" ADD CONSTRAINT "PK_SA_OPBIZFUNCTIONOWNBASE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPBIZFUNCTIONOWNBASE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPBIZMANAGEMENT
--------------------------------------------------------

  ALTER TABLE "SA_OPBIZMANAGEMENT" ADD CONSTRAINT "BIZMANAGEMENT_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPBIZMANAGEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPBIZMANAGEMENTTYPE
--------------------------------------------------------

  ALTER TABLE "SA_OPBIZMANAGEMENTTYPE" ADD CONSTRAINT "BIZMANAGEMENTTYPE_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPDATAKIND
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAKIND" ADD CONSTRAINT "PK_SA_OPDATAKIND" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAKIND" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGEBUSINESS
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGEBUSINESS" ADD CONSTRAINT "PK_SA_OPDATAMANAGEBUSINESS" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGEBUSINESS" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGEBUSINESS_FIELD
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGEBUSINESS_FIELD" ADD CONSTRAINT "PK_SA_OPDATAMANAGEBUSINESS_FIE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGEBUSINESS_FIELD" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGEDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGEDETAIL" ADD CONSTRAINT "PK_SA_OPDATAMANAGEDETAIL" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGEDETAIL" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGEDETAILRESOURCE
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGEDETAILRESOURCE" ADD CONSTRAINT "PK_SA_OPDATAMANAGDETAILRESOURC" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGEDETAILRESOURCE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGEMENT
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGEMENT" ADD CONSTRAINT "PK_SA_OPDATAMANAGEMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGETYPE
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGETYPE" ADD CONSTRAINT "PK_SA_OPDATAMANAGETYPE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGETYPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPDATAMANAGETYPEKIND
--------------------------------------------------------

  ALTER TABLE "SA_OPDATAMANAGETYPEKIND" ADD CONSTRAINT "PK_SA_OPDATAMANAGETYPEKIND" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPDATAMANAGETYPEKIND" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPERATIONLOG
--------------------------------------------------------

  ALTER TABLE "SA_OPERATIONLOG" ADD CONSTRAINT "PK_SA_OPERATIONLOG_NEW" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPERATIONLOG" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPERATIONLOGDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_OPERATIONLOGDETAIL" ADD CONSTRAINT "PK_SA_OPERATIONLOGDETAIL" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPERATIONLOGDETAIL" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPERATIONLOG_BAK
--------------------------------------------------------

  ALTER TABLE "SA_OPERATIONLOG_BAK" ADD CONSTRAINT "PK_SA_OPERATIONLOG" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPERATIONLOG_BAK" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPFUNCTION
--------------------------------------------------------

  ALTER TABLE "SA_OPFUNCTION" ADD CONSTRAINT "PK_OPFUNCTION" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPFUNCTION_FIELD_GROUP
--------------------------------------------------------

  ALTER TABLE "SA_OPFUNCTION_FIELD_GROUP" ADD CONSTRAINT "PK_SA_OPFUNCTION_FIELD_GROUP" PRIMARY KEY ("FUNCTION_FIELD_GROUP_ID") ENABLE;
 
  ALTER TABLE "SA_OPFUNCTION_FIELD_GROUP" MODIFY ("FUNCTION_FIELD_GROUP_ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPFUNCTION_FIELD_GROUP" MODIFY ("FUNCTION_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPFUNCTION_PERMISSIONFIELD
--------------------------------------------------------

  ALTER TABLE "SA_OPFUNCTION_PERMISSIONFIELD" ADD CONSTRAINT "PK_SA_OPFUNCTION_PERMISSIONFIE" PRIMARY KEY ("PERMISSION_FIELD_ID") ENABLE;
 
  ALTER TABLE "SA_OPFUNCTION_PERMISSIONFIELD" MODIFY ("PERMISSION_FIELD_ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPFUNCTION_PERMISSIONFIELD" MODIFY ("FUNCTION_FIELD_GROUP_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPOPERATION
--------------------------------------------------------

  ALTER TABLE "SA_OPOPERATION" ADD CONSTRAINT "OPOPERATION_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPOPERATION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPORG
--------------------------------------------------------

  ALTER TABLE "SA_OPORG" ADD CONSTRAINT "PK_SA_OPORG" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPORG" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPORG" MODIFY ("VERSION" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPORGPROPERTY
--------------------------------------------------------

  ALTER TABLE "SA_OPORGPROPERTY" ADD CONSTRAINT "PK_SYS_ORG_PROPERTY" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPORGPROPERTY" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPORGPROPERTYDEFINITION
--------------------------------------------------------

  ALTER TABLE "SA_OPORGPROPERTYDEFINITION" ADD CONSTRAINT "OPORGPROPERTYDEFINITION_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPORGROLEAUTHORIZE
--------------------------------------------------------

  ALTER TABLE "SA_OPORGROLEAUTHORIZE" ADD CONSTRAINT "PK_OPORGROLEAUTHORIZE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPORGROLEAUTHORIZE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPORGTEMPLATE
--------------------------------------------------------

  ALTER TABLE "SA_OPORGTEMPLATE" ADD CONSTRAINT "PK_OPORGTEMPLATE" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPORGTYPE
--------------------------------------------------------

  ALTER TABLE "SA_OPORGTYPE" ADD CONSTRAINT "PK_OPORGTYPE" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPPERMISSION
--------------------------------------------------------

  ALTER TABLE "SA_OPPERMISSION" ADD CONSTRAINT "PK_OPPERMISSION" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPPERMISSION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPPERSON
--------------------------------------------------------

  ALTER TABLE "SA_OPPERSON" ADD CONSTRAINT "PK_SA_OPPERSON" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPPERSON" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPREMIND
--------------------------------------------------------

  ALTER TABLE "SA_OPREMIND" ADD CONSTRAINT "PK_SA_OPREMIND" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPREMIND" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPREMIND" MODIFY ("ROLE_ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_OPREMIND" MODIFY ("REMIND_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPROLE
--------------------------------------------------------

  ALTER TABLE "SA_OPROLE" ADD CONSTRAINT "PK_ROLE" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_OPROLEPERMISSION
--------------------------------------------------------

  ALTER TABLE "SA_OPROLEPERMISSION" ADD CONSTRAINT "PK_ROLEPERMISSION" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPROLEPERMISSION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPTENANT
--------------------------------------------------------

  ALTER TABLE "SA_OPTENANT" ADD CONSTRAINT "PK_OPTENANT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPTENANT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPUIELEMENT
--------------------------------------------------------

  ALTER TABLE "SA_OPUIELEMENT" ADD CONSTRAINT "PK_OPUIELEMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPUIELEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_OPUIELEMENTPERMISSION
--------------------------------------------------------

  ALTER TABLE "SA_OPUIELEMENTPERMISSION" ADD CONSTRAINT "OPUIELEMENTPERMISSION_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_OPUIELEMENTPERMISSION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_ORGFUN
--------------------------------------------------------

  ALTER TABLE "SA_ORGFUN" ADD CONSTRAINT "PK_SA_ORGFUN" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_ORGFUN" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PARAMETER
--------------------------------------------------------

  ALTER TABLE "SA_PARAMETER" ADD CONSTRAINT "PK_PARAMETER" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_PDSCREEN
--------------------------------------------------------

  ALTER TABLE "SA_PDSCREEN" ADD CONSTRAINT "PDSCREEN_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PDSCREEN" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_PDSCREEN" MODIFY ("PERSON_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PDSCREENFUNCTION
--------------------------------------------------------

  ALTER TABLE "SA_PDSCREENFUNCTION" ADD CONSTRAINT "PDSCREENFUNCTION_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PDSCREENFUNCTION" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PERSONACCOUNTMANAGEMENT
--------------------------------------------------------

  ALTER TABLE "SA_PERSONACCOUNTMANAGEMENT" ADD CONSTRAINT "PK_SA_PERSONACCOUNTMANAGEMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PERSONACCOUNTMANAGEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PERSONCALENDAR
--------------------------------------------------------

  ALTER TABLE "SA_PERSONCALENDAR" ADD CONSTRAINT "PK_SA_PERSONCALENDAR" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PERSONCALENDAR" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PERSONLOGINLIMIT
--------------------------------------------------------

  ALTER TABLE "SA_PERSONLOGINLIMIT" ADD CONSTRAINT "PK_SA_PERSONLOGINLIMIT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PERSONLOGINLIMIT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_PERSONQUERYSCHEME
--------------------------------------------------------

  ALTER TABLE "SA_PERSONQUERYSCHEME" ADD CONSTRAINT "PK_SA_PERSONQUERYSCHEME" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_PERSONQUERYSCHEME" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_SCHEDULING_JOB
--------------------------------------------------------

  ALTER TABLE "SA_SCHEDULING_JOB" ADD CONSTRAINT "PK_SA_SCHEDULING_JOB" PRIMARY KEY ("JOB_ID") ENABLE;
 
  ALTER TABLE "SA_SCHEDULING_JOB" MODIFY ("JOB_ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_SCHEDULING_JOB" MODIFY ("JOB_NAME" NOT NULL ENABLE);
 
  ALTER TABLE "SA_SCHEDULING_JOB" MODIFY ("JOB_GROUP" NOT NULL ENABLE);
 
  ALTER TABLE "SA_SCHEDULING_JOB" MODIFY ("JOB_STATUS" NOT NULL ENABLE);
 
  ALTER TABLE "SA_SCHEDULING_JOB" MODIFY ("CRON_EXPRESSION" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_SCHEDULING_JOB_LOG
--------------------------------------------------------

  ALTER TABLE "SA_SCHEDULING_JOB_LOG" ADD CONSTRAINT "PK_SCHEDULING_JOB_LOG" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_SCHEDULING_JOB_LOG" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_SCHEDULING_JOB_LOG" MODIFY ("JOB_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_SECURITYPOLICY
--------------------------------------------------------

  ALTER TABLE "SA_SECURITYPOLICY" ADD CONSTRAINT "PK_SA_SECURITYPOLICY" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_SECURITYPOLICY" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_SYNBASEDATAVERSION
--------------------------------------------------------

  ALTER TABLE "SA_SYNBASEDATAVERSION" ADD CONSTRAINT "PK_SA_SYNBASEDATAVERSION_ID" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_SYNBASEDATAVERSION" MODIFY ("CODE" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_TMAUTHORIZE
--------------------------------------------------------

  ALTER TABLE "SA_TMAUTHORIZE" ADD CONSTRAINT "PK_SA_TSAUTHORIZE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "SA_TMAUTHORIZE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table SA_USERGROUP
--------------------------------------------------------

  ALTER TABLE "SA_USERGROUP" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_USERGROUP" ADD CONSTRAINT "USERGROUP_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table SA_USERGROUPDETAIL
--------------------------------------------------------

  ALTER TABLE "SA_USERGROUPDETAIL" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "SA_USERGROUPDETAIL" ADD CONSTRAINT "USERGROUPDETAIL_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_APPROVALELEMENT
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALELEMENT" ADD CONSTRAINT "APPROVALELEMENT_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_APPROVALHANDLERKIND
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALHANDLERKIND" ADD CONSTRAINT "PK_WF_APPROVALHANDLERKIND" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULE
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULE" ADD CONSTRAINT "APPROVALRULE_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEELEMENT
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEELEMENT" ADD CONSTRAINT "PK_WF_APPROVALRULEELEMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULEELEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEHANDLER
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEHANDLER" ADD CONSTRAINT "APPROVALRULEHANDLER_PK" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEHANDLERASSIST
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEHANDLERASSIST" ADD CONSTRAINT "PK_APPROVALRULEHANDLERASSIST" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULEHANDLERASSIST" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEHANDLERGROUP
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEHANDLERGROUP" ADD CONSTRAINT "APPROVALRULEHANDLERGROUP_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULEHANDLERGROUP" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEHANDLERUIPERM
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEHANDLERUIPERM" ADD CONSTRAINT "APPROVALRULEHANDLERUIPERM_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULEHANDLERUIPERM" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULEHANDLER_AUTH
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULEHANDLER_AUTH" ADD CONSTRAINT "PK_HANDLER_AUTH_ID" PRIMARY KEY ("HANDLER_AUTH_ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULEHANDLER_AUTH" MODIFY ("HANDLER_AUTH_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_APPROVALRULESCOPE
--------------------------------------------------------

  ALTER TABLE "WF_APPROVALRULESCOPE" ADD CONSTRAINT "PK_WF_APPROVALRULESCOPE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_APPROVALRULESCOPE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_BASESEGMENTATIONTYPE
--------------------------------------------------------

  ALTER TABLE "WF_BASESEGMENTATIONTYPE" ADD CONSTRAINT "PK_WF_BASESEGMENTATIONTYPE" PRIMARY KEY ("BASE_SEGMENTATION_TYPE_ID") ENABLE;
 
  ALTER TABLE "WF_BASESEGMENTATIONTYPE" MODIFY ("BASE_SEGMENTATION_TYPE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_BIZSEGMENTATION
--------------------------------------------------------

  ALTER TABLE "WF_BIZSEGMENTATION" ADD CONSTRAINT "PK_WF_BIZSEGMENTATION" PRIMARY KEY ("BIZ_SEGMENTATION_ID") ENABLE;
 
  ALTER TABLE "WF_BIZSEGMENTATION" MODIFY ("BIZ_SEGMENTATION_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_BIZSEGMENTATIONAUTHORIZE
--------------------------------------------------------

  ALTER TABLE "WF_BIZSEGMENTATIONAUTHORIZE" ADD CONSTRAINT "PK_BIZSEGMENTATIONAUTHORIZE" PRIMARY KEY ("BIZ_SEGMENTATION_AUTHORIZE_ID") ENABLE;
 
  ALTER TABLE "WF_BIZSEGMENTATIONAUTHORIZE" MODIFY ("BIZ_SEGMENTATION_AUTHORIZE_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_HI_PROCUNITHANDLER
--------------------------------------------------------

  ALTER TABLE "WF_HI_PROCUNITHANDLER" ADD CONSTRAINT "PK_HI_PROCUNITHANDLER" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_HI_PROCUNITHANDLER" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_HI_PROCUNITHANDLERINST
--------------------------------------------------------

  ALTER TABLE "WF_HI_PROCUNITHANDLERINST" ADD CONSTRAINT "PK_HI_PROCUNITHANDLERINST" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_HI_PROCUNITHANDLERINST" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_PROCAPPROVALELEMENT
--------------------------------------------------------

  ALTER TABLE "WF_PROCAPPROVALELEMENT" ADD CONSTRAINT "PK_WF_PROCAPPROVALELEMENT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_PROCAPPROVALELEMENT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_PROCDEF
--------------------------------------------------------

  ALTER TABLE "WF_PROCDEF" ADD CONSTRAINT "PK_PROCDEF" PRIMARY KEY ("ID") ENABLE;
--------------------------------------------------------
--  Constraints for Table WF_PROCUNITHANDLER
--------------------------------------------------------

  ALTER TABLE "WF_PROCUNITHANDLER" ADD CONSTRAINT "PK_WF_PROCUNITHANDLER" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_PROCUNITHANDLER" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_PROCUNITHANDLERMANUSCRIPT
--------------------------------------------------------

  ALTER TABLE "WF_PROCUNITHANDLERMANUSCRIPT" ADD CONSTRAINT "PROCUNITHANDLERMANUSCRIPT_PK" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_PROCUNITHANDLERMANUSCRIPT" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_PROCUNITHANDLER_CACHE
--------------------------------------------------------

  ALTER TABLE "WF_PROCUNITHANDLER_CACHE" ADD CONSTRAINT "PK_WF_PROCUNITHANDLER_CACHE" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_PROCUNITHANDLER_CACHE" MODIFY ("ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_SEGMENTATIONHANDLER
--------------------------------------------------------

  ALTER TABLE "WF_SEGMENTATIONHANDLER" ADD CONSTRAINT "PK_WF_BIZSEGMENTATIONHANDLER" PRIMARY KEY ("SEGMENTATION_HANDLER_ID") ENABLE;
 
  ALTER TABLE "WF_SEGMENTATIONHANDLER" MODIFY ("SEGMENTATION_HANDLER_ID" NOT NULL ENABLE);
--------------------------------------------------------
--  Constraints for Table WF_TASKCOLLECTION
--------------------------------------------------------

  ALTER TABLE "WF_TASKCOLLECTION" ADD CONSTRAINT "PK_SYS_PERSON_TASK_COLLECT" PRIMARY KEY ("ID") ENABLE;
 
  ALTER TABLE "WF_TASKCOLLECTION" MODIFY ("ID" NOT NULL ENABLE);
 
  ALTER TABLE "WF_TASKCOLLECTION" MODIFY ("TASK_ID" NOT NULL ENABLE);
 
  ALTER TABLE "WF_TASKCOLLECTION" MODIFY ("PERSON_ID" NOT NULL ENABLE);

  ALTER TABLE WF_ApprovalRuleHandlerGroup
ADD  LIMIT_HANDLER int;

ALTER TABLE wf_procunithandler
ADD  LIMIT_HANDLER int;

ALTER TABLE wf_procunithandler_cache
ADD  LIMIT_HANDLER int;
