This appendix provides an ERD for the database schema used in the task repository.
TASK_EXECUTION. Stores the task execution information.
Column Name | Required | Type | Field Length | Notes |
---|---|---|---|---|
TASK_EXECUTION_ID | TRUE | BIGINT | X | Spring Cloud Task Framework at app startup establishes the next available id as obtained from the |
START_TIME | FALSE | DATETIME | X | Spring Cloud Task Framework at app startup establishes the value. |
END_TIME | FALSE | DATETIME | X | Spring Cloud Task Framework at app exit establishes the value. |
TASK_NAME | FALSE | VARCHAR | 100 | Spring Cloud Task Framework at app startup will set this to "Application" unless user establish the name using the spring.cloud.task.name as discussed here |
EXIT_CODE | FALSE | INTEGER | X | Follows Spring Boot defaults unless overridden by the user as discussed here. |
EXIT_MESSAGE | FALSE | VARCHAR | 2500 | User Defined as discussed here. |
ERROR_MESSAGE | FALSE | VARCHAR | 2500 | Spring Cloud Task Framework at app exit establishes the value. |
LAST_UPDATED | TRUE | DATETIME | X | Spring Cloud Task Framework at app startup establishes the value. Or if the record is created outside of task then the value must be populated at record creation time. |
EXTERNAL_EXECUTION_ID | FALSE | VARCHAR | 250 | If the |
PARENT_TASK_EXECUTION_ID | FALSE | BIGINT | X | If the |
TASK_EXECUTION_PARAMS. Stores the parameters used for a task execution
Column Name | Required | Type | Field Length |
---|---|---|---|
TASK_EXECUTION_ID | TRUE | BIGINT | X |
TASK_PARAM | FALSE | VARCHAR |
TASK_TASK_BATCH. Used to link the task execution to the batch execution.
Column Name | Required | Type | Field Length |
---|---|---|---|
TASK_EXECUTION_ID | TRUE | BIGINT | X |
JOB_EXECUTION_ID | TRUE | BIGINT |
TASK_LOCK. Used for the single-instance-enabled
feature discussed here.
Column Name | Required | Type | Field Length | Notes |
---|---|---|---|---|
LOCK_KEY | TRUE | CHAR | 36 | UUID for the this lock |
REGION | TRUE | VARCHAR | 100 | User can establish a group of locks using this field. |
CLIENT_ID | TRUE | CHAR | 36 | The task execution id that contains the name of the app to lock. |
CREATED_DATE | TRUE | DATETIME | X | The date that the entry was created |
![]() | Note |
---|---|
The DDL for setting up tables for each database type can be found here. |