{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["TB_ORDER_DETAIL_ITEM","TB_ORDER_DETAIL_ITEM_HST","TB_TMTB","TB_TMTB_SECTION","TB_TMTB_REFVAL","TB_TMTB_BURDEN","TB_COUPON","TB_COUPON_RANDOM","Sheet2"],"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_DETAIL_ITEM","index":0,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_ORDER_DETAIL_ITEM",{"$nulls":7},"주문상세단품. 신규 주문 등록에 의한 발생"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_ORDER_DETAIL_ITEM ( "}]
["ORD_DTL_ITEM_SQ","INT",10,"O",null,"O","O",null,"주문상세단품일련번호",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `ORD_DTL_ITEM_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '주문상세단품일련번호'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`ORD_DTL_ITEM_SQ`)"}]
["ORD_DTL_NO","INT",10,"O",null,null,null,"01","주문상세번호",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `ORD_DTL_NO` INT(10) NOT NULL  COMMENT '주문상세번호'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_ORDER_DETAIL_ITEM_01 (`ORD_DTL_NO`)"}]
["ORD_NO","INT",10,"O",null,null,null,"02","주문번호",null,", `ORD_NO` INT(10) NOT NULL  COMMENT '주문번호'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", KEY IX_TB_ORDER_DETAIL_ITEM_02 (`ORD_NO`)"}]
["ORD_DTL_STAT","VARCHAR",20,"O",{"$nulls":4},"주문상세상태(공통코드G013)",null,", `ORD_DTL_STAT` VARCHAR(20) NOT NULL  COMMENT '주문상세상태(공통코드G013)'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" ('\" & A8 & \"')\")","v":", "}]
["ITEM_CD","VARCHAR",20,"O",{"$nulls":4},"단품코드(상품). 일반상품과 딜상품은 상품코드와 동일",null,", `ITEM_CD` VARCHAR(20) NOT NULL  COMMENT '단품코드(상품). 일반상품과 딜상품은 상품코드와 동일'",", ",", "]
["OPT_CD","VARCHAR",200,"O",{"$nulls":4},"옵션코드",null,", `OPT_CD` VARCHAR(200) NOT NULL  COMMENT '옵션코드'",", ",", "]
["OPT_CD1","VARCHAR",200,{"$nulls":5},"옵션코드1(칼라)",null,", `OPT_CD1` VARCHAR(200) COMMENT '옵션코드1(칼라)'",", ",", "]
["OPT_CD2","VARCHAR",200,{"$nulls":5},"옵션코드2(사이즈)",null,", `OPT_CD2` VARCHAR(200) COMMENT '옵션코드2(사이즈)'",", ",", "]
["ITEM_QTY","SMALLINT",5,"O",0,null,null,null,"단품수량(세트상품단품수량)",null,", `ITEM_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품수량(세트상품단품수량)'",", ",", "]
["ITEM_PRICE","INT",10,"O",0,null,null,null,"단품금액(세트상품단품금액)",null,", `ITEM_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품금액(세트상품단품금액)'",", ",", "]
["ITEM_ORD_QTY","SMALLINT",5,"O",0,null,null,null,"단품주문수량(상세주문수량 * 단품수량)",null,", `ITEM_ORD_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품주문수량(상세주문수량 * 단품수량)'",", ",", "]
["ITEM_ORD_PRICE","INT",10,"O",0,null,null,null,"단품주문금액(상세주문수량 * 단품금액)",null,", `ITEM_ORD_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품주문금액(상세주문수량 * 단품금액)'",", ",", "]
["ITEM_CNCL_RTN_QTY","SMALLINT",5,"O",0,null,null,null,"단품취소,반품 수량(상세취소수량 * 단품수량)",null,", `ITEM_CNCL_RTN_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품취소,반품 수량(상세취소수량 * 단품수량)'",", ",", "]
["ITEM_CNCL_RTN_PRICE","INT",10,"O",0,null,null,null,"단품취소,반품 금액(상세취소수량 * 단품금액)",null,", `ITEM_CNCL_RTN_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품취소,반품 금액(상세취소수량 * 단품금액)'",", ",", "]
["OPT_ADD_PRICE","INT",10,"O",0,null,null,null,"옵션추가가격",null,", `OPT_ADD_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '옵션추가가격'",", ",", "]
["DISP_ORD","SMALLINT",5,"O",1,null,null,null,"표시순서",null,", `DISP_ORD` SMALLINT(5) NOT NULL  DEFAULT '1' COMMENT '표시순서'",", ",", "]
["ORD_AMT","INT",10,"O",0,null,null,null,"단품주문금액( ((단품금액 + 옵션추가금액) * 상세주문수량) * 단품수량)",null,", `ORD_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품주문금액( ((단품금액 + 옵션추가금액) * 상세주문수량) * 단품수량)'",", ",", "]
["CNCL_RTN_AMT","INT",10,"O",0,null,null,null,"단품취소금액( ((단품금액 + 옵션추가금액) * 상세취소수량) * 단품수량)",null,", `CNCL_RTN_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품취소금액( ((단품금액 + 옵션추가금액) * 상세취소수량) * 단품수량)'",", ",", "]
["CPN1_DC_AMT","INT",10,"O",0,null,null,null,"단품 1차쿠폰 할인금액",null,", `CPN1_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 1차쿠폰 할인금액'",", ",", "]
["TMTB1_DC_AMT","INT",10,"O",0,null,null,null,"단품 다다익선 1차 할인금액 ",null,", `TMTB1_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 다다익선 1차 할인금액'",", ",", "]
["TMTB2_DC_AMT","INT",10,"O",0,null,null,null,"단품 다다익선 2차 할인금액",null,", `TMTB2_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 다다익선 2차 할인금액'",", ",", "]
["GOODS_CPN_DC_AMT","INT",10,"O",0,null,null,null,"단품 2차쿠폰 할인금액",null,", `GOODS_CPN_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 2차쿠폰 할인금액'",", ",", "]
["CART_CPN_DC_AMT","INT",10,"O",0,null,null,null,"단품 장바구니쿠폰 할인금액",null,", `CART_CPN_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 장바구니쿠폰 할인금액'",", ",", "]
["PNT_DC_AMT","INT",10,"O",0,null,null,null,"단품 포인트 할인 금액",null,", `PNT_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 포인트 할인 금액'",", ",", "]
["PRE_PNT_DC_AMT","INT",10,"O",0,null,null,null,"단품 선포인트 할인 금액",null,", `PRE_PNT_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 선포인트 할인 금액'",", ",", "]
["SAVE_PNT_AMT","INT",10,"O",0,null,null,null,"단품 적립포인트 금액",null,", `SAVE_PNT_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 적립포인트 금액'",", ",", "]
["REAL_ORD_AMT","INT",10,"O",0,null,null,null,"단품 실제 주문금액 (단품주문금액 - 각종할인금액)",null,", `REAL_ORD_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 실제 주문금액 (단품주문금액 - 각종할인금액)'",", ",", "]
["GFCD_USE_AMT","INT",10,"O",0,null,null,null,"단품 상품권 사용 금액",null,", `GFCD_USE_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 상품권 사용 금액'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4},"등록자 NO",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자 NO'",", ",", "]
["REG_DT","timestamp",null,"O","current_timestamp()",null,null,null,"등록일",null,", `REG_DT` timestamp NOT NULL  DEFAULT 'current_timestamp()' COMMENT '등록일'",", ",", "]
["UPD_NO","INT",10,"O",{"$nulls":4},"수정자 NO",null,", `UPD_NO` INT(10) NOT NULL  COMMENT '수정자 NO'",", ",", "]
["UPD_DT","timestamp",null,"O","current_timestamp()",null,null,null,"수정일",null,{"$f":"\", `\" &A36&\"` \"&B36& IF(B36=\"TIMESTAMP\", \"\", \"(\"&C36&\")\") & IF(D36=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E36), \"\", \" DEFAULT \" & E36 ) & IF(F36=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I36) & \"'\"","v":", `UPD_DT` timestamp NOT NULL  DEFAULT current_timestamp() COMMENT '수정일'"},", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='주문상세단품. 신규 주문 등록에 의한 발생'"}]
[{"$nulls":10},";"]

