goodsDetail

Tables (64)

ENTP_HOLIDAY_NO (Untitled15)

  • ENTP_CODE (Key) — Primary key — NOT NULL

TBANNER (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜2242)

  • BANNER_CODE (Field2) — Primary key

TBRAND (CopyOfCopyOf상품)

  • BRAND_CODE (GOODS_CODE) — Primary key — NOT NULL

TBROADGOODSALERT (CopyOf찜)

  • ALERT_SEQ (Field2) — Primary key

TCATEGORY (CopyOfUntitled7)

  • CATEGORY_CODE (Key) — Primary key — NOT NULL

TCATEGORYGOODS (Untitled7)

  • CATEGORY_CODE (Key) — Primary key — NOT NULL
  • GOODS_CODE (Key2) — Primary key — NOT NULL

TCOMMONBANNER (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜22422)

  • BANNER_CODE (Field2) — Primary key

TCOMMONBANNEREXCEPT (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜22422)

  • BANNER_CODE (Field2) — Primary key
  • GOODS_SEQ (Key) — Primary key — NOT NULL

TCOMMONBANNERINFO (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜22422)

  • BANNER_CODE (Field2) — Primary key
  • INFO_SEQ (Key) — Primary key — NOT NULL

TCSKINDS (Untitled9)

  • CS_LGROUP (Key) — Primary key — NOT NULL
  • CS_MGROUP (Key2) — Primary key — NOT NULL
  • CS_SGROUP (Key3) — Primary key — NOT NULL

TCUSTCOUNSELDT (Untitled8)

  • COUNSEL_SEQ (Key) — Primary key — NOT NULL
  • COUNSEL_DT_SEQ (Key2) — Primary key — NOT NULL

TCUSTCOUNSELM (CopyOf상품8)

  • COUNSEL_SEQ (GOODS_CODE) — Primary key — NOT NULL

TCUSTOMER (CopyOfCopyOfCopyOf찜)

  • CUST_NO (GOODS_CODE) — Primary key — NOT NULL

TDAYDELIVERY_GOODS (Untitled14)

  • GOODS_CODE (Key) — Primary key — NOT NULL

TDELYDAY (Untitled16)

  • DELY_GB (Key) — Primary key — NOT NULL
  • YYMMDD (Key2) — Primary key — NOT NULL

TDELYNOAREA (Untitled13)

  • GOODS_CODE (Key) — Primary key — NOT NULL
  • AREA_GB (Key2) — Primary key — NOT NULL

TDESCRIBE (Untitled19)

  • GOODS_CODE (Key) — Primary key — NOT NULL
  • DESCRIBE_CODE (Key2) — Primary key — NOT NULL

TEASYCARDPROMOADDINFO (CopyOfCopyOfCopyOfCopyOfCopyOf찜2222)

  • PROMO_NO (Field2) — Primary key

TEASYCARDPROMOM (CopyOfCopyOfCopyOfCopyOf찜223)

  • PROMO_NO (Field2) — Primary key

TEASYCARDPROMOTARGET (CopyOfCopyOfCopyOfCopyOfCopyOf찜222)

  • PROMO_NO (Field2) — Primary key
  • PROMO_SEQ (Key) — Primary key — NOT NULL
  • GOODS_CODE (Field)

TENTERPRISE (CopyOfUntitled15)

  • ENTP_CODE (Key) — Primary key — NOT NULL

TEVENTADDINFO (Untitled10)

  • EVENT_NO (Key) — Primary key — NOT NULL

TEVENTM (CopyOfCopyOfCopyOfCopyOfCopyOf찜2242)

  • EVENT_NO (Field2) — Primary key

TGOODS (상품)

  • GOODS_CODE — Primary key — NOT NULL

TGOODS (CopyOf상품7)

  • GOODS_CODE — Primary key — NOT NULL

TGOODSADDINFO (CopyOf상품)

  • GOODS_CODE — Primary key — NOT NULL

TGOODSCOMMENT (Untitled2)

  • COMMENT_SEQ (Key) — Primary key — NOT NULL

TGOODSCOMMENTIMAGE (CopyOfCopyOfCopyOfCopyOf찜)

  • GOODS_CODE — Primary key — NOT NULL
  • COMMENT_SEQ (Key) — Primary key — NOT NULL
  • IMAGE_SEQ (Key2) — Primary key — NOT NULL

TGOODSCOMMENTSUM (Untitled3)

  • GOODS_CODE (Key) — Primary key — NOT NULL

TGOODSDELYINFO (CopyOfCopyOf상품2)

  • GOODS_CODE — Primary key — NOT NULL

TGOODSDT (CopyOf상품6)

  • GOODS_CODE — Primary key — NOT NULL
  • GOODSDT_CODE (Key) — Primary key — NOT NULL

TGOODSIMAGE (CopyOf상품3)

  • GOODS_CODE — Primary key — NOT NULL

TGOODSINFOIMAGE (Untitled12)

  • GOODS_CODE (Key) — Primary key — NOT NULL
  • INFO_GOODS_SEQ (Key2) — Primary key — NOT NULL

TGOODSKCINFO (Untitled)

  • GOODS_CODE (Key) — Primary key — NOT NULL

TGOODSKINDS (CopyOfUntitled)

  • LGROUP (Key) — Primary key — NOT NULL
  • MGROUP (Key2) — Primary key — NOT NULL
  • SGROUP (Key3) — Primary key — NOT NULL
  • DGROUP (Key4) — Primary key — NOT NULL

