test

Tables (3)

BANNER_CODE (Untitled3)

  • V_PRODUCTCD (Key2) — Foreign key → SHOP_PRODUCT.V_PRODUCTCD — NOT NULL
  • V_UUID (Key3) — Foreign key → CM_BANNER.V_UUID — NOT NULL

CM_BANNER (배너관리)

  • V_UUID (Key) — Primary key — NOT NULL
  • V_PARTNER_CD (Field)
  • V_TYPE (Field2)
  • N_SEQ (Field4)
  • V_REG_USERID (Field5)
  • V_REG_DTM (Field6)
  • V_FLAG_DEL (Field7)
  • V_FALG_SHOW (Field8)
  • V_START_DATE (Field9)
  • V_END_DATE (Field10)
  • V_CLOB (Field11)
  • V_NAME (Field12)
  • V_FLAG (Field3)
  • V_UPDATE_USERID (Field13)
  • V_UPDATE_DTM (Field14)
  • V_BANNER_AS (Field15)

SHOP_PRODUCT (상품)

  • V_PRODUCTCD (Key) — Primary key — NOT NULL
  • V_PARTNER_CD (Field)
  • V_PRODUCTCD (Field2)
  • V_BANNER_AS (Field3) — CHAR(1)
  • V_PRODUCTNM (Field4)