Etusivu Tutki Apua
Kirjaudu sisään
style24
/
style24.doc
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: f083507d3a
Branchit Tagit
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3970.json.js

t3970.json.js 17 KB
Historia Raaka

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3970","name":"tb_extmall_order_upload_tmp","subtype":"TABLE","is_user_defined":false,"description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n                <html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n                    <head>\r\n                        <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n                        </title>\r\n                        <style type=\"text/css\">\r\n                            .cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n                            .cs82292024{color:#000000;background-color:transparent;font-family:Segoe UI;font-size:10pt;font-weight:normal;font-style:normal;}\r\n                        </style>\r\n                    </head>\r\n                    <body>\r\n                        <p class=\"cs2654AE3A\"><span class=\"cs82292024\">제휴몰주문업로드. 업로드전 임시저장</span></p></body>\r\n                </html>","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_extmall_order_upload_tmp"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-37940","object_id":"column-37940","name":"EXTMALL_ORD_UPL_TMP_SQ","name_without_path":"EXTMALL_ORD_UPL_TMP_SQ","description":null,"is_pk":true,"is_identity":true,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37969","object_id":"column-37969","name":"VENDOR_ID","name_without_path":"VENDOR_ID","description":"벤더ID(공통코드G003)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37938","object_id":"column-37938","name":"EXTMALL_ID","name_without_path":"EXTMALL_ID","description":"외부몰ID(외부몰). TB_EXMALL.EXTMALL_ID","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37939","object_id":"column-37939","name":"EXTMALL_NM","name_without_path":"EXTMALL_NM","description":"외부몰명. SHOPLINKER_ORDER.MALL_NAME","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37932","object_id":"column-37932","name":"AGENT_ORDER_ID","name_without_path":"AGENT_ORDER_ID","description":"에이전트주문번호. SHOPLINKER_ORDER.SHOPLINKER_ORDER_ID","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37941","object_id":"column-37941","name":"EXTMALL_ORDER_ID","name_without_path":"EXTMALL_ORDER_ID","description":"외부몰주문번호(쇼핑몰주문번호). SHOPLINKER_ORDER.MALL_ORDER_ID","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37942","object_id":"column-37942","name":"EXTMALL_PROD_ID","name_without_path":"EXTMALL_PROD_ID","description":"외부몰상품ID. SHOPLINKER_ORDER.ORDER_PRODUCT_ID","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"30","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37943","object_id":"column-37943","name":"EXTMALL_PROD_NM","name_without_path":"EXTMALL_PROD_NM","description":"외부몰상품명. SHOPLINKER_ORDER.PRODUCT_NAME","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37944","object_id":"column-37944","name":"GOODS_CD","name_without_path":"GOODS_CD","description":"상품코드(상품)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37964","object_id":"column-37964","name":"SKU","name_without_path":"SKU","description":"옵션명(필수옵션+추가옵션)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37934","object_id":"column-37934","name":"CURR_PRICE","name_without_path":"CURR_PRICE","description":"현재판매가. SHOPLINKER_ORDER.SALE_PRICE","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37952","object_id":"column-37952","name":"ORD_QTY","name_without_path":"ORD_QTY","description":"주문수량. SHOPLINKER_ORDER.QUANTITY","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37946","object_id":"column-37946","name":"ORD_AMT","name_without_path":"ORD_AMT","description":"주문금액. SHOPLINKER_ORDER.ORDER_PRICE","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37933","object_id":"column-37933","name":"CPN_DC_AMT","name_without_path":"CPN_DC_AMT","description":"쿠폰할인금액(오픈마켓(인터파크,지마켓,옥션,스토어팜,스마트스토어) + 고도몰 적용). SHOPLINKER_ORDER.DIS_PRICE_COUPON","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37955","object_id":"column-37955","name":"PNT_DC_AMT","name_without_path":"PNT_DC_AMT","description":"포인트할인금액(오픈마켓(인터파크,지마켓,옥션,스토어팜,스마트스토어) + 고도몰 적용). SHOPLINKER_ORDER.DIS_PRICE_POINT","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37936","object_id":"column-37936","name":"DELV_FEE","name_without_path":"DELV_FEE","description":"배송비. SHOPLINKER_ORDER.BAESONG_BI","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37953","object_id":"column-37953","name":"ORD_RECV_DT","name_without_path":"ORD_RECV_DT","description":"주문수집일. SHOPLINKER_ORDER.ORDER_REG_DATE","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37947","object_id":"column-37947","name":"ORD_DT","name_without_path":"ORD_DT","description":"주문일. SHOPLINKER_ORDER.ORDERDATE","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37949","object_id":"column-37949","name":"ORD_NM","name_without_path":"ORD_NM","description":"주문자명. SHOPLINKER_ORDER.ORDER_NAME","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"50","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37951","object_id":"column-37951","name":"ORD_PHNNO","name_without_path":"ORD_PHNNO","description":"주문자휴대전화번호. SHOPLINKER_ORDER.ORDER_CEL","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37954","object_id":"column-37954","name":"ORD_TELNO","name_without_path":"ORD_TELNO","description":"주문자전화번호. SHOPLINKER_ORDER.ORDER_TEL","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37948","object_id":"column-37948","name":"ORD_EMAIL","name_without_path":"ORD_EMAIL","description":"주문자이메일. SHOPLINKER_ORDER.ORDER_EMAIL","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37958","object_id":"column-37958","name":"RECIP_NM","name_without_path":"RECIP_NM","description":"수령자명. SHOPLINKER_ORDER.RECEIVE","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37959","object_id":"column-37959","name":"RECIP_PHNNO","name_without_path":"RECIP_PHNNO","description":"수령자휴대전화번호. SHOPLINKER_ORDER.RECEIVE_CEL","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37960","object_id":"column-37960","name":"RECIP_TELNO","name_without_path":"RECIP_TELNO","description":"수령자전화번호. SHOPLINKER_ORDER.RECEIVE_TEL","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37961","object_id":"column-37961","name":"RECIP_ZIPCODE","name_without_path":"RECIP_ZIPCODE","description":"수령자우편번호. SHOPLINKER_ORDER.RECEIVE_ZIPCODE","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"6","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37956","object_id":"column-37956","name":"RECIP_BASE_ADDR","name_without_path":"RECIP_BASE_ADDR","description":"수령자기본주소. SHOPLINKER_ORDER.RECEIVE_ADDR","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37957","object_id":"column-37957","name":"RECIP_DTL_ADDR","name_without_path":"RECIP_DTL_ADDR","description":"수령자상세주소. SHOPLINKER_ORDER.RECEIVE_ADDR","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37937","object_id":"column-37937","name":"DELV_MEMO","name_without_path":"DELV_MEMO","description":"배송메모. SHOPLINKER_ORDER.DELIVERY_MSG","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"1000","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37968","object_id":"column-37968","name":"UPLOAD_STAT","name_without_path":"UPLOAD_STAT","description":"업로드상태(공통코드G021)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37965","object_id":"column-37965","name":"UPLOAD_FAIL_CD","name_without_path":"UPLOAD_FAIL_CD","description":"업로드실패코드(공통코드G022)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37966","object_id":"column-37966","name":"UPLOAD_FAIL_REASON","name_without_path":"UPLOAD_FAIL_REASON","description":"업로드실패사유","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37950","object_id":"column-37950","name":"ORD_NO","name_without_path":"ORD_NO","description":"주문번호(주문)","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37935","object_id":"column-37935","name":"DELV_ADDR_SQ","name_without_path":"DELV_ADDR_SQ","description":"배송지일련번호(배송지)","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37945","object_id":"column-37945","name":"OPT_CD","name_without_path":"OPT_CD","description":"옵션코드.SHOPLINKER_ORDER.sku_match_code","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37967","object_id":"column-37967","name":"UPLOAD_GB","name_without_path":"UPLOAD_GB","description":"업로드구분(샵링커:S, 엑셀:E)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"1","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37963","object_id":"column-37963","name":"REG_NO","name_without_path":"REG_NO","description":"등록자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37962","object_id":"column-37962","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":null,"is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"EXTMALL_ORD_UPL_TMP_SQ","name":"EXTMALL_ORD_UPL_TMP_SQ"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.