PlantUML Web Server

@startuml
!define table(x) class x << (T,#FFAAAA) >>
!define primary_key(x) <u>x</u>
!define foreign_key(x) #x#

' Tables
table(BATCH_JOB_INSTANCE) {
    primary_key(JOB_INSTANCE_ID): BIGINT
    VERSION: BIGINT
    JOB_NAME: VARCHAR(100)
    JOB_KEY: VARCHAR(32)
}

table(BATCH_JOB_EXECUTION) {
    primary_key(JOB_EXECUTION_ID): BIGINT
    VERSION: BIGINT
    foreign_key(JOB_INSTANCE_ID): BIGINT
    CREATE_TIME: TIMESTAMP
    START_TIME: TIMESTAMP
    END_TIME: TIMESTAMP
    STATUS: VARCHAR(10)
    EXIT_CODE: VARCHAR(2500)
    EXIT_MESSAGE: VARCHAR(2500)
    LAST_UPDATED: TIMESTAMP
}

table(BATCH_JOB_EXECUTION_PARAMS) {
    primary_key(JOB_EXECUTION_ID): BIGINT
    primary_key(PARAMETER_NAME): VARCHAR(100)
    PARAMETER_VALUE: VARCHAR(2500)
    PARAMETER_TYPE: VARCHAR(100)
}

table(BATCH_STEP_EXECUTION) {
    primary_key(STEP_EXECUTION_ID): BIGINT
    VERSION: BIGINT
    foreign_key(JOB_EXECUTION_ID): BIGINT
    STEP_NAME: VARCHAR(100)
    START_TIME: TIMESTAMP
    END_TIME: TIMESTAMP
    STATUS: VARCHAR(10)
    COMMIT_COUNT: BIGINT
    READ_COUNT: BIGINT
    FILTER_COUNT: BIGINT
    WRITE_COUNT: BIGINT
    READ_SKIP_COUNT: BIGINT
    WRITE_SKIP_COUNT: BIGINT
    PROCESS_SKIP_COUNT: BIGINT
    ROLLBACK_COUNT: BIGINT
    EXIT_CODE: VARCHAR(2500)
    EXIT_MESSAGE: VARCHAR(2500)
    LAST_UPDATED: TIMESTAMP
}

table(BATCH_JOB_EXECUTION_CONTEXT) {
    primary_key(JOB_EXECUTION_ID): BIGINT
    SHORT_CONTEXT: VARCHAR(2500)
    SERIALIZED_CONTEXT: CLOB
}

table(BATCH_STEP_EXECUTION_CONTEXT) {
    primary_key(STEP_EXECUTION_ID): BIGINT
    SHORT_CONTEXT: VARCHAR(2500)
    SERIALIZED_CONTEXT: CLOB
}

' Relationships
BATCH_JOB_INSTANCE "1" -- "0..*" BATCH_JOB_EXECUTION
BATCH_JOB_EXECUTION "1" -- "0..*" BATCH_JOB_EXECUTION_PARAMS
BATCH_JOB_EXECUTION "1" -- "0..*" BATCH_STEP_EXECUTION
BATCH_JOB_EXECUTION "1" -- "0..1" BATCH_JOB_EXECUTION_CONTEXT
BATCH_STEP_EXECUTION "1" -- "0..1" BATCH_STEP_EXECUTION_CONTEXT

' Notes
note right of BATCH_JOB_INSTANCE
  Stores unique job instances
  based on job name and parameters
end note

note right of BATCH_JOB_EXECUTION
  Tracks each execution of a job
  including start/end times and status
end note

note right of BATCH_STEP_EXECUTION
  Records step-level execution details
  including read/write counts and status
end note
@enduml

🎉 Discover the future PlantUML Web Editor! 🚀 PNG SVG ASCII Art