{"sheet":"TB_ORDER_DETAIL_ITEM_HST","index":1,"n_rows":40,"n_cols":13,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_ORDER_DETAIL_ITEM_HST",{"$nulls":7},"발송완료, 취소완료, 반품회수완료, 교환회완료, 교환발송완료"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_ORDER_DETAIL_ITEM_HST ( "}]
["ORD_DTL_ITEM_HST_SQ","INT",10,"O",null,"O","O",null,"주문상세단품이력일련번호",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `ORD_DTL_ITEM_HST_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '주문상세단품이력일련번호'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`ORD_DTL_ITEM_HST_SQ`)"}]
["ORD_DTL_ITEM_SQ","INT",10,"O",null,null,null,"01","주문상세단품일련번호",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `ORD_DTL_ITEM_SQ` INT(10) NOT NULL  COMMENT '주문상세단품일련번호'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"`)\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_ORDER_DETAIL_ITEM_HST_01 (`ORD_DTL_ITEM_SQ`)"}]
["ORD_DTL_NO","INT",10,"O",null,null,null,"02","주문상세번호",null,", `ORD_DTL_NO` INT(10) NOT NULL  COMMENT '주문상세번호'",{"$f":"\", \" & IF(G7=\"O\",\"PRIMARY KEY (`\" & A7 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", KEY IX_TB_ORDER_DETAIL_ITEM_HST_02 (`ORD_DTL_NO`)"}]
["ORD_NO","INT",10,"O",null,null,null,"03","주문번호",null,", `ORD_NO` INT(10) NOT NULL  COMMENT '주문번호'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" (`\" & A8 & \"`)\")","v":", KEY IX_TB_ORDER_DETAIL_ITEM_HST_03 (`ORD_NO`)"}]
["ORD_DTL_STAT","VARCHAR",20,"O",{"$nulls":4},"주문상세상태(공통코드G013)",null,", `ORD_DTL_STAT` VARCHAR(20) NOT NULL  COMMENT '주문상세상태(공통코드G013)'",", ",{"$f":"\", \"&IF(ISBLANK(H9),\"\",\"KEY IX_\"&$A$3&\"_\"&H9&\" (`\" & A9 & \"`)\")","v":", "}]
["ITEM_CD","VARCHAR",20,"O",{"$nulls":4},"단품코드(상품). 일반상품과 딜상품은 상품코드와 동일",null,", `ITEM_CD` VARCHAR(20) NOT NULL  COMMENT '단품코드(상품). 일반상품과 딜상품은 상품코드와 동일'",", ",{"$f":"\", \"&IF(ISBLANK(H10),\"\",\"KEY IX_\"&$A$3&\"_\"&H10&\" ('\" & A10 & \"')\")","v":", "}]
["OPT_CD","VARCHAR",200,"O",{"$nulls":4},"옵션코드",null,", `OPT_CD` VARCHAR(200) NOT NULL  COMMENT '옵션코드'",", ",", "]
["OPT_CD1","VARCHAR",200,{"$nulls":5},"옵션코드1(칼라)",null,", `OPT_CD1` VARCHAR(200) COMMENT '옵션코드1(칼라)'",", ",", "]
["OPT_CD2","VARCHAR",200,{"$nulls":5},"옵션코드2(사이즈)",null,", `OPT_CD2` VARCHAR(200) COMMENT '옵션코드2(사이즈)'",", ",", "]
["ITEM_QTY","SMALLINT",5,"O",0,null,null,null,"단품수량(세트상품단품수량)",null,", `ITEM_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품수량(세트상품단품수량)'",", ",", "]
["ITEM_PRICE","INT",10,"O",0,null,null,null,"단품금액(세트상품단품금액)",null,", `ITEM_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품금액(세트상품단품금액)'",", ",", "]
["ITEM_ORD_QTY","SMALLINT",5,"O",0,null,null,null,"단품주문수량(상세주문수량 * 단품수량)",null,", `ITEM_ORD_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품주문수량(상세주문수량 * 단품수량)'",", ",", "]
["ITEM_ORD_PRICE","INT",10,"O",0,null,null,null,"단품주문금액(상세주문수량 * 단품금액)",null,", `ITEM_ORD_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품주문금액(상세주문수량 * 단품금액)'",", ",", "]
["ITEM_CNCL_RTN_QTY","SMALLINT",5,"O",0,null,null,null,"단품취소,반품 수량(상세취소수량 * 단품수량)",null,", `ITEM_CNCL_RTN_QTY` SMALLINT(5) NOT NULL  DEFAULT '0' COMMENT '단품취소,반품 수량(상세취소수량 * 단품수량)'",", ",", "]
["ITEM_CNCL_RTN_PRICE","INT",10,"O",0,null,null,null,"단품취소,반품 금액(상세취소수량 * 단품금액)",null,", `ITEM_CNCL_RTN_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품취소,반품 금액(상세취소수량 * 단품금액)'",", ",", "]
["OPT_ADD_PRICE","INT",10,"O",0,null,null,null,"옵션추가가격",null,", `OPT_ADD_PRICE` INT(10) NOT NULL  DEFAULT '0' COMMENT '옵션추가가격'",", ",", "]
["DISP_ORD","SMALLINT",5,"O",1,null,null,null,"표시순서",null,", `DISP_ORD` SMALLINT(5) NOT NULL  DEFAULT '1' COMMENT '표시순서'",", ",", "]
["ORD_AMT","INT",10,"O",0,null,null,null,"단품주문금액( ((단품금액 + 옵션추가금액) * 상세주문수량) * 단품수량)",null,", `ORD_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품주문금액( ((단품금액 + 옵션추가금액) * 상세주문수량) * 단품수량)'",", ",", "]
["CNCL_RTN_AMT","INT",10,"O",0,null,null,null,"단품취소금액( ((단품금액 + 옵션추가금액) * 상세취소수량) * 단품수량)",null,", `CNCL_RTN_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품취소금액( ((단품금액 + 옵션추가금액) * 상세취소수량) * 단품수량)'",", ",", "]
["CPN1_DC_AMT","INT",10,"O",0,null,null,null,"단품 1차쿠폰 할인금액",null,", `CPN1_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 1차쿠폰 할인금액'",", ",", "]
["TMTB1_DC_AMT","INT",10,"O",0,null,null,null,"단품 다다익선 1차 할인금액 ",null,", `TMTB1_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 다다익선 1차 할인금액'",", ",", "]
["TMTB2_DC_AMT","INT",10,"O",0,null,null,null,"단품 다다익선 2차 할인금액",null,", `TMTB2_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 다다익선 2차 할인금액'",", ",", "]
["GOODS_CPN_DC_AMT","INT",10,"O",0,null,null,null,"단품 2차쿠폰 할인금액",null,", `GOODS_CPN_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 2차쿠폰 할인금액'",", ",", "]
["CART_CPN_DC_AMT","INT",10,"O",0,null,null,null,"단품 장바구니쿠폰 할인금액",null,", `CART_CPN_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 장바구니쿠폰 할인금액'",", ",", "]
["PNT_DC_AMT","INT",10,"O",0,null,null,null,"단품 포인트 할인 금액",null,", `PNT_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 포인트 할인 금액'",", ",", "]
["PRE_PNT_DC_AMT","INT",10,"O",0,null,null,null,"단품 선포인트 할인 금액",null,", `PRE_PNT_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 선포인트 할인 금액'",", ",", "]
["SAVE_PNT_AMT","INT",10,"O",0,null,null,null,"단품 적립포인트 금액",null,", `SAVE_PNT_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 적립포인트 금액'",", ",", "]
["REAL_ORD_AMT","INT",10,"O",0,null,null,null,"단품 실제 주문금액 (단품주문금액 - 각종할인금액)",null,", `REAL_ORD_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 실제 주문금액 (단품주문금액 - 각종할인금액)'",", ",", "]
["GFCD_USE_AMT","INT",10,"O",0,null,null,null,"단품 상품권 사용 금액",null,", `GFCD_USE_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '단품 상품권 사용 금액'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4},"등록자 NO",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자 NO'",", ",", "]
["REG_DT","timestamp",null,"O","current_timestamp()",null,null,null,"등록일",null,", `REG_DT` timestamp NOT NULL  DEFAULT 'current_timestamp()' COMMENT '등록일'",", ",", "]
["UPD_NO","INT",10,"O",{"$nulls":4},"수정자 NO",null,", `UPD_NO` INT(10) NOT NULL  COMMENT '수정자 NO'",", ",", "]
["UPD_DT","timestamp",null,"O","current_timestamp()",null,null,null,"수정일",null,", `UPD_DT` timestamp NOT NULL  DEFAULT 'current_timestamp()' COMMENT '수정일'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='발송완료, 취소완료, 반품회수완료, 교환회완료, 교환발송완료'"}]
[{"$nulls":10},";"]

