Home Esplora Aiuto
Accedi
style24
/
style24.doc
2
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Albero (Tree): f083507d3a
Rami (Branch) Tag
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
v4267.json.js

v4267.json.js 9.2 KB
Cronologia Originale

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"triggers_custom_fields":[],"object_id":"v4267","name":"vw_main_category","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 if((`b`.`CATE4_NO` is null),if((`b`.`CATE3_NO` is null),if((`b`.`CATE2_NO` is null),`b`.`CATE1_NO`,`b`.`CATE2_NO`),`b`.`CATE3_NO`),`b`.`CATE4_NO`) AS `LEAF_CATE_NO`,`b`.`CATE1_NO` AS `CATE1_NO`,`b`.`CATE1_NM` AS `CATE1_NM`,`b`.`CATE2_NO` AS `CATE2_NO`,`b`.`CATE2_NM` AS `CATE2_NM`,`b`.`CATE3_NO` AS `CATE3_NO`,`b`.`CATE3_NM` AS `CATE3_NM`,`b`.`CATE4_NO` AS `CATE4_NO`,`b`.`CATE4_NM` AS `CATE4_NM`,if((`b`.`CATE4_NO` is null),if((`b`.`CATE3_NO` is null),if((`b`.`CATE2_NO` is null),cast(`b`.`CATE1_NO` as char charset utf8mb4),cast(concat(`b`.`CATE1_NO`,'>',`b`.`CATE2_NO`) as char charset utf8mb4)),cast(concat(`b`.`CATE1_NO`,'>',`b`.`CATE2_NO`,'>',`b`.`CATE3_NO`) as char charset utf8mb4)),cast(concat(`b`.`CATE1_NO`,'>',`b`.`CATE2_NO`,'>',`b`.`CATE3_NO`,'>',`b`.`CATE4_NO`) as char charset utf8mb4)) AS `FULL_CATE_NO`,if((`b`.`CATE4_NM` is null),if((`b`.`CATE3_NM` is null),if((`b`.`CATE2_NM` is null),cast(`b`.`CATE1_NM` as char charset utf8mb4),cast(concat(`b`.`CATE1_NM`,'>',`b`.`CATE2_NM`) as char charset utf8mb4)),cast(concat(`b`.`CATE1_NM`,'>',`b`.`CATE2_NM`,'>',`b`.`CATE3_NM`) as char charset utf8mb4)),cast(concat(`b`.`CATE1_NM`,'>',`b`.`CATE2_NM`,'>',`b`.`CATE3_NM`,'>',`b`.`CATE4_NM`) as char charset utf8mb4)) AS `FULL_CATE_NM`,`b`.`DISP_ORD` AS `DISP_ORD`,`b`.`CLOC_PREFIX` AS `CLOC_PREFIX` from (select 0 AS `CATE1_NO`,'-----STYLE24-----' AS `CATE1_NM`,NULL AS `CATE2_NO`,NULL AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,1 AS `DISP_ORD`,NULL AS `CLOC_PREFIX` union all select 1700 AS `CATE1_NO`,'몰메인' AS `CATE1_NM`,NULL AS `CATE2_NO`,NULL AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,1 AS `DISP_ORD`,'SMM' AS `CLOC_PREFIX` union all select 1711 AS `CATE1_NO`,'브랜드메인' AS `CATE1_NM`,NULL AS `CATE2_NO`,NULL AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,2 AS `DISP_ORD`,'SBM' AS `CLOC_PREFIX` union all select `a`.`CATE1_NO` AS `CATE1_NO`,`a`.`CATE1_NM` AS `CATE1_NM`,`a`.`CATE2_NO` AS `CATE2_NO`,`a`.`CATE2_NM` AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,3 AS `DISP_ORD`,'SCM' AS `CLOC_PREFIX` from (select 1712 AS `CATE1_NO`,'카테고리메인' AS `CATE1_NM`,`a`.`CATE1_NO` AS `CATE2_NO`,`a`.`CATE1_NM` AS `CATE2_NM`,rank() OVER (ORDER BY `a`.`CATE1_NO` )  AS `DISP_ORD` from `style24`.`tb_cate_4srch` `a` where ((`a`.`SITE_CD` = 'G000_10') and (`a`.`CATE_GB` = 'G032_101') and (`a`.`CATE_TYPE` = 'G031_10')) group by `a`.`CATE1_NO`,`a`.`CATE1_NM`) `a` union all select 1713 AS `CATE1_NO`,'아울렛메인' AS `CATE1_NM`,NULL AS `CATE2_NO`,NULL AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,4 AS `DISP_ORD`,'SOM' AS `CLOC_PREFIX` union all select 1715 AS `CATE1_NO`,'광고상품메인' AS `CATE1_NM`,NULL AS `CATE2_NO`,NULL AS `CATE2_NM`,NULL AS `CATE3_NO`,NULL AS `CATE3_NM`,NULL AS `CATE4_NO`,NULL AS `CATE4_NM`,6 AS `DISP_ORD`,'SAD' AS `CLOC_PREFIX`) `b`","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"vw_main_category"},{"field":"Type","value":"View"}],"columns":[{"id":"column-42845","object_id":"column-42845","name":"LEAF_CATE_NO","name_without_path":"LEAF_CATE_NO","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-42834","object_id":"column-42834","name":"CATE1_NO","name_without_path":"CATE1_NO","description":null,"is_pk":false,"is_identity":false,"data_type":"bigint","data_length":"19, 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-42833","object_id":"column-42833","name":"CATE1_NM","name_without_path":"CATE1_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"17","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-42836","object_id":"column-42836","name":"CATE2_NO","name_without_path":"CATE2_NO","description":null,"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-42835","object_id":"column-42835","name":"CATE2_NM","name_without_path":"CATE2_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-42838","object_id":"column-42838","name":"CATE3_NO","name_without_path":"CATE3_NO","description":null,"is_pk":false,"is_identity":false,"data_type":"binary","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-42837","object_id":"column-42837","name":"CATE3_NM","name_without_path":"CATE3_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"binary","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-42840","object_id":"column-42840","name":"CATE4_NO","name_without_path":"CATE4_NO","description":null,"is_pk":false,"is_identity":false,"data_type":"binary","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-42839","object_id":"column-42839","name":"CATE4_NM","name_without_path":"CATE4_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"binary","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-42844","object_id":"column-42844","name":"FULL_CATE_NO","name_without_path":"FULL_CATE_NO","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"33","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-42843","object_id":"column-42843","name":"FULL_CATE_NM","name_without_path":"FULL_CATE_NM","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"70","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-42842","object_id":"column-42842","name":"DISP_ORD","name_without_path":"DISP_ORD","description":null,"is_pk":false,"is_identity":false,"data_type":"bigint","data_length":"19, 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-42841","object_id":"column-42841","name":"CLOC_PREFIX","name_without_path":"CLOC_PREFIX","description":null,"is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"3","is_nullable":true,"computed_formula":"","default_value":null,"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"};
    2.