시스템_물리

테이블 (5)

TB_BATCHHS

  • BTCH_HIST_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • BTCH_NO — VARCHAR2(50) — NOT NULL
  • BTCH_NM — VARCHAR2(256) — NOT NULL
  • SEND_DT — VARCHAR2(8) — NOT NULL
  • SEND_TIME — VARCHAR2(6) — NOT NULL
  • SUCCES_YN — CHAR(1) — NOT NULL
  • ERROR_MSG — VARCHAR2(5000)

TB_BATCHSC

  • BTCH_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • BTCH_NM — VARCHAR2(256) — NOT NULL
  • WKPL_SN — VARCHAR2(50) — NOT NULL
  • COCEN_CD — VARCHAR2(50)
  • SEND_TIME — VARCHAR2(6) — NOT NULL
  • USE_YN — VARCHAR2(50) — NOT NULL

TB_PUSH

  • PUSH_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • TRGET_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • PUSH_BTCH_NM — VARCHAR2(256) — NOT NULL
  • PUSH_TY — CHAR(1) — NOT NULL
  • PUSH_SE — CHAR(1) — NOT NULL
  • CONT — VARCHAR2(5000)
  • NTCN_CFRM_YN — CHAR(1) — NOT NULL
  • SEND_DT — VARCHAR2(8) — NOT NULL
  • SEND_TIME — VARCHAR2(6) — NOT NULL
  • SENDER — VARCHAR2(50) — NOT NULL
  • SUCCES_YN — CHAR(1) — NOT NULL
  • ERROR_MSG — VARCHAR2(5000)

TB_PUSHSC

  • PUSH_BTCH_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • PUSH_BTCH_NM — VARCHAR2(256) — NOT NULL
  • PUSH_TY — CHAR(1) — NOT NULL
  • PUSH_TRGET_GRP_NO — VARCHAR2(50)
  • PRID — VARCHAR2(500) — NOT NULL
  • SEND_TIME — VARCHAR2(6) — NOT NULL
  • CONT — VARCHAR2(5000)
  • USE_YN — VARCHAR2(50) — NOT NULL
  • PUSH_BTCH_BEGN_DT — VARCHAR2(8) — NOT NULL

TB_PUSH_BATCHTG

  • PUSH_TRGET_GRP_NO — VARCHAR2(50) — 기본 키 — NOT NULL
  • TRGET_NO — VARCHAR2(50) — 기본 키 — NOT NULL