{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["TB_ORDER","TB_DELIVERY_ADDR","TB_DELIVERY_FEE","TB_ORDER_DETAIL","TB_ORDER_DETAIL_ITEM","TB_PAYMENT","TB_CUSTOMER","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TB_ORDER","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
["TB_ORDER"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_ORDER ( "}]
["MALL_GB","VARCHAR(20)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":true},"G011_10",null,{"$f":"A4","v":"MALL_GB"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":"'G011_10'"}]
["ORD_DT","TIMESTAMP",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":false},null,null,{"$f":"\",\"&A5","v":",ORD_DT"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",current_timestamp()"}]
["PAY_DT","TIMESTAMP",false,null,null,{"$f":"\",\"&A6","v":",PAY_DT"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",current_timestamp()"}]
["CUST_NO","INT(10) UNSIGNED",false,0,null,",CUST_NO",",0"]
["ORD_NM","VARCHAR(50)",true,"테스트",null,",ORD_NM",",'테스트'"]
["ORD_PHNNO","VARCHAR(20)",true,"010-1234-5678",null,",ORD_PHNNO",",'010-1234-5678'"]
["ORD_TELNO","VARCHAR(20)",true,"02-1234-5678",null,",ORD_TELNO",",'02-1234-5678'"]
["ORD_EMAIL","VARCHAR(100)",true,"test@email.com",null,",ORD_EMAIL",",'test@email.com'"]
["SITE_CD","VARCHAR(20)",true,"G000_10",null,",SITE_CD",",'G000_10'"]
["NPAY_ORD_NO","INT(10) UNSIGNED",false,0,null,",NPAY_ORD_NO",",0"]
["FRONT_GB","VARCHAR(1)",true,"P",null,",FRONT_GB",",'P'"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",false,0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,",UPD_DT",",current_timestamp()"]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_DELIVERY_ADDR","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
["TB_DELIVERY_ADDR"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_DELIVERY_ADDR ( "}]
["RECIP_NM","VARCHAR(100)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":true},"테스트",null,{"$f":"A4","v":"RECIP_NM"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":"'테스트'"}]
["RECIP_PHNNO","VARCHAR(20)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":true},"010-1234-9453",null,{"$f":"\",\"&A5","v":",RECIP_PHNNO"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",'010-1234-9453'"}]
["RECIP_TELNO","VARCHAR(20)",true,"010-1234-9453",null,{"$f":"\",\"&A6","v":",RECIP_TELNO"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",'010-1234-9453'"}]
["RECIP_ZIP_NO","VARCHAR(6)",true,11223,null,",RECIP_ZIP_NO",",'11223'"]
["RECIP_BASE_ADDR","VARCHAR(200)",true,"인천시 계양구 황어로 115번길 10",null,",RECIP_BASE_ADDR",",'인천시 계양구 황어로 115번길 10'"]
["RECIP_DTL_ADDR","VARCHAR(200)",true,"상세주소 테스트",null,",RECIP_DTL_ADDR",",'상세주소 테스트'"]
["DELV_MEMO","VARCHAR(1000)",true,"메모주소 테스트",null,",DELV_MEMO",",'메모주소 테스트'"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",false,0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,",UPD_DT",",current_timestamp()"]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_DELIVERY_FEE","index":2,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
["TB_DELIVERY_FEE"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_DELIVERY_FEE ( "}]
["PAY_SQ","INT(10) UNSIGNED",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":false},"NULL",null,{"$f":"A4","v":"PAY_SQ"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":"NULL"}]
["ORD_NO","INT(10) UNSIGNED",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":false},7,null,{"$f":"\",\"&A5","v":",ORD_NO"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",7"}]
["DELV_FEE_GB","VARCHAR(20)",true,"G018_10",null,{"$f":"\",\"&A6","v":",DELV_FEE_GB"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",'G018_10'"}]
["DELV_FEE_CD","VARCHAR(20)",true,"S0001_01",null,",DELV_FEE_CD",",'S0001_01'"]
["DELV_FEE","INT(10) UNSIGNED",false,0,null,",DELV_FEE",",0"]
["DELV_CPN_SQ","INT(10) UNSIGNED",false,"NULL",null,",DELV_CPN_SQ",",NULL"]
["DELV_CPN_DC_AMT","INT(10) UNSIGNED",false,0,null,",DELV_CPN_DC_AMT",",0"]
["REAL_DELV_AMT","INT(10) UNSIGNED",false,0,null,",REAL_DELV_AMT",",0"]
["ORD_CHG_SQ","INT(10) UNSIGNED",false,"NULL",null,",ORD_CHG_SQ",",NULL"]
["SUPPLY_COMP_CD","VARCHAR(20)",true,"S0001",null,",SUPPLY_COMP_CD",",'S0001'"]
["DELV_USAC_YN","CHAR(1)",true,"N",null,",DELV_USAC_YN",",'N'"]
["DELV_USAC_DT","TIMESTAMP",false,null,null,",DELV_USAC_DT",",current_timestamp()"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",false,0,null,{"$f":"\",\"&A18","v":",UPD_NO"},{"$f":"\",\"&IF(B18 = \"TIMESTAMP\", \"current_timestamp()\", IF(C18 = TRUE, \"'\"&D18&\"'\", D18))","v":",0"}]
["UPD_DT","TIMESTAMP",false,null,null,",UPD_DT",",current_timestamp()"]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_ORDER_DETAIL","index":3,"n_rows":72,"n_cols":7,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
["TB_ORDER_DETAIL"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_ORDER_DETAIL ( "}]
["ORD_NO","INT(10) UNSIGNED",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":false},7,null,{"$f":"A4","v":"ORD_NO"},{"$f":"\"\"&IF(B4 = \"TIMESTAMP\", \"current_timestamp()\", IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":"7"}]
["ORD_EXCH_GB","CHAR(1)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":true},"O",null,{"$f":"\",\"&A5","v":",ORD_EXCH_GB"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",'O'"}]
["ORD_DTL_STAT","VARCHAR(20)",true,"G013_20",null,{"$f":"\",\"&A6","v":",ORD_DTL_STAT"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",'G013_20'"}]
["ORG_ORD_DTL_NO","INT(10) UNSIGNED",false,"NULL",null,",ORG_ORD_DTL_NO",",NULL"]
["SUPPLY_COMP_CD","VARCHAR(20)",true,"S0001",null,",SUPPLY_COMP_CD",",'S0001'"]
["GOODS_CD","VARCHAR(20)",true,"STYS000000016",null,",GOODS_CD",",'STYS000000016'"]
["FORMAL_GB","VARCHAR(20)",true,"G009_10",null,",FORMAL_GB",",'G009_10'"]
["GOODS_TYPE","VARCHAR(20)",true,"G056_S",null,",GOODS_TYPE",",'G056_S'"]
["LIST_PRICE","INT(10) UNSIGNED",false,45800,null,",LIST_PRICE",",45800"]
["CURR_PRICE","INT(10) UNSIGNED",false,43900,null,",CURR_PRICE",",43900"]
["DC_RATE","FLOAT(5,2) UNSIGNED",false,5,null,",DC_RATE",",5"]
["OPT_ADD_PRICE","INT(11)",false,0,null,",OPT_ADD_PRICE",",0"]
["ORD_QTY","SMALLINT(5) UNSIGNED",false,1,null,",ORD_QTY",",1"]
["ORD_AMT","INT(10) UNSIGNED",false,43900,null,",ORD_AMT",",43900"]
["CNCL_RTN_QTY","SMALLINT(5) UNSIGNED",false,0,null,",CNCL_RTN_QTY",",0"]
["CNCL_RTN_AMT","INT(10) UNSIGNED",false,0,null,",CNCL_RTN_AMT",",0"]
["CPN1_CPN_SQ","INT(10) UNSIGNED",false,"NULL",null,",CPN1_CPN_SQ",",NULL"]
["CPN1_DC_AMT","INT(10) UNSIGNED",false,0,null,",CPN1_DC_AMT",",0"]
["TMTB1_SQ","INT(10) UNSIGNED",false,"NULL",null,",TMTB1_SQ",",NULL"]
["TMTB1_DC_AMT","INT(10) UNSIGNED",false,0,null,",TMTB1_DC_AMT",",0"]
["TMTB2_SQ","INT(10) UNSIGNED",false,"NULL",null,",TMTB2_SQ",",NULL"]
["TMTB2_DC_AMT","INT(10) UNSIGNED",false,0,null,",TMTB2_DC_AMT",",0"]
["GOODS_CPN_SQ","INT(10) UNSIGNED",false,"NULL",null,",GOODS_CPN_SQ",",NULL"]
["GOODS_CPN_DC_AMT","INT(10) UNSIGNED",false,0,null,",GOODS_CPN_DC_AMT",",0"]
["CART_CPN_SQ","INT(10) UNSIGNED",false,"NULL",null,",CART_CPN_SQ",",NULL"]
["CART_CPN_DC_AMT","INT(10) UNSIGNED",false,0,null,",CART_CPN_DC_AMT",",0"]
["BURDEN_RATE","FLOAT(5,2) UNSIGNED",false,0,null,",BURDEN_RATE",",0"]
["PNT_DC_AMT","INT(10) UNSIGNED",false,0,null,",PNT_DC_AMT",",0"]
["PRE_PNT_DC_AMT","INT(10) UNSIGNED",false,0,null,",PRE_PNT_DC_AMT",",0"]
["SAVE_PNT_AMT","INT(10) UNSIGNED",false,0,null,",SAVE_PNT_AMT",",0"]
["REAL_ORD_AMT","INT(10) UNSIGNED",false,43900,null,",REAL_ORD_AMT",",43900"]
["GFCD_USE_AMT","INT(10) UNSIGNED",false,0,null,",GFCD_USE_AMT",",0"]
["VENDOR_ID","VARCHAR(20)",true,null,null,",VENDOR_ID",",''"]
["EXTMALL_ID","VARCHAR(20)",true,null,null,",EXTMALL_ID",",''"]
["AGENT_ORDER_ID","VARCHAR(30)",true,null,null,",AGENT_ORDER_ID",",''"]
["EXTMALL_ORDER_ID","VARCHAR(50)",true,null,null,",EXTMALL_ORDER_ID",",''"]
["CHANGABLE_YN","CHAR(1)",true,"Y",null,",CHANGABLE_YN",",'Y'"]
["CHANGE_FEE_FREE_YN","CHAR(1)",true,"Y",null,",CHANGE_FEE_FREE_YN",",'Y'"]
["RETURNABLE_YN","CHAR(1)",true,"Y",null,",RETURNABLE_YN",",'Y'"]
["RETURN_FEE_FREE_YN","CHAR(1)",true,"Y",null,",RETURN_FEE_FREE_YN",",'Y'"]
["SOLDOUT_YN","CHAR(1)",true,"N",null,",SOLDOUT_YN",",'N'"]
["SOLDOUT_MEMO","VARCHAR(500)",true,null,null,",SOLDOUT_MEMO",",''"]
["SOLDOUT_REG_NO","INT(10) UNSIGNED",false,"NULL",null,",SOLDOUT_REG_NO",",NULL"]
["SOLDOUT_REG_DT","TIMESTAMP",false,null,null,",SOLDOUT_REG_DT",",current_timestamp()"]
["DELV_ADDR_SQ","INT(10) UNSIGNED",false,2,null,",DELV_ADDR_SQ",",2"]
["DELV_FEE_CD","VARCHAR(20)",true,"S0001_01",null,{"$f":"\",\"&A49","v":",DELV_FEE_CD"},{"$f":"\",\"&IF(B49 = \"TIMESTAMP\", \"current_timestamp()\", IF(C49 = TRUE, \"'\"&D49&\"'\", D49))","v":",'S0001_01'"}]
["SHOT_DELV_YN","CHAR(1)",true,"N",null,",SHOT_DELV_YN",",'N'"]
["GIFT_PACK_YN","CHAR(1)",true,"N",null,",GIFT_PACK_YN",",'N'"]
["DELV_LOC_CD","VARCHAR(20)",true,null,null,",DELV_LOC_CD",",''"]
["DELV_ASSIGN_DT","TIMESTAMP",false,null,null,",DELV_ASSIGN_DT",",current_timestamp()"]
["DELV_ASSIGN_STAT","CHAR(1)",true,"N",null,",DELV_ASSIGN_STAT",",'N'"]
["DSTRBT_NOTE","VARCHAR(1000)",true,null,null,",DSTRBT_NOTE",",''"]
["DELV_STDT","TIMESTAMP",false,null,null,",DELV_STDT",",current_timestamp()"]
["DELV_EDDT","TIMESTAMP",false,null,null,",DELV_EDDT",",current_timestamp()"]
["SHIP_COMP_CD","VARCHAR(20)",true,null,null,",SHIP_COMP_CD",",''"]
["INVOICE_NO","VARCHAR(30)",true,null,null,",INVOICE_NO",",''"]
["INVOICE_SEND_YN","CHAR(1)",true,"N",null,",INVOICE_SEND_YN",",'N'"]
["SELL_STORE_CD","VARCHAR(20)",true,null,null,",SELL_STORE_CD",",''"]
["SELL_FEE_RATE","FLOAT(5,2) UNSIGNED",false,0,null,",SELL_FEE_RATE",",0"]
["AF_LINK_CD","VARCHAR(20)",true,null,null,",AF_LINK_CD",",''"]
["ITHR_CD","VARCHAR(20)",true,null,null,",ITHR_CD",",''"]
["CONTENTS_LOC","VARCHAR(20)",true,null,null,",CONTENTS_LOC",",''"]
["PLAN_DTL_SQ","INT(10) UNSIGNED",false,"NULL",null,",PLAN_DTL_SQ",",NULL"]
["SOCIAL_SQ","INT(10) UNSIGNED",false,"NULL",null,",SOCIAL_SQ",",NULL"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B70))","v":false},0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,{"$f":"\",\"&A71","v":",UPD_DT"},{"$f":"\",\"&IF(B71 = \"TIMESTAMP\", \"current_timestamp()\", IF(C71 = TRUE, \"'\"&D71&\"'\", D71))","v":",current_timestamp()"}]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_ORDER_DETAIL_ITEM","index":4,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["TB_ORDER_DETAIL_ITEM"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_ORDER_DETAIL_ITEM ( "}]
["ORD_DTL_NO","INT(10)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":false},4,null,{"$f":"A4","v":"ORD_DTL_NO"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":4}]
["ORD_NO","INT(10)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":false},7,null,{"$f":"\",\"&A5","v":",ORD_NO"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",7"}]
["ORD_DTL_STAT","VARCHAR(20)",true,"G013_20",null,{"$f":"\",\"&A6","v":",ORD_DTL_STAT"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",'G013_20'"}]
["ITEM_CD","VARCHAR(20)",true,14373758,null,",ITEM_CD",",'14373758'"]
["OPT_CD","VARCHAR(200)",true,"블랙100",null,",OPT_CD",",'블랙100'"]
["OPT_CD1","VARCHAR(200)",true,"BK",null,",OPT_CD1",",'BK'"]
["OPT_CD2","VARCHAR(200)",true,100,null,",OPT_CD2",",'100'"]
["ITEM_QTY","SMALLINT(5)",false,1,null,",ITEM_QTY",",1"]
["ITEM_PRICE","INT(10)",false,29900,null,",ITEM_PRICE",",29900"]
["ITEM_ORD_QTY","SMALLINT(5)",false,1,null,",ITEM_ORD_QTY",",1"]
["ITEM_ORD_PRICE","INT(10)",false,29900,null,",ITEM_ORD_PRICE",",29900"]
["ITEM_CNCL_RTN_QTY","SMALLINT(5)",false,0,null,",ITEM_CNCL_RTN_QTY",",0"]
["ITEM_CNCL_RTN_PRICE","INT(10)",false,0,null,",ITEM_CNCL_RTN_PRICE",",0"]
["OPT_ADD_PRICE","INT(10)",false,0,null,",OPT_ADD_PRICE",",0"]
["DISP_ORD","SMALLINT(5)",false,0,null,",DISP_ORD",",0"]
["ORD_AMT","INT(10)",false,0,null,",ORD_AMT",",0"]
["CNCL_RTN_AMT","INT(10)",false,0,null,",CNCL_RTN_AMT",",0"]
["CPN1_DC_AMT","INT(10)",false,0,null,",CPN1_DC_AMT",",0"]
["TMTB1_DC_AMT","INT(10)",false,0,null,",TMTB1_DC_AMT",",0"]
["TMTB2_DC_AMT","INT(10)",false,0,null,",TMTB2_DC_AMT",",0"]
["GOODS_CPN_DC_AMT","INT(10)",false,0,null,",GOODS_CPN_DC_AMT",",0"]
["CART_CPN_DC_AMT","INT(10)",false,0,null,",CART_CPN_DC_AMT",",0"]
["PNT_DC_AMT","INT(10)",false,0,null,",PNT_DC_AMT",",0"]
["PRE_PNT_DC_AMT","INT(10)",false,0,null,",PRE_PNT_DC_AMT",",0"]
["SAVE_PNT_DC_AMT","INT(10)",false,0,null,",SAVE_PNT_DC_AMT",",0"]
["REAL_ORD_AMT","INT(10)",false,29900,null,",REAL_ORD_AMT",",29900"]
["GFCD_USE_AMT","INT(10)",false,0,null,",GFCD_USE_AMT",",0"]
["REG_NO","INT(10)",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10)",false,0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,",UPD_DT",",current_timestamp()"]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_PAYMENT","index":5,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
["TB_PAYMENT"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_PAYMENT ( "}]
["ORD_NO","INT(10) UNSIGNED",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":false},7,null,{"$f":"A4","v":"ORD_NO"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":7}]
["PAY_DT","TIMESTAMP",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":false},null,null,{"$f":"\",\"&A5","v":",PAY_DT"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",current_timestamp()"}]
["PAY_MEANS","VARCHAR(20)",true,"G014_30",null,",PAY_MEANS",",'G014_30'"]
["PAY_AMT","INT(11)",false,43900,null,",PAY_AMT",",43900"]
["PG_CPN_AMT","INT(11)",false,0,null,",PG_CPN_AMT",",0"]
["NPAY_PNT_AMT","INT(11)",false,0,null,",NPAY_PNT_AMT",",0"]
["PAY_GB","CHAR(1)",true,"O",null,",PAY_GB",",'O'"]
["PAY_STAT","VARCHAR(20)",true,"G016_30",null,",PAY_STAT",",'G016_30'"]
["PG_GB","VARCHAR(20)",true,"KCP",null,",PG_GB",",'KCP'"]
["PG_TID","VARCHAR(100)",true,"TID00001",null,",PG_TID",",'TID00001'"]
["PG_TRADE_NO","VARCHAR(50)",true,101010,null,",PG_TRADE_NO",",'101010'"]
["PG_SHOP_ID","VARCHAR(20)",true,"STYLE24",null,",PG_SHOP_ID",",'STYLE24'"]
["CARD_TYPE","VARCHAR(1)",true,"Y",null,",CARD_TYPE",",'Y'"]
["CARD_KIND","VARCHAR(5)",true,null,null,{"$f":"\",\"&A17","v":",CARD_KIND"},{"$f":"\",\"&IF(B17 = \"TIMESTAMP\", \"current_timestamp()\", IF(C17 = TRUE, \"'\"&D17&\"'\", D17))","v":",''"}]
["CARD_BANK","VARCHAR(10)",true,null,null,",CARD_BANK",",''"]
["CARD_NM","VARCHAR(50)",true,null,null,",CARD_NM",",''"]
["CARD_MIPS","VARCHAR(2)",true,null,null,",CARD_MIPS",",''"]
["CARD_PCABLE_YN","CHAR(1)",true,null,null,",CARD_PCABLE_YN",",''"]
["VA_NO","VARCHAR(20)",true,null,null,",VA_NO",",''"]
["VA_NM","VARCHAR(100)",true,null,null,",VA_NM",",''"]
["VA_BANK","VARCHAR(20)",true,null,null,",VA_BANK",",''"]
["VA_DEADLINE","TIMESTAMP",false,null,null,",VA_DEADLINE",",current_timestamp()"]
["TELECOM","VARCHAR(3)",true,null,null,",TELECOM",",''"]
["ESCROW_YN","CHAR(1)",true,null,null,",ESCROW_YN",",''"]
["ORD_CHG_SQ","INT(10) UNSIGNED",false,"NULL",null,",ORD_CHG_SQ",",NULL"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",false,0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,{"$f":"\",\"&A32","v":",UPD_DT"},{"$f":"\",\"&IF(B32 = \"TIMESTAMP\", \"current_timestamp()\", IF(C32 = TRUE, \"'\"&D32&\"'\", D32))","v":",current_timestamp()"}]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"TB_CUSTOMER","index":6,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
["TB_CUSTOMER"]
["칼럼","타입","CHAR","값",null,{"$f":"\"INSERT INTO \"&$A$2&\" ( \"","v":"INSERT INTO TB_CUSTOMER ( "}]
["CUST_ID","VARCHAR(30)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B4))","v":true},"jsh77b@email.com",null,{"$f":"A4","v":"CUST_ID"},{"$f":"IF(B4 = \"TIMESTAMP\", current_timestamp(), IF(C4 = TRUE, \"'\"&D4&\"'\", D4))","v":"'jsh77b@email.com'"}]
["CUST_NM","VARCHAR(200)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B5))","v":true},"테스트",null,{"$f":"\",\"&A5","v":",CUST_NM"},{"$f":"\",\"&IF(B5 = \"TIMESTAMP\", \"current_timestamp()\", IF(C5 = TRUE, \"'\"&D5&\"'\", D5))","v":",'테스트'"}]
["PASSWD","VARCHAR(200)",true,1111,null,{"$f":"\",\"&A6","v":",PASSWD"},{"$f":"\",\"&IF(B6 = \"TIMESTAMP\", \"current_timestamp()\", IF(C6 = TRUE, \"'\"&D6&\"'\", D6))","v":",'1111'"}]
["BIRTH_YMD","VARCHAR(200)",true,19851115,null,",BIRTH_YMD",",'19851115'"]
["BIRTH_SM","VARCHAR(1)",true,"S",null,",BIRTH_SM",",'S'"]
["SEX_GB","VARCHAR(200)",true,"G007_F",null,",SEX_GB",",'G007_F'"]
["CELL_PHNNO","VARCHAR(200)",true,"010-1234-5678",null,",CELL_PHNNO",",'010-1234-5678'"]
["APP_AGREE_YN","CHAR(1)",true,"Y",null,",APP_AGREE_YN",",'Y'"]
["APP_AGREE_DT","TIMESTAMP",false,null,null,",APP_AGREE_DT",",current_timestamp()"]
["SMS_AGREE_YN","CHAR(1)",true,"Y",null,",SMS_AGREE_YN",",'Y'"]
["SMS_AGREE_DT","TIMESTAMP",false,null,null,",SMS_AGREE_DT",",current_timestamp()"]
["EMAIL","VARCHAR(200)",true,"jsh77b@email.com",null,",EMAIL",",'jsh77b@email.com'"]
["EMAIL_AGREE_YN","CHAR(1)",true,"Y",null,",EMAIL_AGREE_YN",",'Y'"]
["EMAIL_AGREE_DT","TIMESTAMP",false,null,null,",EMAIL_AGREE_DT",",current_timestamp()"]
["HOME_POST_NO","VARCHAR(200)",{"$f":"ISNUMBER(SEARCH(\"CHAR\", B18))","v":true},12345,null,{"$f":"\",\"&A18","v":",HOME_POST_NO"},{"$f":"\",\"&IF(B18 = \"TIMESTAMP\", \"current_timestamp()\", IF(C18 = TRUE, \"'\"&D18&\"'\", D18))","v":",'12345'"}]
["HOME_BASE_ADDR","VARCHAR(200)",true,"기본주소 등록",null,",HOME_BASE_ADDR",",'기본주소 등록'"]
["HOME_DTL_ADDR","VARCHAR(200)",true,"상세주소 등록",null,",HOME_DTL_ADDR",",'상세주소 등록'"]
["SITE_CD","VARCHAR(20)",true,"G000_10",null,",SITE_CD",",'G000_10'"]
["FRONT_GB","VARCHAR(1)",true,"P",null,",FRONT_GB",",'P'"]
["AF_LINK_CD","VARCHAR(20)",true,null,null,",AF_LINK_CD",",''"]
["CUST_GB","VARCHAR(20)",true,"G100_10",null,",CUST_GB",",'G100_10'"]
["CUST_GRADE","VARCHAR(20)",true,null,null,",CUST_GRADE",",''"]
["JOIN_DT","TIMESTAMP",false,null,null,",JOIN_DT",",current_timestamp()"]
["FOREIGNER_YN","CHAR(1)",true,"N",null,",FOREIGNER_YN",",'N'"]
["CUST_STAT","VARCHAR(20)",true,null,null,",CUST_STAT",",''"]
["PASSWD_CHG_DT","TIMESTAMP",false,null,null,",PASSWD_CHG_DT",",current_timestamp()"]
["LOGIN_LDT","TIMESTAMP",false,null,null,",LOGIN_LDT",",current_timestamp()"]
["NV_JOIN_ID","VARCHAR(20)",true,null,null,",NV_JOIN_ID",",''"]
["NV_ACCESS_TOKEN","VARCHAR(200)",true,null,null,",NV_ACCESS_TOKEN",",''"]
["NV_JOIN_DT","TIMESTAMP",false,null,null,",NV_JOIN_DT",",current_timestamp()"]
["KK_JOIN_ID","VARCHAR(20)",true,null,null,",KK_JOIN_ID",",''"]
["KK_ACCESS_TOKEN","VARCHAR(200)",true,null,null,",KK_ACCESS_TOKEN",",''"]
["KK_JOIN_DT","TIMESTAMP",false,null,null,",KK_JOIN_DT",",current_timestamp()"]
["YS_JOIN_ID","VARCHAR(20)",true,null,null,",YS_JOIN_ID",",''"]
["YS_ACCESS_TOKEN","VARCHAR(200)",true,null,null,",YS_ACCESS_TOKEN",",''"]
["YS_JOIN_DT","TIMESTAMP",false,null,null,",YS_JOIN_DT",",current_timestamp()"]
["CI","VARCHAR(200)",true,null,null,",CI",",''"]
["AUTH_DT","TIMESTAMP",false,null,null,",AUTH_DT",",current_timestamp()"]
["MANAGED_RSN","VARCHAR(20)",true,null,null,",MANAGED_RSN",",''"]
["MANAGED_DTL_RSN","VARCHAR(500)",true,null,null,",MANAGED_DTL_RSN",",''"]
["MANAGED_DT","TIMESTAMP",false,null,null,",MANAGED_DT",",current_timestamp()"]
["SECEDE_RSN","VARCHAR(20)",true,null,null,",SECEDE_RSN",",''"]
["SECEDE_DTL_RSN","VARCHAR(500)",true,null,null,",SECEDE_DTL_RSN",",''"]
["SECEDE_DT","TIMESTAMP",false,null,null,",SECEDE_DT",",current_timestamp()"]
["REG_NO","INT(10) UNSIGNED",false,0,null,",REG_NO",",0"]
["REG_DT","TIMESTAMP",false,null,null,",REG_DT",",current_timestamp()"]
["UPD_NO","INT(10) UNSIGNED",false,0,null,",UPD_NO",",0"]
["UPD_DT","TIMESTAMP",false,null,null,",UPD_DT",",current_timestamp()"]
[{"$nulls":5},") VALUES (",");"]

