activity工作流表结构分析

整理文档很辛苦,赏杯茶钱您下走!

免费阅读已结束,点击下载阅读编辑剩下 ...

阅读已结束,您可以下载文档离线阅读编辑

资源描述

activityactivity11.1ActivitiACT_ACT_RE_*:RErepository()RepositoryServiceACT_RU_*:RUruntime-RuntimeServicejobActivitiACT_ID_*:IDidentity()IdentityServiceACT_HI_*:HIhistoryHistoryServiceACT_GE_*:(general)1.21act_ge_bytearray2act_ge_property,3act_hi_actinst4act_hi_attachment5act_hi_comment6act_hi_identitylink7act_hi_detail8act_hi_procinst9act_hi_taskinst10act_hi_varinst11act_id_group12act_id_info13act_id_membership14act_id_user15.act_re_deployment16.act_re_model17act_re_procdef18act_ru_event_subscrthrowEventcatchEvent19act_ru_execution20act_ru_identitylink21act_ru_job22act_ru_task23act_ru_variable22.1act_ge_bytearray2.1.1xmlSerializable(),svn2.1.2ID_ID_nvarchar(64)IDREV_intVersion()NAME_nvarchar(255)mail.bpmnmail.pngmail.bpmn20.xmlDEPLOYMENT_ID_IDnvarchar(64)IDBYTES_varbinary(max)GENERATED_tinyint01Activiti2.1.3PRIMARYID_UniqueACT_FK_BYTEARR_DEPLDEPLOYMENT_ID_2.2(act_ge_property)2.2.12.2.2NAME_nvarchar(64)schema.versionschema.historynext.dbidVALUE_nvarchar(300)5.*create(5.*)REV_intversion2.2.3PRIMARYNAME_Unique2.3act_hi_actinst2.3.1HI_TASKINSTtaskinstusertask2.3.2ID_ID_nvarchar(64)PROC_DEF_ID_IDnvarchar(64)PROC_INST_ID_IDnvarchar(64)EXECUTION_ID_IDnvarchar(64)ACT_ID_IDnvarchar(225)IDTASK_ID_IDnvarchar(64)IDIDCALL_PROC_INST_ID_IDnvarchar(64)ID'ACT_NAME_nvarchar(225)ACT_TYPE_nvarchar(225)startEventuserTaskASSIGNEE_nvarchar(64)START_TIME_datetime2013-09-1511:30:00END_TIME_datetime2013-09-1511:30:00DURATION_numeric(19,0)2.3.3PRIMARYID_UniqueACT_IDX_HI_ACT_INST_STARTSTART_TIME_ACT_IDX_HI_ACT_INST_ENDEND_TIME_ACT_IDX_HI_ACT_INST_PROCINSTPROC_INST_ID_ACT_ID_ACT_IDX_HI_ACT_INST_EXECEXECUTION_ID_ACT_ID_2.4(act_hi_attachment)2.4.12.4.2ID_ID_nvarchar(64)IDREV_integerVersionUSER_ID_IDnvarchar(255)IDNAME_nvarchar(255)DESCRIPTION_nvarchar(4000)TYPE_nvarchar(255)TASK_ID_IDnvarchar(64)IDPROC_INST_ID_IDnvarchar(64)IDURL_URL_nvarchar(4000)CONTENT_ID_IDnvarchar(64)ACT_GE_BYTEARRAYID2.4.3PRIMARYID_Unique2.5(act_hi_comment)2.5.12.5.2ID_ID_nvarchar(64)IDTYPE_nvarchar(255)eventcommentTIME_datetime'USER_ID_IDnvarchar(64)TASK_ID_IDnvarchar(64)IDPROC_INST_ID_IDnvarchar(255)IDACTION_nvarchar(64)1MESSAGE_nvarchar(4000)FULL_MSG_varbinary(max)2.5.3PRIMARYID_Unique2.6(act_hi_detail)2.6.12.6.2ID_ID_nvarchar(64)TYPE_nvarchar(255)2PROC_INST_ID_IDnvarchar(64)IDEXECUTION_ID_IDnvarchar(64)IDTASK_ID_IDnvarchar(64)IDACT_INST_ID_IDnvarchar(64)ACT_HI_ACTINSTIDNAME_nvarchar(255)VAR_TYPE_nvarchar(255)3REV_intVersionTIME_datetimeBYTEARRAY_ID_IDnvarcharACT_GE_BYTEARRAYIDDOUBLE_DOUBLE_doubleprecisionDoubleLONG_LONG_numericlongTEXT_TEXT_nvarcharStringTEXT2_TEXT2_nvarcharJPAID2.6.3PRIMARYID_UniqueACT_IDX_HI_ACT_INST_STARTSTART_TIME_ACT_IDX_HI_ACT_INST_ENDEND_TIME_ACT_IDX_HI_ACT_INST_PROCINSTPROC_INST_ID_ACT_ID_ACT_IDX_HI_ACT_INST_EXECEXECUTION_ID_ACT_ID_2.7(act_ru_identitylink)2.7.12.7.2ID_ID_nvarchar(64)ID_GROUP_ID_IDnvarchar(255)IDTYPE_nvarchar(255)4USER_ID_IDnvarchar(255)IDTASK_ID_IDnvarchar(64)IDPROC_INST_ID_IDnvarchar(64)ID2.7.3PRIMARYID_UniqueACT_IDX_HI_IDENT_LNK_USERUSER_ID_UniqueACT_IDX_HI_IDENT_LNK_TASKTASK_ID_ACT_IDX_HI_IDENT_LNK_PROCINSTPROC_INST_ID_2.8act_hi_procinst2.8.12.8.2ID_ID_nvarchar(64)IDPROC_INST_ID_IDnvarchar(64)IDBUSINESS_KEY_nvarchar(255)IDPROC_DEF_ID_IDnvarchar(64)IDSTART_TIME_datetimeEND_TIME_datetimeDURATION_Numeric(19)START_USER_ID_nvarchar(255)START_ACT_ID_IDnvarchar(255)IDEND_ACT_ID_IDnvarchar(255)IDSUPER_PROCESS_INSTANCE_ID_IDnvarchar(64)IDDELETE_REASON_nvarchar(4000)2.8.3PRIMARYID_UniquePROC_INST_ID_PROC_INST_ID_UniqueACT_UNIQ_HI_BUS_KEYPROC_DEF_ID_,BUSINESS_KEY_UniqueACT_IDX_HI_PRO_INST_ENDEND_TIME_ACT_IDX_HI_PRO_I_BUSKEYBUSINESS_KEY_2.9(act_hi_taskinst)2.9.12.9.2ID_ID_nvarchar(64)IDPROC_DEF_ID_IDnvarchar(64)IDTASK_DEF_KEY_IDnvarchar(255)IDPROC_INST_ID_IDnvarchar(64)IDEXECUTION_ID_IDnvarchar(64)IDNAME_varchar(255)PARENT_TASK_ID_IDnvarchar(64)IDDESCRIPTION_nvarchar(400)OWNER_nvarchar(255)ASSIGNEE_nvarchar(255)START_TIME_datetimeCLAIM_TIME_datetimeEND_TIME_datetimeDURATION_numeric(19)DELETE_REASON_nvarchar(4000)(completed,deleted)PRIORITY_intDUE_DATE_datetimeFORM_KEY_formkeynvarchar(255)desingerform_key2.9.3PRIMARYID_Unique2.10(act_hi_varinst)2.10.12.10.2ID_ID_nvarchar(64)ID_PROC_INST_ID_IDnvarchar(64)IDEXECUTION_ID_IDnvarchar(255)IDTASK_ID_IDnvarchar(64)IDNAME_nvarchar(64)()VAR_TYPE_varchar(255)5REV_nvarchar(64)VersionBYTEARRAY_ID_IDnvarchar(400)ACT_GE_BYTEARRAYDOUBLE_DOUBLE_nvarchar(255)DoubleTypeLONG_LONG_nvarchar(255)LongTypeTEXT_TEXT_datetime6TEXT2_TEXT2_datetimeJPAID2.10.3PRIMARYID_UniqueACT_IDX_HI_PROCVAR_PROC_INSTPROC_INST_ID_ACT_IDX_HI_PROCVAR_NAME_TYPENAME_,VAR_TYPE_2.11(act_id_group)2.11.12.11.2ID_ID_nvarchar(64)IDREV_intVersionNAME_nvarchar(255)TYPE_nvarchar(255)2.11.3PRIMARYID_Unique2.12(act_id_info)2.12.1~~~~~2.12.2ID_ID_nvarchar(64)IDREV_intVersionUSER_ID_IDnvarchar(64)TYPE_nvarchar(64)KEY_nvarchar(255)VALUE_nvarchar(255)PASSWORD_ImagePARENT_ID_nvarchar(255)2.12.3PRIMARYID_Unique2.13(act_id_membership)2.13.12.13.2USER_IDIDnvarchar(64)GROUP_IDIDnvarchar(64)2.13.3PRIMARYUSER_ID_,GROUP_ID_UniqueACT_FK_MEMB_GROUPGRO

1 / 20
下载文档,编辑使用

©2015-2020 m.111doc.com 三一刀客.

备案号:赣ICP备18015867号-1 客服联系 QQ:2149211541

×
保存成功