Etusivu Tutki Apua
Kirjaudu sisään
style24
/
style24.doc
2
0
Fork 0
Tiedostot Ongelmat 0 Pull-pyynnöt 0 Wiki
Puu: f083507d3a
Branchit Tagit
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3916.json.js

t3916.json.js 17 KB
Historia Raaka

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3916","name":"tb_counsel","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_counsel"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-37104","object_id":"column-37104","name":"COUNSEL_SQ","name_without_path":"COUNSEL_SQ","description":"상담일련번호","is_pk":true,"is_identity":true,"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-37121","object_id":"column-37121","name":"SITE_CD","name_without_path":"SITE_CD","description":"사이트코드(공통코드G000)","is_pk":false,"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-37102","object_id":"column-37102","name":"COUNSEL_CLSF","name_without_path":"COUNSEL_CLSF","description":"상담분류코드(공통코드G059)","is_pk":false,"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-37103","object_id":"column-37103","name":"COUNSEL_DCLSF","name_without_path":"COUNSEL_DCLSF","description":"상담분류상세코드(공통코드G591~G599)","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-37106","object_id":"column-37106","name":"CUST_NO","name_without_path":"CUST_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-37101","object_id":"column-37101","name":"CELL_PHNNO","name_without_path":"CELL_PHNNO","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-37108","object_id":"column-37108","name":"EMAIL","name_without_path":"EMAIL","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-37109","object_id":"column-37109","name":"EMAIL_REQ_YN","name_without_path":"EMAIL_REQ_YN","description":"이메일요청여부(Y:요청)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37110","object_id":"column-37110","name":"EMAIL_SEND_YN","name_without_path":"EMAIL_SEND_YN","description":"이메일발송여부(Y:발송)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37122","object_id":"column-37122","name":"SMS_REQ_YN","name_without_path":"SMS_REQ_YN","description":"SMS요청여부(Y:요청)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37123","object_id":"column-37123","name":"SMS_SEND_YN","name_without_path":"SMS_SEND_YN","description":"SMS발송여부(Y:발송)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37119","object_id":"column-37119","name":"REL_ORD_NO","name_without_path":"REL_ORD_NO","description":"관련주문번호","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-37118","object_id":"column-37118","name":"REL_GOODS_CD","name_without_path":"REL_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-37105","object_id":"column-37105","name":"COUNSEL_TYPE","name_without_path":"COUNSEL_TYPE","description":"문의타입(C:1:1문의 / G:상품문의)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","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-37115","object_id":"column-37115","name":"QUEST_TITLE","name_without_path":"QUEST_TITLE","description":"문의제목","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-37113","object_id":"column-37113","name":"QUEST_CONTENT","name_without_path":"QUEST_CONTENT","description":"문의내용","is_pk":false,"is_identity":false,"data_type":"longtext","data_length":null,"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-37114","object_id":"column-37114","name":"QUEST_DT","name_without_path":"QUEST_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":[]},{"id":"column-37111","object_id":"column-37111","name":"ORG_FILE_NM1","name_without_path":"ORG_FILE_NM1","description":"원본파일명1","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-37124","object_id":"column-37124","name":"SYS_FILE_NM1","name_without_path":"SYS_FILE_NM1","description":"시스템파일명1","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-37112","object_id":"column-37112","name":"ORG_FILE_NM2","name_without_path":"ORG_FILE_NM2","description":"원본파일명2","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-37125","object_id":"column-37125","name":"SYS_FILE_NM2","name_without_path":"SYS_FILE_NM2","description":"시스템파일명2","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"500","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-37092","object_id":"column-37092","name":"ANS_STAT","name_without_path":"ANS_STAT","description":"답변상태(공통코드G060)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"G060_10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37096","object_id":"column-37096","name":"ANS_TRANS_YN","name_without_path":"ANS_TRANS_YN","description":"답변의뢰여부(Y:입점업체에 답변 의뢰)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37088","object_id":"column-37088","name":"ANS_COMP_CD","name_without_path":"ANS_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-37095","object_id":"column-37095","name":"ANS_TRANS_NO","name_without_path":"ANS_TRANS_NO","description":"답변의뢰자번호(사용자)","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-37094","object_id":"column-37094","name":"ANS_TRANS_DT","name_without_path":"ANS_TRANS_DT","description":"답변의뢰일시","is_pk":false,"is_identity":false,"data_type":"timestamp","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-37097","object_id":"column-37097","name":"ASSIGNED_CS_NO","name_without_path":"ASSIGNED_CS_NO","description":"할당된CS담당자번호(사용자)","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-37099","object_id":"column-37099","name":"ASSIGNED_YMD","name_without_path":"ASSIGNED_YMD","description":"할당된연월일(YYYYMMDD)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"8","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-37098","object_id":"column-37098","name":"ASSIGNED_HMS","name_without_path":"ASSIGNED_HMS","description":"할당된시분초(HH24MISS)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"6","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-37100","object_id":"column-37100","name":"ASSIGNER_NO","name_without_path":"ASSIGNER_NO","description":"할당자번호(사용자)","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-37093","object_id":"column-37093","name":"ANS_TITLE","name_without_path":"ANS_TITLE","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-37089","object_id":"column-37089","name":"ANS_CONTENT","name_without_path":"ANS_CONTENT","description":"답변내용","is_pk":false,"is_identity":false,"data_type":"longtext","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-37091","object_id":"column-37091","name":"ANS_NO","name_without_path":"ANS_NO","description":"답변자번호(사용자)","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-37090","object_id":"column-37090","name":"ANS_DT","name_without_path":"ANS_DT","description":"답변일시","is_pk":false,"is_identity":false,"data_type":"timestamp","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-37120","object_id":"column-37120","name":"SECRET_YN","name_without_path":"SECRET_YN","description":"비밀글여부(Y:비밀글 / 상품문의에서만 사용, 1:1문의 미사용 컬럼)","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37107","object_id":"column-37107","name":"DEL_YN","name_without_path":"DEL_YN","description":"삭제여부","is_pk":false,"is_identity":false,"data_type":"char","data_length":"1","is_nullable":false,"computed_formula":"","default_value":"N","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37117","object_id":"column-37117","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-37116","object_id":"column-37116","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":[]},{"id":"column-37127","object_id":"column-37127","name":"UPD_NO","name_without_path":"UPD_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-37126","object_id":"column-37126","name":"UPD_DT","name_without_path":"UPD_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":"COUNSEL_SQ","name":"COUNSEL_SQ"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.