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)