專案

一般

配置概況

Feature #144 » tmp_patients.sql

Sashiba Chou, 2024-12-30 14:59

 
-- phpMyAdmin SQL Dump
-- version 5.0.4
-- https://www.phpmyadmin.net/
--
-- 主機: 127.0.0.1
-- 產生時間: 2024-12-30 15:50:29
-- 伺服器版本: 10.4.16-MariaDB
-- PHP 版本: 7.4.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- 資料庫: `stock`
--

-- --------------------------------------------------------

--
-- 資料表結構 `tmp_patients`
--

CREATE TABLE `tmp_patients` (
`patient_id` varchar(128) NOT NULL,
`hospital_visit_serial_number` varchar(128) NOT NULL,
`triage_raw_data` text NOT NULL,
`er_hpi` text NOT NULL,
`name` varchar(128) NOT NULL,
`current_bed` varchar(64) NOT NULL,
`gender` tinyint(4) NOT NULL,
`age` tinyint(4) NOT NULL,
`triage_level` varchar(64) NOT NULL,
`arrival_datetime` datetime NOT NULL,
`status` varchar(64) NOT NULL,
`lab` text NOT NULL,
`exam` text NOT NULL,
`resident` varchar(128) NOT NULL,
`resident_note` text NOT NULL,
`attending_note` text NOT NULL,
`icd10` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- 傾印資料表的資料 `tmp_patients`
--

INSERT INTO `tmp_patients` (`patient_id`, `hospital_visit_serial_number`, `triage_raw_data`, `er_hpi`, `name`, `current_bed`, `gender`, `age`, `triage_level`, `arrival_datetime`, `status`, `lab`, `exam`, `resident`, `resident_note`, `attending_note`, `icd10`) VALUES
('567', 'HOSP202412050001', '{\r\n \"triage_category\": \"medicine\",\r\n \"triage_level\": \"2\",\r\n \"dnr_status\": \"w/o DNR\",\r\n \"patient_id\": \"567\",\r\n \"patient_name\": \"虛擬病患A\",\r\n \"triage_arival_datetime\": \"2024-12-05 10:25\",\r\n \"triage_departure_datetime\": \"2024-12-05 12:45\",\r\n \"age\": \"65\",\r\n \"triage_means_of_transportation\": \"ems\",\r\n \"triage_reason_of_referral\": null,\r\n \"triage_activity\": \"wheelchair\",\r\n \"glasgow_coma_scale\": {\r\n \"E\": 3,\r\n \"V\": 4,\r\n \"M\": 6\r\n },\r\n \"pupil\": {\r\n \"right\": \"3mm reactive\",\r\n \"left\": \"3mm reactive\"\r\n },\r\n \"vital_signs\": {\r\n \"respiratory_rate\": 20,\r\n \"capillary_refill\": \"< 2s\",\r\n \"oxygen_saturation\": \"96%\",\r\n \"pulse\": \"130 bpm\",\r\n \"blood_pressure\": {\r\n \"site\": \"left_arm\",\r\n \"sbp\": 180,\r\n \"dbp\": 90\r\n },\r\n \"body_temperature\": {\r\n \"method\": \"oral\",\r\n \"value\": 37.2\r\n },\r\n \"blood_glucose\": 150\r\n },\r\n \"weight\": 70,\r\n \"triage_basis\": \"病患為急性胸痛伴有出汗,疑似STEMI,需要緊急心導管檢查\",\r\n \"chief_complaint\": \"胸痛,從胸骨後方開始,持續時間超過20分鐘,伴有冒冷汗和噁心。疼痛分數:8\",\r\n \"medical_history\": \"高血壓, 冠心病, 曾接受支架手術\",\r\n \"allergy_history\": \"青黴素過敏\",\r\n \"travel_history\": \"\",\r\n \"occupation\": \"退休教師\",\r\n \"medication_history\": \"常規服用降血壓藥物,抗血小板藥物\",\r\n \"contact_history\": \"\",\r\n \"cluster_history\": \"\"\r\n}', 'The patient is a 65-year-old retired teacher presenting to the emergency department via EMS with a chief complaint of acute chest pain. The pain began approximately 20 minutes before arrival and is described as substernal, crushing, and radiating. It was accompanied by diaphoresis, nausea, and a sensation of impending doom. Pain intensity is rated as 8/10 at its worst. The patient denies recent physical exertion or trauma as precipitating factors.\r\n\r\nThe patient has a known history of hypertension, coronary artery disease, and a prior stent placement. They report compliance with medications, including antihypertensives and antiplatelet therapy. The patient has a known allergy to penicillin. No recent travel, sick contacts, or cluster exposure is reported.\r\n\r\nOn EMS arrival, vital signs showed a pulse of 130 bpm, blood pressure of 180/90 mmHg (left arm), and oxygen saturation of 96% on room air. On examination, the patient had a Glasgow Coma Scale of E3 V4 M6 (13) with no signs of respiratory distress. Pupils were bilaterally reactive at 3 mm. The patient was diaphoretic and appeared uncomfortable but was able to provide history. Capillary refill was less than 2 seconds.\r\n\r\nInitial evaluation raises concern for ST-elevation myocardial infarction (STEMI). The patient’s triage priority is high, and they were referred for urgent cardiology consultation with plans for expedited cardiac catheterization.\r\n\r\nMedical History: Hypertension, coronary artery disease, prior stent placement.\r\nAllergies: Penicillin.\r\nMedications: Routine use of antihypertensive and antiplatelet agents.\r\nSocial/Family History: Retired, no recent travel, no significant family history provided.', '虛擬病患A', 'C005', 1, 65, 'M-2', '2024-12-05 15:56:12', 'A0002', '[\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"X3556891\",\r\n \"order_code\": \"0314C\",\r\n \"item_name\": \"PT (Prothrombin Time)\", \r\n \"high_low\": \"H\",\r\n \"value\": 15.8,\r\n \"reference_range\": \"(11.0~14.0)\",\r\n \"unit\": \"sec\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:30:12\",\r\n \"result_datetime\": \"2024/12/01 03:45:45\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"X3556892\",\r\n \"order_code\": \"0314D\",\r\n \"item_name\": \"aPTT (Activated Partial Thromboplastin Time)\", \r\n \"high_low\": null,\r\n \"value\": 30.5,\r\n \"reference_range\": \"(25.0~35.0)\",\r\n \"unit\": \"sec\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:30:12\",\r\n \"result_datetime\": \"2024/12/01 03:45:45\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358515\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Hemoglobin血紅素\", \r\n \"high_low\": \"L\",\r\n \"value\": 10.5,\r\n \"reference_range\": \"(12.0~16.0)\",\r\n \"unit\": \"g/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:25:30\",\r\n \"result_datetime\": \"2024/12/01 03:40:10\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358516\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"AST (Aspartate Aminotransferase)\", \r\n \"high_low\": \"H\",\r\n \"value\": 45,\r\n \"reference_range\": \"(0~40)\",\r\n \"unit\": \"U/L\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:28:15\",\r\n \"result_datetime\": \"2024/12/01 03:50:00\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358517\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"ALT (Alanine Aminotransferase)\", \r\n \"high_low\": null,\r\n \"value\": 35,\r\n \"reference_range\": \"(0~40)\",\r\n \"unit\": \"U/L\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:28:15\",\r\n \"result_datetime\": \"2024/12/01 03:50:00\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358518\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Creatinine血清肌酸酐\", \r\n \"high_low\": null,\r\n \"value\": 1.2,\r\n \"reference_range\": \"(0.5~1.4)\",\r\n \"unit\": \"mg/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:27:45\",\r\n \"result_datetime\": \"2024/12/01 03:48:10\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358519\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"BUN (Blood Urea Nitrogen)\", \r\n \"high_low\": null,\r\n \"value\": 18,\r\n \"reference_range\": \"(8~20)\",\r\n \"unit\": \"mg/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:27:45\",\r\n \"result_datetime\": \"2024/12/01 03:48:10\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358520\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Sodium鈉\", \r\n \"high_low\": null,\r\n \"value\": 137,\r\n \"reference_range\": \"(135~145)\",\r\n \"unit\": \"mmol/L\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:26:30\",\r\n \"result_datetime\": \"2024/12/01 03:47:05\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358521\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Potassium鉀\", \r\n \"high_low\": \"H\",\r\n \"value\": 5.1,\r\n \"reference_range\": \"(3.5~5.0)\",\r\n \"unit\": \"mmol/L\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:26:30\",\r\n \"result_datetime\": \"2024/12/01 03:47:05\"\r\n },\r\n {\r\n \"patient_id\": \"451\", \r\n \"exam_lab_serial_number\": \"T0358522\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Troponin I\", \r\n \"high_low\": \"H\",\r\n \"value\": 0.45,\r\n \"reference_range\": \"(0~0.04)\",\r\n \"unit\": \"ng/mL\",\r\n \"sample_datetime\": \"2024/12/01 03:15:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:33:00\",\r\n \"result_datetime\": \"2024/12/01 03:55:00\"\r\n }\r\n]\r\n', 'null', '', '', '', ''),
('453', 'HOSP2024120002', '{\r\n \"triage_category\": \"medicine\",\r\n \"triage_level\": \"2\",\r\n \"dnr_status\": \"w DNR\",\r\n \"patient_id\": \"453\",\r\n \"patient_name\": \"虛擬病患111\",\r\n \"triage_arival_datetime\": \"2024/12/01 03:00:00\",\r\n \"triage_departure_datetime\": \"0000-00-00\",\r\n \"age\": 76,\r\n \"triage_means_of_transportation\": \"friend\",\r\n \"triage_reason_of_referral\": null,\r\n \"triage_activity\": \"bed\",\r\n \"glasgow_coma_scale\": {\r\n \"E\": 4,\r\n \"V\": 4,\r\n \"M\": 5\r\n },\r\n \"pupil\": {\r\n \"right\": \"3mm reactive\",\r\n \"left\": \"3mm reactive\"\r\n },\r\n \"vital_signs\": {\r\n \"respiratory_rate\": 13,\r\n \"capillary_refill\": \"< 2s\",\r\n \"oxygen_saturation\": \"98%\",\r\n \"pulse\": \"83 bpm\",\r\n \"blood_pressure\": {\r\n \"site\": \"right_arm\",\r\n \"sbp\": 122,\r\n \"dbp\": 91\r\n },\r\n \"body_temperature\": {\r\n \"method\": \"ear\",\r\n \"value\": 36.1\r\n },\r\n \"blood_glucose\": 96\r\n },\r\n \"weight\": 63,\r\n \"triage_basis\": \"病患訴頭暈,需要緊急評估。\",\r\n \"chief_complaint\": \"自訴無法呼吸,疼痛分數: 5\",\r\n \"medical_history\": \"慢性腎衰竭\",\r\n \"allergy_history\": \"青黴素過敏\",\r\n \"travel_history\": \"\",\r\n \"occupation\": null,\r\n \"medication_history\": \"常規服藥\",\r\n \"contact_history\": \"\",\r\n \"cluster_history\": \"\"\r\n }', 'The patient is a 76-year-old retired teacher presenting to the emergency department with a chief complaint of inability to breathe. The symptom started acutely prior to arrival and is described as a moderate difficulty breathing, with an associated pain score of 5/10. The patient reports dizziness and a general sense of discomfort, prompting an urgent evaluation. No recent physical exertion or trauma has been reported.\r\n\r\nThe patient has a history of chronic kidney failure and is compliant with routine medication. They report an allergy to penicillin. Travel, contact, and cluster histories are negative.\r\n\r\nOn arrival, the patient was brought in on a bed, appearing moderately distressed. Vital signs showed:\r\n\r\nRespiratory Rate: 13 breaths/min\r\nPulse: 83 bpm\r\nBlood Pressure: 122/91 mmHg (right arm)\r\nOxygen Saturation: 98% on room air\r\nBody Temperature: 36.1°C (ear method)\r\nPhysical examination revealed bilaterally reactive pupils (3 mm), no obvious external injuries, and no cyanosis or pallor. The Glasgow Coma Scale (GCS) was 13 (E4, V5, M4), indicating mild impairment. Capillary refill time was less than 2 seconds, indicating adequate perfusion.\r\n\r\nThe patient is hemodynamically stable but symptomatic. Given the acute onset of respiratory difficulty in the context of chronic kidney disease, the presentation warrants immediate workup for potential fluid overload, electrolyte imbalance, or respiratory compromise. The triage priority is urgent.\r\n\r\nMedical History: Chronic kidney failure\r\nAllergies: Penicillin\r\nMedications: Routine prescription compliance\r\nSocial/Family History: No relevant recent exposures or travel.\r\n\r\nFurther diagnostic workup, including ABG analysis, chest X-ray, and routine labs (CBC, electrolytes, renal function tests), is underway. The patient is being closely monitored in the ED.\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '虛擬病患111', 'R20', 0, 76, 'M-2', '2024-12-05 07:26:21', '07B181', ' [\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682447\",\r\n \"order_code\": \"0314C\",\r\n \"item_name\": \"PT (Prothrombin Time)\",\r\n \"high_low\": \"H\",\r\n \"value\": 15.2,\r\n \"reference_range\": \"(11.0~14.0)\",\r\n \"unit\": \"sec\",\r\n \"sample_datetime\": \"2024/12/01 03:04:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:12:00\",\r\n \"result_datetime\": \"2024/12/01 03:31:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682823\",\r\n \"order_code\": \"0314D\",\r\n \"item_name\": \"aPTT (Activated Partial Thromboplastin Time)\",\r\n \"high_low\": null,\r\n \"value\": 26.4,\r\n \"reference_range\": \"(25.0~35.0)\",\r\n \"unit\": \"sec\",\r\n \"sample_datetime\": \"2024/12/01 03:00:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:09:00\",\r\n \"result_datetime\": \"2024/12/01 03:20:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682404\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Hemoglobin血紅素\",\r\n \"high_low\": \"L\",\r\n \"value\": 9.7,\r\n \"reference_range\": \"(12.0~16.0)\",\r\n \"unit\": \"g/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:03:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:14:00\",\r\n \"result_datetime\": \"2024/12/01 03:33:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682110\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"AST (Aspartate Aminotransferase)\",\r\n \"high_low\": \"H\",\r\n \"value\": 51,\r\n \"reference_range\": \"(0~40)\",\r\n \"unit\": \"U/L\",\r\n \"sample_datetime\": \"2024/12/01 03:04:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:16:00\",\r\n \"result_datetime\": \"2024/12/01 03:35:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682253\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"ALT (Alanine Aminotransferase)\",\r\n \"high_low\": null,\r\n \"value\": 47,\r\n \"reference_range\": \"(0~40)\",\r\n \"unit\": \"U/L\",\r\n \"sample_datetime\": \"2024/12/01 03:04:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:19:00\",\r\n \"result_datetime\": \"2024/12/01 03:39:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682683\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Creatinine血清肌酸酐\",\r\n \"high_low\": null,\r\n \"value\": 0.9,\r\n \"reference_range\": \"(0.5~1.4)\",\r\n \"unit\": \"mg/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:00:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:12:00\",\r\n \"result_datetime\": \"2024/12/01 03:30:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682100\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"BUN (Blood Urea Nitrogen)\",\r\n \"high_low\": null,\r\n \"value\": 23,\r\n \"reference_range\": \"(8~20)\",\r\n \"unit\": \"mg/dL\",\r\n \"sample_datetime\": \"2024/12/01 03:02:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:13:00\",\r\n \"result_datetime\": \"2024/12/01 03:28:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682752\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Sodium鈉\",\r\n \"high_low\": null,\r\n \"value\": 144,\r\n \"reference_range\": \"(135~145)\",\r\n \"unit\": \"mmol/L\",\r\n \"sample_datetime\": \"2024/12/01 03:10:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:18:00\",\r\n \"result_datetime\": \"2024/12/01 03:29:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682600\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Potassium鉀\",\r\n \"high_low\": null,\r\n \"value\": 3.8,\r\n \"reference_range\": \"(3.5~5.0)\",\r\n \"unit\": \"mmol/L\",\r\n \"sample_datetime\": \"2024/12/01 03:08:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:18:00\",\r\n \"result_datetime\": \"2024/12/01 03:36:00\"\r\n },\r\n {\r\n \"patient_id\": \"453\",\r\n \"exam_lab_serial_number\": \"X355682336\",\r\n \"order_code\": \"0305\",\r\n \"item_name\": \"Troponin I\",\r\n \"high_low\": \"H\",\r\n \"value\": 0.75,\r\n \"reference_range\": \"(0~0.04)\",\r\n \"unit\": \"ng/mL\",\r\n \"sample_datetime\": \"2024/12/01 03:10:00\",\r\n \"receipt_datetime\": \"2024/12/01 03:21:00\",\r\n \"result_datetime\": \"2024/12/01 03:40:00\"\r\n }\r\n ]', '[\r\n {\r\n \"patient_id\": \"453\", \r\n \"exam_lab_serial_number\" : \"N0202886\",\r\n \"order_datetime\" : \"2024/11/30 01:10:33\",\r\n \"finish_datetime\" : \"2024/11/30 01:22:58\",\r\n \"result_datetime\": \"2024/11/30 02:01:15\",\r\n \"diagnosis\" : \"急性胃炎, 未提及出血\",\r\n \"item_name\" : \"72WHABCT-Whole Abdomen(含Pelvis) 有/\",\r\n \"report_doctor\" : \"...\",\r\n \"report\" : \"Computed tomography (CT) of the Abdomen:\r\n \r\nFindings:\r\nThe pre- and post-enhanced axial and reformatted images were obtained\r\n with a multidetector computed tomography.\r\nThe surface of the liver is regular and smooth.\r\nNo intrahepatic space-occupying lesion is noted.\r\nThe gallbladder and bile ducts are unremarkable.\r\nThe pancreas and spleen and both kidneys are also unremarkable.\r\nThe collecting systems are well-opacified without dilatation.\r\nNo enlarged lymph node is found.\r\nThe bony structures are intact.\r\nNo focal osteolytic lesion is depicted.\r\nThe abdomen is free of abnormal fluid collection.\r\n \r\nImpression:\r\nImpression:\r\nNo acute intra-abdominal pathology identified.\r\nFindings consistent with chronic kidney disease (bilateral mild cortical thinning).\r\nNo evidence of bowel obstruction, perforation, or other acute surgical conditions.\r\n (END\"\r\n }\r\n]', '', '', '', '');
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
    (1-1/1)