Weekly Data Load

테이블 (3)

EBAY_3S_w2316T

  • PID — varchar — 기본 키
  • CD — varchar
  • CDName — varchar
  • FName — varchar
  • E제품명 — varchar
  • EPIN — int
  • 카테고리 — varchar
  • PID1 — varchar
  • Barcode — varchar
  • Barcode1 — varchar
  • URL — varchar
  • TAG — varchar
  • EBAY_DESCK — varchar
  • 표준화_EBAY_DESCK — varchar
  • Opt — varchar
  • Tag01 — varchar
  • Tag02 — varchar
  • Tag03 — varchar
  • Tag04 — varchar
  • Tag05 — varchar
  • Tag06 — varchar
  • Tag07 — varchar
  • Tag08 — varchar
  • Tag09 — varchar
  • Tag10 — varchar
  • Tag11 — varchar
  • Tag12 — varchar
  • Tag13 — varchar
  • Tag14 — varchar
  • Tag15 — varchar
  • Tag16 — varchar
  • Tag17 — varchar
  • Tag18 — varchar
  • Tag19 — varchar
  • Tag20 — varchar
  • Tag21 — varchar
  • Tag22 — varchar
  • Tag23 — varchar
  • Tag24 — varchar
  • Tag25 — varchar
  • Tag26 — varchar
  • Tag27 — varchar
  • Tag28 — varchar
  • Tag29 — varchar
  • Tag30 — varchar
  • 작업유무 — varchar
  • 재작업유무 — varchar
  • memo1 — varchar
  • 모델번호 — varchar
  • 제조사명K — varchar
  • MID — varchar
  • MS_CHK — varchar
  • EManuf — varchar
  • EBrand — varchar
  • EdesckF — varchar
  • EdesckS — varchar
  • DManuf — varchar
  • DBrand — varchar
  • Dmodel_no — varchar
  • DdesckF — varchar
  • … +15

ESA_w2316

  • sdcd — varchar
  • pid — varchar
  • pid1 — varchar
  • barcode — varchar
  • barcode1 — varchar
  • ebname — varchar
  • ebbchk — varchar
  • ebcnt1 — int
  • ebcnt2 — int
  • nes_yn — varchar
  • ebvalue1 — varchar
  • flag1 — varchar
  • flag2 — varchar

