gateway

테이블 (13)

GATEWAY_APIKEY

  • APIKEY_SN — INTEGER — 기본 키 — NOT NULL
  • APIKEY_NAME — VARCHAR2(256) — NOT NULL
  • APIKEY_SHOP_ID — VARCHAR2(256) — NOT NULL
  • APIKEY_VALUE — VARCHAR2(256) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL

GATEWAY_CATEGORY_MASTER

  • CATEGORY_SN — INTEGER — 기본 키 — NOT NULL
  • CATEGORY_DESC — VARCHAR2(256) — NOT NULL
  • CATEGORY_NM — VARCHAR2(256) — NOT NULL
  • CATEGORY_PART — VARCHAR2(256) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL

GATEWAY_DISTRIBUTOR_MASTER

  • DIS_SN — INTEGER — 기본 키 — NOT NULL
  • DIS_ADDR — VARCHAR2(256) — NOT NULL
  • DIS_CONTRACTTERMS — CLOB — NOT NULL
  • DIS_EMAIL — VARCHAR2(256) — NOT NULL
  • DIS_NAME — VARCHAR2(256) — NOT NULL
  • DIS_PHONE — VARCHAR2(256) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL

GATEWAY_MAKE_MASTER

  • MAKE_SN — INTEGER — 기본 키 — NOT NULL
  • MAKE_PX — VARCHAR2(256) — NOT NULL
  • MAKE_TYPE — VARCHAR2(20) — NOT NULL
  • MAKE_TYPE_SET — CLOB — NOT NULL
  • REG_DT — DATE — NOT NULL
  • APIKEY_SN — INTEGER — 외래 키 → GATEWAY_APIKEY.APIKEY_SN — NOT NULL

GATEWAY_MAKE_REUSLT

  • MAKE_RESULT_SN — INTEGER — 기본 키 — NOT NULL
  • MAKE_RESULT_DATA — CLOB — NOT NULL
  • MAKE_SN — INTEGER — NOT NULL
  • REG_DT — DATE — NOT NULL
  • USE_DATA — CLOB — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL

GATEWAY_PRODUCT_MASTER

  • PRO_SN — INTEGER — 기본 키 — NOT NULL
  • PRO_CNTS — CLOB — NOT NULL
  • PRO_DESC — VARCHAR2(256) — NOT NULL
  • PRO_NM — VARCHAR2(256) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL
  • DIS_SN — INTEGER — 외래 키 → GATEWAY_DISTRIBUTOR_MASTER.DIS_SN — NOT NULL
  • CATEGORY_SN — INTEGER — 외래 키 → GATEWAY_CATEGORY_MASTER.CATEGORY_SN — NOT NULL

GATEWAY_SETTING_INFO

  • INFO_SN — INTEGER — 기본 키 — NOT NULL
  • APIKEY_SN — INTEGER — 외래 키 → GATEWAY_APIKEY.APIKEY_SN — NOT NULL
  • INFO_CNTS — CLOB — NOT NULL
  • INFO_KEY — VARCHAR2(256) — NOT NULL
  • INFO_NAME — VARCHAR2(256) — NOT NULL
  • INFO_URL — VARCHAR2(256) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL
  • USE_YN — CHAR(1) — NOT NULL

GATEWAY_SETTING_SCT_INFO

  • SCT_INFO_SN — INTEGER — 기본 키 — NOT NULL
  • SCR_INFO_DATA — CLOB — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL
  • APIKEY_SN — INTEGER — 외래 키 → GATEWAY_SETTING_INFO.APIKEY_SN — NOT NULL
  • INFO_SN — INTEGER — 외래 키 → GATEWAY_SETTING_INFO.INFO_SN — NOT NULL

GATEWAY_STS_ERR_CODE

  • ERR_CODE_SN — INTEGER — 기본 키 — NOT NULL
  • ERR_CODE_NAME — CLOB — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL

GATEWAY_STS_HISTORY

  • HISOTRY_SN — INTEGER — 기본 키 — NOT NULL
  • HISTORY_CNT — INTEGER — NOT NULL
  • ERR_CODE_SN — INTEGER — 외래 키 → GATEWAY_STS_ERR_CODE.ERR_CODE_SN — NOT NULL
  • HISTORY_KEY — VARCHAR2(20) — NOT NULL
  • HISTORY_STATUS — VARCHAR2(20) — NOT NULL
  • REG_DT — DATE — NOT NULL
  • RDG_ID — VARCHAR2(20) — NOT NULL
  • STS_SN — INTEGER — 외래 키 → GATEWAY_STS_OUT.STS_SN — NOT NULL
  • MAKE_HIST_SN — INTEGER — NOT NULL
  • STS_SN (STS_SN2) — INTEGER — 외래 키 → GATEWAY_STS_IN.STS_SN — NOT NULL

GATEWAY_STS_IN

  • STS_SN — INTEGER — 기본 키 — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL
  • STS_DATA — CLOB — NOT NULL
  • SCT_INFO_SN — INTEGER — 외래 키 → GATEWAY_SETTING_SCT_INFO.SCT_INFO_SN — NOT NULL

GATEWAY_STS_OUT

  • STS_SN — INTEGER — 기본 키 — NOT NULL
  • REG_DT — DATE — NOT NULL
  • REG_ID — VARCHAR2(20) — NOT NULL
  • STS_DATA — CLOB — NOT NULL
  • SCT_INFO_SN — INTEGER — 외래 키 → GATEWAY_SETTING_SCT_INFO.SCT_INFO_SN — NOT NULL

생성_이력_관리_테이블

  • MAKE_HIST_SN — INTEGER — 기본 키 — NOT NULL
  • MAKE_HIST_TYPE — CHAR(1) — NOT NULL
  • MAKE_HIST_YN — CHAR(1) — NOT NULL
  • MAKE_RESULT_SN — INTEGER — NOT NULL
  • REG_DT — DATE — NOT NULL