batman

Tables (20)

BATCH_JOB_EXECUTION

  • JOB_EXECUTION_ID — BIGINT — Primary key — NOT NULL
  • VERSION — BIGINT
  • JOB_INSTANCE_ID — BIGINT — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL
  • START_TIME — TIMESTAMP
  • END_TIME — TIMESTAMP
  • STATUS — VARCHAR(10)
  • EXIT_CODE — VARCHAR(2500)
  • EXIT_MESSAGE — VARCHAR(2500)
  • LAST_UPDATED — TIMESTAMP

BATCH_JOB_EXECUTION_PARAMS

  • PARAMETER_NAME — VARCHAR(100) — Primary key — NOT NULL
  • JOB_EXECUTION_ID — BIGINT — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • PARAMETER_TYPE — VARCHAR(100) — NOT NULL
  • PARAMETER_VALUE — VARCHAR(2500)
  • IDENTIFYING — CHAR(1) — NOT NULL

BATCH_STEP_EXECUTION

  • STEP_EXECUTION_ID — BIGINT — Primary key — NOT NULL
  • VERSION — BIGINT — NOT NULL
  • STEP_NAME — VARCHAR(100) — NOT NULL
  • CREATE_TIME — TIMESTAMP — NOT NULL
  • 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
  • JOB_EXECUTION_ID — BIGINT — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL

QRTZ_CRON_TRIGGERS

  • SCHED_NAME — VARCHAR(120) — Foreign key → QRTZ_TRIGGERS.SCHED_NAME — NOT NULL
  • TRIGGER_NAME — VARCHAR(200) — Foreign key → QRTZ_TRIGGERS.TRIGGER_NAME — NOT NULL
  • TRIGGER_GROUP — VARCHAR(200) — Foreign key → QRTZ_TRIGGERS.TRIGGER_GROUP — NOT NULL
  • CRON_EXPRESSION — VARCHAR(120) — NOT NULL
  • TIME_ZONE_ID — VARCHAR(80)

QRTZ_JOB_DETAILS

  • SCHED_NAME — VARCHAR(120) — Primary key — NOT NULL
  • JOB_NAME — VARCHAR(200) — Primary key — NOT NULL
  • JOB_GROUP — VARCHAR(200) — Primary key — NOT NULL
  • DESCRIPTION — VARCHAR(250)
  • JOB_CLASS_NAME — VARCHAR(250) — NOT NULL
  • IS_DURABLE — BOOL — NOT NULL
  • IS_NONCONCURRENT — BOOL — NOT NULL
  • IS_UPDATE_DATA — BOOL — NOT NULL
  • REQUESTS_RECOVERY — BOOL — NOT NULL
  • JOB_DATA — BYTEA

QRTZ_TRIGGERS

  • SCHED_NAME — VARCHAR(120) — Primary key — NOT NULL
  • TRIGGER_NAME — VARCHAR(200) — Primary key — NOT NULL
  • TRIGGER_GROUP — VARCHAR(200) — Primary key — NOT NULL
  • JOB_NAME — VARCHAR(200) — Foreign key → QRTZ_JOB_DETAILS.JOB_NAME — NOT NULL
  • JOB_GROUP — VARCHAR(200) — Foreign key → QRTZ_JOB_DETAILS.JOB_GROUP — NOT NULL
  • DESCRIPTION — VARCHAR(250)
  • NEXT_FIRE_TIME — BIGINT
  • PREV_FIRE_TIME — BIGINT
  • PRIORITY — INTEGER
  • TRIGGER_STATE — VARCHAR(16) — NOT NULL
  • TRIGGER_TYPE — VARCHAR(8) — NOT NULL
  • START_TIME — BIGINT — NOT NULL
  • END_TIME — BIGINT
  • CALENDAR_NAME — VARCHAR(200)
  • MISFIRE_INSTR — SMALLINT
  • JOB_DATA — BYTEA

app_exec_his

  • seq — varchar(255) — Primary key — NOT NULL
  • app_id — varchar(255) — Foreign key → app_info.app_id — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • server_id — varchar(255)
  • exec_user_id — varchar(10) — NOT NULL
  • exec_dt — timestamp — NOT NULL
  • exec_tm — varchar(10)
  • exec_st_cd — varchar(50) — NOT NULL
  • exec_ver — varchar(255)
  • exec_param — varchar(255)
  • error_code — varchar(50)
  • job_execution_id — BIGINT — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • pod_name — varchar(50)
  • exec_env — varchar(50)
  • env_value — text
  • error_msg — varchar(2000)

app_info

  • app_id — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • app_nm — varchar(255) — NOT NULL
  • app_st_cd — varchar(10) — NOT NULL
  • app_info — varchar(20) — NOT NULL
  • app_dv_cd — varchar(20) — NOT NULL
  • app_category — varchar(20) — NOT NULL
  • server_id — varchar(255) — Foreign key → batch_server_info.server_id — NOT NULL
  • lst_exec_dt — timestamp
  • lst_job_execution_id — int8
  • namespace — varchar(255) — NOT NULL