gmarket 주별작업용 테이블 (total_weekly_working)

  • year_week — VARCHAR(50) — 기본 키 — NOT NULL — 주 넘버' COLLATE 'utf8_general_ci
  • h — VARCHAR(20) — 기본 키 — NOT NULL — 상품번호 PID' COLLATE 'utf8_general_ci
  • i — VARCHAR(20) — 기본 키 — NOT NULL — PID 1' COLLATE 'utf8_general_ci
  • k — VARCHAR(20) — 기본 키 — NOT NULL — barcode1' COLLATE 'utf8_general_ci
  • Idx — INT(11) — NOT NULL
  • a — VARCHAR(20) — NOT NULL — tno' COLLATE 'utf8_general_ci
  • b — VARCHAR(10) — NOT NULL — 작업자' COLLATE 'utf8_general_ci
  • c — VARCHAR(20) — NOT NULL — CD재분리' COLLATE 'utf8_general_ci
  • d — VARCHAR(20) — NOT NULL — SD2 카테고리 코드' COLLATE 'utf8_general_ci
  • e — VARCHAR(200) — NOT NULL — SD2 카테고리명' COLLATE 'utf8_general_ci
  • f — VARCHAR(20) — NOT NULL — SD2수정카테고리코드' COLLATE 'utf8_general_ci
  • g — VARCHAR(200) — NOT NULL — SD2수정카테고리 명' COLLATE 'utf8_general_ci
  • j — VARCHAR(20) — NOT NULL — barcode' COLLATE 'utf8_general_ci
  • l — VARCHAR(50) — NOT NULL — 네이버 Leaf 명' COLLATE 'utf8_general_ci
  • m — VARCHAR(1000) — NOT NULL — URL1' COLLATE 'utf8_general_ci
  • n — VARCHAR(2000) — NOT NULL — 상품정보테그' COLLATE 'utf8_general_ci
  • o — VARCHAR(100) — NOT NULL — 원본_Desck' COLLATE 'utf8_general_ci
  • p — VARCHAR(200) — NOT NULL — EBAY_Desck' COLLATE 'utf8_general_ci
  • q — VARCHAR(500) — NOT NULL — 표준화_EBAY_Desck' COLLATE 'utf8_general_ci
  • r — VARCHAR(500) — NOT NULL — 수정_EBAY_Desck' COLLATE 'utf8_general_ci
  • s — VARCHAR(200) — NOT NULL — 모델번호' COLLATE 'utf8_general_ci
  • t — VARCHAR(300) — NOT NULL — OPT' COLLATE 'utf8_general_ci
  • u — VARCHAR(100) — NOT NULL — Memo1' COLLATE 'utf8_general_ci
  • v — VARCHAR(50) — NOT NULL — 상품보조명' COLLATE 'utf8_general_ci
  • w — VARCHAR(50) — NOT NULL — 규약기준' COLLATE 'utf8_general_ci
  • x — VARCHAR(500) — NOT NULL — 제조사URL' COLLATE 'utf8_general_ci
  • y — VARCHAR(20) — NOT NULL — 제조사코드' COLLATE 'utf8_general_ci
  • z — VARCHAR(50) — NOT NULL — 제조사명 K' COLLATE 'utf8_general_ci
  • aa — VARCHAR(50) — NOT NULL — 제조사명 E' COLLATE 'utf8_general_ci
  • ab — VARCHAR(20) — NOT NULL — 브랜드 코드' COLLATE 'utf8_general_ci
  • ac — VARCHAR(50) — NOT NULL — 브랜드명 K' COLLATE 'utf8_general_ci
  • ad — VARCHAR(50) — NOT NULL — 브랜드명 E' COLLATE 'utf8_general_ci
  • ae — VARCHAR(20) — NOT NULL — p브랜드 코드' COLLATE 'utf8_general_ci
  • af — VARCHAR(50) — NOT NULL — p브랜드명K' COLLATE 'utf8_general_ci
  • ag — VARCHAR(50) — NOT NULL — p브랜드명E' COLLATE 'utf8_general_ci
  • ah — VARCHAR(20) — NOT NULL — 총용량' COLLATE 'utf8_general_ci
  • ai — VARCHAR(20) — NOT NULL — 총용량_단위' COLLATE 'utf8_general_ci
  • aj — VARCHAR(20) — NOT NULL — 총무게' COLLATE 'utf8_general_ci
  • ak — VARCHAR(20) — NOT NULL — 총무게_단위' COLLATE 'utf8_general_ci
  • al — VARCHAR(20) — NOT NULL — 개당용량' COLLATE 'utf8_general_ci
  • am — VARCHAR(20) — NOT NULL — 개당용량_단위' COLLATE 'utf8_general_ci
  • an — VARCHAR(20) — NOT NULL — 개당무게' COLLATE 'utf8_general_ci
  • ao — VARCHAR(20) — NOT NULL — 개당무게_단위' COLLATE 'utf8_general_ci
  • ap — VARCHAR(20) — NOT NULL — 수량' COLLATE 'utf8_general_ci
  • aq — VARCHAR(20) — NOT NULL — 수량_단위' COLLATE 'utf8_general_ci
  • ar — VARCHAR(20) — NOT NULL — 매수_내지' COLLATE 'utf8_general_ci
  • as — VARCHAR(20) — NOT NULL — 매수_내지_단위' COLLATE 'utf8_general_ci
  • at — VARCHAR(20) — NOT NULL — UNIT' COLLATE 'utf8_general_ci
  • au — VARCHAR(20) — NOT NULL — BOX' COLLATE 'utf8_general_ci
  • av — VARCHAR(20) — NOT NULL — PACK' COLLATE 'utf8_general_ci
  • aw — VARCHAR(20) — NOT NULL — YN용량' COLLATE 'utf8_general_ci
  • ax — VARCHAR(20) — NOT NULL — YN무게' COLLATE 'utf8_general_ci
  • ay — VARCHAR(20) — NOT NULL — YN개당용량' COLLATE 'utf8_general_ci
  • az — VARCHAR(20) — NOT NULL — YN개당무게' COLLATE 'utf8_general_ci
  • ba — VARCHAR(20) — NOT NULL — YN수량' COLLATE 'utf8_general_ci
  • bb — VARCHAR(20) — NOT NULL — YN매수_내지' COLLATE 'utf8_general_ci
  • bc — VARCHAR(50) — NOT NULL — 캡슐용량' COLLATE 'utf8_general_ci
  • bd — VARCHAR(20) — NOT NULL — 캡슐용량단위' COLLATE 'utf8_general_ci
  • be — VARCHAR(20) — NOT NULL — 캡슐수량' COLLATE 'utf8_general_ci
  • bf — VARCHAR(20) — NOT NULL — 캡슐수량단위' COLLATE 'utf8_general_ci
  • … +40