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)