-------------------------------------------------------- -- 샘플 데이터 -- EX : 테스트 등을 위한 샘플 데이터 이며 SEQ를 맞추는 작업 및 실데이터 정리 작업 등 필요 -------------------------------------------------------- REM INSERTING into MP_API_CATEGORY SET DEFINE OFF; Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (1,'가셔야 할 곳',null,null,'roadlist',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (2,'검사결과','검사결과 ',null,'totalexam',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (4,'도우미 화면','도우미에서 사용할 용도 만드는 API 집합',null,'helper',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (5,'도우미용 Push','도우미 push 관련 ',null,'helperpush',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (7,'동의서','동의서 카테고리',null,'agreement',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (9,'사용자관리','사용자 관리를 위한 API집합',null,'user',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (11,'앱관리','등록된 최신 앱 버전 확인',null,'app',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (13,'전화번호',null,null,'telno',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (21,'로그인',null,9,'login',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (22,'비밀번호',null,9,'password',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (23,'사용자정보',null,9,'userinfo',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (24,'토큰',null,9,'tokens',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); Insert into MP_API_CATEGORY (CAT_SEQ,CAT_NAME,CAT_DESC,PARENT_CAT_SEQ,PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (29,'_실험용모음','언제 없어질지 모르는 실험용 API들의 모임 ',null,'test',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/06/21','RR/MM/DD'),'DBS(Console)'); REM INSERTING into MP_API SET DEFINE OFF; Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (9,'SQL','mplusExtDataSource',null,'PUT','30_결제알림',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'', ''paymentSuccess'', :userId, :userName, :messageValue, :stageOrder, :senderId)','INT','payment',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (34,'SQL','mplusDataSource',null,'POST','토큰추가',null,'INSERT INTO MNS_RECEIVER_DEVICE (RECEIVER_ID, DEVICE_TOKEN_ID, PLATFORM_TYPE, CERT_TYPE) VALUES (:receiverId, :deviceTokenId, :platformType, :certType)','INT','saveDeviceToken',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (2,'WEB_SERVICE',null,'examResult : 검사결과 examNm : 검사명 examGrpNm : 검사분류 referenceVal : 참고치 date : 검사날짜 ','POST','검사결과목록',null,null,'LIST','getExamList','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00017&business_id=com&hospitalCd=031&userId={userId}&startDt={startDt}&endDt={endDt} ',2,'/totalexam/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (4,'SQL','mplusDataSource',null,'GET','Action 가져오기',null,'SELECT USER_MSG FROM MP_HELPER_CONTENTS WHERE HELPER_SEQ=:accessSeq AND TO_CHAR(SEND_DT, ''ss'')=:accessKey','MAP','getAction',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (19,'SQL','mplusDataSource',null,'PUT','로그인실패횟수증가',null,'UPDATE MP_USER SET LOGIN_FAIL_CNT = (SELECT LOGIN_FAIL_CNT + 1 FROM MP_USER WHERE USER_ID=:userId) WHERE USER_ID =:userId','INT','incLoginFailCnt',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (23,'SQL','mplusDataSource',null,'GET','비밀번호 확인',null,'SELECT CASE WHEN COUNT(*) = 0 THEN ''false'' ELSE ''true'' END AS validPassword FROM MP_USER WHERE USER_ID=:userId AND PASSWORD_VALUE=:passwordValue','MAP','checkPWD',null,22,'/user/password/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (36,'SQL','mplusDataSource',null,'GET','앱이름과 버전확인',null,'SELECT PLATFORM_TYPE, CERT_TYPE, VERSION_ORDER, VERSION_ORDER AS VERSION_VALUE, APP_NAME, MARKET_URL FROM MP_VERSION WHERE PLATFORM_TYPE=:platformType AND APP_NAME=:appName AND CERT_TYPE=:certType','MAP','checkAppNameVersion',null,11,'/app/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (51,'SQL','mplusExtDataSource',null,'PUT','PUSH_텍스트전송',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, FORM_ID, HOSPITAL_VALUE, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, :guide, ''031'', :userId, :userName, :messageValue, :stageOrder, :pgubn)','INT','sendPushText',null,29,'/test/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (1,'WEB_SERVICE',null,null,'POST','가셔야할곳',null,null,'LIST','getVisitInfo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00015&business_id=com&hospitalCd=031&userId={userId}',1,'/roadlist/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (8,'WEB_SERVICE',null,null,'POST','10_웰컴처리',null,null,'MAP','arrival','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00035&business_id=com&hospitalCd=031&userId={userId}',5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (13,'SQL','mplusDataSource',null,'GET','14세 미만 최신동의서 조회',null,'SELECT AGREEMENT_SEQ, AGREEMENT_ID, VERSION_NUMBER, AGREEMENT_ORDER, AGREEMENT_NAME, AGREEMENT_CL, ENABLED_YN, REQUIRED_YN, NEW_YN, TYPE_NAME FROM MP_AGREEMENT WHERE NEW_YN = ''Y'' AND ENABLED_YN = ''Y'' AND TYPE_NAME = ''UNDER14'' AND AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ FROM MP_USER_AGREEMENT WHERE USER_ID=:userId)','LIST','getUnder14NewAgreementList',null,7,'/agreement/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (24,'SQL','mplusDataSource',null,'GET','M_사용자 동의서 조회',null,'SELECT AGREE.AGREEMENT_SEQ, AGREE.AGREEMENT_ORDER, AGREE.AGREEMENT_NAME, AGREE.AGREEMENT_CL, AGREE.AGREEMENT_ID, AGREE.VERSION_NUMBER, AGREE.REQUIRED_YN, AGREE.ENABLED_YN, AGREE.NEW_YN, AGREE.TYPE_NAME, USERAGREE.AGREEMENT_YN, USERAGREE.REGISTER_DT FROM MP_AGREEMENT AGREE, ( SELECT USERAGR.USER_AGREEMENT_SEQ, USERAGR.AGREEMENT_SEQ, USERAGR.USER_ID, USERAGR.AGREEMENT_YN, USERAGR.REGISTER_DT FROM MP_USER_AGREEMENT USERAGR, ( SELECT AGREEMENT_ID, MAX(USER_AGREEMENT_SEQ) AS USER_AGREEMENT_SEQ FROM MP_USER_AGREEMENT WHERE USER_ID=:userId GROUP BY AGREEMENT_ID ) NEWUSERAGR WHERE USERAGR.USER_AGREEMENT_SEQ = NEWUSERAGR.USER_AGREEMENT_SEQ ) USERAGREE WHERE AGREE.AGREEMENT_SEQ = USERAGREE.AGREEMENT_SEQ','LIST','getUserAgreementList',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (25,'SQL','mplusDataSource','사용자 ID를 이용해서 등록된 사용자 정보를 조회한다. ','GET','M_사용자 등록정보 조회',null,'SELECT USER_ID, LOGIN_FAIL_CNT, PASSWORD_VALUE, PASSWORD_UPDATE_DT, LOCAL_CIPHER_KEY_VALUE, USE_ATTR_ORDER FROM MP_USER WHERE USER_ID=:userId','MAP','getLoginInfo',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (26,'SQL','mplusDataSource','- 등록된 모든 사용자 ID를 조회 - 이 API는 통계에서 사용됨','GET','M_사용자 ID목록',null,'SELECT USER_ID FROM MP_USER','LIST','getUserIdList',null,23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/08/08','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (27,'WEB_SERVICE',null,'3개의 값은 선택적으로 입력됨 ','POST','사용자 ID 찾기',null,null,'MAP','findPid','SELECT * FROM MP_DEMO_USER WHERE USER_NAME=:userName AND TELNO_VALUE=:cellphoneNo',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (28,'SQL','mplusDataSource',null,'GET','사용자 정보 조회',null,'SELECT USER_ID, USER_NAME AS USER_NAME, TELNO_VALUE AS CELLPHONE_NO, INHOSPITAL_YN AS IN_HOSPITAL_YN, ZIPCODE_TXT_VALUE AS ZIP_CODE_TXT, ZIPCODE_VALUE AS ZIP_CODE, ADDR_VALUE AS ADDRESS, GENDER_VALUE AS GENDER_CD, TO_CHAR(BIRTHDAY_DT, ''yyyyMMdd'') AS BIRTH_DT, CARNO_VALUE AS VEHICLE_NO FROM MP_DEMO_USER WHERE USER_ID=:userId','MAP','getUserInfo','SELECT * FROM MP_DEMO_USER WHERE USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/08/08','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (29,'SQL','mplusDataSource',null,'PUT','사용자 주소 수정',null,'UPDATE MP_DEMO_USER SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address WHERE USER_ID=:userId','INT','updateAddress','UPDATE MP_DEMO_USER SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address WHERE USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (30,'SQL','mplusDataSource',null,'PUT','사용자 전화번호 수정',null,'UPDATE MP_DEMO_USER SET TELNO_VALUE=:cellphoneNo WHERE USER_ID=:userId','INT','updateTelNo','UPDATE MP_DEMO_USER SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address WHERE USER_ID=:userId',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (31,'SQL','mplusDataSource','사용자의 차량번호 수정 ','PUT','차량번호 수정',null,'UPDATE MP_DEMO_USER SET CARNO_VALUE=:vehicleNo WHERE USER_ID=:userId ','INT','updateVehicleNo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TXZIF00010&business_id=com&hospitalCd=031&userId={userId}&vehicleNo={vehicleNo}',23,'/user/userinfo/',to_date('16/06/21','RR/MM/DD'),'DBS(Console)',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (44,'SQL','mplusDataSource',null,'GET','전화번호 목록',null,'SELECT BUILDING_DESC, ROOM_DESC, TEL_VALUE, TELNO_ORDER FROM MP_TELNO ORDER BY TELNO_ORDER ASC ','LIST','getList',null,13,'/telno/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (3,'WEB_SERVICE',null,null,'POST','혈당_키_몸무게',null,null,'MAP','getPersonHealthInfo','https://mcare-demo.idatabank.com/MP_demo/api/virtual.json?submit_id=TRZIF00018&hospitalCd=031&business_id=com&userId={userId}',2,'/totalexam/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (5,'SQL','mplusDataSource',null,'GET','도우미메시지',null,'SELECT HELPER_SEQ, USER_MSG, TO_CHAR(SEND_DT, ''yyyy-MM-dd HH24:MI:ss'') AS SEND_DT FROM MP_HELPER_CONTENTS WHERE USER_ID=:userId AND TO_CHAR(SEND_DT, ''yyyyMMdd'') BETWEEN :startDate AND :endDate ORDER BY SEND_DT ASC','LIST','messageList',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (6,'SQL','mplusDataSource',null,'DELETE','메시지 삭제',null,'DELETE FROM MP_HELPER_CONTENTS WHERE TO_CHAR(SEND_DT, ''yyyyMMdd'')<=:deleteDay','INT','deleteContents',null,4,'/helper/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (7,'SQL','mplusDataSource',null,'PUT','00_탈퇴안내',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'', ''guide'', :userId, :userName, :messageValue, 0, :senderId)','INT','withdrawal',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (10,'SQL','mplusExtDataSource',null,'PUT','30_결제취소알림',null,'INSERT INTO MP_INF_PUSH_MSG(PUSH_SEQ, HOSPITAL_VALUE, FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID) VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'', ''paymentCancelSuccess'', :userId, :userName, :messageValue, :stageOrder, :senderId)','INT','paymentCancel',null,5,'/helperpush/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (14,'SQL','mplusDataSource',null,'GET','최신 동의서 조회',null,'SELECT AGREEMENT_SEQ, AGREEMENT_ID, VERSION_NUMBER, AGREEMENT_ORDER, AGREEMENT_NAME, AGREEMENT_CL, ENABLED_YN, REQUIRED_YN, NEW_YN, TYPE_NAME FROM MP_AGREEMENT WHERE NEW_YN = ''Y'' AND ENABLED_YN = ''Y'' AND TYPE_NAME = ''ALL'' AND AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ FROM MP_USER_AGREEMENT WHERE USER_ID=:userId)','LIST','getNewAgreementList',null,7,'/agreement/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/14','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (20,'SQL','mplusDataSource',null,'PUT','로그인실패횟수초기화',null,'UPDATE MP_USER SET LOGIN_FAIL_CNT=0 WHERE USER_ID=:userId','INT','clearLoginFailCnt',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (21,'SQL','mplusDataSource',null,'GET','최근로그인조회',null,'SELECT A.USER_ID, A.LAST_ACCESS_DAY, A.REGISTER_DAY FROM ( SELECT U.USER_ID, CAST(SYSDATE - HJ.ACCESS_DT AS INTEGER) AS LAST_ACCESS_DAY, CAST(SYSDATE - U.REGISTER_DT AS INTEGER) AS REGISTER_DAY FROM MP_USER U LEFT JOIN ( SELECT DISTINCT(H.USER_ID) AS USER_ID, MAX(H.ACCESS_DT) AS ACCESS_DT FROM MP_ACCESS_HISTORY H GROUP BY H.USER_ID ) HJ ON U.USER_ID=HJ.USER_ID) A WHERE A.LAST_ACCESS_DAY = :baseDay OR A.REGISTER_DAY = :baseDay','LIST','getAccessDay',null,21,'/user/login/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),'admin'); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (22,'SQL','mplusDataSource',null,'PUT','비밀번호 변경',null,'UPDATE MP_USER SET PASSWORD_VALUE=:passwordValue, LOGIN_FAIL_CNT=0, PASSWORD_UPDATE_DT=SYSDATE WHERE USER_ID=:userId','INT','resetPWD',null,22,'/user/password/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (32,'SQL','mplusDataSource',null,'GET','사용자 토큰조회',null,'SELECT DEVICE_TOKEN_ID FROM MNS_RECEIVER_DEVICE WHERE RECEIVER_ID=:userId','LIST','getUserDeviceTokens',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (33,'SQL','mplusDataSource',null,'GET','토큰등록여부확인',null,'SELECT COUNT(1) AS USER_CNT FROM MNS_RECEIVER_DEVICE WHERE DEVICE_TOKEN_ID=:deviceTokenId AND RECEIVER_ID=:receiverId AND PLATFORM_TYPE=:platformType AND CERT_TYPE=:certType','MAP','checkDeviceToken',null,24,'/user/tokens/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (35,'SQL','mplusDataSource',null,'GET','버전확인',null,'SELECT * FROM MP_VERSION WHERE PLATFORM_TYPE=:platformType','MAP','checkAppVersion',null,11,'/app/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/06/21','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (82,'SQL','mplusDataSource',null,'GET','사용자 속성 목록',null,'SELECT MAU.USER_ID AS USER_ID, (SELECT USER_NAME FROM MP_USER WHERE USER_ID = MAU.USER_ID) AS USER_NAME, MAU.USER_ATTR_ORDER AS USER_ATTR_ORDER, MAU.HOSPITAL_ID AS HOSPITAL_ID, (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''hospital'' AND MP_ATTR.ATTR_ID = MAU.HOSPITAL_ID) AS HOSPITAL_NAME, MAU.DUTY_ID AS DUTY_ID, (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''duty'' AND MP_ATTR.ATTR_ID = MAU.DUTY_ID) AS DUTY_NAME, MAU.WORK_ID AS WORK_ID, (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''work'' AND MP_ATTR.ATTR_ID = MAU.WORK_ID) AS WORK_NAME FROM MP_USER_ATTR MAU WHERE MAU.USER_ID = :userId','LIST','getUserAttrList',null,23,'/user/userinfo/',to_date('16/08/08','RR/MM/DD'),'admin',to_date('16/08/08','RR/MM/DD'),null); Insert into MP_API (API_SEQ,API_TYPE,DATA_SOURCE_NAME,API_DESC,HTTP_METHOD_TYPE,API_NAME,TARGET_NAME,QUERY_MSG,RESULT_TYPE,REQ_URL_ADDR,TARGET_URL_ADDR,CAT_SEQ,CAT_PATH_NAME,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values (162,'SQL','mplusDataSource',null,'POST','사용자 속성 정보 수정',null,'UPDATE MP_USER SET USE_ATTR_ORDER = :useAttrOrder WHERE USER_ID = :userId','INT','updateUseAttrOrder',null,23,'/user/userinfo/',to_date('16/08/10','RR/MM/DD'),'admin',to_date('16/08/10','RR/MM/DD'),'admin'); REM INSERTING into MP_API_HEADER SET DEFINE OFF; Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (6,2,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (8,8,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (7,3,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (36,29,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (38,31,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (5,1,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (1,27,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (2,30,'Accept','application/json'); Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (21,28,'Accept','application/json'); REM INSERTING into MP_API_PARAM SET DEFINE OFF; Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,25,'STRING',null,'userId','1512202'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,23,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,23,'STRING','SHA256해쉬(솔트적용)','passwordValue',null); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,13,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,14,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,2,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,8,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,2,'STRING',null,'startDt','20160101'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,2,'STRING',null,'endDt','20160317'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,3,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,24,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,29,'STRING',null,'userId','1512201'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (85,29,'STRING',null,'zipCode','1234'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (86,29,'STRING',null,'zipCodeTxt','서울 금천구 '); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (87,29,'STRING',null,'address','삼성리더스타워 '); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (90,31,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (91,31,'STRING',null,'vehicleNo','실험1234'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,5,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,5,'STRING','시작날짜 ','startDate','20160101'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,5,'STRING','종료날짜 ','endDate','20160101'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (11,6,'STRING','삭제할날짜','deleteDay','20160101'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (56,22,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (57,22,'STRING','SHA256 해쉬 (솔트적용)','passwordValue',null); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (72,32,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (81,35,'STRING','플랫폼유형','platformType','I'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (5,1,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,4,'STRING','접근할 도우미 메시지 시퀀스','accessSeq','123'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,4,'STRING','접근할 도우미 시퀀스 접근 키 ','accessKey','abcdefg'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (82,36,'STRING','플랫폼 유형 ','platformType','I'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (83,36,'STRING','앱이름','appName','mcare-hyumc-seoul'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,36,'STRING','인증서유형','certType','AppStore'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (37,10,'STRING','사용자 이름','userName','홍길동'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (38,10,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (39,10,'STRING','누가 보냈는지 ','senderId','WEB_ADMIN_CONSOLE'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (40,10,'STRING','단계 ','stageOrder','30'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (27,7,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (28,7,'STRING','사용자 이름','userName','홍길동'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (29,7,'STRING','보낼 메시지','messageValue','가내두루평안하신지요?'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (30,7,'STRING','표시방식 ','senderId','WEB_ADMIN_CONSOLE'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (31,9,'STRING','사용자 ID ','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (32,9,'STRING','사용자 이름','userName','홍길동'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (33,9,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (34,9,'STRING','누가 보냈는지 ','senderId','WEB_ADMIN_CONSOLE'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (35,9,'STRING','단계 ','stageOrder','30'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (36,10,'STRING','사용자 ID ','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (73,33,'STRING','토큰','deviceTokenId','dyxgA1Gar8k:APA91bEz7xQOOHZh4F6aMIqQ6xUugagyi4eKdAUoOf1-xjC3EpwmvOgZFssLTGdoY-wJoXw_YpYAEa8K2APUYU7cP2KRLlmbNBmeSilKzQKalNiwwmF2f4FqKmvmxElIt3mVNx23Ez21'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (74,33,'STRING','사용자 ID','receiverId','111'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (75,33,'STRING','플랫폼 유형 ','platformType','A:Android, I:iOS'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (76,33,'STRING','인증서 유형 ','certType','InHouse'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (77,34,'STRING','토큰','deviceTokenId','111'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (78,34,'STRING','사용자 ID','receiverId','111'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (79,34,'STRING','android:A, iOS:I','platformType','A'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (80,34,'STRING','인증서 유형 ','certType','InHouse'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (183,51,'STRING','메시지 형식','guide','guide'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (184,51,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (185,51,'STRING','사용자 이름','userName','홍길동'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (186,51,'STRING','보낼 메시지 ','messageValue','실험입니다.'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (187,51,'STRING','어떤 단계의 메시지인지','stageOrder','10'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (188,51,'STRING','푸쉬로 전달유무','pgubn','WEB_ADMIN_CONSOLE'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1,27,'STRING','이름','userName','권혜은'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,27,'STRING','전화번호','cellphoneNo','01020125023'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,30,'STRING',null,'userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,30,'STRING',null,'cellphoneNo','01011112222'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (21,19,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (22,20,'STRING','사용자 ID','userId','03000000'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (23,21,'STRING','조회할기준일','baseDay','10'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (24,28,'STRING','사용자 ID','userId','1512202'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (25,82,'STRING',null,'userId','1512202'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1683,162,'NUMBER',null,'useAttrOrder','0'); Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1870,162,'STRING',null,'userId','1512202'); REM INSERTING into MP_ATTR_TYPE SET DEFINE OFF; Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (1,'hospital','소속'); Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (2,'duty','직무'); Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (3,'work','업무'); Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (21,'extra','추가속성'); REM INSERTING into MP_ATTR SET DEFINE OFF; Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (1,'hospital','seoul','서울','none'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (2,'hospital','guri','구리','none'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (3,'duty','medical','의료','none'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (4,'duty','nurse','간호','none'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (5,'duty','general','일반','none'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (6,'work','treatment','진료의','medical'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (7,'work','doctor','주치의','medical'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (8,'work','ward_nurse','병동 간호','nurse'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (9,'work','treatment_nurse','진료 간호','nurse'); Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (10,'work','normal','일반','general'); REM INSERTING into MP_AUTH SET DEFINE OFF; Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (1,'auth02','권한1','권한1'); Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (2,'auth01','권한2','권한2'); REM INSERTING into MP_AUTH_ATTR SET DEFINE OFF; Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (1,'auth01','add','hospital','seoul'); Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (2,'auth01','add','hospital','guri'); Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (3,'auth02','add','hospital','seoul'); Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (4,'auth02','add','work','doctor'); Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (5,'auth02','add','duty','medical'); Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (6,'auth02','minus','work','normal'); REM INSERTING into MP_DEMO_USER SET DEFINE OFF; Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1603220','김우석','01063910582','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512186','김홍섭','01092240010','Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512205','김해동','01048308110','Y','02무0233','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1602001','강영길','01090437309','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1602002','복중효','01020738643','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('15122022','김희성2','01029502538','Y',null,'192.6','97.2',null,to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512001','홍병진','01028034513','Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512201','권혜은','01020125023','Y','서울 1234','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M','1234','서울 금천구 ','삼성리더스타워 '); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512197','서영일','01033661397','Y','31나 3456','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M','04417','서울 용산구 다산로 8-11 (한남동, 응봉공원 숲속 유아쉼터)','테스트'); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512202','김희성','01029502538','Y','내차1234','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512207','안성철','01030187371','Y','17모1869','192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512047','김준현',null,'Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); Insert into MP_DEMO_USER (USER_ID,USER_NAME,TELNO_VALUE,INHOSPITAL_YN,CARNO_VALUE,HEIGHT_VALUE,WEIGHT_VALUE,CHECK_DT,BIRTHDAY_DT,GENDER_VALUE,ZIPCODE_VALUE,ZIPCODE_TXT_VALUE,ADDR_VALUE) values ('1512119','연제봉 ',null,'Y',null,'192.6','97.2',to_date('15/12/01','RR/MM/DD'),to_date('81/09/04','RR/MM/DD'),'M',null,null,null); REM INSERTING into MP_HELPER_CONTENTS SET DEFINE OFF; REM INSERTING into MP_I18N SET DEFINE OFF; REM INSERTING into MP_INF_NURSE SET DEFINE OFF; REM INSERTING into MP_INF_PUSH_MSG SET DEFINE OFF; Insert into MP_INF_PUSH_MSG (PUSH_SEQ,FORM_ID,HOSPITAL_VALUE,USER_ID,USER_NAME,MESSAGE_VALUE,PARAM_VALUE,STAGE_ORDER,REQ_DT,SENDER_ID,PUMPING_DT,SEND_YN,RESERVE_SEND_DT) values (1,'guide','031','03000000','홍길동','실험입니다.',null,10,to_date('16/08/03','RR/MM/DD'),'WEB_ADMIN_CONSOLE',null,'N',to_date('16/08/03','RR/MM/DD')); REM INSERTING into MP_LOGIN_HISTORY SET DEFINE OFF; Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (2,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (3,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (4,'1512202',to_date('16/07/25','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (21,'1512202',to_date('16/08/08','RR/MM/DD'),'Y','5bced8e6a97d646394f3c4d0634e7f86be195883024551afac945ac423d8e546'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (22,'1512207',to_date('16/08/08','RR/MM/DD'),'Y','64968e8c931e8d9789821d739363891b8a1324f146a7ff899783e9c0a7f99482'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (5,'1512207',to_date('16/07/27','RR/MM/DD'),'Y','31c62c7ef9bf671a66608ec29e2a04ecf9b5d8a47abde04b3cba5caaa48d91a2'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (23,'1512202',to_date('16/08/08','RR/MM/DD'),'Y','5bced8e6a97d646394f3c4d0634e7f86be195883024551afac945ac423d8e546'); Insert into MP_LOGIN_HISTORY (LOGIN_SEQ,USER_ID,LOGIN_DT,REMEMBER_ME_YN,LOGIN_HASH_VALUE) values (1,'1512202',to_date('16/07/21','RR/MM/DD'),'Y','1061a5a9acd21604edd0cd4cfe8e3a8421dce0aaed074828a38a501dae141c79'); REM INSERTING into MP_MANAGER SET DEFINE OFF; Insert into MP_MANAGER (USER_ID,USER_NAME,ENABLED_YN,DEPT_NAME,PWD_VALUE,CREATE_DT,CREATE_ID,UPDATE_DT,UPDATE_ID) values ('admin','knuh1_admin','Y','DBS','4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/08','RR/MM/DD'),'DBS(Console)',to_date('16/07/08','RR/MM/DD'),'DBS(Console)'); REM INSERTING into MP_MENU SET DEFINE OFF; Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkAgreementList','myInfo',166,'CONT','서비스약관','Y','/mobile/agreement/agreement.page','/resources/css/images/mobile/main/agreement.png','- 이미 동의한 서비스 약과 보기 및 철회','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('inpatientExam',null,180,'CONT','입원환자 검사안내','Y','/mobile/inpatientExam/inpatientExam.page','/resources/css/images/mobile/main/inpatientExam.png',null,'Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('hospital',null,910,'SIDE','병원선택_실험용','N','/hospital.page',null,null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('address','myInfo',162,'CONT','주소','Y','/mobile/user/address.page',null,'사용자 주소 설정 화면','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('telephone','myInfo',161,'CONT','전화번호','Y','/mobile/user/telephone.page',null,'사용자 전화번호 변경 화면','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('inpatientBrochure',null,170,'CONT','입원진료안내','N','/mobile/inpatientBrochure/inpatientBrochure.page','/resources/css/images/mobile/main/inpatientBrochure.png',null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('brochureDetail','inpatientBrochure',922,'CONT','입원안내문상세','Y','/mobile/inpatientBrochure/brochureDetail.page',null,null,'N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('mobileHomepage',null,911,'SIDE','병원모바일홈','Y','javascript:goHomepage(''http://www.idatabank.com/'')',null,'병원 모바일 홈','N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('outpatientBrochure',null,160,'CONT','외래진료안내','Y','/mobile/outpatientBrochure/outpatientBrochure.page','/resources/css/images/mobile/main/outpatientBrochure.png','내원안내문','N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkProgramVersion',null,950,'SIDE','프로그램 정보','Y','javascript:checkProgramVersion();',null,'프로그램 정보 보여주기','N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('receipt','payment',30,'CONT','영수증','Y','/mobile/pay/receipt.page',null,'영수증 테스트 화면','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('medicineSearch',null,940,'SIDE','의약품백과사전','Y','javascript:medicineSearch()',null,'의약품 백과사전','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payment',null,20,'CONT','스마트 결제','Y','/mobile/pay/payment.page','/resources/css/images/mobile/main/payment.png',null,'Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payDetail','payment',21,'CONT','결제상세','Y','/mobile/pay/payDetail.page',null,'결제 상세 화면','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('myCar','myInfo',163,'CONT','차량번호','Y','/mobile/parking/parking.page','/resources/css/images/mobile/main/parking.png',null,'Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payCancel','payment',22,'CONT','결제취소','Y','/mobile/pay/payCancel.page',null,'결제취소 화면','Y','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('gMap',null,1,'CONT','찾아오시는길','Y','/mobile/map/map.page','/resources/css/images/mobile/main/openMap.png',null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('payManagement','myInfo',164,'CONT','병원비 카드','Y','/mobile/user/payManagement.page',null,'결제정보관리','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('setUserPwd','findPidPwd',933,'CONT','비밀번호설정','Y','/mobile/user/setUserPwd.page',null,'본인인증 후에 비밀번호를 설정하는 페이지','N','N','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('openMap',null,120,'CONT','길찾기','Y','javascript:openMap()','/resources/css/images/mobile/main/openMap.png',null,'N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('exitApp',null,990,'SIDE','종료','Y','javascript:exitApp()',null,'앱종료','N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('myInfo',null,130,'NAVI','내 정보관리','Y','/navigation.page','/resources/css/images/mobile/main/myInfo.png',null,'Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('withdrawal','myInfo',169,'CONT','회원탈퇴','Y','/mobile/user/withdrawal.page',null,null,'Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('changeMyPwd','myInfo',165,'CONT','비밀번호 변경','Y','/mobile/user/changeMyPwd.page',null,'비밀번호를 변경한다.','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('findPidPwd',null,1100,'NAVI','_사용자 ID 및 비번찾기','N','/navigation.page',null,'- 로그인 화면에 있는 사용자 ID 찾기와 비밀번호 찾기를 위한 메뉴 - 이 메뉴는 보이지 않지만, 하위의 사용자 ID 찾기와 비밀번호 찾기는 접근할 수 있는 메뉴임','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('certificationResult','certification',40,'CONT','인증결과','Y','/mobile/user/certificationResult.page',null,'휴대폰 인증, iPin 인증의 인증 결과를 반환 받는다.','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('appointmentSearchDetail','appointmentSearch',71,'CONT','예약조회상세','Y','/mobile/appointmentSearch/appointmentSearchDetail.page',null,'예약조회 상세','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('searchId','userRegister',22,'CONT','사용자 ID찾기','Y','/mobile/user/searchPId.page',null,'사용자 등록(userRegister) 에서 사용자 ID 찾기로 넘어가는 화면.','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('registerPWD','userRegister',21,'CONT','비밀번호 설정','Y','/mobile/user/registerPWD.page',null,null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userAgreement','userRegister',27,'CONT','서비스약관 동의','Y','/mobile/user/userAgreement.page',null,'- 사용등록 후 최초로 약관 동의하는 페이지 - 로그인하다가 추가로 동의할게 있으면 오는 페이지 - 사용등록 시 가입은 되었으나, 로그인은 하지 않은 상태로 사용자가 여기에 오게 됨','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('treatmentHistoryDetail','treatmentHistory',91,'CONT','진료이력','Y','/mobile/history/treatmentHistoryDetail.page',null,'이력조회상세','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('resultExam',null,110,'CONT','검사결과','Y','/mobile/resultExam/resultExam.page','/resources/css/images/mobile/main/resultExam.png','검사결과조회','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('prescription',null,100,'CONT','처방조회','Y','/mobile/prescription/prescription.page','/resources/css/images/mobile/main/prescription.png','처방조회','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('ticket',null,30,'CONT','번호표발급','Y','/mobile/ticket/ticket.page','/resources/css/images/mobile/main/ticket.png','번호표발급 - 번호표발급기 목록','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('issueTicket','ticket',31,'CONT','번호표발급','Y','/mobile/ticket/issueTicket.page',null,'번호표발급','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('help',null,170,'CONT','도움말','N','/mobile/help/help.page',null,'로그인 하지 않았을 때, 시작화면에 표시되는 도움말','N','N','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('paymentDetail','treatmentHistoryDetail',10,'CONT','진료비 상세내역','Y','/mobile/history/paymentDetail.page',null,'진료비 내역 상세','Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('nextLocation',null,50,'CONT','가야할곳','Y','/mobile/nextLocation/nextLocation.page','/resources/css/images/mobile/main/navigation.png','가셔야 할 곳','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('nurse',null,150,'CONT','간호요청','N','/mobile/nurse/nurse.page','/resources/css/images/mobile/main/nurse.png','간호호출','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('sidehelp',null,960,'SIDE','도움말','Y','/mobile/help/help.page','/resources/css/images/mobile/main/help.png','로그인 후 사이드 메뉴에 표시되는 도움말 이었는데.. 시작메뉴에 아이콘이 너무 많아서 도움말은 사이드로 배치','N','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('smsCertification','certification',34,'CONT','SMS인증 코드','Y','/mobile/user/smsCertification.page',null,'SMS인증 대기 화면','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('telNo',null,150,'CONT','전화번호안내','Y','/mobile/telNo/telNo.page','/resources/css/images/mobile/main/telNo.png','주요전화번호','N','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('authUserInfo','findPidPwd',932,'CONT','본인인증','Y','/mobile/user/authUserInfo.page',null,'- 비밀번호 설정 시작하는 페이지로 본인인증을 먼저하고 비밀번호를 바꿔줌','N','N','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('mobileCard',null,10,'CONT','진료카드','Y','/mobile/mobileCard/mobileCard.page','/resources/css/images/mobile/main/mobileCard.png','환자카드','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('appointmentSearch',null,70,'CONT','예약조회','Y','/mobile/appointmentSearch/appointmentSearch.page','/resources/css/images/mobile/main/appointmentSearch.png','예약조회','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('sms','certification',30,'CONT','SMS','Y','/mobile/user/sms.page',null,'병원에 등록한 휴대폰 번호','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('certification','userRegister',20,'CONT','본인인증','Y','/mobile/user/certification.page',null,'- 사용등록 화면에서 사용자 ID를 입력한 다음 "다음" 버튼 누르면 열리는 화면임','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('iPin','certification',40,'CONT','i-Pin','Y','/mobile/user/iPin.page',null,'i-Pin 인증','N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('searchPNumber','findPidPwd',1120,'CONT','사용자 ID 찾기','Y','/mobile/user/searchPId.page',null,'- 로그인 화면에 있는 사용자 ID찾기','N','N','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('helper',null,0,'CONT','도우미','Y','/mobile/helper/helper.page','/resources/css/images/mobile/main/helper.png','도우미ㅋㅋㅋ','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('treatmentHistory',null,90,'CONT','진료이력','Y','/mobile/history/treatmentHistory.page','/resources/css/images/mobile/main/treatmentHistory.png','이력조회','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('waitingTime',null,50,'CONT','진료대기순서','Y','/mobile/waitingTime/waitingTime.page','/resources/css/images/mobile/main/waitingTime.png','진료대기조회','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userRegister',null,0,'CONT','사용등록','Y','/mobile/user/register.page','/resources/css/images/mobile/main/register.png',null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbook',null,140,'CONT','건강수첩','Y','/mobile/resultExam/resultExam.page','/resources/css/images/mobile/main/healthHandbook.png','건강수첩','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbookInsert','healthHandbook',162,'CONT','건강수첩등록','Y','/mobile/healthHandbook/healthHandbookInsert.page',null,null,'Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('healthHandbookUpdate','healthHandbook',152,'CONT','건강수첩수정','Y','/mobile/healthHandbook/healthHandbookUpdate.page',null,null,'Y','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('reservation',null,80,'CONT','진료예약','Y','/mobile/reservation/reservation.page','/resources/css/images/mobile/main/reservation.png','예약','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('announceArrival',null,40,'CONT','진료도착확인','Y','/mobile/announceArrival/announceArrival.page','/resources/css/images/mobile/main/announceArrival.png','진료도착확인','Y','Y','Y'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkPlusFailed','certification',20,'CONT','휴대폰 인증실패','Y','/mobile/user/checkPlusFailed.page',null,null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('checkPlusSuccess','certification',10,'CONT','휴대폰 인증성공','Y','/mobile/user/checkPlusSuccess.page',null,null,'N','N','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('iPinSuccess','certification',41,'CONT','iPin인증성공','Y','/mobile/user/iPinSuccess.page',null,null,'N','Y','N'); Insert into MP_MENU (MENU_ID,PARENT_MENU_ID,MENU_ORDER,MENU_TYPE,MENU_NAME,ENABLED_YN,ACCESS_URI_ADDR,IMAGE_URI_ADDR,MENU_DESC,AUTH_YN,AUTH_VIEW_YN,AGG_YN) values ('userAuthList',null,1400,'CONT','권한 목록','Y','/mobile/auth/userAuthList.page',null,null,'Y','Y','N'); REM INSERTING into MP_MENU_AUTH SET DEFINE OFF; Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (16,'waitingTime','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (24,'payment','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (15,'helper','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (17,'nextLocation','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (32,'reservation','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (23,'mobileCard','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (28,'announceArrival','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (29,'prescription','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (33,'treatmentHistory','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (2,'telNo','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (26,'openMap','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (27,'resultExam','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (18,'gMap','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (19,'help','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (21,'checkProgramVersion','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (8,'ticket','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (9,'outpatientBrochure','auth02'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (10,'outpatientBrochure','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (31,'medicineSearch','auth01'); Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (34,'inpatientExam','auth02'); REM INSERTING into MP_MENU_PARAM SET DEFINE OFF; Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (1,'ticket','sendTimeNum','STRING','3','호출 횟수'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (2,'appointmentSearch','periodDay','NUMBER','30','기본 검색기간 (일)'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (43,'prescription','periodDay','NUMBER','30','기본 검색기간 (일)'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (44,'treatmentHistory','periodDay','NUMBER','30','기본 검색기간 (일)'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (6,'checkAgreementList','minimum','NUMBER','3','전체동의 보이는 최저 갯수'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (7,'userAgreement','minimum','NUMBER','3','전체동의 보이는 최저 갯수'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (42,'resultExam','periodDay','NUMBER','30','기본 검색기간 (일)'); Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (41,'healthHandbook','periodDay','NUMBER','30','기본 검색기간 (일)'); REM INSERTING into MP_MNS_MSGMAPPING SET DEFINE OFF; REM INSERTING into MP_PAYMENT_MASTER SET DEFINE OFF; REM INSERTING into MP_PUBLIC_DEVICE SET DEFINE OFF; REM INSERTING into MP_PUSH_FORM SET DEFINE OFF; Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('welcome','GUIDE','Y',null,'Y','웹컴',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('guide','GUIDE','Y',null,'Y','일반 text 전송',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('medicineSearch','PAGE','Y','medicineSearch','Y','의약품백과사전 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('openMap','MAP','Y','openMap','Y','길찾기 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('resultExam','PAGE','Y','resultExam','Y','검사결과 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('prescription','PAGE','Y','prescription','Y','처방조회 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('ticket','PAGE','Y','ticket','Y','번호표발급 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('myCar','PAGE','Y','myCar','Y','주차관리 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('nextLocation','PAGE','Y','nextLocation','Y','가야할곳 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('sidehelp','PAGE','Y','sidehelp','Y','도움말_시작메뉴 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('telNo','PAGE','Y','telNo','Y','주요전화번호 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('mobileCard','PAGE','Y','mobileCard','Y','진료카드 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('appointmentSearch','PAGE','Y','appointmentSearch','Y','예약조회 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('treatmentHistory','PAGE','Y','treatmentHistory','Y','진료이력 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('waitingTime','PAGE','Y','waitingTime','Y','진료대기순서 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('reservation','PAGE','Y','reservation','Y','진료예약 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('announceArrival','PAGE','Y','announceArrival','Y','진료도착확인 (DBS일괄입력)',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('paymentSuccess','PAGE','Y','treatmentHistory','Y','진료이력에서 결제결과 보기 가능함',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('paymentCancelSuccess','PAGE','Y','treatmentHistory','Y','진료이력에서 결제결과 보기 가능하여 일단 연결',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('outpatientBrochure','PAGE','Y','outpatientBrochure','Y','DBS에서 한땀한땀 입력',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('inpatientBrochure','PAGE','Y','inpatientBrochure','Y','DB에서 한땀한땀 입력함',to_date('16/06/21','RR/MM/DD')); Insert into MP_PUSH_FORM (FORM_ID,FORM_TYPE,USE_YN,MENU_ID,INCLUDE_NAME_YN,FORM_DESC,REG_DT) values ('inpatientExam','PAGE','Y','inpatientExam','Y','DBS에서 한땀한땀 입력함',to_date('16/06/21','RR/MM/DD')); REM INSERTING into MP_TELNO SET DEFINE OFF; Insert into MP_TELNO (TELNO_SEQ,BUILDING_DESC,ROOM_DESC,TEL_VALUE,TELNO_ORDER) values (1,'건물1','1호','02-123-4567',13); REM INSERTING into MP_USER SET DEFINE OFF; Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (1,'1512201','권혜은',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (2,'1603220','김우석',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (3,'1512186','김홍섭',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (4,'1512205','김해동',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (5,'1602001','강영길',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (6,'1602002','복중효',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (7,'15122022','김희성2',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (8,'1512001','홍병진',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (9,'1512197','서영일',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (10,'1512202','김희성',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (11,'1512207','안성철',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (12,'1512047','김준현',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); Insert into MP_USER (USER_SEQ,USER_ID,USER_NAME,LOGIN_FAIL_CNT,PASSWORD_VALUE,PASSWORD_UPDATE_DT,REGISTER_DT,LOCAL_CIPHER_KEY_VALUE,USE_ATTR_ORDER) values (13,'1512119','연제봉',0,'4e6e03cdd3fedeef6bd750ea71585e4930d1134f8914bc2f6ffc2f3e4831959e',to_date('16/07/07','RR/MM/DD'),to_date('16/07/07','RR/MM/DD'),'401b9e55dc48c9b30c6c5',0); REM INSERTING into MP_USER_ATTR SET DEFINE OFF; Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (1,1,'1512202','seoul','medical','doctor'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (2,1,'1512119','guri','general','normal'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (3,1,'1512201','seoul','medical','treatment'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (4,1,'1603220','seoul','nurse','ward_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (5,1,'1512205','seoul','nurse','treatment_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (6,1,'1602001','guri','nurse','ward_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (7,1,'1602002','guri','nurse','treatment_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (8,1,'15122022','seoul','medical','doctor'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (9,1,'1512001','guri','nurse','treatment_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (10,1,'1512197','seoul','medical','doctor'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (11,1,'1512207','seoul','nurse','ward_nurse'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (12,1,'1512047','seoul','medical','treatment'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (13,1,'1512186','guri','medical','doctor'); Insert into MP_USER_ATTR (USER_ATTR_SEQ,USER_ATTR_ORDER,USER_ID,HOSPITAL_ID,DUTY_ID,WORK_ID) values (14,2,'1512202','seoul','general','normal'); REM INSERTING into MP_VERSION SET DEFINE OFF; Insert into MP_VERSION (PLATFORM_TYPE,CERT_TYPE,VERSION_ORDER,APP_NAME,MARKET_URL) values ('I','InHouse',1,'M-Care (Demo)',null); REM INSERTING into MP_EVENT_LOG SET DEFINE OFF; REM INSERTING into MP_EXTRA_ATTR SET DEFINE OFF; Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (1,'extraAttr01','추가 속성1','테스트'); Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (2,'extraAttr02','추가 속성2','2'); Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (21,'extraAttr03','추가 속성3','테스트03'); REM INSERTING into MP_EXTRA_ATTR_USER SET DEFINE OFF; Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (1,'extraAttr03','1512202',1); Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (2,'extraAttr01','1512119',1); Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (3,'extraAttr01','1512201',2); Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (4,'extraAttr01','1512202',3); Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (5,'extraAttr02','1512119',1); Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (6,'extraAttr02','1512202',2); commit;