AVON_DAM초안
테이블 (9)
공통코드 (CM_CODE)
- CD — VARCHAR2(50) — 기본 키 — NOT NULL
- GRP_CD — VARCHAR2(50) — 외래 키 → 공통코드그룹.GRP_CD — NOT NULL
- 회사코드 (COMP_CD) — VARCHAR2(20) — 외래 키 → 회사.회사코드 — NOT NULL — 회사코드
- CD_NM — VARCHAR2(200) — NOT NULL
- STRT_DATE — VARCHAR2(8) — NOT NULL
- END_DATE — VARCHAR2(8) — NOT NULL
- USE_FLAG — VARCHAR2(1) — NOT NULL
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
- SORT_ORG — NUMBER
- C_ATTR1 — VARCHAR2(300)
- C_ATTR2 — VARCHAR2(300)
- C_ATTR3 — VARCHAR2(300)
- C_ATTR4 — VARCHAR2(300)
- C_ATTR5 — VARCHAR2(300)
- N_ATTR1 — NUMBER
- N_ATTR2 — NUMBER
- N_ATTR3 — NUMBER
- N_ATTR4 — NUMBER
- N_ATTR5 — NUMBER
공통코드그룹 (CM_CODE_GRP)
- GRP_CD — VARCHAR2(50) — 기본 키 — NOT NULL
- GRP_NM — VARCHAR2(200) — NOT NULL
- USE_FLAG — VARCHAR2(1) — NOT NULL
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
- C_ATTR1 — VARCHAR2(300)
- C_ATTR2 — VARCHAR2(300)
- C_ATTR3 — VARCHAR2(300)
- C_ATTR4 — VARCHAR2(300)
- C_ATTR5 — VARCHAR2(300)
- N_ATTR1 — NUMBER
- N_ATTR2 — NUMBER
- N_ATTR3 — NUMBER
- N_ATTR4 — NUMBER
- N_ATTR5 — NUMBER
언어코드 (CM_LANG)
- LANG_CD — VARCHAR2(5) — 기본 키 — NOT NULL — 언어코드
- LANG_NM — VARCHAR2(50) — NOT NULL
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
캠페인마스터 (CM_CMPGN)
- CMPGN_ID — VARCHAR2(6) — 기본 키 — NOT NULL
- 회사코드 (COMP_CD) — VARCHAR2(20) — 외래 키 → 회사.회사코드 — NOT NULL — 회사코드
- CMPGN_YR_NR — NUMBER(4) — NOT NULL
- CMPGN_NR — NUMBER(2) — NOT NULL
- CMPGN_STRT_DT — DATE
- CMPGN_END_DT — DATE
- BLOKED_STUS_IND — VARCHAR(1)
- CLOSD_STUS_IND — VARCHAR(1)
- MGLG_YR_NR — NUMBER
- MGLG_NR — NUMBER
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
품목마스터 (CM_ITEM_MST)
- ITEM_ID — VARCHAR2(50) — 기본 키 — NOT NULL
- 회사코드 (COMP_CD) — VARCHAR2(20) — 외래 키 → 회사.회사코드 — NOT NULL — 회사코드
- PROF_ID — VARCHAR2(50) — NOT NULL
- FSC_LEGAL_NM — VARCHAR2(250)
- FSC_NM — VARCHAR2(250)
- COI — VARCHAR2(6)
- TARGET_CD — VARCHAR2(5)
- CREATED_BY — VARCHAR2(100) — NOT NULL
- CREATION_DATE — DATE — NOT NULL
- LAST_UPDATED_BY — VARCHAR2(100) — NOT NULL
- LAST_UPDATE_DATE — DATE — NOT NULL
- C_ATTR1 — VARCHAR2(300)
- C_ATTR2 — VARCHAR2(300)
- C_ATTR3 — VARCHAR2(300)
- C_ATTR4 — VARCHAR2(300)
- C_ATTR5 — VARCHAR2(300)
- N_ATTR1 — NUMBER
- N_ATTR2 — NUMBER
- N_ATTR3 — NUMBER
- N_ATTR4 — NUMBER
- N_ATTR5 — NUMBER
품목상세 (CM_ITEM_DETL)
- ITEM_ID — VARCHAR2(50) — 외래 키 → 품목마스터.ITEM_ID — NOT NULL
- 회사코드 (COMP_CD) — VARCHAR2(20) — 외래 키 → 품목마스터.회사코드 — NOT NULL — 회사코드
- CMPGN_ID — VARCHAR2(6) — 외래 키 → 캠페인마스터.CMPGN_ID — NOT NULL
- PROF_ID — VARCHAR2(50)
- PRICE_REFULAR — NUMBER
- NUM_SPEC_FOR — NUMBER
- PRICE_SEPCIAL — NUMBER
- SAL_QTY_FSCT — NUMBER
- PROD_CST — NUMBER
- PFID — NUMBER
- OFFER_ID — NUMBER
- SALES_MAJOR — VARCHAR2(50)
- SALES_MINOR — VARCHAR2(50)
- OFFER_TYPE — VARCHAR2(50)
- FSC_LEGAL_NM — VARCHAR2(250)
- FSC_NM — VARCHAR2(250)
- LINE_NO — VARCHAR2(10)
- TAG_BILL — VARCHAR2(1)
- PROD_CATEGORY — VARCHAR2(50)
- TAG_BROCHURE — VARCHAR2(1)
- COI — VARCHAR2(6)
- START_PG — NUMBER
- PROD_PG — NUMBER
- VEH_ID — NUMBER
- MSET_NO — VARCHAR2(50)
- MSET_FSC_ID — VARCHAR2(50)
- BSET_NO — VARCHAR2(50)
- BSET_FSC_NO — VARCHAR2(50)
- STAT_CD — VARCHAR2(10)
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
품목언어 (CM_ITEM_LANG)
- ITEM_ID — VARCHAR2(50) — 외래 키 → 품목마스터.ITEM_ID — NOT NULL
- 회사코드 (COMP_CD) — VARCHAR2(20) — 외래 키 → 품목마스터.회사코드 — NOT NULL — 회사코드
- LANG_CD — VARCHAR2(5) — 외래 키 → 언어코드.LANG_CD — NOT NULL — 언어코드
- ITEM_DESC — VARCHAR2(250) — NOT NULL
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
회사 (CM_COMP)
- 회사코드 (COMP_CD) — VARCHAR2(20) — 기본 키 — NOT NULL — 회사코드
- COMP_NM — VARCHAR2(100) — NOT NULL
- MRKT_ID — NUMBER
- MRKT_CD — VARCHAR2(50)
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDT_DATE — DATE
회사별언어 (CM_COMP_LANG)
- COMP_CD — VARCHAR2(20) — 외래 키 → 회사.회사코드 — NOT NULL — 회사코드
- LANG_CD — VARCHAR2(5) — 외래 키 → 언어코드.LANG_CD — NOT NULL — 언어코드
- CREATED_BY — VARCHAR2(100)
- CREATION_DATE — DATE
- LAST_UPDATED_BY — VARCHAR2(100)
- LAST_UPDATE_DATE — DATE
- PRIMARY_FLAG — VARCHAR2(1) — NOT NULL
- USE_FLAG — VARCHAR2(1) — NOT NULL