{"sheet":"TB_TMTB","index":2,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_TMTB",{"$nulls":7},"다다익선 마스터 테이블 확인요청(대상회원등급, 대상상품(전체, 개별))"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_TMTB ( "}]
["TMTB_SQ","INT",10,"O",null,"O","O",null,"다다익선 시퀀스                                                                  ",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `TMTB_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '다다익선 시퀀스'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`TMTB_SQ`)"}]
["TMTB_NM","VARCHAR",100,"O",{"$nulls":4},"다다익선 명                                                                     ",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `TMTB_NM` VARCHAR(100) NOT NULL  COMMENT '다다익선 명'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", "}]
["TMTB_STAT","VARCHAR",20,"O",{"$nulls":4},"다다익선 상태값 (G232_10|대기, G232_11|진행, G232_12|중지, G232_13|종료, G232_14|삭제) ",null,", `TMTB_STAT` VARCHAR(20) NOT NULL  COMMENT '다다익선 상태값 (G232_10|대기, G232_11|진행, G232_12|중지, G232_13|종료, G232_14|삭제)'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["TMTB_ST_DT","timestamp",null,"O",{"$nulls":4},"다다익선 적용 시작 날짜                                                            ",null,", `TMTB_ST_DT` timestamp NOT NULL  COMMENT '다다익선 적용 시작 날짜'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" ('\" & A8 & \"')\")","v":", "}]
["TMTB_ED_DT","timestamp",null,"O",{"$nulls":4},"다다익선 적용 종료 날짜                                                            ",null,", `TMTB_ED_DT` timestamp NOT NULL  COMMENT '다다익선 적용 종료 날짜'",", ",", "]
["DC_GB","VARCHAR",20,"O",{"$nulls":4},"할인대상구분 (G999_10|수량, G999_11|금액)                                          ",null,", `DC_GB` VARCHAR(20) NOT NULL  COMMENT '할인대상구분 (G999_10|수량, G999_11|금액)'",", ",", "]
["MULTI_YN","CHAR",1,"O",{"$nulls":4},"(Y|복합상품, N|단품상품)                                                         ",null,", `MULTI_YN` CHAR(1) NOT NULL  COMMENT '(Y|복합상품, N|단품상품)'",", ",", "]
["SITE_CD","VARCHAR",20,{"$nulls":5},"사이트코드(공통코드G000)                                                          ",null,", `SITE_CD` VARCHAR(20) COMMENT '사이트코드(공통코드G000)'",", ",", "]
["AF_LINK_CD","VARCHAR",50,{"$nulls":5},"제휴링크코드                                                                    ",null,", `AF_LINK_CD` VARCHAR(50) COMMENT '제휴링크코드'",", ",", "]
["USABLE_CUST_GB","VARCHAR",20,{"$nulls":5},"사용가능고객구분(공통코드G100)                                                      ",null,", `USABLE_CUST_GB` VARCHAR(20) COMMENT '사용가능고객구분(공통코드G100)'",", ",", "]
["USABLE_CUST_GRADE","VARCHAR",20,{"$nulls":5},"용가능고객등급(공통코드G110)                                                       ",null,", `USABLE_CUST_GRADE` VARCHAR(20) COMMENT '용가능고객등급(공통코드G110)'",", ",", "]
["DEL_YN","CHAR",1,"O","N",null,null,null,"삭제여부                                                                       ",null,", `DEL_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '삭제여부'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4},"등록자                                                                        ",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자'",", ",", "]
["REG_DT","timestamp",null,"O",{"$nulls":4},"등록날짜                                                                       ",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록날짜'",", ",", "]
["UDP_NO","INT",10,"O",{"$nulls":4},"수정자                                                                        ",null,", `UDP_NO` INT(10) NOT NULL  COMMENT '수정자'",", ",", "]
["UDT_DT","timestamp",null,"O",{"$nulls":4},"수정날짜                                                                       ",null,", `UDT_DT` timestamp NOT NULL  COMMENT '수정날짜'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='다다익선 마스터 테이블 확인요청(대상회원등급, 대상상품(전체, 개별))'"}]
[{"$nulls":10},";"]

