lenboo commented on issue #4325: URL: https://github.com/apache/incubator-dolphinscheduler/issues/4325#issuecomment-751673724
### 1. New tables and data structures, DB query interface (new structures do not delete/modify existing workflow/task structures at this time): - 1. New Workflow Definition Table: t_ds_Process_Definithon ``` |Column Name|Description| | -------------------------------| ---------------- | | id | Self-Increasing id | | code | encoding (original name field)| | version | version | | description | description | | project_code | project code | | task_type | job type | | task_params | Job Custom Parameters | | run_flag | run flag | | task_priority | job priority | | worker_group | worker grouping | | fail_retry_times | Number of failed retries | | fail_retry_interval | failed retry interval | | timeout_flag | timeout flag | | timeout_notify_strategy | Timeout Notification Policy | | timeout_duration | timeout length | | create_time | creation time | | update_time | modification time | ``` - 2. Workflow Job Relationships Table: t_ds_Process_Task_Relation ``` |Column Name|Description| | -------------------------------| ---------------- | | id | Self-Increasing id | | code | encoding (original name field)| | version | version | | description | description | | project_code | project code | | task_type | job type | | task_params | Job Custom Parameters | | run_flag | run flag | | task_priority | job priority | | worker_Group | worker grouping | | fail_Retry_Times | Number of failed retries | | fail_retry_interval | failed retry interval | | timeout_flag | timeout flag | | timeout_notify_strategy | Timeout Notification Policy | | timeout_duration | timeout length | | create_time | creation time | | update_time | modification time | ``` - 3. Job Definition Table: t_ds_Task_Definithon ``` |Column Name|Description| | ---- | ---- | | id | Self-Increasing id | | code | encoding (original name field)| | version | version | | description | description | | project_code | project code | | release_state | Publish status | | user_id | Owner id | | global_params | global parameters | | flag | Is the process available: 0 not available, 1 available | | receivers | recipients | | receivers_CC | Cc | | timeout | timeout | | tenant_id | Tenant id | | locations | node coordinate information | | create_time | creation time | | update_time | modification time | ``` - 4. Workflow Definition Log Table: t_ds_Process_Definithon_Log `Add operation type (add, modify, delete), operator, operation time based on workflow definition table` - 5. Workflow job relationship log table: t_ds_Process_Task_Relation_Log `Add workflow version, operation type (add, modify, delete), operator, operation time based on job relationship table` - 6. Job Definition Log Table: t_ds_Task_Definithon_Log `Add operation type (add, modify, delete), operator, operation time based on job definition table` - 7. Workflow Instance Table Modification: t_ds_Process_Instance `Add Workflow Definition Version Number Field` ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected]
