tb_erd
Tables (8)
TB_COMMON_CODE
- CODE_ID — BIGINT — Primary key — NOT NULL
- CODE_GROUP_ID — BIGINT — NOT NULL
- CODE — VARCHAR(50) — NOT NULL
- CODE_NAME — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(500)
- SORT_ORDER — INTEGER — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_COMMON_CODE_GROUP
- CODE_GROUP_ID — BIGINT — Primary key — NOT NULL
- GROUP_CODE — VARCHAR(50) — NOT NULL
- GROUP_NAME — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(500)
- SORT_ORDER — INTEGER — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_MESSAGE
- MESSAGE_ID — BIGINT — Primary key — NOT NULL
- MESSAGE_CODE — VARCHAR(50) — NOT NULL
- MESSAGE_NAME — VARCHAR(200) — NOT NULL
- MSG_TYPE_CODE_ID — BIGINT — NOT NULL
- TR_CODE_CODE_ID — BIGINT — NOT NULL
- TR_TYPE_CODE_ID — BIGINT — NOT NULL
- MESSAGE_CONTENT — CLOB — NOT NULL
- DESCRIPTION — VARCHAR(1000)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_TARGET_INFO
- TARGET_INFO_ID — BIGINT — Primary key — NOT NULL
- TARGET_CODE — VARCHAR(50) — NOT NULL
- TARGET_NAME — VARCHAR(200) — NOT NULL
- TR_CODE_CODE_ID — BIGINT — NOT NULL
- TARGET_URL — VARCHAR(2000)
- TARGET_HOST — VARCHAR(255)
- TARGET_PORT — INTEGER
- CONNECT_TIMEOUT_MS — INTEGER
- READ_TIMEOUT_MS — INTEGER
- CONTENT_TYPE — VARCHAR(255)
- HEADER_TEXT — CLOB
- ENCODING — VARCHAR(50)
- DESCRIPTION — VARCHAR(1000)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_TRANSACTION
- TRANSACTION_ID — BIGINT — Primary key — NOT NULL
- TRANSACTION_CODE — VARCHAR(50) — NOT NULL
- TRANSACTION_NAME — VARCHAR(200) — NOT NULL
- AUTO_RESPONSE_YN — CHAR(1) — NOT NULL
- AUTO_RESPONSE_MESSAGE_ID — BIGINT
- DESCRIPTION — VARCHAR(1000)
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_TRANSACTION_TRANSFER_CONFIG
- TRANSFER_CONFIG_ID — BIGINT — Primary key — NOT NULL
- TRANSACTION_ID — BIGINT — Foreign key → TB_TRANSACTION.TRANSACTION_ID — NOT NULL
- SEND_MESSAGE_ID — BIGINT — NOT NULL
- TARGET_INFO_ID — BIGINT — NOT NULL
- TRANSFER_ORDER — INTEGER — NOT NULL
- USE_YN — CHAR(1) — NOT NULL
- CREATED_AT — TIMESTAMP(6) — NOT NULL
- CREATED_BY — VARCHAR(100)
- UPDATED_AT — TIMESTAMP(6) — NOT NULL
- UPDATED_BY — VARCHAR(100)
TB_TRANSFER_HISTORY
- TRANSFER_HISTORY_ID — BIGINT — Primary key — NOT NULL
- TRANSFER_REQUEST_ID — BIGINT — Foreign key → TB_TRANSFER_REQUEST.TRANSFER_REQUEST_ID — NOT NULL
- TRANSACTION_ID — BIGINT — Foreign key → TB_TRANSACTION.TRANSACTION_ID — NOT NULL
- TRANSFER_CONFIG_ID — BIGINT — Foreign key → TB_TRANSACTION_TRANSFER_CONFIG.TRANSFER_CONFIG_ID — NOT NULL
- SEND_MESSAGE_ID — BIGINT — NOT NULL
- TARGET_INFO_ID — BIGINT — NOT NULL
- AUTO_RESPONSE_MESSAGE_ID — BIGINT
- REPEAT_COUNT — INTEGER — NOT NULL
- REPEAT_SEQ — INTEGER — NOT NULL
- AUTO_RESPONSE_YN — CHAR(1) — NOT NULL
- TARGET_ENDPOINT — VARCHAR(2000)
- REQUEST_CONTENT — CLOB
- RESPONSE_CONTENT — CLOB
- RESULT_CODE — VARCHAR(30) — NOT NULL
- HTTP_STATUS — INTEGER
- ERROR_CODE — VARCHAR(100)
- ERROR_MESSAGE — CLOB
- STARTED_AT — TIMESTAMP(6) — NOT NULL
- ENDED_AT — TIMESTAMP(6)
- ELAPSED_MS — BIGINT
- CREATED_AT — TIMESTAMP(6) — NOT NULL
TB_TRANSFER_REQUEST
- TRANSFER_REQUEST_ID — BIGINT — Primary key — NOT NULL
- REPEAT_COUNT — INTEGER — NOT NULL
- AUTO_RESPONSE_YN — CHAR(1) — NOT NULL
- SELECTED_TRANSACTION_COUNT — INTEGER — NOT NULL
- PLANNED_SEND_COUNT — BIGINT — NOT NULL
- REQUEST_STATUS — VARCHAR(30) — NOT NULL
- REQUESTED_AT — TIMESTAMP(6) — NOT NULL
- REQUESTED_BY — VARCHAR(100)
- COMPLETED_AT — TIMESTAMP(6)