{"sheet":"Sheet3","index":7,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["ORD_DTL_ITEM_SQ"]
["ORD_DTL_NO",null,null,"SELECT COLUMN_NAME"]
["ORD_NO",null,null,"     , UPPER(COLUMN_TYPE)"]
["ORD_DTL_STAT",null,null,"FROM   information_schema.COLUMNS "]
["ITEM_CD",null,null,"WHERE  TABLE_NAME = 'TB_ORDER_DETAIL'"]
["OPT_CD"]
["OPT_CD1"]
["OPT_CD2"]
["ITEM_QTY"]
["ITEM_PRICE"]
["ITEM_ORD_QTY"]
["ITEM_ORD_PRICE"]
["ITEM_CNCL_RTN_QTY"]
["ITEM_CNCL_RTN_PRICE"]
["OPT_ADD_PRICE"]
["DISP_ORD"]
["ORD_AMT"]
["CNCL_RTN_AMT"]
["CPN1_DC_AMT"]
["TMTB1_DC_AMT"]
["TMTB2_DC_AMT"]
["GOODS_CPN_DC_AMT"]
["CART_CPN_DC_AMT"]
["PNT_DC_AMT"]
["PRE_PNT_DC_AMT"]
["SAVE_PNT_DC_AMT"]
["REAL_ORD_AMT"]
["GFCD_USE_AMT"]
["REG_NO"]
["REG_DT"]
["UPD_NO"]
["UPD_DT"]