Weekly Data Load
테이블 (14)
EBAY_ATTR_CHG
- tno — varchar
- EPIN정책 — varchar
- DNS정책 — varchar
- SD카테고리코드 — varchar
- 카테고리상태 — varchar
- Leaf — varchar
- SD2_카테고리코드 — varchar
- SD카테고리명 — varchar
- c1 — varchar
- c2 — varchar
- c3 — varchar
- c4 — varchar
- c5 — varchar
- 속성상태 — varchar
- 속성필수 — varchar
- 타입 — varchar
- 속성순위 — varchar
- 속성ID — varchar
- 관리속성명 — varchar
- 전시속성명 — varchar
- 속성값순위 — varchar
- 속성값ID — varchar
- 속성값 — varchar
- 속성값_판단기준 — varchar
- 타사이트_SD속성값치환 — varchar
- 원산지_판단기준 — varchar
- 참고url — varchar
- naver_attr — varchar
- danawa_attr — varchar
- enuri_attr — varchar
- total_attr — varchar
- 제품명에_영향주는_속성 — varchar
- 서비스속성_여부 — varchar
- 전체리스트_사이즈항목치환 — varchar
- memo — varchar
- 수량과_PACK의_관계 — varchar
- 표준화규약_해당속성 — varchar
- 표준화규약_속성값_치환 — varchar
- 타사이트_속성치환 — varchar
- 소스사이트 — varchar
- 프로그램속성비교 — varchar
- naver_attr01 — varchar
- naver_attr02 — varchar
- naver_attr03 — varchar
- naver_attr04 — varchar
- naver_attr05 — varchar
- naver_attr06 — varchar
- naver_attr07 — varchar
- naver_attr08 — varchar
- naver_attr09 — varchar
- naver_attr10 — varchar
- naver_attr11 — varchar
- naver_attr12 — varchar
- naver_attr13 — varchar
- naver_attr14 — varchar
- naver_attr15 — varchar
- naver_attr16 — varchar
- naver_attr17 — varchar
- naver_attr18 — varchar
- naver_attr19 — varchar
- … +61
EBAY_attr_match
- cd — varchar
- cdname — varchar
- ebay_attr_name — varchar
- ebay_attr_value — varchar
- naver_attr_name — varchar
- naver_attr_no — int
- naver_memo — varchar
- danawa_attr_name — varchar
- danawa_attr_no — int
- danawa_memo — varchar
- enuri_attr_name — varchar
- enuri_attr_no — int
- enuri_memo — varchar
- naver_attr_name01 — varchar
- naver_attr_name02 — varchar
- naver_attr_name03 — varchar
- naver_attr_name04 — varchar
- naver_attr_name05 — varchar
- naver_attr_name06 — varchar
- naver_attr_name07 — varchar
- naver_attr_name08 — varchar
- naver_attr_name09 — varchar
- naver_attr_name10 — varchar
- naver_attr_name11 — varchar
- naver_attr_name12 — varchar
- naver_attr_name13 — varchar
- naver_attr_name14 — varchar
- naver_attr_name15 — varchar
- naver_attr_name16 — varchar
- naver_attr_name17 — varchar
- naver_attr_name18 — varchar
- naver_attr_name19 — varchar
- naver_attr_name20 — varchar
- danawa_attr_name01 — varchar
- danawa_attr_name02 — varchar
- danawa_attr_name03 — varchar
- danawa_attr_name04 — varchar
- danawa_attr_name05 — varchar
- danawa_attr_name06 — varchar
- danawa_attr_name07 — varchar
- danawa_attr_name08 — varchar
- danawa_attr_name09 — varchar
- danawa_attr_name10 — varchar
- danawa_attr_name11 — varchar
- danawa_attr_name12 — varchar
- danawa_attr_name13 — varchar
- danawa_attr_name14 — varchar
- danawa_attr_name15 — varchar
- danawa_attr_name16 — varchar
- danawa_attr_name17 — varchar
- danawa_attr_name18 — varchar
- danawa_attr_name19 — varchar
- danawa_attr_name20 — varchar
- enuri_attr_name01 — varchar
- enuri_attr_name02 — varchar
- enuri_attr_name03 — varchar
- enuri_attr_name04 — varchar
- enuri_attr_name05 — varchar
- enuri_attr_name06 — varchar
- enuri_attr_name07 — varchar
- … +13
ebay_3s_w2316t
- cd — VARCHAR(50) — NOT NULL
- cdname — VARCHAR(100) — NOT NULL
- fname — VARCHAR(200) — NOT NULL
- edesck — VARCHAR(500) — NOT NULL
- epin — INT(11) — NOT NULL
- category — VARCHAR(200) — NOT NULL
- pid — VARCHAR(50) — NOT NULL
- pid1 — VARCHAR(50) — NOT NULL
- barcode — VARCHAR(50) — NOT NULL
- barcode1 — VARCHAR(50) — NOT NULL
- url — VARCHAR(1000) — NOT NULL
- tag — VARCHAR(2000) — NOT NULL
- ebay_desck — VARCHAR(500) — NOT NULL
- std_ebay_desck — VARCHAR(500) — NOT NULL
- opt — VARCHAR(200) — NOT NULL
- tag01 — VARCHAR(1000) — NOT NULL
- tag02 — VARCHAR(200) — NOT NULL
- tag03 — VARCHAR(200) — NOT NULL
- tag04 — VARCHAR(200) — NOT NULL
- tag05 — VARCHAR(200) — NOT NULL
- tag06 — VARCHAR(200) — NOT NULL
- tag07 — VARCHAR(200) — NOT NULL
- tag08 — VARCHAR(200) — NOT NULL
- tag09 — VARCHAR(200) — NOT NULL
- tag10 — VARCHAR(200) — NOT NULL
- tag11 — VARCHAR(200) — NOT NULL
- tag12 — VARCHAR(200) — NOT NULL
- tag13 — VARCHAR(200) — NOT NULL
- tag14 — VARCHAR(200) — NOT NULL
- tag15 — VARCHAR(200) — NOT NULL
- tag16 — VARCHAR(200) — NOT NULL
- tag17 — VARCHAR(200) — NOT NULL
- tag18 — VARCHAR(200) — NOT NULL
- tag19 — VARCHAR(200) — NOT NULL
- tag20 — VARCHAR(200) — NOT NULL
- tag21 — VARCHAR(200) — NOT NULL
- tag22 — VARCHAR(200) — NOT NULL
- tag23 — VARCHAR(200) — NOT NULL
- tag24 — VARCHAR(200) — NOT NULL
- tag25 — VARCHAR(200) — NOT NULL
- tag26 — VARCHAR(200) — NOT NULL
- tag27 — VARCHAR(200) — NOT NULL
- tag28 — VARCHAR(200) — NOT NULL
- tag29 — VARCHAR(200) — NOT NULL
- tag30 — VARCHAR(200) — NOT NULL
- 작업유무 — VARCHAR(50) — NOT NULL
- 재작업유무 — VARCHAR(50) — NOT NULL
- memo1 — VARCHAR(200) — NOT NULL
- 모델번호 — VARCHAR(200) — NOT NULL
- 제조사명k — VARCHAR(200) — NOT NULL
- mid — VARCHAR(200) — NOT NULL
- ms_chk — VARCHAR(20) — NOT NULL
- emanuf — VARCHAR(200) — NOT NULL
- ebrand — VARCHAR(200) — NOT NULL
- edesckf — VARCHAR(200) — NOT NULL
- edescks — VARCHAR(200) — NOT NULL
- dmanuf — VARCHAR(200) — NOT NULL
- dbrand — VARCHAR(200) — NOT NULL
- dmodel_no — VARCHAR(200) — NOT NULL
- ddesckf — VARCHAR(200) — NOT NULL
- … +15
ebay_total
- cd — VARCHAR(20) — NOT NULL
- cdname — VARCHAR(100) — NOT NULL
- epin — VARCHAR(50) — NOT NULL
- gmarket — VARCHAR(20) — NOT NULL
- epid — VARCHAR(20) — NOT NULL
- pid — VARCHAR(20) — NOT NULL
- pid1 — VARCHAR(20) — NOT NULL
- barcode — VARCHAR(20) — NOT NULL
- model_name — VARCHAR(200) — NOT NULL
- model_no — VARCHAR(100) — NOT NULL
- opt — VARCHAR(100) — NOT NULL
- delivery — VARCHAR(50) — NOT NULL
- udate — VARCHAR(10) — NOT NULL
- finalchk — VARCHAR(10) — NOT NULL
- flag1 — VARCHAR(200) — NOT NULL
- edesck — VARCHAR(200) — NOT NULL
- naver_description — VARCHAR(200) — NOT NULL
- group_no — VARCHAR(20) — NOT NULL
- manuf_code — VARCHAR(50) — NOT NULL
- manuf_desck — VARCHAR(100) — NOT NULL
- manuf_desce — VARCHAR(100) — NOT NULL
- brand_code — VARCHAR(50) — NOT NULL
- brand_desck — VARCHAR(100) — NOT NULL
- brand_desce — VARCHAR(100) — NOT NULL
- pbrand_code — VARCHAR(50) — NOT NULL
- pbrand_desck — VARCHAR(100) — NOT NULL
- pbrand_desce — VARCHAR(100) — NOT NULL
ebay_total_attr
- sdcd — VARCHAR(20) — NOT NULL
- epin — VARCHAR(50) — NOT NULL
- gmarket — VARCHAR(20) — NOT NULL
- epid — VARCHAR(20) — NOT NULL
- pid — VARCHAR(20) — NOT NULL
- pid1 — VARCHAR(20) — NOT NULL
- barcode — VARCHAR(20) — NOT NULL
- ebname — VARCHAR(100) — NOT NULL
- ebbchk — VARCHAR(2) — NOT NULL
- ebcnt1 — INT(11) — NOT NULL
- ebcnt2 — INT(11) — NOT NULL
- nes_yn — VARCHAR(10) — NOT NULL
- ebvalue1 — VARCHAR(2000) — NOT NULL
ebay_total_attr_org
- 카테고리코드 (sdcd) — varchar
- epin — varchar
- gmarket — varchar
- epid — varchar
- pid — varchar
- pid1 — varchar
- barcode — varchar
- ebname — varchar
- ebbchk — varchar
- ebcnt1 — int
- ebcnt2 — int
- nes_yn — varchar
- ebvalue1 — varchar
ebay_total_org
- cd — varchar
- cdname — varchar
- epin — varchar
- gmarket — varchar
- epid — varchar
- pid — varchar
- pid1 — varchar
- barcode — varchar
- model_name — varchar
- model_no — varchar
- opt — varchar
- delivery — varchar
- udate — varchar
- finalchk — varchar
- flag1 — varchar
- edesck — varchar
- naver_description — varchar
- group_no — varchar
- manuf_code — varchar
- manuf_desck — varchar
- manuf_desce — varchar
- brand_code — varchar
- brand_desck — varchar
- brand_desce — varchar
- pbrand_code — varchar
- pbrand_desck — varchar
- pbrand_desce — varchar
esa_w2317
- sdcd — VARCHAR(20) — NOT NULL
- pid — VARCHAR(50) — NOT NULL
- pid1 — VARCHAR(50) — NOT NULL
- barcode — VARCHAR(50) — NOT NULL
- barcode1 — VARCHAR(50) — NOT NULL
- ebname — VARCHAR(100) — NOT NULL
- ebbchk — VARCHAR(2) — NOT NULL
- ebcnt1 — INT(11) — NOT NULL
- ebcnt2 — INT(11) — NOT NULL
- nes_yn — VARCHAR(100) — NOT NULL
- ebvalue1 — VARCHAR(1000) — NOT NULL
- flag1 — VARCHAR(100) — NOT NULL
- flag2 — VARCHAR(100) — NOT NULL
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
total_naver_goods
- main_goods_code — VARCHAR(12) — 기본 키 — NOT NULL — 모델번호' COLLATE 'utf8_general_ci
- cate1_code — VARCHAR(10) — NOT NULL — 카테고리1코드' COLLATE 'utf8_general_ci
- cate2_code — VARCHAR(10) — NOT NULL — 카테고리2코드' COLLATE 'utf8_general_ci
- cate3_code — VARCHAR(10) — NOT NULL — 카테고리3코드' COLLATE 'utf8_general_ci
- cate4_code — VARCHAR(10) — NOT NULL — 카테고리4코드' COLLATE 'utf8_general_ci
- maker — VARCHAR(50) — NOT NULL — 제조사' COLLATE 'utf8_general_ci
- goods_name — VARCHAR(200) — NOT NULL — 모델명' COLLATE 'utf8_general_ci
- brand — VARCHAR(50) — NOT NULL — 브랜드' COLLATE 'utf8_general_ci
- create_date — VARCHAR(10) — NOT NULL — 등록일' COLLATE 'utf8_general_ci
- model_cnt — TINYINT(4) — NOT NULL — 모델수
- img_url — VARCHAR(200) — NOT NULL — 이미지URL' COLLATE 'utf8_general_ci
- min_price — INT(11) — NOT NULL — 최저가
- min_price_mall — VARCHAR(40) — NOT NULL — 최저가몰' COLLATE 'utf8_general_ci
- bbs_num — INT(11) — NOT NULL — 상품평수
- bbs_point — TINYINT(4) — NOT NULL — 상품평점
- sale_cnt — SMALLINT(6) — NOT NULL — 구매건수
- keyword — VARCHAR(50) — NOT NULL — 팁' COLLATE 'utf8_general_ci
- spec — VARCHAR(2000) — NOT NULL — 상세정보' COLLATE 'utf8_general_ci
- popular — INT(10) — NOT NULL — 인기순위
- leaf_cate — VARCHAR(50) — NOT NULL — leaf 카테고리 코드' COLLATE 'utf8_general_ci
- in_date — VARCHAR(8) — NOT NULL — 입력일' COLLATE 'utf8_general_ci
- INDEX — `cidx1`
- INDEX — `cidx2`
- INDEX — `cidx3`
- INDEX — `cidx4`
- INDEX — `main_goods_code`
total_naver_goods_attr
- main_goods_code — VARCHAR(12) — 기본 키 — NOT NULL — 상품번호' COLLATE 'utf8_general_ci
- attr_id — VARCHAR(10) — 기본 키 — NOT NULL — 속성코드' COLLATE 'utf8_general_ci
- attr_group — VARCHAR(40) — NOT NULL — 속성그룹명' COLLATE 'utf8_general_ci
- attr_name — VARCHAR(40) — NOT NULL — 속성명' COLLATE 'utf8_general_ci
- attr_value — VARCHAR(3000) — NOT NULL — 속성값' COLLATE 'utf8_general_ci
- in_date — VARCHAR(10) — NOT NULL — 입력일' COLLATE 'utf8_general_ci
total_naver_goods_opt
- main_goods_code — VARCHAR(12) — 기본 키 — NOT NULL — 모델번호' COLLATE 'utf8_general_ci
- opt1_code — VARCHAR(10) — 기본 키 — NOT NULL — 옵션키' COLLATE 'utf8_general_ci
- opt2_code — VARCHAR(10) — NOT NULL — 옵션키2' COLLATE 'utf8_general_ci
- min_price — INT(11) — NOT NULL — 최저가
- mall_cnt — INT(11) — NOT NULL — 등록몰수
- sale_cnt — INT(11) — NOT NULL — 판매수
- opt_name — VARCHAR(50) — NOT NULL — 옵션명' COLLATE 'utf8_general_ci
- img_url — VARCHAR(200) — NOT NULL — 이미지URL' COLLATE 'utf8_general_ci
- in_date — VARCHAR(8) — NOT NULL — 입력일' COLLATE 'utf8_general_ci
- svr_no — VARCHAR(2) — NOT NULL — 상세수집서버' COLLATE 'utf8_general_ci
- dt_date — VARCHAR(8) — NOT NULL — 상세수집일' COLLATE 'utf8_general_ci
- INDEX — `svridx`
- INDEX — `idx_indate`
- INDEX — `idx_ddt`
- INDEX — `opt_name`
- INDEX — `main_goods_code`
weekly 기본 테이블 (ebay_3s_wyymmt)
- naver/gmarket code (pid) — varchar — 기본 키
- naver opt code (pid1) — varchar — 기본 키
- Barcode (barcode) — varchar — 기본 키
- category code (cd) — varchar
- category name (cdname) — varchar
- 작업 종류 (fname) — varchar
- 원본 제품명 (org_desck) — varchar
- gmarket epin code (epin) — int
- 원본 카테고리 (org_category) — varchar
- Barcode1 (barcode1) — varchar
- URL (url) — varchar
- TAG total (tag) — varchar
- 제품명 (ebay_desck) — varchar
- 표준화 제품명 (std_ebay_desck) — varchar
- naver opt name (opt) — varchar
- Tag01 (tag01) — varchar
- Tag02 (tag02) — varchar
- Tag03 (tag03) — varchar
- Tag04 (tag04) — varchar
- Tag05 (tag05) — varchar
- Tag06 (tag06) — varchar
- Tag07 (tag07) — varchar
- Tag08 (tag08) — varchar
- Tag09 (tag09) — varchar
- Tag10 (tag10) — varchar
- Tag11 (tag11) — varchar
- Tag12 (tag12) — varchar
- Tag13 (tag13) — varchar
- Tag14 (tag14) — varchar
- Tag15 (tag15) — varchar
- Tag16 (tag16) — varchar
- Tag17 (tag17) — varchar
- Tag18 (tag18) — varchar
- Tag19 (tag19) — varchar
- Tag20 (tag20) — varchar
- Tag21 (tag21) — varchar
- Tag22 (tag22) — varchar
- Tag23 (tag23) — varchar
- Tag24 (tag24) — varchar
- Tag25 (tag25) — varchar
- Tag26 (tag26) — varchar
- Tag27 (tag27) — varchar
- Tag28 (tag28) — varchar
- Tag29 (tag29) — varchar
- Tag30 (tag30) — varchar
- 작업유무 (sdesck1) — varchar
- 재작업유무 (sdesck2) — varchar
- memo1 — varchar
- 모델번호 (model_no) — varchar
- 제조사명K (manuf_desck) — varchar
- 작업유형 (mid) — varchar
- sub유무 (ms_chk) — varchar
- EManuf (emanuf) — varchar
- EBrand (ebrand) — varchar
- EdesckF (edesckf) — varchar
- EdesckS (edescks) — varchar
- DManuf (dmanuf) — varchar
- DBrand (dbrand) — varchar
- Dmodel_no (dmodel_no) — varchar
- DdesckF (ddesckf) — varchar
- … +15
weekly 속성 테이블 (esa_wyyww)
- pid — varchar — 기본 키
- pid1 — varchar — 기본 키
- barcode — varchar — 기본 키
- sdcd — varchar
- barcode1 — varchar
- ebbchk — varchar
- ebname — varchar
- ebcnt1 — int
- ebcnt2 — int
- nes_yn — varchar
- ebvalue1 — varchar
- flag1 — varchar
- flag2 — varchar