DATABASE MODHOSPITAL.KR — 45K KOREAN HOSPITAL PATIENT & SYSTEM RECORDS 14.01.2026

Quote:INSERT INTO `ocs_patient` (`no`, `name`, `chartid`, `authid`, `creationtime`, `hid`, `room`, `bedno`, `doctorno`, `logintime`, `islogin`, `fee_sum`, `fee_paid`, `clinic`, `checkindate`, `checkoutdate`, `checkouttime`, `ischeckout`, `round_am`, `round_pm`, `mobile`, `istest`, `usingmod`, `etc`, `updatetime`, `authsent`, `age`, `sex`, `param1`, `param2`) VALUES

(288855299, '권영숙', '00127411', '34526', '2026-01-08 23:29:03', 'IM69', '1004', '4', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-09', NULL, NULL, 1, NULL, NULL, '010-5212-2360', 0, 1, NULL, '2026-01-10 11:44:01', 0, 70, 'F', '{"PATNAME":"권영숙","PATID":"00127411","HANDPHONENO":"010-5212-2360","STEP":"퇴원예약","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"1004","BEDNO":"4","AGE":"70","SEX":"F","ADMAPPLYDATE":"20260109","ADMAPPLYTIME":"0828","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"손목터널증후군","OPDATE":"20260109"}', NULL),
(288918011, '박노례', '00344567', '30681', '2026-01-10 01:16:03', 'IM69', '1005', '3', 316554, NULL, 0, NULL, NULL, '정형외과(OLS)', '2026-01-11', NULL, NULL, 0, NULL, NULL, '010-8743-3184', 0, 1, NULL, '2026-01-14 19:06:03', 0, 71, 'F', '{"PATNAME":"박노례","PATID":"00344567","HANDPHONENO":"010-8743-3184","STEP":"재원","DEPTCD":"OLS","DEPTNM":"정형외과(OLS)","DRID":"10002","DRNM":"유석주","ROOMCODE":"1005","BEDNO":"3","AGE":"71","SEX":"F","ADMAPPLYDATE":"20260111","ADMAPPLYTIME":"1600","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"양쪽 원발성 무릎관절증","OPDATE":"20260112"}', NULL),
(288918081, '염은자', '00343580', '57741', '2026-01-10 01:18:02', 'IM69', '1004', '3', 316554, NULL, 0, NULL, NULL, '정형외과(OLS)', '2026-01-11', NULL, NULL, 0, NULL, NULL, '010-3887-4055', 0, 1, NULL, '2026-01-14 19:06:02', 0, 83, 'F', '{"PATNAME":"염은자","PATID":"00343580","HANDPHONENO":"010-3887-4055","STEP":"재원","DEPTCD":"OLS","DEPTNM":"정형외과(OLS)","DRID":"10002","DRNM":"유석주","ROOMCODE":"1004","BEDNO":"3","AGE":"83","SEX":"F","ADMAPPLYDATE":"20260111","ADMAPPLYTIME":"1600","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":"20260112"}', NULL),
(289014968, '김영길', '00345351', '42920', '2026-01-12 03:31:02', 'IM69', '1004', '1', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-12', NULL, NULL, 1, NULL, NULL, '010-9676-2820', 0, 1, NULL, '2026-01-14 09:57:02', 0, 87, 'F', '{"PATNAME":"김영길","PATID":"00345351","HANDPHONENO":"010-9676-2820","STEP":"퇴원예약","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"1004","BEDNO":"1","AGE":"87","SEX":"F","ADMAPPLYDATE":"20260112","ADMAPPLYTIME":"1113","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":"20260112"}', NULL),
(289019570, '장종태', '00344991', '79957', '2026-01-12 06:04:04', 'IM69', '1003', '1', 316571, NULL, 0, NULL, NULL, '신경외과(NDG)', '2026-01-12', NULL, NULL, 0, NULL, NULL, '010-6273-6755', 0, 1, NULL, '2026-01-14 19:06:03', 0, 67, 'M', '{"PATNAME":"장종태","PATID":"00344991","HANDPHONENO":"010-6273-6755","STEP":"재원","DEPTCD":"NDG","DEPTNM":"신경외과(NDG)","DRID":"10107","DRNM":"김도근","ROOMCODE":"1003","BEDNO":"1","AGE":"67","SEX":"M","ADMAPPLYDATE":"20260112","ADMAPPLYTIME":"1244","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"신경뿌리병증을 동반한 요추 및 기타 추간판장애(G55.1*)","OPDATE":"20260113"}', NULL),
(289020066, '김경미', '00345344', '75620', '2026-01-12 06:20:03', 'IM69', '1006', '2', 316571, NULL, 0, NULL, NULL, '신경외과(NDG)', '2026-01-12', NULL, NULL, 1, NULL, NULL, '010-3464-2070', 0, 1, NULL, '2026-01-12 17:40:03', 0, 54, 'F', '{"PATNAME":"김경미","PATID":"00345344","HANDPHONENO":"010-3464-2070","STEP":"퇴원예약","DEPTCD":"NDG","DEPTNM":"신경외과(NDG)","DRID":"10107","DRNM":"김도근","ROOMCODE":"1006","BEDNO":"2","AGE":"54","SEX":"F","ADMAPPLYDATE":"20260112","ADMAPPLYTIME":"0905","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":""}', NULL),
(289058193, '박종대', '00342250', '21997', '2026-01-13 02:17:02', 'IM69', '1008', '3', 316554, NULL, 0, NULL, NULL, '정형외과(OLS)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-8620-5564', 0, 1, NULL, '2026-01-14 19:06:03', 0, 72, 'M', '{"PATNAME":"박종대","PATID":"00342250","HANDPHONENO":"010-8620-5564","STEP":"재원","DEPTCD":"OLS","DEPTNM":"정형외과(OLS)","DRID":"10002","DRNM":"유석주","ROOMCODE":"1008","BEDNO":"3","AGE":"72","SEX":"M","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"0946","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":"20260114"}', NULL),
(289058645, '송정섭', '00082753', '14485', '2026-01-13 02:34:02', 'IM69', '908', '1', 316571, NULL, 0, NULL, NULL, '신경외과(NDG)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-5125-2043', 0, 1, NULL, '2026-01-14 19:07:02', 0, 79, 'M', '{"PATNAME":"송정섭","PATID":"00082753","HANDPHONENO":"010-5125-2043","STEP":"재원","DEPTCD":"NDG","DEPTNM":"신경외과(NDG)","DRID":"10107","DRNM":"김도근","ROOMCODE":"908","BEDNO":"1","AGE":"79","SEX":"M","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"0933","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"척추협착, 요추부","OPDATE":"20260114"}', NULL),
(289063125, '성화영', '00258327', '43206', '2026-01-13 05:14:02', 'IM69', '1005', '4', 316571, NULL, 0, NULL, NULL, '신경외과(NDG)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-3766-8508', 0, 1, NULL, '2026-01-14 19:06:02', 0, 89, 'F', '{"PATNAME":"성화영","PATID":"00258327","HANDPHONENO":"010-3766-8508","STEP":"재원","DEPTCD":"NDG","DEPTNM":"신경외과(NDG)","DRID":"10107","DRNM":"김도근","ROOMCODE":"1005","BEDNO":"4","AGE":"89","SEX":"F","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"1300","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"T11 및 T12 부위의 골절, 폐쇄성","OPDATE":"20260114"}', NULL),
(289063427, '신수희', '00110947', '63345', '2026-01-13 05:24:03', 'IM69', '1007', '3', 316552, NULL, 0, NULL, NULL, '정형외과(ORH)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-7722-4828', 0, 1, NULL, '2026-01-14 19:06:03', 0, 55, 'F', '{"PATNAME":"신수희","PATID":"00110947","HANDPHONENO":"010-7722-4828","STEP":"재원","DEPTCD":"ORH","DEPTNM":"정형외과(ORH)","DRID":"10023","DRNM":"류호광","ROOMCODE":"1007","BEDNO":"3","AGE":"55","SEX":"F","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"1342","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":"20260114"}', NULL),
(289064396, '최영숙', '00345107', '20062', '2026-01-13 05:58:01', 'IM69', '1006', '5', 316570, NULL, 0, NULL, NULL, '신경외과(NHM)', '2026-01-13', NULL, NULL, 1, NULL, NULL, '010-3708-0392', 0, 1, NULL, '2026-01-14 10:49:02', 0, 73, 'F', '{"PATNAME":"최영숙","PATID":"00345107","HANDPHONENO":"010-3708-0392","STEP":"퇴원예약","DEPTCD":"NHM","DEPTNM":"신경외과(NHM)","DRID":"10106","DRNM":"김형민","ROOMCODE":"1006","BEDNO":"5","AGE":"73","SEX":"F","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"1008","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"척추협착, 요추부","OPDATE":""}', NULL),
(289065051, '서한나', '00345253', '31237', '2026-01-13 06:19:04', 'IM69', '906', '4', 316571, NULL, 0, NULL, NULL, '신경외과(NDG)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-5654-2500', 0, 1, NULL, '2026-01-14 19:06:02', 0, 34, 'F', '{"PATNAME":"서한나","PATID":"00345253","HANDPHONENO":"010-5654-2500","STEP":"재원","DEPTCD":"NDG","DEPTNM":"신경외과(NDG)","DRID":"10107","DRNM":"김도근","ROOMCODE":"906","BEDNO":"4","AGE":"34","SEX":"F","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"1158","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":"20260114"}', NULL),
(289065194, '이기숙', '00345058', '97399', '2026-01-13 06:24:03', 'IM69', '1004', '2', 316558, NULL, 0, NULL, NULL, '정형외과(OTS)', '2026-01-13', NULL, NULL, 0, NULL, NULL, '010-3768-8839', 0, 1, NULL, '2026-01-14 19:06:03', 0, 68, 'F', '{"PATNAME":"이기숙","PATID":"00345058","HANDPHONENO":"010-3768-8839","STEP":"재원","DEPTCD":"OTS","DEPTNM":"정형외과(OTS)","DRID":"10077","DRNM":"안태수","ROOMCODE":"1004","BEDNO":"2","AGE":"68","SEX":"F","ADMAPPLYDATE":"20260113","ADMAPPLYTIME":"1357","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"회전근개증후군","OPDATE":"20260114"}', NULL),
(289103127, '이영희', '00345393', '78477', '2026-01-14 01:37:02', 'IM69', '1006', '1', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-9902-7405', 0, 1, NULL, '2026-01-14 19:06:02', 0, 65, 'F', '{"PATNAME":"이영희","PATID":"00345393","HANDPHONENO":"010-9902-7405","STEP":"재원","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"1006","BEDNO":"1","AGE":"65","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"0921","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"","OPDATE":""}', NULL),
(289104143, '이수자', '00195952', '77789', '2026-01-14 02:10:01', 'IM69', '1006', '2', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-8701-8899', 0, 1, NULL, '2026-01-14 19:07:02', 0, 83, 'F', '{"PATNAME":"이수자","PATID":"00195952","HANDPHONENO":"010-8701-8899","STEP":"재원","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"1006","BEDNO":"2","AGE":"83","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"0903","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"회전근개증후군","OPDATE":""}', NULL),
(289105651, '홍태선', '00344955', '60595', '2026-01-14 02:58:03', 'IM69', '907', '1', 316552, NULL, 0, NULL, NULL, '정형외과(ORH)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-2796-9252', 0, 1, NULL, '2026-01-14 19:07:02', 0, 72, 'F', '{"PATNAME":"홍태선","PATID":"00344955","HANDPHONENO":"010-2796-9252","STEP":"재원","DEPTCD":"ORH","DEPTNM":"정형외과(ORH)","DRID":"10023","DRNM":"류호광","ROOMCODE":"907","BEDNO":"1","AGE":"72","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"0955","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"원발성 무릎관절증 NOS","OPDATE":""}', NULL),
(289110283, '민지현', '00345279', '23831', '2026-01-14 05:24:01', 'IM69', '1006', '5', 316552, NULL, 0, NULL, NULL, '정형외과(ORH)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-4329-7396', 0, 1, NULL, '2026-01-14 19:06:03', 0, 43, 'F', '{"PATNAME":"민지현","PATID":"00345279","HANDPHONENO":"010-4329-7396","STEP":"재원","DEPTCD":"ORH","DEPTNM":"정형외과(ORH)","DRID":"10023","DRNM":"류호광","ROOMCODE":"1006","BEDNO":"5","AGE":"43","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"1355","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"전십자인대의 파열","OPDATE":""}', NULL),
(289111337, '손주영', '00345402', NULL, '2026-01-14 05:56:05', 'IM69', '908', '6', 316558, NULL, 0, NULL, NULL, '정형외과(OTS)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-4334-3695', 0, 1, NULL, '2026-01-14 19:06:04', 0, 21, 'M', '{"PATNAME":"손주영","PATID":"00345402","HANDPHONENO":"010-4334-3695","STEP":"재원","DEPTCD":"OTS","DEPTNM":"정형외과(OTS)","DRID":"10077","DRNM":"안태수","ROOMCODE":"908","BEDNO":"6","AGE":"21","SEX":"M","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"1421","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"외측복사의 골절, 폐쇄성","OPDATE":""}', NULL),
(289111407, '이현주', '00099818', '20135', '2026-01-14 05:59:02', 'IM69', '904', '4', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-2733-2759', 0, 1, NULL, '2026-01-14 19:06:02', 0, 69, 'F', '{"PATNAME":"이현주","PATID":"00099818","HANDPHONENO":"010-2733-2759","STEP":"재원","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"904","BEDNO":"4","AGE":"69","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"1340","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"요골 하단의 상세불명 골절, 폐쇄성","OPDATE":""}', NULL),
(289113103, '김영태', '00118702', '63411', '2026-01-14 06:48:04', 'IM69', '905', '4', 316553, NULL, 0, NULL, NULL, '정형외과(OHS)', '2026-01-14', NULL, NULL, 0, NULL, NULL, '010-5808-9336', 0, 1, NULL, '2026-01-14 19:06:03', 0, 70, 'F', '{"PATNAME":"김영태","PATID":"00118702","HANDPHONENO":"010-5808-9336","STEP":"재원","DEPTCD":"OHS","DEPTNM":"정형외과(OHS)","DRID":"10029","DRNM":"홍수헌","ROOMCODE":"905","BEDNO":"4","AGE":"70","SEX":"F","ADMAPPLYDATE":"20260114","ADMAPPLYTIME":"1402","LEAVEROOMDATE":"","LEAVEROOMTIME":"","DXNAME":"아래팔 부위의 기타 손가락의 신근 및 힘줄의 손상, 기타 및 상세불명의 손상","OPDATE":""}', NULL);​

Click to expand...