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