| 1 |
- window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t4042","name":"tb_inflow_daily","subtype":"TABLE","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\">사이트유입일별집계. 프론트 사이트 유입 일별 집계에 의한 발생</span></p></body>\r\n </html>","summary":[{"field":"Documentation","value":{"_type":"link","name":"style24@172.30.90.100","id":"d10"}},{"field":"Schema","value":""},{"field":"Name","value":"tb_inflow_daily"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-39206","object_id":"column-39206","name":"INFLOW_YMD","name_without_path":"INFLOW_YMD","description":"유입일시","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"8","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-39215","object_id":"column-39215","name":"SITE_CD","name_without_path":"SITE_CD","description":"사이트코드(공통코드G000)","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39203","object_id":"column-39203","name":"AF_LINK_CD","name_without_path":"AF_LINK_CD","description":"제휴링크코드","is_pk":true,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39212","object_id":"column-39212","name":"PC_INFLOW_TCNT","name_without_path":"PC_INFLOW_TCNT","description":"PC총유입수(TB_INFLOW_HST.JSESSION_ID 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39210","object_id":"column-39210","name":"MOB_INFLOW_TCNT","name_without_path":"MOB_INFLOW_TCNT","description":"모바일총유입수(TB_INFLOW_HST.JSESSION_ID 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39205","object_id":"column-39205","name":"AOS_INFLOW_TCNT","name_without_path":"AOS_INFLOW_TCNT","description":"AOS총유입수(TB_INFLOW_HST.JSESSION_ID 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39208","object_id":"column-39208","name":"IOS_INFLOW_TCNT","name_without_path":"IOS_INFLOW_TCNT","description":"IOS총유입수(TB_INFLOW_HST.JSESSION_ID 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39211","object_id":"column-39211","name":"PC_INFLOW_CNT","name_without_path":"PC_INFLOW_CNT","description":"PC순유입수(TB_INFLOW_HST.IP_ADDR 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39209","object_id":"column-39209","name":"MOB_INFLOW_CNT","name_without_path":"MOB_INFLOW_CNT","description":"모바일순유입수(TB_INFLOW_HST.IP_ADDR 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39204","object_id":"column-39204","name":"AOS_INFLOW_CNT","name_without_path":"AOS_INFLOW_CNT","description":"AOS순유입수(TB_INFLOW_HST.IP_ADDR 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39207","object_id":"column-39207","name":"IOS_INFLOW_CNT","name_without_path":"IOS_INFLOW_CNT","description":"OS순유입수(TB_INFLOW_HST.IP_ADDR 중복 제거 후 집계)","is_pk":false,"is_identity":false,"data_type":"unsigned smallint","data_length":"5, 0","is_nullable":false,"computed_formula":"","default_value":"0","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39214","object_id":"column-39214","name":"REG_NO","name_without_path":"REG_NO","description":"등록자번호","is_pk":false,"is_identity":false,"data_type":"unsigned int","data_length":"10, 0","is_nullable":false,"computed_formula":"","default_value":null,"path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-39213","object_id":"column-39213","name":"REG_DT","name_without_path":"REG_DT","description":"등록일시","is_pk":false,"is_identity":false,"data_type":"timestamp","data_length":null,"is_nullable":false,"computed_formula":"","default_value":"CURRENT_TIMESTAMP","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"유입일시","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"INFLOW_YMD","name":"INFLOW_YMD"},{"path":null,"name_without_path":"SITE_CD","name":"SITE_CD"},{"path":null,"name_without_path":"AF_LINK_CD","name":"AF_LINK_CD"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
|
