sample_Data_Oracle_Table_For_MPlus.sql 83 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582
  1. --------------------------------------------------------
  2. -- 샘플 데이터
  3. -- EX : 테스트 등을 위한 샘플 데이터 이며 SEQ를 맞추는 작업 및 실데이터 정리 작업 등 필요
  4. --------------------------------------------------------
  5. REM INSERTING into MP_API_CATEGORY
  6. SET DEFINE OFF;
  7. 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)');
  8. 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)');
  9. 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)');
  10. 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)');
  11. 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)');
  12. 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)');
  13. 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)');
  14. 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)');
  15. 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)');
  16. 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)');
  17. 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)');
  18. 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)');
  19. 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)');
  20. REM INSERTING into MP_API
  21. SET DEFINE OFF;
  22. 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,
  23. FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID)
  24. VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'',
  25. ''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');
  26. 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)
  27. 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);
  28. 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 : 검사결과
  29. examNm : 검사명
  30. examGrpNm : 검사분류
  31. referenceVal : 참고치
  32. 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}
  33. ',2,'/totalexam/',to_date('16/06/21','RR/MM/DD'),'admin',to_date('16/07/07','RR/MM/DD'),'admin');
  34. 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
  35. FROM MP_HELPER_CONTENTS
  36. 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);
  37. 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
  38. SET LOGIN_FAIL_CNT = (SELECT LOGIN_FAIL_CNT + 1 FROM MP_USER WHERE USER_ID=:userId)
  39. 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');
  40. 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
  41. CASE WHEN COUNT(*) = 0 THEN ''false''
  42. ELSE ''true'' END AS validPassword
  43. FROM MP_USER
  44. WHERE USER_ID=:userId
  45. 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');
  46. 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
  47. PLATFORM_TYPE, CERT_TYPE, VERSION_ORDER, VERSION_ORDER AS VERSION_VALUE,
  48. APP_NAME, MARKET_URL
  49. FROM MP_VERSION
  50. 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);
  51. 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,
  52. FORM_ID, HOSPITAL_VALUE, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID)
  53. VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL,
  54. :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);
  55. 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');
  56. 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');
  57. 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
  58. AGREEMENT_SEQ,
  59. AGREEMENT_ID,
  60. VERSION_NUMBER,
  61. AGREEMENT_ORDER,
  62. AGREEMENT_NAME,
  63. AGREEMENT_CL,
  64. ENABLED_YN,
  65. REQUIRED_YN,
  66. NEW_YN,
  67. TYPE_NAME
  68. FROM MP_AGREEMENT
  69. WHERE NEW_YN = ''Y'' AND
  70. ENABLED_YN = ''Y'' AND
  71. TYPE_NAME = ''UNDER14'' AND
  72. AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ
  73. FROM MP_USER_AGREEMENT
  74. 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');
  75. 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
  76. AGREE.AGREEMENT_SEQ,
  77. AGREE.AGREEMENT_ORDER,
  78. AGREE.AGREEMENT_NAME,
  79. AGREE.AGREEMENT_CL,
  80. AGREE.AGREEMENT_ID,
  81. AGREE.VERSION_NUMBER,
  82. AGREE.REQUIRED_YN,
  83. AGREE.ENABLED_YN,
  84. AGREE.NEW_YN,
  85. AGREE.TYPE_NAME,
  86. USERAGREE.AGREEMENT_YN,
  87. USERAGREE.REGISTER_DT
  88. FROM
  89. MP_AGREEMENT AGREE,
  90. (
  91. SELECT
  92. USERAGR.USER_AGREEMENT_SEQ,
  93. USERAGR.AGREEMENT_SEQ,
  94. USERAGR.USER_ID,
  95. USERAGR.AGREEMENT_YN,
  96. USERAGR.REGISTER_DT
  97. FROM
  98. MP_USER_AGREEMENT USERAGR,
  99. (
  100. SELECT
  101. AGREEMENT_ID, MAX(USER_AGREEMENT_SEQ) AS USER_AGREEMENT_SEQ
  102. FROM
  103. MP_USER_AGREEMENT
  104. WHERE
  105. USER_ID=:userId
  106. GROUP BY AGREEMENT_ID
  107. ) NEWUSERAGR
  108. WHERE
  109. USERAGR.USER_AGREEMENT_SEQ = NEWUSERAGR.USER_AGREEMENT_SEQ
  110. ) USERAGREE
  111. WHERE
  112. 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');
  113. 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
  114. FROM MP_USER
  115. 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');
  116. 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를 조회
  117. - 이 API는 통계에서 사용됨','GET','M_사용자 ID목록',null,'SELECT USER_ID
  118. 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');
  119. 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 *
  120. FROM MP_DEMO_USER
  121. 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');
  122. 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
  123. USER_ID,
  124. USER_NAME AS USER_NAME,
  125. TELNO_VALUE AS CELLPHONE_NO,
  126. INHOSPITAL_YN AS IN_HOSPITAL_YN,
  127. ZIPCODE_TXT_VALUE AS ZIP_CODE_TXT,
  128. ZIPCODE_VALUE AS ZIP_CODE,
  129. ADDR_VALUE AS ADDRESS,
  130. GENDER_VALUE AS GENDER_CD,
  131. TO_CHAR(BIRTHDAY_DT, ''yyyyMMdd'') AS BIRTH_DT,
  132. CARNO_VALUE AS VEHICLE_NO
  133. FROM MP_DEMO_USER
  134. WHERE USER_ID=:userId','MAP','getUserInfo','SELECT *
  135. FROM MP_DEMO_USER
  136. 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');
  137. 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
  138. SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address
  139. WHERE
  140. USER_ID=:userId','INT','updateAddress','UPDATE MP_DEMO_USER
  141. SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address
  142. WHERE
  143. 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');
  144. 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
  145. SET TELNO_VALUE=:cellphoneNo
  146. WHERE USER_ID=:userId','INT','updateTelNo','UPDATE MP_DEMO_USER
  147. SET ZIPCODE_VALUE=:zipCode, ZIPCODE_TXT_VALUE=:zipCodeTxt, ADDR_VALUE=:address
  148. WHERE
  149. 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');
  150. 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
  151. SET CARNO_VALUE=:vehicleNo
  152. 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');
  153. 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
  154. FROM MP_TELNO
  155. 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);
  156. 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');
  157. 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
  158. FROM MP_HELPER_CONTENTS
  159. WHERE USER_ID=:userId AND TO_CHAR(SEND_DT, ''yyyyMMdd'') BETWEEN :startDate AND :endDate
  160. 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);
  161. 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
  162. 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);
  163. 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,
  164. FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID)
  165. VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL,
  166. ''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');
  167. 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,
  168. FORM_ID, USER_ID, USER_NAME, MESSAGE_VALUE, STAGE_ORDER, SENDER_ID)
  169. VALUES(SEQ_MP_INF_FORM_PUSH_PS.NEXTVAL, ''SEOUL'',
  170. ''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');
  171. 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
  172. AGREEMENT_SEQ,
  173. AGREEMENT_ID,
  174. VERSION_NUMBER,
  175. AGREEMENT_ORDER,
  176. AGREEMENT_NAME,
  177. AGREEMENT_CL,
  178. ENABLED_YN,
  179. REQUIRED_YN,
  180. NEW_YN,
  181. TYPE_NAME
  182. FROM MP_AGREEMENT
  183. WHERE NEW_YN = ''Y'' AND
  184. ENABLED_YN = ''Y'' AND
  185. TYPE_NAME = ''ALL'' AND
  186. AGREEMENT_SEQ NOT IN (SELECT AGREEMENT_SEQ
  187. FROM MP_USER_AGREEMENT
  188. 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');
  189. 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
  190. SET LOGIN_FAIL_CNT=0
  191. 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');
  192. 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
  193. A.USER_ID, A.LAST_ACCESS_DAY, A.REGISTER_DAY
  194. FROM (
  195. SELECT
  196. U.USER_ID,
  197. CAST(SYSDATE - HJ.ACCESS_DT AS INTEGER) AS LAST_ACCESS_DAY,
  198. CAST(SYSDATE - U.REGISTER_DT AS INTEGER) AS REGISTER_DAY
  199. FROM MP_USER U
  200. LEFT JOIN (
  201. SELECT DISTINCT(H.USER_ID) AS USER_ID, MAX(H.ACCESS_DT) AS ACCESS_DT
  202. FROM MP_ACCESS_HISTORY H
  203. GROUP BY H.USER_ID ) HJ
  204. ON U.USER_ID=HJ.USER_ID) A
  205. 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');
  206. 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
  207. SET PASSWORD_VALUE=:passwordValue,
  208. LOGIN_FAIL_CNT=0,
  209. PASSWORD_UPDATE_DT=SYSDATE
  210. WHERE
  211. 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);
  212. 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
  213. FROM MNS_RECEIVER_DEVICE
  214. 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);
  215. 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
  216. FROM MNS_RECEIVER_DEVICE
  217. WHERE
  218. DEVICE_TOKEN_ID=:deviceTokenId AND
  219. RECEIVER_ID=:receiverId AND
  220. PLATFORM_TYPE=:platformType AND
  221. 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);
  222. 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 *
  223. FROM MP_VERSION
  224. 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);
  225. 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
  226. MAU.USER_ID AS USER_ID,
  227. (SELECT USER_NAME FROM MP_USER WHERE USER_ID = MAU.USER_ID) AS USER_NAME,
  228. MAU.USER_ATTR_ORDER AS USER_ATTR_ORDER,
  229. MAU.HOSPITAL_ID AS HOSPITAL_ID,
  230. (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''hospital'' AND MP_ATTR.ATTR_ID = MAU.HOSPITAL_ID) AS HOSPITAL_NAME,
  231. MAU.DUTY_ID AS DUTY_ID,
  232. (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''duty'' AND MP_ATTR.ATTR_ID = MAU.DUTY_ID) AS DUTY_NAME,
  233. MAU.WORK_ID AS WORK_ID,
  234. (SELECT ATTR_NAME FROM MP_ATTR WHERE MP_ATTR.ATTR_TYPE = ''work'' AND MP_ATTR.ATTR_ID = MAU.WORK_ID) AS WORK_NAME
  235. FROM
  236. MP_USER_ATTR MAU
  237. WHERE
  238. 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);
  239. 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
  240. MP_USER
  241. SET
  242. USE_ATTR_ORDER = :useAttrOrder
  243. WHERE
  244. 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');
  245. REM INSERTING into MP_API_HEADER
  246. SET DEFINE OFF;
  247. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (6,2,'Accept','application/json');
  248. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (8,8,'Accept','application/json');
  249. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (7,3,'Accept','application/json');
  250. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (36,29,'Accept','application/json');
  251. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (38,31,'Accept','application/json');
  252. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (5,1,'Accept','application/json');
  253. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (1,27,'Accept','application/json');
  254. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (2,30,'Accept','application/json');
  255. Insert into MP_API_HEADER (HEADER_SEQ,API_SEQ,HEADER_NAME,HEADER_VALUE) values (21,28,'Accept','application/json');
  256. REM INSERTING into MP_API_PARAM
  257. SET DEFINE OFF;
  258. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,25,'STRING',null,'userId','1512202');
  259. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,23,'STRING','사용자 ID','userId','03000000');
  260. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,23,'STRING','SHA256해쉬(솔트적용)','passwordValue',null);
  261. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,13,'STRING',null,'userId','03000000');
  262. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,14,'STRING',null,'userId','03000000');
  263. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,2,'STRING',null,'userId','03000000');
  264. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,8,'STRING','사용자 ID','userId','03000000');
  265. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,2,'STRING',null,'startDt','20160101');
  266. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,2,'STRING',null,'endDt','20160317');
  267. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,3,'STRING',null,'userId','03000000');
  268. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,24,'STRING',null,'userId','03000000');
  269. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,29,'STRING',null,'userId','1512201');
  270. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (85,29,'STRING',null,'zipCode','1234');
  271. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (86,29,'STRING',null,'zipCodeTxt','서울 금천구 ');
  272. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (87,29,'STRING',null,'address','삼성리더스타워 ');
  273. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (90,31,'STRING',null,'userId','03000000');
  274. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (91,31,'STRING',null,'vehicleNo','실험1234');
  275. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (8,5,'STRING','사용자 ID','userId','03000000');
  276. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (9,5,'STRING','시작날짜 ','startDate','20160101');
  277. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (10,5,'STRING','종료날짜 ','endDate','20160101');
  278. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (11,6,'STRING','삭제할날짜','deleteDay','20160101');
  279. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (56,22,'STRING','사용자 ID','userId','03000000');
  280. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (57,22,'STRING','SHA256 해쉬 (솔트적용)','passwordValue',null);
  281. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (72,32,'STRING','사용자 ID','userId','03000000');
  282. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (81,35,'STRING','플랫폼유형','platformType','I');
  283. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (5,1,'STRING',null,'userId','03000000');
  284. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (6,4,'STRING','접근할 도우미 메시지 시퀀스','accessSeq','123');
  285. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (7,4,'STRING','접근할 도우미 시퀀스 접근 키 ','accessKey','abcdefg');
  286. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (82,36,'STRING','플랫폼 유형 ','platformType','I');
  287. 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');
  288. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (84,36,'STRING','인증서유형','certType','AppStore');
  289. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (37,10,'STRING','사용자 이름','userName','홍길동');
  290. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (38,10,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.');
  291. 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');
  292. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (40,10,'STRING','단계 ','stageOrder','30');
  293. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (27,7,'STRING','사용자 ID','userId','03000000');
  294. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (28,7,'STRING','사용자 이름','userName','홍길동');
  295. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (29,7,'STRING','보낼 메시지','messageValue','가내두루평안하신지요?');
  296. 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');
  297. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (31,9,'STRING','사용자 ID ','userId','03000000');
  298. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (32,9,'STRING','사용자 이름','userName','홍길동');
  299. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (33,9,'STRING','보낼 메시지','messageValue','300원이 수납되었습니다.');
  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');
  301. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (35,9,'STRING','단계 ','stageOrder','30');
  302. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (36,10,'STRING','사용자 ID ','userId','03000000');
  303. 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');
  304. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (74,33,'STRING','사용자 ID','receiverId','111');
  305. 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');
  306. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (76,33,'STRING','인증서 유형 ','certType','InHouse');
  307. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (77,34,'STRING','토큰','deviceTokenId','111');
  308. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (78,34,'STRING','사용자 ID','receiverId','111');
  309. 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');
  310. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (80,34,'STRING','인증서 유형 ','certType','InHouse');
  311. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (183,51,'STRING','메시지 형식','guide','guide');
  312. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (184,51,'STRING','사용자 ID','userId','03000000');
  313. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (185,51,'STRING','사용자 이름','userName','홍길동');
  314. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (186,51,'STRING','보낼 메시지 ','messageValue','실험입니다.');
  315. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (187,51,'STRING','어떤 단계의 메시지인지','stageOrder','10');
  316. 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');
  317. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1,27,'STRING','이름','userName','권혜은');
  318. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (2,27,'STRING','전화번호','cellphoneNo','01020125023');
  319. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (3,30,'STRING',null,'userId','03000000');
  320. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (4,30,'STRING',null,'cellphoneNo','01011112222');
  321. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (21,19,'STRING','사용자 ID','userId','03000000');
  322. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (22,20,'STRING','사용자 ID','userId','03000000');
  323. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (23,21,'STRING','조회할기준일','baseDay','10');
  324. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (24,28,'STRING','사용자 ID','userId','1512202');
  325. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (25,82,'STRING',null,'userId','1512202');
  326. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1683,162,'NUMBER',null,'useAttrOrder','0');
  327. Insert into MP_API_PARAM (PARAM_SEQ,API_SEQ,DATA_TYPE,PARAM_DESC,PARAM_NAME,SAMPLE_VALUE) values (1870,162,'STRING',null,'userId','1512202');
  328. REM INSERTING into MP_ATTR_TYPE
  329. SET DEFINE OFF;
  330. Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (1,'hospital','소속');
  331. Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (2,'duty','직무');
  332. Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (3,'work','업무');
  333. Insert into MP_ATTR_TYPE (ATTR_TYPE_SEQ,ATTR_TYPE,ATTR_TYPE_NAME) values (21,'extra','추가속성');
  334. REM INSERTING into MP_ATTR
  335. SET DEFINE OFF;
  336. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (1,'hospital','seoul','서울','none');
  337. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (2,'hospital','guri','구리','none');
  338. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (3,'duty','medical','의료','none');
  339. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (4,'duty','nurse','간호','none');
  340. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (5,'duty','general','일반','none');
  341. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (6,'work','treatment','진료의','medical');
  342. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (7,'work','doctor','주치의','medical');
  343. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (8,'work','ward_nurse','병동 간호','nurse');
  344. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (9,'work','treatment_nurse','진료 간호','nurse');
  345. Insert into MP_ATTR (ATTR_SEQ,ATTR_TYPE,ATTR_ID,ATTR_NAME,UPPER_ATTR) values (10,'work','normal','일반','general');
  346. REM INSERTING into MP_AUTH
  347. SET DEFINE OFF;
  348. Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (1,'auth02','권한1','권한1');
  349. Insert into MP_AUTH (AUTH_SEQ,AUTH_ID,AUTH_NAME,AUTH_DESC) values (2,'auth01','권한2','권한2');
  350. REM INSERTING into MP_AUTH_ATTR
  351. SET DEFINE OFF;
  352. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (1,'auth01','add','hospital','seoul');
  353. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (2,'auth01','add','hospital','guri');
  354. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (3,'auth02','add','hospital','seoul');
  355. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (4,'auth02','add','work','doctor');
  356. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (5,'auth02','add','duty','medical');
  357. Insert into MP_AUTH_ATTR (AUTH_ATTR_SEQ,AUTH_ID,AUTH_TYPE,AUTH_ATTR_TYPE,AUTH_ATTR_ID) values (6,'auth02','minus','work','normal');
  358. REM INSERTING into MP_DEMO_USER
  359. SET DEFINE OFF;
  360. 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);
  361. 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);
  362. 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);
  363. 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);
  364. 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);
  365. 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);
  366. 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);
  367. 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','서울 금천구 ','삼성리더스타워 ');
  368. 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 (한남동, 응봉공원 숲속 유아쉼터)','테스트');
  369. 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);
  370. 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);
  371. 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);
  372. 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);
  373. REM INSERTING into MP_HELPER_CONTENTS
  374. SET DEFINE OFF;
  375. REM INSERTING into MP_I18N
  376. SET DEFINE OFF;
  377. REM INSERTING into MP_INF_NURSE
  378. SET DEFINE OFF;
  379. REM INSERTING into MP_INF_PUSH_MSG
  380. SET DEFINE OFF;
  381. 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'));
  382. REM INSERTING into MP_LOGIN_HISTORY
  383. SET DEFINE OFF;
  384. 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');
  385. 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');
  386. 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');
  387. 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');
  388. 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');
  389. 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');
  390. 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');
  391. 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');
  392. REM INSERTING into MP_MANAGER
  393. SET DEFINE OFF;
  394. 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)');
  395. REM INSERTING into MP_MENU
  396. SET DEFINE OFF;
  397. 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');
  398. 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');
  399. 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');
  400. 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');
  401. 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');
  402. 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');
  403. 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');
  404. 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');
  405. 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');
  406. 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');
  407. 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');
  408. 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');
  409. 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');
  410. 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');
  411. 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');
  412. 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');
  413. 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');
  414. 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');
  415. 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');
  416. 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');
  417. 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');
  418. 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');
  419. 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');
  420. 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');
  421. 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 찾기와 비밀번호 찾기를 위한 메뉴
  422. - 이 메뉴는 보이지 않지만, 하위의 사용자 ID 찾기와 비밀번호 찾기는 접근할 수 있는 메뉴임','N','N','N');
  423. 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');
  424. 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');
  425. 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');
  426. 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');
  427. 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,'- 사용등록 후 최초로 약관 동의하는 페이지
  428. - 로그인하다가 추가로 동의할게 있으면 오는 페이지
  429. - 사용등록 시 가입은 되었으나, 로그인은 하지 않은 상태로 사용자가 여기에 오게 됨','N','N','N');
  430. 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');
  431. 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');
  432. 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');
  433. 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');
  434. 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');
  435. 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');
  436. 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');
  437. 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');
  438. 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');
  439. 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','로그인 후 사이드 메뉴에 표시되는 도움말
  440. 이었는데.. 시작메뉴에 아이콘이 너무 많아서 도움말은 사이드로 배치','N','Y','Y');
  441. 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');
  442. 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');
  443. 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');
  444. 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');
  445. 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');
  446. 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');
  447. 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');
  448. 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');
  449. 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');
  450. 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');
  451. 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');
  452. 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');
  453. 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');
  454. 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');
  455. 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');
  456. 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');
  457. 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');
  458. 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');
  459. 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');
  460. 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');
  461. 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');
  462. 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');
  463. REM INSERTING into MP_MENU_AUTH
  464. SET DEFINE OFF;
  465. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (16,'waitingTime','auth02');
  466. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (24,'payment','auth02');
  467. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (15,'helper','auth01');
  468. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (17,'nextLocation','auth01');
  469. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (32,'reservation','auth02');
  470. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (23,'mobileCard','auth02');
  471. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (28,'announceArrival','auth02');
  472. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (29,'prescription','auth02');
  473. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (33,'treatmentHistory','auth02');
  474. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (2,'telNo','auth01');
  475. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (26,'openMap','auth02');
  476. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (27,'resultExam','auth02');
  477. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (18,'gMap','auth02');
  478. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (19,'help','auth01');
  479. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (21,'checkProgramVersion','auth02');
  480. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (8,'ticket','auth02');
  481. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (9,'outpatientBrochure','auth02');
  482. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (10,'outpatientBrochure','auth01');
  483. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (31,'medicineSearch','auth01');
  484. Insert into MP_MENU_AUTH (MENU_AUTH_SEQ,MENU_ID,AUTH_ID) values (34,'inpatientExam','auth02');
  485. REM INSERTING into MP_MENU_PARAM
  486. SET DEFINE OFF;
  487. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (1,'ticket','sendTimeNum','STRING','3','호출 횟수');
  488. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (2,'appointmentSearch','periodDay','NUMBER','30','기본 검색기간 (일)');
  489. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (43,'prescription','periodDay','NUMBER','30','기본 검색기간 (일)');
  490. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (44,'treatmentHistory','periodDay','NUMBER','30','기본 검색기간 (일)');
  491. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (6,'checkAgreementList','minimum','NUMBER','3','전체동의 보이는 최저 갯수');
  492. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (7,'userAgreement','minimum','NUMBER','3','전체동의 보이는 최저 갯수');
  493. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (42,'resultExam','periodDay','NUMBER','30','기본 검색기간 (일)');
  494. Insert into MP_MENU_PARAM (MENU_PARAM_SEQ,MENU_ID,PARAM_NAME,DATA_TYPE,PARAM_VALUE,PARAM_DESC) values (41,'healthHandbook','periodDay','NUMBER','30','기본 검색기간 (일)');
  495. REM INSERTING into MP_MNS_MSGMAPPING
  496. SET DEFINE OFF;
  497. REM INSERTING into MP_PAYMENT_MASTER
  498. SET DEFINE OFF;
  499. REM INSERTING into MP_PUBLIC_DEVICE
  500. SET DEFINE OFF;
  501. REM INSERTING into MP_PUSH_FORM
  502. SET DEFINE OFF;
  503. 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'));
  504. 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'));
  505. 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'));
  506. 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'));
  507. 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'));
  508. 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'));
  509. 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'));
  510. 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'));
  511. 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'));
  512. 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'));
  513. 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'));
  514. 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'));
  515. 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'));
  516. 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'));
  517. 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'));
  518. 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'));
  519. 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'));
  520. 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'));
  521. 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'));
  522. 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'));
  523. 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'));
  524. 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'));
  525. REM INSERTING into MP_TELNO
  526. SET DEFINE OFF;
  527. Insert into MP_TELNO (TELNO_SEQ,BUILDING_DESC,ROOM_DESC,TEL_VALUE,TELNO_ORDER) values (1,'건물1','1호','02-123-4567',13);
  528. REM INSERTING into MP_USER
  529. SET DEFINE OFF;
  530. 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);
  531. 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);
  532. 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);
  533. 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);
  534. 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);
  535. 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);
  536. 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);
  537. 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);
  538. 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);
  539. 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);
  540. 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);
  541. 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);
  542. 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);
  543. REM INSERTING into MP_USER_ATTR
  544. SET DEFINE OFF;
  545. 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');
  546. 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');
  547. 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');
  548. 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');
  549. 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');
  550. 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');
  551. 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');
  552. 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');
  553. 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');
  554. 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');
  555. 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');
  556. 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');
  557. 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');
  558. 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');
  559. REM INSERTING into MP_VERSION
  560. SET DEFINE OFF;
  561. Insert into MP_VERSION (PLATFORM_TYPE,CERT_TYPE,VERSION_ORDER,APP_NAME,MARKET_URL) values ('I','InHouse',1,'M-Care (Demo)',null);
  562. REM INSERTING into MP_EVENT_LOG
  563. SET DEFINE OFF;
  564. REM INSERTING into MP_EXTRA_ATTR
  565. SET DEFINE OFF;
  566. Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (1,'extraAttr01','추가 속성1','테스트');
  567. Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (2,'extraAttr02','추가 속성2','2');
  568. Insert into MP_EXTRA_ATTR (EXTRA_ATTR_SEQ,EXTRA_ATTR_ID,EXTRA_ATTR_NAME,EXTRA_ATTR_DESC) values (21,'extraAttr03','추가 속성3','테스트03');
  569. REM INSERTING into MP_EXTRA_ATTR_USER
  570. SET DEFINE OFF;
  571. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (1,'extraAttr03','1512202',1);
  572. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (2,'extraAttr01','1512119',1);
  573. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (3,'extraAttr01','1512201',2);
  574. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (4,'extraAttr01','1512202',3);
  575. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (5,'extraAttr02','1512119',1);
  576. Insert into MP_EXTRA_ATTR_USER (EXTRA_ATTR_USER_SEQ,EXTRA_ATTR_ID,USER_ID,EXTRA_ATTR_USER_ORDER) values (6,'extraAttr02','1512202',2);
  577. commit;