Strona główna Odkrywaj Pomoc
Zaloguj się
style24
/
style24.doc
2
0
Forkuj 0
Pliki Problemy 0 Oczekujące zmiany 0 Wiki
Drzewo: f083507d3a
Gałęzie Tagi
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3751.json.js

t3751.json.js 30 KB
Historia Czysty

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3751","name":"back1_tb_order_detail","subtype":"TABLE","is_user_defined":false,"description":null,"summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"back1_tb_order_detail"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-34768","object_id":"column-34768","name":"ORD_DTL_NO","name_without_path":"ORD_DTL_NO","description":"주문상세번호","is_pk":false,"is_identity":false,"data_type":"unsigned 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-34771","object_id":"column-34771","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":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34770","object_id":"column-34770","name":"ORD_EXCH_GB","name_without_path":"ORD_EXCH_GB","description":"주문교환구분(O:주문,E:교환)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"O","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34769","object_id":"column-34769","name":"ORD_DTL_STAT","name_without_path":"ORD_DTL_STAT","description":"주문상세상태(공통코드G013)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"G013_00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34773","object_id":"column-34773","name":"ORG_ORD_DTL_NO","name_without_path":"ORG_ORD_DTL_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-34792","object_id":"column-34792","name":"SUPPLY_COMP_CD","name_without_path":"SUPPLY_COMP_CD","description":"공급업체코드","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-34756","object_id":"column-34756","name":"GOODS_CD","name_without_path":"GOODS_CD","description":"상품코드","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-34740","object_id":"column-34740","name":"DEAL_GOODS_CD","name_without_path":"DEAL_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-34752","object_id":"column-34752","name":"FORMAL_GB","name_without_path":"FORMAL_GB","description":"정상이월구분(공통코드G009)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":"G009_10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34759","object_id":"column-34759","name":"GOODS_TYPE","name_without_path":"GOODS_TYPE","description":"상품타입(공통코드G056)","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-34763","object_id":"column-34763","name":"LIST_PRICE","name_without_path":"LIST_PRICE","description":"정상가(최초판매가)","is_pk":false,"is_identity":false,"data_type":"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-34738","object_id":"column-34738","name":"CURR_PRICE","name_without_path":"CURR_PRICE","description":"현재판매가","is_pk":false,"is_identity":false,"data_type":"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-34739","object_id":"column-34739","name":"DC_RATE","name_without_path":"DC_RATE","description":"할인율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":false,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34766","object_id":"column-34766","name":"OPT_ADD_PRICE","name_without_path":"OPT_ADD_PRICE","description":"옵션추가가격. 주문상세단품 옵션 추가가격의 합","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-34772","object_id":"column-34772","name":"ORD_QTY","name_without_path":"ORD_QTY","description":"주문수량","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 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-34767","object_id":"column-34767","name":"ORD_AMT","name_without_path":"ORD_AMT","description":"주문금액(=(현재판매가 + 옵션추가가격) * 주문수량)","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-34734","object_id":"column-34734","name":"CNCL_RTN_QTY","name_without_path":"CNCL_RTN_QTY","description":"취소반품수량","is_pk":false,"is_identity":false,"data_type":"smallint","data_length":"5, 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-34733","object_id":"column-34733","name":"CNCL_RTN_AMT","name_without_path":"CNCL_RTN_AMT","description":"취소반품금액","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-34736","object_id":"column-34736","name":"CPN1_CPN_SQ","name_without_path":"CPN1_CPN_SQ","description":"1차쿠폰(즉시할인쿠폰)일련번호(고객보유쿠폰일련번호)","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-34737","object_id":"column-34737","name":"CPN1_DC_AMT","name_without_path":"CPN1_DC_AMT","description":"1차쿠폰(즉시할인쿠폰)할인금액","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-34794","object_id":"column-34794","name":"TMTB1_SQ","name_without_path":"TMTB1_SQ","description":"다다익선1일련번호(수량)","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-34793","object_id":"column-34793","name":"TMTB1_DC_AMT","name_without_path":"TMTB1_DC_AMT","description":"다다익선1할인금액(수량)","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-34796","object_id":"column-34796","name":"TMTB2_SQ","name_without_path":"TMTB2_SQ","description":"다다익선2일련번호(금액)","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-34795","object_id":"column-34795","name":"TMTB2_DC_AMT","name_without_path":"TMTB2_DC_AMT","description":"다다익선2할인금액(금액)","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-34758","object_id":"column-34758","name":"GOODS_CPN_SQ","name_without_path":"GOODS_CPN_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-34757","object_id":"column-34757","name":"GOODS_CPN_DC_AMT","name_without_path":"GOODS_CPN_DC_AMT","description":"상품쿠폰할인금액","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-34730","object_id":"column-34730","name":"CART_CPN_SQ","name_without_path":"CART_CPN_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-34729","object_id":"column-34729","name":"CART_CPN_DC_AMT","name_without_path":"CART_CPN_DC_AMT","description":"장바구니쿠폰할인금액","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-34728","object_id":"column-34728","name":"BURDEN_RATE","name_without_path":"BURDEN_RATE","description":"쿠폰분담율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":false,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34775","object_id":"column-34775","name":"PNT_DC_AMT","name_without_path":"PNT_DC_AMT","description":"포인트할인금액","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-34776","object_id":"column-34776","name":"PRE_PNT_DC_AMT","name_without_path":"PRE_PNT_DC_AMT","description":"선포인트할인금액","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-34782","object_id":"column-34782","name":"SAVE_PNT_AMT","name_without_path":"SAVE_PNT_AMT","description":"적립포인트금액","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-34777","object_id":"column-34777","name":"REAL_ORD_AMT","name_without_path":"REAL_ORD_AMT","description":"실주문금액(주문금액 - 취소반품금액 - 1차쿠폰 - 다다익선1 - 다다익선2 - 상품쿠폰 - 장바구니쿠폰 - 포인트할인금액 - 선포인트할인금액)","is_pk":false,"is_identity":false,"data_type":"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-34753","object_id":"column-34753","name":"GFCD_USE_AMT","name_without_path":"GFCD_USE_AMT","description":"상품권사용금액","is_pk":false,"is_identity":false,"data_type":"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-34799","object_id":"column-34799","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":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34750","object_id":"column-34750","name":"EXTMALL_ID","name_without_path":"EXTMALL_ID","description":"외부몰ID(외부몰)","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-34727","object_id":"column-34727","name":"AGENT_ORDER_ID","name_without_path":"AGENT_ORDER_ID","description":"에이전트주문번호. 몰구분이 \"G011_20:외부몰\"일 때 사용","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-34751","object_id":"column-34751","name":"EXTMALL_ORDER_ID","name_without_path":"EXTMALL_ORDER_ID","description":"외부몰주문번호(=쇼핑몰주문번호). 몰구분이 \"G011_20:외부몰\"일 때 사용","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-34732","object_id":"column-34732","name":"CHANGEABLE_YN","name_without_path":"CHANGEABLE_YN","description":"교환가능여부(Y:교환가능)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"Y","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34731","object_id":"column-34731","name":"CHANGE_FEE_FREE_YN","name_without_path":"CHANGE_FEE_FREE_YN","description":"교환배송비무료여부(Y:교환배송비무료)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34781","object_id":"column-34781","name":"RETURNABLE_YN","name_without_path":"RETURNABLE_YN","description":"반품가능여부(Y:반품가능)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"Y","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34780","object_id":"column-34780","name":"RETURN_FEE_FREE_YN","name_without_path":"RETURN_FEE_FREE_YN","description":"반품배송비무료여부(Y:반품배송비무료)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34791","object_id":"column-34791","name":"SOLDOUT_YN","name_without_path":"SOLDOUT_YN","description":"결품여부(Y:결품)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34788","object_id":"column-34788","name":"SOLDOUT_MEMO","name_without_path":"SOLDOUT_MEMO","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-34790","object_id":"column-34790","name":"SOLDOUT_REG_NO","name_without_path":"SOLDOUT_REG_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-34789","object_id":"column-34789","name":"SOLDOUT_REG_DT","name_without_path":"SOLDOUT_REG_DT","description":"결품등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"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-34741","object_id":"column-34741","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":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34745","object_id":"column-34745","name":"DELV_FEE_CD","name_without_path":"DELV_FEE_CD","description":"배송비정책코드","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-34786","object_id":"column-34786","name":"SHOT_DELV_YN","name_without_path":"SHOT_DELV_YN","description":"총알배송여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34755","object_id":"column-34755","name":"GIFT_PACK_YN","name_without_path":"GIFT_PACK_YN","description":"선물포장여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34754","object_id":"column-34754","name":"GIFT_ADDR_INP_YN","name_without_path":"GIFT_ADDR_INP_YN","description":"선물주소입력여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34764","object_id":"column-34764","name":"MAKE_GOODS_YN","name_without_path":"MAKE_GOODS_YN","description":"주문제작상품확인여부: 주문제작상품 주문 시 확인","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34749","object_id":"column-34749","name":"ENTRY_NO","name_without_path":"ENTRY_NO","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-34746","object_id":"column-34746","name":"DELV_LOC_CD","name_without_path":"DELV_LOC_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-34742","object_id":"column-34742","name":"DELV_ASSIGN_DT","name_without_path":"DELV_ASSIGN_DT","description":"출고지정일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"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-34743","object_id":"column-34743","name":"DELV_ASSIGN_STAT","name_without_path":"DELV_ASSIGN_STAT","description":"출고지정상태(P:대기,Y:수락,N:거부). 입점은 DEFAULT 'Y'","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"P","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34748","object_id":"column-34748","name":"DSTRBT_NOTE","name_without_path":"DSTRBT_NOTE","description":"물류비고(물류담당자에게 공지)","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-34747","object_id":"column-34747","name":"DELV_STDT","name_without_path":"DELV_STDT","description":"배송시작일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"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-34744","object_id":"column-34744","name":"DELV_EDDT","name_without_path":"DELV_EDDT","description":"배송완료일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"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-34785","object_id":"column-34785","name":"SHIP_COMP_CD","name_without_path":"SHIP_COMP_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-34760","object_id":"column-34760","name":"INVOICE_NO","name_without_path":"INVOICE_NO","description":"송장번호","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-34761","object_id":"column-34761","name":"INVOICE_SEND_YN","name_without_path":"INVOICE_SEND_YN","description":"송장전송여부(Y:전송완료, N:전송미완료, X:전송할필요없음)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34784","object_id":"column-34784","name":"SELL_STORE_CD","name_without_path":"SELL_STORE_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-34783","object_id":"column-34783","name":"SELL_FEE_RATE","name_without_path":"SELL_FEE_RATE","description":"판매수수료율","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":false,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-34726","object_id":"column-34726","name":"AF_LINK_CD","name_without_path":"AF_LINK_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-34762","object_id":"column-34762","name":"ITHR_CD","name_without_path":"ITHR_CD","description":"유입경로(공통코드G027)","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-34735","object_id":"column-34735","name":"CONTENTS_LOC","name_without_path":"CONTENTS_LOC","description":"컨텐츠위치(공통코드G028)","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-34774","object_id":"column-34774","name":"PLAN_DTL_SQ","name_without_path":"PLAN_DTL_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-34787","object_id":"column-34787","name":"SOCIAL_SQ","name_without_path":"SOCIAL_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-34765","object_id":"column-34765","name":"NPAY_ORD_DTL_NO","name_without_path":"NPAY_ORD_DTL_NO","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-34779","object_id":"column-34779","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-34778","object_id":"column-34778","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":[]},{"id":"column-34798","object_id":"column-34798","name":"UPD_NO","name_without_path":"UPD_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-34797","object_id":"column-34797","name":"UPD_DT","name_without_path":"UPD_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":[],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.