Activiti Workflow Engine database table structure

Activiti Workflow Engine database table structure one,Naming a database table
Automotive engineering league tables

The names of tables in the Acitiviti database begin with Act_. The second part is the identification of a two-character use case table. This use case is broadly matched to the service API.

Engineering drawing table buy online

L act_re_*: ' RE ' means repository. The table with the prefix contains static information, such as the process definition, the flow of resources (pictures, rules, etc.).
L act_ru_*: ' RU ' indicates runtime. This is the runtime table that stores the process variables, user tasks, variables,civil engineering tables  responsibilities (job), and other runtime data. Activiti only stores run-time data during instance execution, and when the process instance ends, the records are deleted. This ensures that these run-time tables are small and fast.
L act_id_*: ' ID ' denotes identity. These tables contain information that is identified, such as users, user groups, and so on.
L act_hi_*: ' HI ' means history. These are the tables that contain historical data, such as end-of-process instances, variables, tasks, and so on.
Act_ge_*: General data, data used in various situations.
Twodatabase table Structure Description   1,act_ge_property: Property Data table. Store data at this process engine level.


Name_: Property Name

Search engine land seo periodic table



Value_: Attribute value


search engine land periodic table


Rev_int: Version number

Engineering uni league tables

2,act_ge_bytearray: Large text data to save the deployment file


Id_: Resource file number, self-growth





Rev_int: Version number





Name_: Resource File name





DEPLOYMENT_ID_: Primary key from parent table Act_re_deployment





Bytes_: Large text type, storing text byte stream



3,act_re_deployment: Used to store information that is persisted during deployment


ID_: Deployment number, self-growth





Name_: Name of the deployment package





Deploy_time_: Deployment Time



4, Act_re_procdef: Business process definition data table


ID_: Process ID, consisting of "process number: Process version number: Self-growth id"





Category_: Process Namespace (this number is the property value of the process file targetnamespace)





Name_: The process name (which is the Name property value of the process file procedure element)





KEY_: The process number (which is the id attribute value of the process file procedure element)





Version_: Process version number (by program control, added is 1, modified and then added to complete)





DEPLOYMENT_ID_: Deployment Number





Resource_name_: Resource File name





Dgrm_resource_name_: Picture Resource file name





Has_start_from_key_: If there is a START from KEY





Note: This table and Act_re_deployment are a many-to-one relationship, that is, a deployed bar package may contain multiple process definition files,





Each process definition file will have a record in the Act_reprocdef table, The data for each process definition will be for a resource file within the Act_ge_bytearray table





and PNG image files. The association with Act_ge_bytearray is through the program with Act_ge_bytearray. NAME and Act_re_procdef.name_ completed,





is not reflected in the database table structure.



5,Act_id_group: Used to store user group information.


Id_: User Group name *





Rev_int: Version number





Name_: User group description Information *





Type_: User Group type



6,act_id_membership: Used to save user's group information


User_id_: User Name





Group_id_: User group name



7,act_id_user: User Information table


Id_: User Name





Rev_int: Version number





First_: User Name





Last_: User Last Name





Email_: Email





Pwd_: Password



8,act_ru_execution:


ID_: Primary Key





REV_: Version number





PROC_INST_ID_: Process Instance number





BUSINESS_KEY_: Business Number





Parent_id_: Finds the parent of the execution instance and eventually finds the execution instance of the entire process





PROC_DEF_ID_: Process ID





SUPER_EXEC_: Referenced execution template





ACT_ID_: Node ID





Is_active_: whether to access





Is_concurrent_:





Is_scope_:



 9,act_ru_task: Run-time Task data table.


ID_: Primary Key





REV_: Version number





Execution_id_: The ID of the execution instance





Proc_inst_id_: ID of the process instance





Proc_def_id_: ID of the process definition, corresponding to Act_re_procdef id_





Name_: Task name, corresponding to the ***task name





PARENT_TASK_ID_: Corresponding parent task





Description_:





Task_def_key_: ID of ***task





Owner_: Initiator





Assignee_: The person assigned to the task





Delegation_: Principal





Priority_: Emergency level





Create_time_: Initiation Time





Due_time_: Length of approval



10,act_ru_identitylink: Task contributor data table. Primarily stores information about the current node participants.


Id_: Identification





REV_: Version





GROUP_ID_: Organization ID





Type_: Type





User_id_: User ID





Task_id_: Task ID



11,act_ru_variable: Run-time process variable data table.


Id_: Identification





REV_: Version number





Type_: Data type





Name_: Variable Name





Execution_id_: execution Instance ID





PROC_INST_ID_: Process Instance ID





Task_id_: Task ID





Bytearray_id_:





Double_: If the data type is double, save the data in this column





Long_: Save data to this column if the data type is long





Text_: String saved to this column





Text2_:



12,act_hi_procinst:


ID_: Uniquely identifying





PROC_INST_ID_: Process ID





BUSINESS_KEY_: Business Number





PROC_DEF_ID_: Process Definition ID





Start_time_: Process Start time





Ent__time: End Time





Duration_: Process Elapsed time





START_USER_ID_: Open Process user ID





Start_act_id_: Start node





End_act_id_: End Node





SUPER_PROCESS_INSTANCE_ID_: Parent Process Process ID





Delete_reason_: Removing the reason from the running task table











Activiti Workflow Engine database table structure