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