TGOODSPRICE (CopyOf상품4)

  • GOODS_CODE — Primary key — NOT NULL
  • APPLY_DATE (Key) — Primary key — NOT NULL

TGOODSVOD (CopyOfCopyOf상품3)

  • GOODS_CODE — Primary key — NOT NULL

TINALERT (CopyOfCopyOf찜2)

  • ALERT_SEQ (Field2) — Primary key

TINPLANQTY (Untitled18)

  • GOODS_CODE (Key) — Primary key — NOT NULL
  • GOODSDT_CODE (Key2) — Primary key — NOT NULL
  • SEQ (Key3) — Primary key — NOT NULL

TMDGOODSCOMMENT (CopyOf상품5)

  • GOODS_CODE — Primary key — NOT NULL

TMULTIDTBROAD (CopyOfUntitled5)

  • SEQ_FRAME_NO (Key) — Primary key — NOT NULL
  • SEQ_NO (Key2) — Primary key — NOT NULL

TMULTIFRAMESCHE (Untitled5)

  • SEQ_FRAME_NO (Key) — Primary key — NOT NULL

TOFFER (CopyOfCopyOf상품4)

  • GOODS_CODE — Primary key — NOT NULL
  • OFFER_TYPE (Key) — Primary key — NOT NULL
  • OFFER_CODE (Key2) — Primary key — NOT NULL

TOFFERCODE (CopyOfCopyOfCopyOf상품4)

  • OFFER_TYPE (Key) — Primary key — NOT NULL
  • OFFER_CODE (Key2) — Primary key — NOT NULL

TORDERDT (CopyOfCopyOfCopyOfCopyOfCopyOf찜)

  • ORDER_NO (GOODS_CODE) — Primary key — NOT NULL
  • ORDER_G_SEQ (Key) — Primary key — NOT NULL
  • ORDER_D_SEQ (Key2) — Primary key — NOT NULL
  • ORDER_W_SEQ (Key3) — Primary key — NOT NULL

TORDERGOODS (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜)

  • ORDER_NO (GOODS_CODE) — Primary key — NOT NULL
  • ORDER_G_SEQ (Key) — Primary key — NOT NULL

TORDERSTOCK (Untitled17)

  • GOODS_CODE (Key) — Primary key — NOT NULL
  • GOODSDT_CODE (Key2) — Primary key — NOT NULL
  • WH_CODE (Key3) — Primary key — NOT NULL

TPGMTAPEGOODS (Untitled4)

  • TAPE_CODE (Key) — Primary key — NOT NULL
  • GOODS_CODE (Key2) — Primary key — NOT NULL

TPLAN (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜2242)

  • PLAN_CODE (Field2) — Primary key

TPLANBANNER (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜224222)

  • PLANCLASS_CODE (Field2) — Primary key
  • PLAN_CODE (Key) — Primary key — NOT NULL
  • AREA_CODEB (Key2) — Primary key — NOT NULL
  • BANNER_SEQ (Key3) — Primary key — NOT NULL

TPLANGOODS (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜22422)

  • PLAN_CODE (Field2) — Primary key
  • GOODS_CODE (Field)

TPOLICY (CopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOfCopyOf찜224223)

  • POLICY_NO (Field2) — Primary key

TPRESENTABLE (CopyOf상품2)

  • GOODS_CODE — Primary key — NOT NULL

TPRM_EVENT_EXCLUSION_MGMT (Untitled11)

  • EVENT_NO (Key) — Primary key — NOT NULL
  • EXCLUSION_EVENT_NO (Key2) — Primary key — NOT NULL

TPRM_EVENT_PLAN (CopyOfCopyOfCopyOfCopyOfCopyOf찜224)

  • EVENT_NO (Field2) — Primary key
  • PLAN_CODE (Key) — Primary key — NOT NULL

TPRM_EVENT_PROMO (CopyOfCopyOfCopyOfCopyOf찜224)

  • EVENT_PROMO_NO (Field2) — Primary key

TPRM_EVENT_PROMO_GOODS (Untitled6)

  • EVENT_PROMO_NO (Key) — Primary key — NOT NULL
  • TARGET_EXCEPT_GB (Key2) — Primary key — NOT NULL
  • GOODS_INFO_GB (Key3) — Primary key — NOT NULL
  • GOODS_INFO_CODE (Key4) — Primary key — NOT NULL

TPROMOADDINFO (CopyOfCopyOfCopyOfCopyOf찜222)

  • PROMO_NO (Field2) — Primary key

TPROMOGIFT (CopyOfCopyOfCopyOfCopyOfCopyOf찜22)

  • PROMO_NO (Field2) — Primary key
  • PROMO_SEQ (Key) — Primary key — NOT NULL

TPROMOM (CopyOfCopyOfCopyOf찜22)

  • PROMO_NO (Field2) — Primary key

TPROMOTARGET (CopyOfCopyOfCopyOfCopyOf찜22)

  • PROMO_NO (Field2) — Primary key
  • PROMO_SEQ (Key) — Primary key — NOT NULL
  • GOODS_CODE (Field)

TSHIPCOSTDT (CopyOfCopyOfCopyOfCopyOf찜2)

  • SHIP_COST_CODE (GOODS_CODE) — Primary key — NOT NULL

TSHIPCOSTM (CopyOfCopyOfCopyOf찜2)

  • ENTP_CODE (Field) — Primary key
  • SHIP_COST_CODE (GOODS_CODE) — Primary key — NOT NULL

TWISHLIST (찜)

  • CUST_NO (GOODS_CODE) — Primary key — NOT NULL