Página inicial Explorar Ajuda
Entrar
style24
/
style24.doc
2
0
Fork 0
Arquivos Issues 0 Pull Requests 0 Wiki
Tree: f083507d3a
Branches Tags
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t4259.json.js

t4259.json.js 30 KB
Histórico Raw

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4259","name":"tmp20211021_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":"tmp20211021_tb_order_detail"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-42474","object_id":"column-42474","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-42477","object_id":"column-42477","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-42476","object_id":"column-42476","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-42475","object_id":"column-42475","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-42479","object_id":"column-42479","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-42498","object_id":"column-42498","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-42462","object_id":"column-42462","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-42446","object_id":"column-42446","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-42458","object_id":"column-42458","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-42465","object_id":"column-42465","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-42469","object_id":"column-42469","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-42444","object_id":"column-42444","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-42445","object_id":"column-42445","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-42472","object_id":"column-42472","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-42478","object_id":"column-42478","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-42473","object_id":"column-42473","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-42440","object_id":"column-42440","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-42439","object_id":"column-42439","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-42442","object_id":"column-42442","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-42443","object_id":"column-42443","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-42500","object_id":"column-42500","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-42499","object_id":"column-42499","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-42502","object_id":"column-42502","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-42501","object_id":"column-42501","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-42464","object_id":"column-42464","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-42463","object_id":"column-42463","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-42436","object_id":"column-42436","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-42435","object_id":"column-42435","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-42434","object_id":"column-42434","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-42481","object_id":"column-42481","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-42482","object_id":"column-42482","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-42488","object_id":"column-42488","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-42483","object_id":"column-42483","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-42459","object_id":"column-42459","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-42505","object_id":"column-42505","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-42456","object_id":"column-42456","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-42433","object_id":"column-42433","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-42457","object_id":"column-42457","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-42438","object_id":"column-42438","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-42437","object_id":"column-42437","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-42487","object_id":"column-42487","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-42486","object_id":"column-42486","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-42497","object_id":"column-42497","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-42494","object_id":"column-42494","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-42496","object_id":"column-42496","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-42495","object_id":"column-42495","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-42447","object_id":"column-42447","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-42451","object_id":"column-42451","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-42492","object_id":"column-42492","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-42461","object_id":"column-42461","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-42460","object_id":"column-42460","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-42470","object_id":"column-42470","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-42455","object_id":"column-42455","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-42452","object_id":"column-42452","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-42448","object_id":"column-42448","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-42449","object_id":"column-42449","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-42454","object_id":"column-42454","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-42453","object_id":"column-42453","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-42450","object_id":"column-42450","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-42491","object_id":"column-42491","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-42466","object_id":"column-42466","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-42467","object_id":"column-42467","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-42490","object_id":"column-42490","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-42489","object_id":"column-42489","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-42432","object_id":"column-42432","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-42468","object_id":"column-42468","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-42441","object_id":"column-42441","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-42480","object_id":"column-42480","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-42493","object_id":"column-42493","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-42471","object_id":"column-42471","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-42485","object_id":"column-42485","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-42484","object_id":"column-42484","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-42504","object_id":"column-42504","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-42503","object_id":"column-42503","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.