Trang chủ Khám phá Trợ giúp
Đăng nhập
style24
/
style24.doc
2
0
Fork 0
Các tập tin Các vấn đề 0 Yêu cầu khéo về 0 Wiki
Tree: f083507d3a
Branches Tags
style24.doc
/
스타일24산출물(요청)_2021216
/
01.개발산출물
/
03.테이블정의서
/
data
/
t3939.json.js

t3939.json.js 20 KB
Lịch sử Raw

1 
  1. window.repositoryObject = {"columns_custom_fields":[],"relations_custom_fields":[],"unique_keys_custom_fields":[],"triggers_custom_fields":[],"object_id":"t3939","name":"tb_customer","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_customer"},{"field":"Type","value":"Table"}],"columns":[{"id":"column-37377","object_id":"column-37377","name":"CUST_NO","name_without_path":"CUST_NO","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-37375","object_id":"column-37375","name":"CUST_ID","name_without_path":"CUST_ID","description":"고객ID(탈퇴 시 \"secede_cust\"로 처리)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"30","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-37376","object_id":"column-37376","name":"CUST_NM","name_without_path":"CUST_NM","description":"고객명_암호화","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","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-37396","object_id":"column-37396","name":"PASSWD","name_without_path":"PASSWD","description":"비밀번호_암호화","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"200","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-37370","object_id":"column-37370","name":"BIRTH_YMD","name_without_path":"BIRTH_YMD","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-37404","object_id":"column-37404","name":"SEX_GB","name_without_path":"SEX_GB","description":"성별구분(공통코드G007). 탈퇴 시 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-37371","object_id":"column-37371","name":"CELL_PHNNO","name_without_path":"CELL_PHNNO","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-37367","object_id":"column-37367","name":"APP_AGREE_YN","name_without_path":"APP_AGREE_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-37366","object_id":"column-37366","name":"APP_AGREE_DT","name_without_path":"APP_AGREE_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-37407","object_id":"column-37407","name":"SMS_AGREE_YN","name_without_path":"SMS_AGREE_YN","description":"SMS수신동의여부","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-37406","object_id":"column-37406","name":"SMS_AGREE_DT","name_without_path":"SMS_AGREE_DT","description":"SMS수신동의일시","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-37379","object_id":"column-37379","name":"EMAIL","name_without_path":"EMAIL","description":"이메일(탈퇴 시 NULL로 처리)","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-37381","object_id":"column-37381","name":"EMAIL_AGREE_YN","name_without_path":"EMAIL_AGREE_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-37380","object_id":"column-37380","name":"EMAIL_AGREE_DT","name_without_path":"EMAIL_AGREE_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-37395","object_id":"column-37395","name":"MK_AGREE_YN","name_without_path":"MK_AGREE_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-37394","object_id":"column-37394","name":"MK_AGREE_DT","name_without_path":"MK_AGREE_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-37387","object_id":"column-37387","name":"HOME_ZIPCODE","name_without_path":"HOME_ZIPCODE","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-37385","object_id":"column-37385","name":"HOME_BASE_ADDR","name_without_path":"HOME_BASE_ADDR","description":"자택기본주소(탈퇴 시 NULL로 처리)","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-37386","object_id":"column-37386","name":"HOME_DTL_ADDR","name_without_path":"HOME_DTL_ADDR","description":"자택상세주소(탈퇴 시 NULL로 처리)","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-37405","object_id":"column-37405","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-37384","object_id":"column-37384","name":"FRONT_GB","name_without_path":"FRONT_GB","description":"프론트구분(P:PC, M:모바일, A:앱)","is_pk":false,"is_identity":false,"data_type":"varchar","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-37365","object_id":"column-37365","name":"AF_LINK_CD","name_without_path":"AF_LINK_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-37373","object_id":"column-37373","name":"CUST_GB","name_without_path":"CUST_GB","description":"회원구분(공통코드G100)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37374","object_id":"column-37374","name":"CUST_GRADE","name_without_path":"CUST_GRADE","description":"회원등급(공통코드G110)","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-37388","object_id":"column-37388","name":"JOIN_DT","name_without_path":"JOIN_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-37383","object_id":"column-37383","name":"FOREIGNER_YN","name_without_path":"FOREIGNER_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-37378","object_id":"column-37378","name":"CUST_STAT","name_without_path":"CUST_STAT","description":"고객상태(공통코드G104)","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"20","is_nullable":false,"computed_formula":"","default_value":"10","path":null,"level":1,"item_type":"COLUMN","is_user_defined":false,"custom_fields":{},"linked_terms":[],"references":[]},{"id":"column-37397","object_id":"column-37397","name":"PASSWD_CHG_DT","name_without_path":"PASSWD_CHG_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-37409","object_id":"column-37409","name":"TEMP_PASSWD_YN","name_without_path":"TEMP_PASSWD_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-37389","object_id":"column-37389","name":"LOGIN_LDT","name_without_path":"LOGIN_LDT","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-37372","object_id":"column-37372","name":"CI","name_without_path":"CI","description":"인증CI","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-37368","object_id":"column-37368","name":"AUTH_DT","name_without_path":"AUTH_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-37408","object_id":"column-37408","name":"SNS_TYPE","name_without_path":"SNS_TYPE","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-37392","object_id":"column-37392","name":"MANAGED_RSN","name_without_path":"MANAGED_RSN","description":"관리대상지정사유(공통코드G103)","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-37391","object_id":"column-37391","name":"MANAGED_DTL_RSN","name_without_path":"MANAGED_DTL_RSN","description":"관리대상지정상세사유","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-37390","object_id":"column-37390","name":"MANAGED_DT","name_without_path":"MANAGED_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-37403","object_id":"column-37403","name":"SECEDE_RSN","name_without_path":"SECEDE_RSN","description":"탈퇴사유(공통코드G102)","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-37402","object_id":"column-37402","name":"SECEDE_DTL_RSN","name_without_path":"SECEDE_DTL_RSN","description":"탈퇴상세사유","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-37401","object_id":"column-37401","name":"SECEDE_DT","name_without_path":"SECEDE_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-37400","object_id":"column-37400","name":"RM_DORMANT_DT","name_without_path":"RM_DORMANT_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-37369","object_id":"column-37369","name":"BIRTH_MM","name_without_path":"BIRTH_MM","description":"생월","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"40","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-37399","object_id":"column-37399","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-37398","object_id":"column-37398","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-37411","object_id":"column-37411","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-37410","object_id":"column-37410","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":[]},{"id":"column-37393","object_id":"column-37393","name":"MEMBER_GUID","name_without_path":"MEMBER_GUID","description":"AS-IS 회원고유번호","is_pk":false,"is_identity":false,"data_type":"varchar","data_length":"36","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-37382","object_id":"column-37382","name":"ENC_UPD_YN","name_without_path":"ENC_UPD_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":[]}],"relations":[],"unique_keys":[{"name":"PRIMARY","description":"고객번호","is_pk":true,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CUST_NO","name":"CUST_NO"}],"custom_fields":{}},{"name":"IX_CUSTOMER_01","description":"고객ID(탈퇴 시 \"secede_cust\"로 처리)","is_pk":false,"is_user_defined":false,"columns":[{"path":null,"name_without_path":"CUST_ID","name":"CUST_ID"}],"custom_fields":{}}],"triggers":[],"dependencies":null,"imported_at":"2021-11-11 16:37"};
    2.