app_queue_base

  • queue_id — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(10) — NOT NULL
  • reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(10)
  • upd_dtm — timestamp
  • call_target_nm — varchar(10)
  • app_id — varchar(255)
  • app_his_seq — varchar(255)
  • app_nm — varchar(255)
  • app_param — varchar(255)
  • req_dtm — timestamp
  • exec_dtm — timestamp
  • lst_polling_dtm — timestamp
  • relaunch_exec_yn — varchar(1)
  • retry_cnt — int8
  • retry_exec_cnt — int8
  • queue_st_cd — varchar(10)
  • polling_minutes — int8
  • job_execution_id — BIGINT — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • dup_chk_cd — varchar(10)
  • dup_chk_param — varchar(255)
  • global_id — varchar(10)
  • parent_queue_id — varchar(255)

app_schedule_his

  • seq — varchar(255) — Primary key — NOT NULL
  • sch_id — varchar(255) — Foreign key → app_schedule_info.sch_id — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • app_id — varchar(255)
  • server_id — varchar(244)
  • exec_user_id — varchar(10) — NOT NULL
  • exec_dt — timestamp — NOT NULL
  • exec_tm — varchar(10)
  • exec_st_cd — varchar(50) — NOT NULL
  • exec_ver — varchar(255)
  • exec_param — varchar(255)
  • error_code — varchar(50)
  • job_execution_id — BIGINT — Foreign key → BATCH_JOB_EXECUTION.JOB_EXECUTION_ID — NOT NULL
  • pod_name — varchar(50)
  • env_value — text
  • error_msg — varchar(2000)

app_schedule_info

  • sch_id — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • sch_nm (SCHED_NAME) — VARCHAR(120) — Foreign key → QRTZ_TRIGGERS.SCHED_NAME — NOT NULL
  • trigger_nm (TRIGGER_NAME) — VARCHAR(200) — Foreign key → QRTZ_TRIGGERS.TRIGGER_NAME — NOT NULL
  • app_id — varchar(255) — Foreign key → app_info.app_id — NOT NULL
  • sch_st_cd — varchar(10) — NOT NULL
  • sch_grp (TRIGGER_GROUP) — VARCHAR(200) — Foreign key → QRTZ_TRIGGERS.TRIGGER_GROUP — NOT NULL
  • sch_param — varchar(255)
  • server_id — varchar(255)

app_token_info

  • pod_namespace — varchar(255) — Primary key — NOT NULL
  • service_acct — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • token_info — varchar(2000) — NOT NULL
  • token_created_dt — timestamp — NOT NULL
  • token_expi_dt — timestamp — NOT NULL

app_ver

  • app_ver — varchar(255) — Primary key — NOT NULL
  • app_id — varchar(255) — Foreign key → app_info.app_id — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • created_dt — timestamp — NOT NULL
  • default_yn — varchar(1) — NOT NULL
  • image_uri — varchar(255) — NOT NULL

batch_server_info

  • server_id — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • server_nm — varchar(255) — NOT NULL
  • url — varchar(255) — NOT NULL
  • app_category — varchar(20)
  • status — varchar(10) — NOT NULL
  • req_setting_info — varchar(255)

batch_server_template

  • template_type — vvarchar(20) — Primary key
  • server_id — varchar(255) — Foreign key → batch_server_info.server_id — NOT NULL
  • reg_user_id — varchar(20)
  • sys_reg_dtm — timestamp
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • template — text
  • sort_seq — int4

daemon_server_info

  • server_id — varchar(255) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • server_nm — varchar(255) — NOT NULL
  • daemon_ver — varchar(50) — NOT NULL
  • url — varchar(255) — NOT NULL
  • app_category — varchar(20)
  • status — varchar(10) — NOT NULL
  • req_setting_info — varchar(255)
  • deployment_name — varchar(255)
  • namespace — varchar(255) — NOT NULL
  • batch_server_id — varchar(255) — Foreign key → batch_server_info.server_id — NOT NULL

log_trace

  • batman_global_id — varchar(255) — Primary key — NOT NULL
  • origin_global_id — varchar(255)
  • create_dtm — timestamp
  • request_body — varchar(2000)
  • response_body — varchar(2000)
  • log — text

nogt_sequence

  • nogt_kind_cd — varchar(10) — Primary key — NOT NULL
  • nogt_dv_cd — varchar(50) — Primary key — NOT NULL
  • basc_dt — varchar(8) — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • seq_no — int8

param_info

  • param_nm — varchar — Primary key — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • type — varchar

param_rel

  • app_id — varchar(255) — Foreign key → app_info.app_id — NOT NULL
  • param_nm — varchar — Foreign key → param_info.param_nm — NOT NULL
  • reg_user_id — varchar(20) — NOT NULL
  • sys_reg_dtm — timestamp — NOT NULL
  • upd_user_id — varchar(20)
  • sys_upd_dtm — timestamp
  • type — varchar(50)
  • active_cd — varchar(50) — NOT NULL
  • mandatory_cd — varchar(50) — NOT NULL
  • default_setting — varchar(255) — NOT NULL