| 1 |
- window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v4268","name":"vw_search_goods","subtype":"VIEW","is_user_defined":false,"description":"<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n <html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n <head>\r\n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\" /><title>\r\n </title>\r\n <style type=\"text/css\">\r\n .cs2654AE3A{text-align:left;text-indent:0pt;margin:0pt 0pt 0pt 0pt}\r\n .cs82292024{color:#000000;background-color:transparent;font-family:Segoe UI;font-size:10pt;font-weight:normal;font-style:normal;}\r\n </style>\r\n </head>\r\n <body>\r\n <p class=\"cs2654AE3A\"><span class=\"cs82292024\">VIEW</span></p></body>\r\n </html>","script":"select distinct `g`.`GOODS_CD` AS `GOODS_CD`,if((`g`.`SELF_GOODS_YN` = 'Y'),`o`.`OPT_CD1`,`g`.`MAIN_COLOR_CD`) AS `COLOR_CD`,(select group_concat(distinct concat(`t`.`OPT_CD2`,'|',`t`.`SOLDOUT_YN`,'|',`style24`.`vs`.`CURR_STOCK_QTY`) separator ',') from (`style24`.`tb_option` `t` join `style24`.`vw_stock` `vs` on(((`t`.`GOODS_CD` = `style24`.`vs`.`GOODS_CD`) and (`t`.`OPT_CD` = `style24`.`vs`.`OPT_CD`)))) where ((`t`.`DISP_YN` = 'Y') and (`t`.`GOODS_CD` = `g`.`GOODS_CD`) and (`t`.`OPT_CD1` = `o`.`OPT_CD1`))) AS `SIZE_INFO`,`i`.`SIZE_GB` AS `SIZE_GB`,(case when (`i`.`SIZE_GB` = 'T') then '상의' when (`i`.`SIZE_GB` = 'B') then '하의' when (`i`.`SIZE_GB` = 'S') then '신발' else '' end) AS `SIZE_GB_NM`,(select group_concat(distinct concat(`t`.`OPT_CD1`,'|',`c`.`COLOR_FILE`) separator ',') from (`style24`.`tb_option` `t` join `style24`.`tb_color` `c` on((`t`.`OPT_CD1` = `c`.`COLOR_CD`))) where ((`t`.`GOODS_CD` = `g`.`GOODS_CD`) and (`t`.`DISP_YN` = 'Y'))) AS `COLOR_INFO`,`g`.`GOODS_NM` AS `GOODS_NM`,`g`.`GOODS_TNM` AS `GOODS_TNM`,concat(if((ifnull(`g`.`GOODS_GB`,'') in ('G073_11','G073_15','')),'',ifnull(concat('[',`FN_GET_CODE_NM`('G073',`g`.`GOODS_GB`),']'),'')),if((`g`.`FOREIGN_BUY_YN` = 'Y'),'[해외구매대행]',''),if((`g`.`PARALLEL_IMPORT_YN` = 'Y'),'[병행수입]',''),if((`g`.`ORDER_MADE_YN` = 'Y'),'[주문제작]',''),`g`.`GOODS_NM`) AS `GOODS_FULL_NM`,`g`.`GOODS_SNM` AS `GOODS_SNM`,`g`.`BRAND_CD` AS `BRAND_CD`,(case when (`bg`.`DISP_NM_LANG` = 'EN') then `bg`.`BRAND_GROUP_ENM` else `bg`.`BRAND_GROUP_KNM` end) AS `BRAND_GROUP_NM`,`bg`.`BRAND_GROUP_NO` AS `BRAND_GROUP_NO`,`g`.`ITEMKIND_CD` AS `ITEMKIND_CD`,`g`.`FORMAL_GB` AS `FORMAL_GB`,`g`.`LIST_PRICE` AS `LIST_PRICE`,`g`.`CURR_PRICE` AS `CURR_PRICE`,`bp`.`PC_CURR_PRICE` AS `PC_CURR_PRICE`,`bp`.`MO_CURR_PRICE` AS `MO_CURR_PRICE`,`bp`.`APP_CURR_PRICE` AS `APP_CURR_PRICE`,`g`.`SELF_GOODS_YN` AS `SELF_GOODS_YN`,`g`.`GOODS_STAT` AS `GOODS_STAT`,`g`.`PNT_PRATE` AS `PNT_PRATE`,`g`.`PRE_PPNT_USABLE_YN` AS `PRE_PPNT_USABLE_YN`,`g`.`PNT_MRATE` AS `PNT_MRATE`,`g`.`PRE_MPNT_USABLE_YN` AS `PRE_MPNT_USABLE_YN`,`g`.`MIN_ORD_QTY` AS `MIN_ORD_QTY`,`g`.`MAX_ORD_QTY` AS `MAX_ORD_QTY`,`g`.`DAY_MAX_ORD_QTY` AS `DAY_MAX_ORD_QTY`,`g`.`SEX_GB` AS `SEX_GB`,`FN_GET_CODE_NM`('G007',`g`.`SEX_GB`) AS `SEX_NM`,`e`.`DELV_FEE` AS `DELV_FEE`,`e`.`MIN_ORD_AMT` AS `MIN_ORD_AMT`,`g`.`GOODS_GB` AS `GOODS_GB`,(select max(`style24`.`tb_goods_noti_info`.`NI_CLSF_CD`) from `style24`.`tb_goods_noti_info` where (`style24`.`tb_goods_noti_info`.`GOODS_CD` = `g`.`GOODS_CD`)) AS `NI_CLSF_CD`,`g`.`MAIN_COLOR_CD` AS `MAIN_COLOR_CD`,`g`.`SUPPLY_COMP_CD` AS `SUPPLY_COMP_CD`,`g`.`SELF_MALL_YN` AS `SELF_MALL_YN`,`g`.`AGE_GRP_CD` AS `AGE_GRP_CD`,`FN_GET_CODE_NM`('G023',`g`.`AGE_GRP_CD`) AS `AGE_GRP_NM`,`g`.`SEASON_CD` AS `SEASON_CD`,`FN_GET_CODE_NM`('G006',`g`.`SEASON_CD`) AS `SEASON_NM`,`g`.`GOODS_TYPE` AS `GOODS_TYPE`,(select max(`style24`.`tb_goods_img`.`SYS_IMG_NM`) from `style24`.`tb_goods_img` where ((`style24`.`tb_goods_img`.`GOODS_CD` = `g`.`GOODS_CD`) and (`style24`.`tb_goods_img`.`COLOR_CD` = if(((`g`.`SELF_GOODS_YN` = 'Y') and (`g`.`GOODS_TYPE` = 'G056_N')),`o`.`OPT_CD1`,`g`.`MAIN_COLOR_CD`)) and (`style24`.`tb_goods_img`.`DEFAULT_IMG_YN` = 'Y'))) AS `SYS_IMG_NM`,(select max(`style24`.`tb_goods_img`.`SYS_IMG_NM`) from `style24`.`tb_goods_img` where ((`style24`.`tb_goods_img`.`GOODS_CD` = `g`.`GOODS_CD`) and (`style24`.`tb_goods_img`.`COLOR_CD` = if(((`g`.`SELF_GOODS_YN` = 'Y') and (`g`.`GOODS_TYPE` = 'G056_N')),`o`.`OPT_CD1`,`g`.`MAIN_COLOR_CD`)) and (`style24`.`tb_goods_img`.`MOUSEOVER_IMG_YN` = 'Y'))) AS `SYS_IMG_NM2`,(case when (`g`.`GOODS_TYPE` = 'G056_N') then (select ifnull(max((case when (`style24`.`vw_stock`.`SOLDOUT_YN` = 'Y') then 0 else `style24`.`vw_stock`.`CURR_STOCK_QTY` end)),0) from `style24`.`vw_stock` where ((`style24`.`vw_stock`.`GOODS_CD` = `g`.`GOODS_CD`) and (`style24`.`vw_stock`.`OPT_CD1` = (case when (`g`.`SELF_GOODS_YN` = 'N') then `style24`.`vw_stock`.`OPT_CD1` else ifnull(`g`.`MAIN_COLOR_CD`,'XX') end))) group by `style24`.`vw_stock`.`GOODS_CD`) else (select ifnull(max((case when (`style24`.`vw_stock_compose`.`SOLDOUT_YN` = 'Y') then 0 else `style24`.`vw_stock_compose`.`CURR_STOCK_QTY` end)),0) from `style24`.`vw_stock_compose` where (`style24`.`vw_stock_compose`.`GOODS_CD` = `g`.`GOODS_CD`) group by `style24`.`vw_stock_compose`.`GOODS_CD`) end) AS `STOCK_QTY`,`k`.`AD_KEYWORD` AS `AD_KEYWORD`,(select group_concat(distinct concat(`c4`.`LEAF_CATE_NO`,'|',`c4`.`FULL_CATE_NM`) separator ',') from (`style24`.`tb_cate_4srch` `c4` join `style24`.`tb_cate_goods` `cg` on((`c4`.`LEAF_CATE_NO` = `cg`.`CATE_NO`))) where ((`c4`.`SITE_CD` = 'G000_10') and (`c4`.`CATE_TYPE` = 'G031_10') and (`c4`.`CATE_GB` = 'G032_101') and (`cg`.`GOODS_CD` = `g`.`GOODS_CD`))) AS `CATE_INFO`,`g`.`REG_DT` AS `REG_DT`,`gs`.`SELL_WEEK_QTY` AS `ORDER_CNT`,`gs`.`REVIEW_REG_CNT` AS `REVIEW_CNT`,(case when ((`g`.`SELF_GOODS_YN` = 'Y') and (0 <> ifnull(`qds`.`GOODS_CD`,'Y'))) then 'Y' else 'N' end) AS `QUIK_DELV_YN` from ((((((((((`style24`.`tb_goods` `g` join `style24`.`tb_brand` `b` on(((`g`.`BRAND_CD` = `b`.`BRAND_CD`) and (`b`.`USE_YN` = 'Y')))) join `style24`.`tb_brand_group` `bg` on(((`b`.`BRAND_GROUP_NO` = `bg`.`BRAND_GROUP_NO`) and (`bg`.`USE_YN` = 'Y')))) join `style24`.`tb_delv_fee_policy` `e` on(((`g`.`SUPPLY_COMP_CD` = `e`.`SUPPLY_COMP_CD`) and (`g`.`DELV_FEE_CD` = `e`.`DELV_FEE_CD`)))) join `style24`.`tb_goods_summary` `gs` on((`g`.`GOODS_CD` = `gs`.`GOODS_CD`))) join `style24`.`tb_option` `o` on(((`g`.`GOODS_CD` = `o`.`GOODS_CD`) and (`o`.`DISP_YN` = 'Y')))) left join `style24`.`tb_goods_benefit_price` `bp` on(((`g`.`GOODS_CD` = `bp`.`GOODS_CD`) and (`bp`.`CUST_GB` = 'G100_00')))) left join (select `akg`.`GOODS_CD` AS `GOODS_CD`,group_concat(`ak`.`AD_KEYWORD` separator ',') AS `AD_KEYWORD` from (`style24`.`tb_ad_keyword` `ak` join `style24`.`tb_ad_keyword_goods` `akg` on((`ak`.`AD_KEYWORD_SQ` = `akg`.`AD_KEYWORD_SQ`))) where ((now() between `ak`.`AD_KEYWORD_STDT` and `ak`.`AD_KEYWORD_EDDT`) and (`ak`.`USE_YN` = 'Y')) group by `akg`.`GOODS_CD`) `k` on((`g`.`GOODS_CD` = `k`.`GOODS_CD`))) left join (select max(`v`.`GOODS_CD`) AS `GOODS_CD`,max((case when (`v`.`RNUM` = 1) then `v`.`VIDEO_GB` end)) AS `VIDEO_GB_M`,max((case when (`v`.`RNUM` = 1) then `v`.`VIDEO_VAL` end)) AS `VIDEO_VAL_M`,max((case when (`v`.`RNUM` = 2) then `v`.`VIDEO_GB` end)) AS `VIDEO_GB_S`,max((case when (`v`.`RNUM` = 2) then `v`.`VIDEO_VAL` end)) AS `VIDEO_VAL_S` from (select `a`.`DISPLOC_VAL` AS `GOODS_CD`,`b`.`VIDEO_GB` AS `VIDEO_GB`,`b`.`VIDEO_VAL` AS `VIDEO_VAL`,`a`.`REG_DT` AS `REG_DT`,rank() OVER (PARTITION BY `a`.`DISPLOC_VAL` ORDER BY `a`.`REG_DT` ) AS `RNUM` from (`style24`.`tb_video_disploc` `a` join `style24`.`tb_video` `b` on(((`a`.`VIDEO_SQ` = `b`.`VIDEO_SQ`) and (`b`.`DISP_YN` = 'Y')))) where ((`a`.`DISPLOC_GB` = 'G') and (`a`.`DISP_YN` = 'Y'))) `v`) `v` on((`g`.`GOODS_CD` = `v`.`GOODS_CD`))) left join `style24`.`tb_itemkind` `i` on((`g`.`ITEMKIND_CD` = `i`.`ITEMKIND_CD`))) left join `style24`.`tb_goods_shot_delv_skip` `qds` on((`g`.`GOODS_CD` = `qds`.`GOODS_CD`))) where ((1 = 1) and (`g`.`SELF_MALL_YN` = 'Y') and (`g`.`GOODS_STAT` = 'G008_90'))","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"vw_search_goods"},{"field":"Type","value":"View"}],"columns":[{"id":"column-42860","object_id":"column-42860","name":"GOODS_CD","name_without_path":"GOODS_CD","description":"상품코드","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42854","object_id":"column-42854","name":"COLOR_CD","name_without_path":"COLOR_CD","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42893","object_id":"column-42893","name":"SIZE_INFO","name_without_path":"SIZE_INFO","description":null,"is_pk":false,"is_identity":false,"data_type":"text","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-42891","object_id":"column-42891","name":"SIZE_GB","name_without_path":"SIZE_GB","description":"사이즈구분(T:상의, B:하의, S:신발)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"1","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42892","object_id":"column-42892","name":"SIZE_GB_NM","name_without_path":"SIZE_GB_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"2","is_nullable":false,"computed_formula":"","default_value":"","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42855","object_id":"column-42855","name":"COLOR_INFO","name_without_path":"COLOR_INFO","description":null,"is_pk":false,"is_identity":false,"data_type":"text","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-42863","object_id":"column-42863","name":"GOODS_NM","name_without_path":"GOODS_NM","description":"상품명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42866","object_id":"column-42866","name":"GOODS_TNM","name_without_path":"GOODS_TNM","description":"상품타이틀명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"100","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42861","object_id":"column-42861","name":"GOODS_FULL_NM","name_without_path":"GOODS_FULL_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"372","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-42864","object_id":"column-42864","name":"GOODS_SNM","name_without_path":"GOODS_SNM","description":"상품검색명","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"4000","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-42850","object_id":"column-42850","name":"BRAND_CD","name_without_path":"BRAND_CD","description":"브랜드코드","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"5","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-42851","object_id":"column-42851","name":"BRAND_GROUP_NM","name_without_path":"BRAND_GROUP_NM","description":null,"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-42852","object_id":"column-42852","name":"BRAND_GROUP_NO","name_without_path":"BRAND_GROUP_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-42868","object_id":"column-42868","name":"ITEMKIND_CD","name_without_path":"ITEMKIND_CD","description":"품목코드","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"10","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-42859","object_id":"column-42859","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":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42869","object_id":"column-42869","name":"LIST_PRICE","name_without_path":"LIST_PRICE","description":"정상가(최초판매가)","is_pk":false,"is_identity":false,"data_type":"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-42856","object_id":"column-42856","name":"CURR_PRICE","name_without_path":"CURR_PRICE","description":"현재판매가","is_pk":false,"is_identity":false,"data_type":"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-42877","object_id":"column-42877","name":"PC_CURR_PRICE","name_without_path":"PC_CURR_PRICE","description":"PC즉시할인판매가","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42874","object_id":"column-42874","name":"MO_CURR_PRICE","name_without_path":"MO_CURR_PRICE","description":"MOBILE즉시할인판매가","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42849","object_id":"column-42849","name":"APP_CURR_PRICE","name_without_path":"APP_CURR_PRICE","description":"APP즉시할인판매가","is_pk":false,"is_identity":false,"data_type":"int","data_length":"10, 0","is_nullable":true,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42887","object_id":"column-42887","name":"SELF_GOODS_YN","name_without_path":"SELF_GOODS_YN","description":"자사상품여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":true,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42865","object_id":"column-42865","name":"GOODS_STAT","name_without_path":"GOODS_STAT","description":"상품상태(공통코드G008)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":true,"computed_formula":"","default_value":"G008_00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42879","object_id":"column-42879","name":"PNT_PRATE","name_without_path":"PNT_PRATE","description":"포인트적립율(PC)","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":true,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42881","object_id":"column-42881","name":"PRE_PPNT_USABLE_YN","name_without_path":"PRE_PPNT_USABLE_YN","description":"선포인트사용가능여부(PC)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":true,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42878","object_id":"column-42878","name":"PNT_MRATE","name_without_path":"PNT_MRATE","description":"포인트적립율(모바일)","is_pk":false,"is_identity":false,"data_type":"unsigned float","data_length":"5, 2","is_nullable":true,"computed_formula":"","default_value":"0.00","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42880","object_id":"column-42880","name":"PRE_MPNT_USABLE_YN","name_without_path":"PRE_MPNT_USABLE_YN","description":"선포인트사용가능여부(모바일)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":true,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42873","object_id":"column-42873","name":"MIN_ORD_QTY","name_without_path":"MIN_ORD_QTY","description":"최소주문수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":true,"computed_formula":"","default_value":"1","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42871","object_id":"column-42871","name":"MAX_ORD_QTY","name_without_path":"MAX_ORD_QTY","description":"최대주문수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":true,"computed_formula":"","default_value":"20","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42857","object_id":"column-42857","name":"DAY_MAX_ORD_QTY","name_without_path":"DAY_MAX_ORD_QTY","description":"ID당1일최대구매수량","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":true,"computed_formula":"","default_value":"20","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42889","object_id":"column-42889","name":"SEX_GB","name_without_path":"SEX_GB","description":"성별구분(공통코드G007)","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-42890","object_id":"column-42890","name":"SEX_NM","name_without_path":"SEX_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"150","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-42858","object_id":"column-42858","name":"DELV_FEE","name_without_path":"DELV_FEE","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-42872","object_id":"column-42872","name":"MIN_ORD_AMT","name_without_path":"MIN_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-42862","object_id":"column-42862","name":"GOODS_GB","name_without_path":"GOODS_GB","description":"상품구뷴(공통코드 G073)","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-42875","object_id":"column-42875","name":"NI_CLSF_CD","name_without_path":"NI_CLSF_CD","description":null,"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-42870","object_id":"column-42870","name":"MAIN_COLOR_CD","name_without_path":"MAIN_COLOR_CD","description":"대표색상코드","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"2","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-42895","object_id":"column-42895","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":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42888","object_id":"column-42888","name":"SELF_MALL_YN","name_without_path":"SELF_MALL_YN","description":"자사몰노출여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":true,"computed_formula":"","default_value":"Y","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42847","object_id":"column-42847","name":"AGE_GRP_CD","name_without_path":"AGE_GRP_CD","description":"상품연령대(공통코드 G023)","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-42848","object_id":"column-42848","name":"AGE_GRP_NM","name_without_path":"AGE_GRP_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"150","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-42885","object_id":"column-42885","name":"SEASON_CD","name_without_path":"SEASON_CD","description":"시즌코드(공통코드G006)","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-42886","object_id":"column-42886","name":"SEASON_NM","name_without_path":"SEASON_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"150","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-42867","object_id":"column-42867","name":"GOODS_TYPE","name_without_path":"GOODS_TYPE","description":"상품타입(공통코드G056)","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-42896","object_id":"column-42896","name":"SYS_IMG_NM","name_without_path":"SYS_IMG_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42897","object_id":"column-42897","name":"SYS_IMG_NM2","name_without_path":"SYS_IMG_NM2","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","is_nullable":true,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42894","object_id":"column-42894","name":"STOCK_QTY","name_without_path":"STOCK_QTY","description":null,"is_pk":false,"is_identity":false,"data_type":"decimal","data_length":"54, 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-42846","object_id":"column-42846","name":"AD_KEYWORD","name_without_path":"AD_KEYWORD","description":null,"is_pk":false,"is_identity":false,"data_type":"text","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-42853","object_id":"column-42853","name":"CATE_INFO","name_without_path":"CATE_INFO","description":null,"is_pk":false,"is_identity":false,"data_type":"text","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-42883","object_id":"column-42883","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":true,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-42876","object_id":"column-42876","name":"ORDER_CNT","name_without_path":"ORDER_CNT","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-42884","object_id":"column-42884","name":"REVIEW_CNT","name_without_path":"REVIEW_CNT","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-42882","object_id":"column-42882","name":"QUIK_DELV_YN","name_without_path":"QUIK_DELV_YN","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"triggers":[],"unique_keys":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
