OW SKU그룹 테이블

테이블 (5)

Copy Of SKU_GROUP_B (CopyOfUntitled)

  • group_id (PK) — VARCHAR2 — 기본 키 — NOT NULL
  • group_name (Field) — VARCHAR2(11)
  • exposure_seq (Field2) — NUMBER

PDMP_SKU_B (Untitled4)

  • SKU_SEQ (Key) — LONG — 외래 키 → SKU_PRODUCT_B.SKU_ID — NOT NULL

SKU_GROUP_B (Untitled)

  • group_id (PK) — VARCHAR2 — 기본 키 — NOT NULL
  • group_name (Field) — VARCHAR2(11)
  • exposure_seq (Field2) — NUMBER

SKU_GROUP_R (Untitled2)

  • Key — LONG — 기본 키 — NOT NULL
  • group_id (PK) — VARCHAR2 — 외래 키 → SKU_GROUP_B.group_id — NOT NULL
  • SKU_ID (Key2) — VARCHAR2 — 외래 키 → SKU_PRODUCT_B.SKU_ID — NOT NULL

SKU_PRODUCT_B (Untitled3)

  • SKU_ID (Key) — LONG — 기본 키 — NOT NULL
  • SKU_CODE (Field4) — VARCHAR2
  • PRD_NO (Field) — VARCHAR2
  • OPT_NO (Field2) — VARCHAR2
  • SKU_NAME (Field3) — VARCHAR2
  • 물류사명,바코드 (Field5)