[Copy_20190113] 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