{"sheet":"TB_TMTB_SECTION","index":3,"n_rows":20,"n_cols":13,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_TMTB_SECTION",{"$nulls":7},"다다익선 할인구간설정"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_TMTB_SECTION ( "}]
["TB_TMTB_SECTION_SQ","INT",10,"O",null,"O","O",null,"다다익선 할인구간 시퀀스                          ",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `TB_TMTB_SECTION_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '다다익선 할인구간 시퀀스'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`TB_TMTB_SECTION_SQ`)"}]
["TMTB_SQ","INT",10,"O",null,null,null,"01","다다익선 시퀀스                                 ",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `TMTB_SQ` INT(10) NOT NULL  COMMENT '다다익선 시퀀스'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_TMTB_SECTION_01 (`TMTB_SQ`)"}]
["DC_GB","VARCHAR",20,"O",{"$nulls":4},"할인대상구분 (G999_10|수량, G999_11|금액)         ",null,", `DC_GB` VARCHAR(20) NOT NULL  COMMENT '할인대상구분 (G999_10|수량, G999_11|금액)'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["DC_SECTION","INT",10,"O",{"$nulls":4},"구간할인시작(수량이상, 금액이상)                    ",null,", `DC_SECTION` INT(10) NOT NULL  COMMENT '구간할인시작(수량이상, 금액이상)'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" ('\" & A8 & \"')\")","v":", "}]
["DC_WAY","VARCHAR",20,"O",{"$nulls":4},"할인방식(G240_10|할인금액, G240_11|할인율)        ",null,", `DC_WAY` VARCHAR(20) NOT NULL  COMMENT '할인방식(G240_10|할인금액, G240_11|할인율)'",", ",", "]
["DC_PVAL","INT",10,"O",0,null,null,null,"PC 할인값 10,000                             ",null,", `DC_PVAL` INT(10) NOT NULL  DEFAULT '0' COMMENT 'PC 할인값 10,000'",", ",", "]
["DC_MVAL","INT",10,"O",0,null,null,null,"MOBILE 할인값 10,000                         ",null,", `DC_MVAL` INT(10) NOT NULL  DEFAULT '0' COMMENT 'MOBILE 할인값 10,000'",", ",", "]
["DC_AVAL","INT",10,"O",0,null,null,null,"APP 할인값 10,000                            ",null,", `DC_AVAL` INT(10) NOT NULL  DEFAULT '0' COMMENT 'APP 할인값 10,000'",", ",", "]
["DEL_YN","CHAR",1,"O","N",null,null,null,"삭제여부                                      ",null,", `DEL_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '삭제여부'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4},"등록자                                       ",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자'",", ",", "]
["REG_DT","timestamp",null,"O",{"$nulls":4},"등록날짜                                      ",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록날짜'",", ",", "]
["UDP_NO","INT",10,"O",{"$nulls":4},"수정자                                       ",null,", `UDP_NO` INT(10) NOT NULL  COMMENT '수정자'",", ",", "]
["UDT_DT","timestamp",null,"O",{"$nulls":4},"수정날짜                                      ",null,", `UDT_DT` timestamp NOT NULL  COMMENT '수정날짜'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='다다익선 할인구간설정'"}]
[{"$nulls":10},";"]

