obzen_outcome_table
Tables (12)
C_CD_MNG (마케팅 공통코드)
- CDM_CD (공통코드) — VARCHAR2(64) — Primary key — NOT NULL
- CDM_TY (공통코드유형) — VARCHAR2(8)
- CULTURE (언어코드) — VARCHAR2(16)
- CDM_TY_NM (공통코드유형명) — VARCHAR2(95)
- CDM_CD_NM (공통코드명) — VARCHAR2(95)
- CDM_USE_DSTIC_CD (공통코드사용여부) — VARCHAR2(8)
- CDM_NM1 (TEMP명1) — VARCHAR2(150)
- CDM_CD1 (TEMP코드1) — VARCHAR2(100)
- CDM_MODI_EMP (수정사원번호) — VARCHAR2(16)
- CDM_MODI_DT (수정일시) — VARCHAR2(20)
- CDM_DESC (코드설명) — VARCHAR2(385)
- CDM_FLD1 (코드필드1) — VARCHAR2(2000)
- CDM_FLD2 (코드필드2) — VARCHAR2(2000)
C_CHAN (채널매체)
- CHAN_CD (채널코드) — VARCHAR2(8) — Primary key — NOT NULL
- CHAN_TY (채널종류) — VARCHAR2(2)
- TEMPLATE_NM (템플릿리소스명) — VARCHAR2(128)
- RESOURCE_NM (리소스명) — VARCHAR2(128)
- CHAN_DSTIC_CD (채널사용구분코드) — VARCHAR2(8)
- SCRT_PSNL_RPLC_YN (스크립트개인화치환여부) — CHAR(1)
- CHAN_RSNAL_AMT (채널매체개별단가) — NUMBER(16,0)
- TEM_APL_YN (기간적용여부) — CHAR(1)
- CHAN_EX_CAPA (채널수행용량) — NUMBER
- SCRT_REG_SIZE (스크립트등록사이즈) — NUMBER
- SMP_CAMP_FRAME_PATH (심플캠페인프레임경로) — VARCHAR2(256)
- CHAN_TRNS_TEM (채널전송기간) — NUMBER
- REBM_CHAN_QUEUE_NM (REBM채널큐명) — VARCHAR2(32)
- BBRN_USE_YN (영업점사용여부) — CHAR(1)
- SCRT_FRAME_PATH (스크립트프레임경로) — VARCHAR2(512)
- PRNT_SEQNO (출력순서) — NUMBER
- IMG_MNG_ID (이미지관리ID) — VARCHAR2(24)
- CHAN_SMP_MSG (채널간략메시지) — VARCHAR2(128)
- CHANIF_NM (채널인터페이스이름) — VARCHAR2(10)
- CHAN_MODI_EMP (수정사원번호) — VARCHAR2(16)
- CHAN_MODI_DT (최종수정일시) — VARCHAR2(20)
- CONT_RSRCT_TEM (접촉제한기간) — NUMBER
- CONT_RSRCT_CNT (접촉제한회수) — NUMBER
- TRNS_CRAT_TM (전송데이터생성시간) — VARCHAR2(8)
- WORK_DT_APL_YN (영업일적용여부) — CHAR(1)
- REBM_DT_RSRCT_CNT (REBM일별제한회수) — NUMBER
- REBM_TRNS_STR_TM (REBM전송시작시간) — VARCHAR2(4)
- REBM_TRNS_END_TM (REBM전송종료시간) — VARCHAR2(4)
- REBM_EX_USE_YN (REBM 수행채널 사용여부) — CHAR(1)
- TEBM_EX_USE_YN (Time-Gap EBM 수행채널 사용여부) — CHAR(1)
- DDMA_PROC_ID (DDMA프로세스식별자) — VARCHAR2(16)
- REBM_PSNL_RPLC_YN (REBM개인화치환여부) — CHAR(1)
- CHAN_DT_INPUT_CD (채널일자입력구분코드) — VARCHAR2(8)
C_CUST_CONT_HIST (고객접촉이력)
- CUST_ID (Key) — VARCHAR2(15) — Primary key — NOT NULL
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
- REBM_DETECT_ID (실시간EBM검출식별자) — NUMBER(20,0)
- EX_CAMP_ID (수행캠페인 ID) — VARCHAR2(24)
- CONT_CHAN_DIV_CD (고객 접촉 채널) — VARCHAR2(5)
- CONT_WRK_DIV_CD (채널 결과코드) — VARCHAR2(2)
- AGNT_SND_DT (채널 AGENT에 전송된 시각) — VARCHAR2(14)
- AGNT_SND_CD (채널 AGENT에 전송된 결과코드) — VARCHAR2(5)
- SND_RSLT_DIV_CD (고객수신코드(노출여부)) — VARCHAR2(1)
- CONT_RSLT_DIV_CD (수신접촉 결과코드(클릭여부)) — VARCHAR2(4)
- RECV_DT (고객수신시간(노출일시)) — DATE
- RETN_DT (고객으로부터 회송된 시간) — DATE
- OPN_DT (고객으로부터 OPEN된 시간(클릭일시)) — DATE
- CONT_DEPT_CD (고객접촉 부서ID) — VARCHAR2(5)
- CONT_EMP_NO (고객접촉 직원ID) — VARCHAR2(10)
- CONT_TXT (고객접촉 내용 요약) — VARCHAR2(512)
- UPD_DTM (최종 UPDATE시간) — VARCHAR2(14)
C_EX_ACT (수행활동고객목록)
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Primary key — NOT NULL
- EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24) — Foreign key → C_EX_CAMP.EX_CAMP_ID — NOT NULL
- ACT_ID (캠페인활동식별자) — VARCHAR2(24)
- EX_ACT_STAT (캠페인활동상태) — VARCHAR2(8)
- EX_ACT_STR_DT (시작일자) — VARCHAR2(10) — NOT NULL
- EX_ACT_END_DT (종료일자) — VARCHAR2(10)
- CHAN_TRNS_CUSTG_CNT (채널전송고객수) — NUMBER(16,0)
- EX_ACT_LST_INPUT_DT (최종입력일시) — VARCHAR2(1)
- EA_WORK_DT (작업일) — VARCHAR2(10)
- EA_WORK_EX_YN (작업수행여부) — VARCHAR2(1)
- CHAN_CD (채널코드) — VARCHAR2(8)
- EX_STEP_ID (수행캠페인단계식별자) — VARCHAR2(24)
- STEP_LEVEL (단계레벨) — NUMBER(38,0)
- EX_ACT_CRAT_STR_DTM (생성 시작일시) — VARCHAR2(20)
- EX_ACT_CRAT_END_DTM (생성 종료일시) — VARCHAR2(20)
- EX_ACT_CRAT_TERM (생성소요시간) — NUMBER(10,0)
- PSNL_SCRT_CRAT_CD (개인화스크립트생성코드) — VARCHAR2(15)
C_EX_ACT_CUST_LIST (수행활동별개인화목록)
- CUST_ID (고객번호) — VARCHAR2(32) — Primary key — NOT NULL
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
- EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24)
- CAMP_BRCH (캠페인유형코드) — VARCHAR2(8)
- CAMP_EX_SYS (캠페인수행시스템) — VARCHAR2(8)
- CHAN_CD (채널코드) — VARCHAR2(8) — NOT NULL
- WORK_DT (작업일) — VARCHAR2(8)
- SEGM_ID (세그먼트식별자) — VARCHAR2(24)
- CONT_SET_YN (대조군여부) — VARCHAR2(1)
- CHAN_BRCH_CD (채널분류코드) — VARCHAR2(8)
- FATG_USE_YN (퍼티그사용여부) — VARCHAR2(1)
- ACT_ID (캠페인활동식별자) — VARCHAR2(24)
- CUST_ID_INFO1 (고객식별자 정보1) — VARCHAR2(32)
- CUST_ID_INFO2 (고객식별자 정보2) — VARCHAR2(32)
- CUST_ID_INFO3 (고객식별자 정보3) — VARCHAR2(32)
C_EX_ACT_SCRT (수행캠페인활동스크립트)
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Primary key — NOT NULL
- SCRT_ID (스크립트식별자) — VARCHAR2(16)
- EAS_WORK_DT (작업일) — VARCHAR2(10)
- EAS_WORK_EX_YN (작업수행여부) — CHAR(1)
C_EX_CAMP (수행캠페인)
- EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24) — Primary key — NOT NULL
- CAMP_ID (캠페인식별자) — VARCHAR2(24)
- EX_CAMP_NM (수행캠페인명) — VARCHAR2(16)
- EX_CAMP_STAT (수행캠페인상태) — VARCHAR2(195)
- CAMP_EX_TY (캠페인실행유형코드) — VARCHAR2(8)
- CAMP_KIND (기획그룹종류) — VARCHAR2(8)
- FRST_BRCH_CD (캠페인제1유형코드) — VARCHAR2(8)
- SCND_BRCH_CD (캠페인제2유형코드) — VARCHAR2(8)
- CAMP_BRCH (캠페인유형) — VARCHAR2(8)
- EX_CAMP_STR_DT (수행시작일자) — VARCHAR2(8)
- EX_CAMP_END_DT (수행종료일자) — VARCHAR2(10)
- EC_WORK_DT (작업일) — VARCHAR2(10)
- EC_WORK_EX_YN (작업수행여부) — VARCHAR2(10)
- EX_CAMP_VALID_STR_DT (수행유효시작일) — CHAR(1)
- EX_CAMP_VALID_DT (수행유효일자) — VARCHAR2(10)
- CAMP_PRITY (캠페인우선순위) — VARCHAR2(10)
- CAMP_DRFT_DEPT (캠페인기안부서코드) — NUMBER(38,0)
- CAMP_DRFT_EMP (캠페인기안사원번호) — VARCHAR2(16)
- CAMP_INV_ID (캠페인Inv식별자) — VARCHAR2(16)
- CAMP_INV_KIND_CD (기획방법종류코드) — VARCHAR2(16)
- CAMP_BZWK_DSTIC (캠페인업무구분) — VARCHAR2(8)
- CAMP_DETSUBJ_CD (캠페인세부주제코드) — VARCHAR2(8)
- TEST_EX_YN (테스트수행여부) — CHAR(1)
- CAMP_PLAN_WORK_SYS (캠페인기획작업시스템) — VARCHAR2(8)
- CAMP_EX_SYS (수행시스템) — VARCHAR2(8)
- EX_CAMP_BACKUP_YN (수행캠페인백업여부) — CHAR(1)
- SYS_AR_CD (시스템영역코드) — VARCHAR2(8)
- CAMP_EX_NUM (캠페인 수행번호) — NUMBER(38,0)
- EX_CAMP_OZID (캠페인 설계정보) — VARCHAR2(32)
- CAMP_COST_TOT_AMT (캠페인비용) — NUMBER(10,0)
- EX_CAMP_CRAT_TM (수행캠페인생성시간) — VARCHAR2(6)
- CAMP_GRP_ID (캠페인그룹식별자) — VARCHAR2(16)
- CAMP_AFTER_ACT (캠페인후속조치) — VARCHAR2(512)
- END_TM (종료시간) — VARCHAR2(6)
- CAMP_ABT_EX_CD (AB테스트 수행캠페인 종류) — VARCHAR2(32)
C_SCRT_CONT (스크립트컨텐츠)
- SCRT_ID (스크립트식별자) — VARCHAR2(16) — Primary key — NOT NULL
- SCRT_TTL (제목) — VARCHAR2(256)
- SCRT_CONT (내용) — VARCHAR2(4000)
- SCRT_ADD_CONT (상세문구) — VARCHAR2(4000)
C_TY_SCND_BRCH (캠페인 유형 제2분류)
- SCND_BRCH_CD (캠페인유형제2분류코드) — VARCHAR2(8) — Primary key — NOT NULL
- CULTURE (언어코드) — VARCHAR2(16)
- PLAN_WORK_SYS (기획작업시스템) — VARCHAR2(8)
- FRST_BRCH_CD (캠페인유형제1분류코드) — VARCHAR2(8)
- SCND_BRCH_NM (캠페인유형제2분류명) — VARCHAR2(95)
- SCND_BRCH_EMP (제2분류수정사원) — VARCHAR2(16)
- SCND_BRCH_DTM (제2분류수정일시) — VARCHAR2(20)
- SBRCH_USE_DSTIC_CD (사용구분코드) — CHAR(1)
C_TY_THRD_BRCH (캠페인 유형 제3분류)
- CAMP_BRCH (캠페인유형분류코드) — VARCHAR2(8) — Primary key — NOT NULL
- CULTURE (언어코드) — VARCHAR2(16)
- PLAN_WORK_SYS (기획작업시스템) — VARCHAR2(8)
- SCND_BRCH_CD (캠페인유형제2분류코드) — VARCHAR2(8)
- CAMP_BRCH_NM (캠페인유형분류명) — VARCHAR2(95)
- CAMP_BRCH_EMP (캠페인유형수정사원) — VARCHAR2(16)
- CAMP_BRCH_DTM (캠페인유형수정일시) — VARCHAR2(20)
- CAMP_PRITY (캠페인우선순위) — NUMBER(38,0)
- PROD_HOLD_YN (상품보유여부) — CHAR(1)
OBZEN_RSLT (오브젠성과분석테이블)
- CUST_ID (고객번호) — VARCHAR2(32) — Foreign key → C_EX_ACT_CUST_LIST.CUST_ID — NOT NULL
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(32) — Foreign key → C_EX_ACT_CUST_LIST.EX_ACT_ID — NOT NULL
- CUST_ID (고객번호2) — Foreign key → C_CUST_CONT_HIST.CUST_ID
- EX_ACT_ID (수행캠페인활동식별자2) — Foreign key → C_CUST_CONT_HIST.EX_ACT_ID
- EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24)
- CONT_SET_YN (대조군여부) — VARCHAR2(1)
- EX_CAMP_NM (수행캠페인명) — VARCHAR2(16)
- CONT_CHAN_DIV_CD (고객접촉채널코드) — VARCHAR2(5)
- CONT_CHAN_DIV_NM (고객접촉채널이름) — VARCHAR2(5)
- CHAN_TRNS_CUSTG_CNT (채널전송고객수) — NUMBER(16,0)
- CAMP_EX_TY (캠페인실행유형코드) — VARCHAR2(8)
- CAMP_EX_TY_NM (캠페인실행유형코드이름) — VARCHAR2(95)
- SCND_BRCH_CD (캠페인제2유형코드) — VARCHAR2(8)
- SCND_BRCH_NM (캠페인제2유형이름) — VARCHAR2(95)
- CAMP_BRCH (캠페인유형) — VARCHAR2(8)
- CAMP_BRCH_NM (캠페인유형이름) — VARCHAR2(95)
- REBM_DETECT_ID (실시간ebm검출식별아이디) — NUMBER(20,0)
- EX_CAMP_STR_DT (수행시작일자) — VARCHAR2(8)
- EX_CAMP_END_DT (수행종료일자) — VARCHAR2(10)
- AGNT_SND_DT (채널agent에전송된시각) — VARCHAR2(14)
- SCRT_TTL (스크립트제목) — VARCHAR2(256)
- SCRT_CONT (스크립트) — VARCHAR2(4000)
- TEST_EX_YN (테스트수행여부) — CHAR(1)
- FATG_USE_YN (퍼티그사용여부) — VARCHAR2(1)
- CAMP_PRITY (캠페인우선순위) — VARCHAR2(10)
- EX_ACT_STAT (캠페인활동상태) — VARCHAR2(8)
- EX_ACT_STAT_NM (캠페인활동상태이름) — VARCHAR2(95)
- PSNL_SCRT_CRAT_CD (개인화스크립트생성코드) — VARCHAR2(15)
- AGNT_SND_CD (채널agent에전송된결과코드) — VARCHAR2(5)
- SND_RSLT_DIV_CD (고객수신코드) — VARCHAR2(1)
- SND_RSLT_DIV_NM (고객수신코드이름) — VARCHAR2(95)
- CONT_RSLT_DIV_CD (수신접촉결과코드) — VARCHAR2(4)
- CONT_RSLT_DIV_NM (수신접촉결과이름) — VARCHAR2(95)
- RECV_DT (고객수신시간) — DATE
- OPN_DT (고객으로부터오픈된시간) — DATE
- EX_CAMP_ID (수행캠페인식별자2) — Foreign key → C_EX_CAMP.EX_CAMP_ID — NOT NULL
- EX_ACT_ID (수행캠페인활동식별자3) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
- EX_ACT_ID (수행캠페인활동식별자4) — Foreign key → SCRT_TEMP.EX_ACT_ID — NOT NULL
- SCND_BRCH_CD (캠페인유형제2분류코드2) — Foreign key → C_TY_SCND_BRCH.SCND_BRCH_CD — NOT NULL
- CAMP_BRCH (캠페인유형분류코드) — Foreign key → C_TY_THRD_BRCH.CAMP_BRCH — NOT NULL
- CHAN_CD (채널코드) — Foreign key → C_CHAN.CHAN_CD — NOT NULL
- CDM_CD (공통코드) — Foreign key → C_CD_MNG.CDM_CD — NOT NULL
SCRT_TEMP (스크립트 임시테이블)
- EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT_SCRT.EX_ACT_ID — NOT NULL
- SCRT_ID (스크립트식별자) — VARCHAR2(16) — Foreign key → C_SCRT_CONT.SCRT_ID — NOT NULL
- SCRT_TTL (제목) — VARCHAR2(256)
- SCRT_CONT (내용) — VARCHAR2(4000)