제휴사관리
테이블 (4)
TB_CMPT_USER_B (CMPT_사용자기본)
- USER_ID (Key) — NUMBER — 기본 키 — NOT NULL
- USER_NM (Field) — VARCHAR2(10)
- SVC_ACNT_ID (Field2) — VARCHAR2(100)
- EMP_SEQNO (Field3) — VARCHAR2(2)
- USER_TP_DIV_CD (Field4) — VARCHAR2(2)
- RPSN_ACNT_YN (Field5) — VARCHAR2(3)
- PSTN_NM (Field6) — VARCHAR2(50)
- USER_GD_DIV_CD (Field7) — VARCHAR2(3)
- SORT_SRNO (Field8) — NUMBER
- ECPT_CP_TEL_NO (Field9) — VARCHAR2(100)
- ECPT_HNDPN_NO (Field10) — VARCHAR2(100)
- ECPT_EML_ADDR (Field11) — VARCHAR2(150)
- ECPT_PWD (Field12) — VARCHAR2(200)
- ECPT_OTPK_VL (Field13) — VARCHAR2(100)
- ZIPCD (Field14) — VARCHAR2(8)
- BSC_ADDR (Field15) — VARCHAR2(500)
- FNL_LOGIN_DT (Field16) — DATE
- PWD_CHG_DT (Field17) — DATE
- LOGIN_FAIL_CNT (Field18) — NUMBER
- MKTG_ADV_SMS_RCPTN_AGR_YN (Field19) — VARCHAR2(1)
- MKTG_ADV_SMS_RCPTN_AGR_CHOC_DT (Field20) — NUMBER
- MKTG_ADV_EML_RCPTN_AGR_YN (Field21) — VARCHAR2(1)
- MKTG_ADV_EML_RCPTN_AGR_CHOC_DT (Field22) — NUMBER
- MKTG_ADV_NTTK_RCPTN_AGR_YN (Field23) — VARCHAR2(1)
- MKTG_ADV_NTTK_RCPTN_AGR_CHOC_DT (Field24) — NUMBER
- API_ATKY_USER_YN (Field25) — VARCHAR2(1)
- USE_YN (Field26) — VARCHAR2(1)
- LOGIN_AUTZ_UPD_TKN_VL (Field27) — VARCHAR2(500)
- MKTG_ADV_TEL_RCPTN_AGR_YN (Field28) — VARCHAR2(1)
- MKTG_ADV_TEL_RCPTN_AGR_CHOC_DT (Field29) — DATE
TB_CPPR_ALNC_MNGT_ADD_FLD_C (CPPR_제휴사관리추가필드코드)
- ALNC_MNGT_TP_DIV_CD (Key) — VARCHAR2(2) — 기본 키 — NOT NULL
- ALNC_MNGT_FLD_SRNO (Key1) — NUMBER — 기본 키 — NOT NULL
- ALNC_MNGT_FLD_NM (Field) — VARCHAR2(200)
TB_CPPR_ALNC_MNGT_ADD_FLD_D (CPPR_제휴사관리추가필드상세)
- SVC_ACNT_ID (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
- USER_ID (Key1) — VARCHAR2(100) — 기본 키 — NOT NULL
- ALNC_MNGT_TP_DIV_CD (Key2) — VARCHAR2(3) — 기본 키 — NOT NULL
- ALNC_MNGT_FLD_SRNO (Key3) — NUMBER — 기본 키 — NOT NULL
- SVC_ACNT_ID (Key4) — VARCHAR2(10) — 외래 키 → TB_CPPR_ALNC_MNGT_B.SVC_ACNT_ID — NOT NULL
- USER_ID (Key12) — VARCHAR2(100) — 외래 키 → TB_CPPR_ALNC_MNGT_B.USER_ID — NOT NULL
- ALNC_MNGT_TP_DIV_CD (Key22) — VARCHAR2(2) — 외래 키 → TB_CPPR_ALNC_MNGT_B.ALNC_MNGT_TP_DIV_CD — NOT NULL
- USER_ID (Key32) — NUMBER — 외래 키 → TB_CPPR_ALNC_MNGT_B.USER_ID — NOT NULL
- ALNC_MNGT_TP_DIV_CD (Key5) — VARCHAR2(2) — 외래 키 → TB_CPPR_ALNC_MNGT_ADD_FLD_C.ALNC_MNGT_TP_DIV_CD — NOT NULL
- ALNC_MNGT_FLD_SRNO (Key13) — NUMBER — 외래 키 → TB_CPPR_ALNC_MNGT_ADD_FLD_C.ALNC_MNGT_FLD_SRNO — NOT NULL
- ALNC_MNGT_FLD_VL (Field) — VARCHAR2(200)
TB_CPPR_ALNC_MNGT_B (CPPR_제휴사관리기본)
- SVC_ACNT_ID (Key) — VARCHAR2(10) — 기본 키 — NOT NULL
- USER_ID (Key1) — VARCHAR2(100) — 기본 키 — NOT NULL
- ALNC_MNGT_TP_DIV_CD (Key2) — VARCHAR2(2) — 기본 키 — NOT NULL
- USER_ID (Key3) — NUMBER — 외래 키 → TB_CMPT_USER_B.USER_ID — NOT NULL
- API_TP_DIV_CD (Field2) — VARCHAR2(2)
- ALNC_MNGT_APPV_STS_CD (Field3) — VARCHAR2(3)