{"sheet":"TB_TMTB_REFVAL","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_TMTB_REFVAL",{"$nulls":7},"다다익선 적용상품설정"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_TMTB_REFVAL ( "}]
["TB_TMTB_GOODS_SQ","INT",10,"O",null,"O","O",null,"다다익선 할인구간 시퀀스                                               ",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `TB_TMTB_GOODS_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '다다익선 할인구간 시퀀스'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`TB_TMTB_GOODS_SQ`)"}]
["TMTB_SQ","INT",10,"O",null,null,null,"01","다다익선 시퀀스                                                      ",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `TMTB_SQ` INT(10) NOT NULL  COMMENT '다다익선 시퀀스'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_TMTB_REFVAL_01 (`TMTB_SQ`)"}]
["TMTB_GOODS_GB","VARCHAR",20,"O",{"$nulls":4},"공통코드 (G999_10|기본상품, G999_20|적용상품, G999_30|제외상품)           ",null,", `TMTB_GOODS_GB` VARCHAR(20) NOT NULL  COMMENT '공통코드 (G999_10|기본상품, G999_20|적용상품, G999_30|제외상품)'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["TMTB_TARGET","VARCHAR",20,"O",{"$nulls":4},"적용대상 (G260_10|상품, G260_11|카테고리, G260_12|브랜드, G260_13|공급처) ",null,", `TMTB_TARGET` VARCHAR(20) NOT NULL  COMMENT '적용대상 (G260_10|상품, G260_11|카테고리, G260_12|브랜드, G260_13|공급처)'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" ('\" & A8 & \"')\")","v":", "}]
["TMTB_REF_VAL","VARCHAR",20,"O",{"$nulls":4},"브랜드코드, 상품코드, 품목코드                                            ",null,", `TMTB_REF_VAL` VARCHAR(20) NOT NULL  COMMENT '브랜드코드, 상품코드, 품목코드'",", ",", "]
["DEL_YN","CHAR",1,"O","N",null,null,null,"삭제여부                                                           ",null,", `DEL_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '삭제여부'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4},"등록자                                                            ",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자'",", ",", "]
["REG_DT","timestamp",null,"O",{"$nulls":4},"등록날짜                                                           ",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록날짜'",", ",", "]
["UDP_NO","INT",10,"O",{"$nulls":4},"수정자                                                            ",null,", `UDP_NO` INT(10) NOT NULL  COMMENT '수정자'",", ",", "]
["UDT_DT","timestamp",null,"O",{"$nulls":4},"수정날짜                                                           ",null,", `UDT_DT` timestamp NOT NULL  COMMENT '수정날짜'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='다다익선 적용상품설정'"}]
[{"$nulls":10},";"]

{"sheet":"TB_TMTB_BURDEN","index":5,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_TMTB_BURDEN",{"$nulls":7},"다다익선 업체 분담율"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_TMTB_BURDEN ( "}]
["TB_TMTB_BURDEN_SQ","INT",10,"O",null,"O","O",null," 다다익선 할인구간 시퀀스       ",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(B5=\"TIMESTAMP\", \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `TB_TMTB_BURDEN_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '다다익선 할인구간 시퀀스'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`TB_TMTB_BURDEN_SQ`)"}]
["TMTB_SQ","INT",10,"O",null,null,null,"01"," 다다익선 시퀀스              ",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(B6=\"TIMESTAMP\", \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `TMTB_SQ` INT(10) NOT NULL  COMMENT '다다익선 시퀀스'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"')\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_TMTB_BURDEN_01 (`TMTB_SQ`)"}]
["TMTB_SUPPLY_CD","VARCHAR",20,"O",{"$nulls":4}," 다다익선 업체 코드           ",null,", `TMTB_SUPPLY_CD` VARCHAR(20) NOT NULL  COMMENT '다다익선 업체 코드'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["TMTB_BURDEN_RATE","VARCHAR",20,"O",{"$nulls":4}," 다다익선 업체 분담율          ",null,", `TMTB_BURDEN_RATE` VARCHAR(20) NOT NULL  COMMENT '다다익선 업체 분담율'",", ",{"$f":"\", \"&IF(ISBLANK(H8),\"\",\"KEY IX_\"&$A$3&\"_\"&H8&\" ('\" & A8 & \"')\")","v":", "}]
["USE_YN","CHAR",1,"O","N",null,null,null," 사용여부                   ",null,", `USE_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '사용여부'",", ",", "]
["REG_NO","INT",10,"O",{"$nulls":4}," 등록자                    ",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자'",", ",", "]
["REG_DT","timestamp",null,"O",{"$nulls":4}," 등록날짜                   ",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록날짜'",", ",", "]
["UDP_NO","INT",10,"O",{"$nulls":4}," 수정자                    ",null,", `UDP_NO` INT(10) NOT NULL  COMMENT '수정자'",", ",", "]
["UDT_DT","timestamp",null,"O",{"$nulls":4}," 수정날짜                   ",null,", `UDT_DT` timestamp NOT NULL  COMMENT '수정날짜'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='다다익선 업체 분담율'"}]
[{"$nulls":10},";"]

{"sheet":"TB_COUPON","index":6,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_COUPON",{"$nulls":7},"쿠폰. 신규 쿠폰 등록에 의한 발생"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_COUPON ( "}]
["CPN_ID","INT",10,"O",null,null,"O",null,"쿠폰ID(CPN+SEQ_CPN_NO sequence)",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(OR(B5=\"TIMESTAMP\", B5=\"FLOAT\"), \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `CPN_ID` INT(10) NOT NULL  COMMENT '쿠폰ID(CPN+SEQ_CPN_NO sequence)'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`CPN_ID`)"}]
["CPN_NM","INT",10,"O",null,null,null,"01","쿠폰명",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(OR(B6=\"TIMESTAMP\", B6=\"FLOAT\"), \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `CPN_NM` INT(10) NOT NULL  COMMENT '쿠폰명'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"`)\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_COUPON_01 (`CPN_NM`)"}]
["SITE_CD","VARCHAR",20,"O",{"$nulls":4},"사이트코드(공통코드G000)",null,", `SITE_CD` VARCHAR(20) NOT NULL  COMMENT '사이트코드(공통코드G000)'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["AF_LINK_CD","VARCHAR",20,"O","AF001",null,null,null,"제휴링크코드",null,", `AF_LINK_CD` VARCHAR(20) NOT NULL  DEFAULT 'AF001' COMMENT '제휴링크코드'",", ",", "]
["USABLE_CUST_GB","VARCHAR",20,"O",{"$nulls":4},"사용가능고객구분(공통코드G100)",null,", `USABLE_CUST_GB` VARCHAR(20) NOT NULL  COMMENT '사용가능고객구분(공통코드G100)'",", ",", "]
["CUST_GRADE10_YN","CHAR",1,"O","Y",null,null,null,"사용가능고객등급(공통코드G110)(추가칼럼)",null,", `CUST_GRADE10_YN` CHAR(1) NOT NULL  DEFAULT 'Y' COMMENT '사용가능고객등급(공통코드G110)(추가칼럼)'",", ",", "]
["CUST_GRADE20_YN","CHAR",1,"O","Y",null,null,null,"사용가능고객등급(공통코드G110)(추가칼럼)",null,", `CUST_GRADE20_YN` CHAR(1) NOT NULL  DEFAULT 'Y' COMMENT '사용가능고객등급(공통코드G110)(추가칼럼)'",", ",", "]
["CUST_GRADE30_YN","CHAR",1,"O","Y",null,null,null,"사용가능고객등급(공통코드G110)(추가칼럼)",null,", `CUST_GRADE30_YN` CHAR(1) NOT NULL  DEFAULT 'Y' COMMENT '사용가능고객등급(공통코드G110)(추가칼럼)'",", ",", "]
["CUST_GRADE40_YN","CHAR",1,"O","Y",null,null,null,"사용가능고객등급(공통코드G110)(추가칼럼)",null,", `CUST_GRADE40_YN` CHAR(1) NOT NULL  DEFAULT 'Y' COMMENT '사용가능고객등급(공통코드G110)(추가칼럼)'",", ",", "]
["CPN_TYPE","VARCHAR",20,"O",{"$nulls":4},"쿠폰유형(공통코드G230)",null,", `CPN_TYPE` VARCHAR(20) NOT NULL  COMMENT '쿠폰유형(공통코드G230)'",", ",", "]
["APPLY_SCOPE","CHAR",1,"O","A",null,null,null,"적용범위(A:전체, I:개별). \"I:개별\"이고 쿠폰유형이 \"20:장바구니쿠폰\" 외 이면 TB_COUPON_REFVAL 참조",null,", `APPLY_SCOPE` CHAR(1) NOT NULL  DEFAULT 'A' COMMENT '적용범위(A:전체, I:개별). \"I:개별\"이고 쿠폰유형이 \"20:장바구니쿠폰\" 외 이면 TB_COUPON_REFVAL 참조'",", ",", "]
["DC_WAY","VARCHAR",20,"O",{"$nulls":4},"할인방식(공통코드G240)",null,", `DC_WAY` VARCHAR(20) NOT NULL  COMMENT '할인방식(공통코드G240)'",", ",", "]
["DC_PVAL","FLOAT",null,"O",0,null,null,null,"할인값(PC). 할인방식이 금액이면 할인금액, 율이면 할인율",null,", `DC_PVAL` FLOAT NOT NULL  DEFAULT '0' COMMENT '할인값(PC). 할인방식이 금액이면 할인금액, 율이면 할인율'",", ",", "]
["DC_MVAL","FLOAT",null,"O",0,null,null,null,"할인값(모바일). 할인방식이 금액이면 할인금액, 율이면 할인율",null,", `DC_MVAL` FLOAT NOT NULL  DEFAULT '0' COMMENT '할인값(모바일). 할인방식이 금액이면 할인금액, 율이면 할인율'",", ",", "]
["DC_AVAL","FLOAT",null,"O",0,null,null,null,"할인값(모바일앱)",null,", `DC_AVAL` FLOAT NOT NULL  DEFAULT '0' COMMENT '할인값(모바일앱)'",", ",", "]
["MAX_DC_AMT","INT",10,"O",0,null,null,null,"최고할인금액",null,", `MAX_DC_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '최고할인금액'",", ",", "]
["PD_GB","CHAR",1,"O","P",null,null,null,"기간/일수구분(P:기간, D:일수)",null,", `PD_GB` CHAR(1) NOT NULL  DEFAULT 'P' COMMENT '기간/일수구분(P:기간, D:일수)'",", ",", "]
["AVAIL_STDT","timestamp",null,"O",{"$nulls":4},"유효시작일시(기간/일수구분 \"P:기간\"일 때 사용됨)",null,", `AVAIL_STDT` timestamp NOT NULL  COMMENT '유효시작일시(기간/일수구분 \"P:기간\"일 때 사용됨)'",", ",", "]
["AVAIL_EDDT","timestamp",null,"O",{"$nulls":4},"유효종료일시(기간/일수구분 \"P:기간\"일 때 사용됨)",null,", `AVAIL_EDDT` timestamp NOT NULL  COMMENT '유효종료일시(기간/일수구분 \"P:기간\"일 때 사용됨)'",", ",", "]
["AVAIL_DAYS","SMALLINT",5,"O",{"$nulls":4},"유효일수(기간/일수구분 \"D:일수\"일 때 사용됨)",null,", `AVAIL_DAYS` SMALLINT(5) NOT NULL  COMMENT '유효일수(기간/일수구분 \"D:일수\"일 때 사용됨)'",", ",", "]
["CUST_PUB_LIMIT_QTY","SMALLINT",5,"O",{"$nulls":4},"고객당발행제한수량(0은 무제한)",null,", `CUST_PUB_LIMIT_QTY` SMALLINT(5) NOT NULL  COMMENT '고객당발행제한수량(0은 무제한)'",", ",", "]
["TOT_PUB_LIMIT_QTY","SMALLINT",5,"O",{"$nulls":4},"총발행제한수량(0은 무제한)",null,", `TOT_PUB_LIMIT_QTY` SMALLINT(5) NOT NULL  COMMENT '총발행제한수량(0은 무제한)'",", ",", "]
["ONE_PUB_QTY","SMALLINT",5,"O",1,null,null,null,"1회발행수량(기본은 1)",null,", `ONE_PUB_QTY` SMALLINT(5) NOT NULL  DEFAULT '1' COMMENT '1회발행수량(기본은 1)'",", ",", "]
["DN_GB","VARCHAR",20,"O","G058_10",null,null,null,"다운로드구분(공통코드G058)",null,", `DN_GB` VARCHAR(20) NOT NULL  DEFAULT 'G058_10' COMMENT '다운로드구분(공통코드G058)'",", ",", "]
["DOWN_STDT","timestamp",null,"O",{"$nulls":4},"다운로드시작일시",null,", `DOWN_STDT` timestamp NOT NULL  COMMENT '다운로드시작일시'",", ",", "]
["DOWN_EDDT","timestamp",null,"O",{"$nulls":4},"다운로드종료일시",null,", `DOWN_EDDT` timestamp NOT NULL  COMMENT '다운로드종료일시'",", ",", "]
["BUY_LIMIT_AMT","INT",10,"O",0,null,null,null,"구매제한금액(0은 제한없음. 그 외는 00 이상 구매 시 사용)",null,", `BUY_LIMIT_AMT` INT(10) NOT NULL  DEFAULT '0' COMMENT '구매제한금액(0은 제한없음. 그 외는 00 이상 구매 시 사용)'",", ",", "]
["PLAN_SQ","INT",10,{"$nulls":5},"기획전번호(쿠폰유형이 플러스쿠폰 일 때 사용 기획전번호)",null,", `PLAN_SQ` INT(10) COMMENT '기획전번호(쿠폰유형이 플러스쿠폰 일 때 사용 기획전번호)'",", ",", "]
["REISSUANCE","VARCHAR",20,{"$nulls":5},"쿠폰재발급여부(공통코드G231)",null,", `REISSUANCE` VARCHAR(20) COMMENT '쿠폰재발급여부(공통코드G231)'",", ",", "]
["CPN_STAT","VARCHAR",20,"O",{"$nulls":4},"쿠폰상태(공통코드G232)",null,", `CPN_STAT` VARCHAR(20) NOT NULL  COMMENT '쿠폰상태(공통코드G232)'",", ",", "]
["END_ALIM_YN","CHAR",1,"O","N",null,null,null,"만료알림여부",null,", `END_ALIM_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '만료알림여부'",", ",", "]
["NEW_BUY_YN","CHAR",1,"O","N",null,null,null,"첫구매여부 (Y:구매이력이없음 | N:구매이력있음)(추가칼럼)",null,", `NEW_BUY_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '첫구매여부 (Y:구매이력이없음 | N:구매이력있음)(추가칼럼)'",", ",", "]
["CUST_REG_FROM","timestamp",{"$nulls":6},"회원가입일자_FROM (신규회원여부의 판단을 가입일자로 설정함)(추가칼럼)",null,", `CUST_REG_FROM` timestamp COMMENT '회원가입일자_FROM (신규회원여부의 판단을 가입일자로 설정함)(추가칼럼)'",", ",", "]
["CUST_REG_TO","timestamp",{"$nulls":6},"회원가입일자_TO(추가칼럼)",null,", `CUST_REG_TO` timestamp COMMENT '회원가입일자_TO(추가칼럼)'",", ",", "]
["BUY_FROM","timestamp",{"$nulls":6},"구매기간일자_FROM (해당기간에 구매이력이 없으면 다운로드 가능)(추가칼럼)",null,", `BUY_FROM` timestamp COMMENT '구매기간일자_FROM (해당기간에 구매이력이 없으면 다운로드 가능)(추가칼럼)'",", ",", "]
["BUY_TO","timestamp",{"$nulls":6},"구매기간일자_TO(추가칼럼)",null,", `BUY_TO` timestamp COMMENT '구매기간일자_TO(추가칼럼)'",", ",", "]
["REG_NO","INT",10,"O",null,null,null,"03","등록자번호",null,", `REG_NO` INT(10) NOT NULL  COMMENT '등록자번호'",", ",", KEY IX_TB_COUPON_03 (`REG_NO`)"]
["REG_DT","timestamp",null,"O",{"$nulls":4},"등록일시",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록일시'",", ",", "]
["UPD_NO","INT",10,"O",{"$nulls":4},"수정자번호",null,", `UPD_NO` INT(10) NOT NULL  COMMENT '수정자번호'",", ",", "]
["UPD_DT","timestamp",null,"O",{"$nulls":4},"수정일시",null,", `UPD_DT` timestamp NOT NULL  COMMENT '수정일시'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='쿠폰. 신규 쿠폰 등록에 의한 발생'"}]
[{"$nulls":10},";"]

{"sheet":"TB_COUPON_RANDOM","index":7,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
["TB_COUPON_RANDOM",{"$nulls":7},"쿠폰 난수관리코드 테이블"]
["COLUMN","TYPE","LEN","NOT NULL","DEFAULT","AUTO_INCREMENT","PRIMARY KEY","MUL","COMMENT",null,{"$f":"\"CREATE TABLE \" & $A$3 & \" ( \"","v":"CREATE TABLE TB_COUPON_RANDOM ( "}]
["CPN_RANOM_SQ","INT",10,"O",null,"O","O",null,"난수관리번호                                  ",null,{"$f":"\", `\" &A5&\"` \"&B5& IF(OR(B5=\"TIMESTAMP\", B5=\"FLOAT\"), \"\", \"(\"&C5&\")\") & IF(D5=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E5), \"\", \" DEFAULT '\" & E5 & \"'\" ) & IF(F5=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I5) & \"'\"","v":", `CPN_RANOM_SQ` INT(10) NOT NULL  AUTO_INCREMENT  COMMENT '난수관리번호'"},{"$f":"\", \" & IF(G5=\"O\",\"PRIMARY KEY (`\" & A5 &\"`)\",\"\")","v":", PRIMARY KEY (`CPN_RANOM_SQ`)"}]
["CPN_ID","INT",10,"O",null,null,null,"01","쿠폰ID                                      ",null,{"$f":"\", `\" &A6&\"` \"&B6& IF(OR(B6=\"TIMESTAMP\", B6=\"FLOAT\"), \"\", \"(\"&C6&\")\") & IF(D6=\"O\",\" NOT NULL \",\"\") & IF(ISBLANK(E6), \"\", \" DEFAULT '\" & E6 & \"'\" ) & IF(F6=\"O\",\" AUTO_INCREMENT \", \"\") & \" COMMENT '\" & TRIM(I6) & \"'\"","v":", `CPN_ID` INT(10) NOT NULL  COMMENT '쿠폰ID'"},{"$f":"\", \" & IF(G6=\"O\",\"PRIMARY KEY (`\" & A6 &\"`)\",\"\")","v":", "},{"$f":"\", \"&IF(ISBLANK(H6),\"\",\"KEY IX_\"&$A$3&\"_\"&H6&\" (`\" & A6 & \"`)\")","v":", KEY IX_TB_COUPON_RANDOM_01 (`CPN_ID`)"}]
["CPN_CODE","VARCHAR",100,"O",{"$nulls":4},"쿠폰코드                                     ",null,", `CPN_CODE` VARCHAR(100) NOT NULL  COMMENT '쿠폰코드'",", ",{"$f":"\", \"&IF(ISBLANK(H7),\"\",\"KEY IX_\"&$A$3&\"_\"&H7&\" (`\" & A7 & \"`)\")","v":", "}]
["CPN_CUST_NO","INT",10,{"$nulls":5},"쿠폰코드 사용자 번호                            ",null,", `CPN_CUST_NO` INT(10) COMMENT '쿠폰코드 사용자 번호'",", ",", "]
["CPN_PUB_LIMIT_QTY","SMALLINT",5,"O",1,null,null,null,"쿠폰다운로드수 (네임쿠폰일때는 발행수, 랜덤쿠폰일때는 1개) ",null,", `CPN_PUB_LIMIT_QTY` SMALLINT(5) NOT NULL  DEFAULT '1' COMMENT '쿠폰다운로드수 (네임쿠폰일때는 발행수, 랜덤쿠폰일때는 1개)'",", ",", "]
["DEL_YN","CHAR",1,"O","N",null,null,null,"삭제여부                                     ",null,", `DEL_YN` CHAR(1) NOT NULL  DEFAULT 'N' COMMENT '삭제여부'",", ",", "]
["REG_ID","INT",10,"O",{"$nulls":4},"등록자                                      ",null,", `REG_ID` INT(10) NOT NULL  COMMENT '등록자'",", ",", "]
["REG_DT","timestamp",null,"O",{"$nulls":4},"등록일자                                     ",null,", `REG_DT` timestamp NOT NULL  COMMENT '등록일자'",", ",", "]
["UPD_ID","INT",10,"O",{"$nulls":4},"수정자                                      ",null,", `UPD_ID` INT(10) NOT NULL  COMMENT '수정자'",", ",", "]
["UPD_DT","timestamp",null,"O",{"$nulls":4},"수정일자                                     ",null,", `UPD_DT` timestamp NOT NULL  COMMENT '수정일자'",", ",", "]
[{"$nulls":10},")"]
[{"$nulls":10},{"$f":"\"COMMENT='\"&$I$3&\"'\"","v":"COMMENT='쿠폰 난수관리코드 테이블'"}]
[{"$nulls":10},";"]

{"sheet":"Sheet2","index":8,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["CPN_RANOM_SQ"]
["CPN_ID"]
["CPN_CODE"]
["CPN_CUST_NO"]
["CPN_PUB_LIMIT_QTY"]
["DEL_YN"]
["REG_ID"]
["REG_DT"]
["UPD_ID"]
["UPD_DT"]