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