GPOne_PDP_Mig

테이블 (6)

MIG_ADOBE_MAPPING (Untitled5)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → MIG_COMPONENT_MAPPING.Key — NOT NULL
  • seq (seq2) — 외래 키 → MIG_COMPONENT_MAPPING.seq — NOT NULL
  • comp (Field3)
  • attr (Field4)
  • key (Field)
  • val (Field6)

MIG_COMPONENT_MAPPING (Untitled6)

  • Key — 기본 키 — NOT NULL
  • seq (seq2) — 외래 키 → MIG_PDP_EXTRACT.seq — NOT NULL
  • to_be_comp (Field3)
  • to_be_attr (Field4)
  • as_is_comp (Field)
  • as_is_attr (Field2)
  • excel_order (Field5)
  • max_cnt (Field6)
  • repli_flag (Field7)
  • max_attr (Field8)
  • repli_attr (Field9)

MIG_PDP_EXTRACT (Untitled)

  • seq — 기본 키 — NOT NULL
  • locale (Field7) — varchar(100)
  • page (Field) — varchar(500)
  • comp (Field2) — varchar(100)
  • attr (Field3) — varchar(500)
  • val (Field4) — text
  • creation_date (Field5) — datetime
  • comp_order (Field6) — varchar(100)
  • repli_order (Field8) — varchar(100)
  • type (Field9) — varchar(100)

MIG_PDP_MAPPING (Untitled2)

  • seq (Key) — 기본 키 — NOT NULL
  • ext_no (seq) — 외래 키 → MIG_PDP_EXTRACT.seq — NOT NULL
  • Key (Key2) — 외래 키 → MIG_COMPONENT_MAPPING.Key — NOT NULL
  • seq (seq2) — 외래 키 → MIG_COMPONENT_MAPPING.seq — NOT NULL
  • locale (Field3)
  • page (Field7)
  • comp (Field4)
  • attr (Field5)
  • val (Field) — text
  • type (Field6)
  • creation_date (Field2)

MIG_URL_MAPPING (Untitled4)

  • Key — 기본 키 — NOT NULL
  • seq (Key2) — 외래 키 → MIG_PDP_MAPPING.seq — NOT NULL
  • seq — 외래 키 → MIG_PDP_MAPPING.ext_no — NOT NULL
  • Key (Key22) — 외래 키 → MIG_PDP_MAPPING.Key — NOT NULL
  • seq (seq2) — 외래 키 → MIG_PDP_MAPPING.seq — NOT NULL
  • locale (Field)
  • as_is_url (Field2)
  • to_be_url (Field3)
  • val (Field4)

MKT_MODEL_M(예정) (Untitled3)

  • Key — 기본 키 — NOT NULL
  • seq (Key2) — 외래 키 → MIG_PDP_MAPPING.seq — NOT NULL
  • seq — 외래 키 → MIG_PDP_MAPPING.ext_no — NOT NULL
  • Key (Key22) — 외래 키 → MIG_PDP_MAPPING.Key — NOT NULL
  • seq (seq2) — 외래 키 → MIG_PDP_MAPPING.seq — NOT NULL
  • locale (Field)
  • model_id (Field2)
  • sku (Field3)