iT邦幫忙

2025 iThome 鐵人賽
DAY 12
0
自我挑戰組

基於 Oracle 資料庫的醫院電子病歷系統設計與建置系列 第 12 篇

Day12：資料插入(3/3)

17th鐵人賽
19 瀏覽

  • 分享至 

  • xImage
    •  

大家好，今天要跟大家分享的最後一批資料插入的表為：

  • 病患病歷表 - Records
  • 診斷記錄表 - Diagnoses
  • 處方籤表 - Prescriptions
  • 過敏記錄表 - AllergyRecords
  • 手術記錄表 - SurgeryRecords
  1. 病患病歷表 - Records
INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3001,
10342,
1023,
35102,
'高血壓家族史',
'吸菸',
'心導管置放術',
'曾住院治療胸痛',
'花粉過敏',
'COVID-19疫苗',
TO_DATE('2022-08-19','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3002,
12491,
1056,
36215,
'癲癇家族史',
'熬夜',
'顱內電極植入手術',
'無住院紀錄',
'無',
'流感疫苗',
TO_DATE('2022-12-26','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3003,
13577,
1098,
38541,
'無',
'偏食',
'腫瘤切除手術',
'曾因腫瘤住院',
'蝦類過敏',
'B型肝炎疫苗',
TO_DATE('2025-09-21','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3004,
14620,
1132,
39673,
'無',
'熬夜',
'腦部腫瘤切除手術',
'曾住院神經科',
'花生過敏',
'COVID-19疫苗',
TO_DATE('2022-02-19','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3005,
15834,
1175,
37488,
'無',
'無',
'無',
'小兒科急診觀察',
'無',
'五合一疫苗',
TO_DATE('2023-06-28','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3006,
16988,
1209,
40756,
'高血脂家族史',
'高油飲食',
'膽囊切除手術',
'曾住院外科',
'牛奶過敏',
'B型肝炎疫苗',
TO_DATE('2023-11-11','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3007,
17241,
1244,
41839,
'過敏體質家族史',
'熬夜',
'無',
'皮膚科門診',
'藥物過敏（青黴素）',
'COVID-19疫苗',
TO_DATE('2022-07-05','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3008,
18395,
1287,
42922,
'無',
'無',
'無',
'心理諮詢門診',
'無',
'HPV疫苗',
TO_DATE('2023-03-24','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3009,
19462,
1321,
44005,
'子宮肌瘤家族史',
'無',
'子宮鏡肌瘤切除手術',
'婦科住院',
'蛋白過敏',
'B型肝炎疫苗',
TO_DATE('2023-09-01','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3010,
20513,
1354,
45188,
'無',
'熬夜',
'無',
'內分泌科門診',
'荷爾蒙藥物過敏',
'流感疫苗',
TO_DATE('2024-01-12','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3011,
21674,
1389,
47554,
'關節炎家族史',
'久坐',
'關節鏡手術',
'骨科住院',
'無',
'COVID-19疫苗',
TO_DATE('2024-11-25','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3012,
22735,
1423,
48737,
'胃食道逆流家族史',
'高油飲食',
'胃鏡下修復手術',
'消化科門診',
'無',
'B型肝炎疫苗',
TO_DATE('2024-07-16','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3013,
23896,
1456,
49920,
'腎臟病家族史',
'無',
'腎臟活檢術',
'泌尿科住院',
'無',
'COVID-19疫苗',
TO_DATE('2025-04-02','YYYY-MM-DD')
)

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3014,
24957,
149,
51103,
'無',
'熬夜',
'無',
'泌尿科門診',
'藥物過敏（阿斯匹靈）',
'流感疫苗',
TO_DATE('2023-05-21','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3015,
26018,
1524,
52286,
'肝病家族史',
'飲酒',
'肝臟腫瘤切除手術',
'外科住院',
'香水過敏',
'B型肝炎疫苗',
TO_DATE('2022-12-22','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3016,
27179,
1557,
53469,
'無',
'無',
'關節鏡手術',
'骨科門診',
'芒果過敏',
'COVID-19疫苗',
TO_DATE('2024-04-14','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3017,
28340,
1591,
54652,
'無',
'無',
'無',
'感染科門診',
'藥物過敏（止痛藥）',
'流感疫苗',
TO_DATE('2024-03-12','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3018,
29401,
1624,
55835,
'無',
'無',
'無',
'復健科門診',
'蛋黃過敏',
'B型肝炎疫苗',
TO_DATE('2024-01-28','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3019,
30562,
1658,
57018,
'血液疾病家族史',
'無',
'骨髓活檢手術',
'血液腫瘤科住院',
'無',
'COVID-19疫苗',
TO_DATE('2023-06-18','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3020,
34528,
1692,
58101,
'無',
'無',
'病理切片手術',
'外科門診',
'花粉過敏',
'B型肝炎疫苗',
TO_DATE('2025-08-04','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3021,
34689,
1725,
59284,
'無',
'無',
'麻醉前評估處置',
'麻醉科門診',
'無',
'COVID-19疫苗',
TO_DATE('2022-03-03','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3022,
34850,
1759,
60467,
'無',
'無',
'麻醉前評估處置',
'眼科門診',
'無',
'流感疫苗',
TO_DATE('2022-03-13','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3023,
34911,
1793,
61650,
'無',
'熬夜',
'無',
'耳鼻喉科門診',
'藥物過敏（止痛藥）',
'B型肝炎疫苗',
TO_DATE('2024-10-27','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3024,
13284,
1826,
62833,
'無',
'無',
'無',
'健康檢查門診',
'花生過敏',
'COVID-19疫苗',
TO_DATE('2024-10-05','YYYY-MM-DD')
);

INSERT INTO Records(
RecordsID,
AppointmentID,
StaffID,
PATIENTID,
FamilyHistory,
Habits,
SURGICALHISTORY,
HospitalHistory,
AllergyHistory,
VaccinationRecord,
CreateDate
)
VALUES
(3025,
34999,
1859,
39673,
'高血壓家族史',
'久坐',
'無',
'內科門診',
'灰塵過敏',
'B型肝炎疫苗',
TO_DATE('2024-10-05','YYYY-MM-DD')
);

查詢整個資料表：
SELECT * FROM Records;
結果：
https://ithelp.ithome.com.tw/upload/images/20250924/201677876KPAF3JFBU.png
2. 診斷記錄表 - Diagnoses

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600001,
3001,
35102,
'初診',
TO_DATE('2022-08-19','YYYY-MM-DD'),
'胸悶胸痛',
'心音異常',
'疑似冠狀動脈堵塞',
'安排心導管檢查',
'I25.10',
'建議住院進一步觀察'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600002,
3002,
36215,
'初診',
TO_DATE('2022-12-26','YYYY-MM-DD'),
'癲癇發作',
'EEG異常',
'癲癇症候群',
'安排顱內電極植入手術',
'G40.9',
'建議神經科住院觀察'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600003,
3003,
38541,
'初診',
TO_DATE('2025-09-21','YYYY-MM-DD'),
'腹部腫塊',
'腫瘤可觸及',
'腹部腫瘤疑似惡性',
'安排切片與影像檢查',
'C78.7',
'建議手術切除並送病理'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600004,
3004,
39673,
'初診',
TO_DATE('2022-02-19','YYYY-MM-DD'),
'頭痛、視力模糊',
'MRI顯示腫瘤',
'顱內腫瘤',
'安排腦部切除手術',
'D33.0',
'建議術前麻醉評估'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600005,
3005,
37488,
'初診',
TO_DATE('2023-06-28','YYYY-MM-DD'),
'發燒、咳嗽糊',
'體溫38.9°C',
'上呼吸道感染',
'開立退燒藥與觀察',
'J06.9',
'無需手術，門診追蹤'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600006,
3006,
40756,
'初診',
TO_DATE('2023-11-11','YYYY-MM-DD'),
'右上腹痛',
'超音波顯示膽結石',
'急性膽囊炎',
'安排腹腔鏡膽囊切除手術',
'K81.0',
'建議住院手術處理'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600007,
3007,
41839,
'初診',
TO_DATE('2022-07-05','YYYY-MM-DD'),
'皮膚紅疹',
'紅疹分布於背部',
'接觸性皮膚炎',
'開立抗組織胺藥物',
'L23.9',
'建議避免接觸過敏原'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600008,
3008,
42922,
'初診',
TO_DATE('2022-03-24','YYYY-MM-DD'),
'情緒低落',
'PHQ-9分數偏高',
'輕度憂鬱症',
'安排心理諮商與追蹤',
'F32.0',
'建議定期心理評估'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600009,
3009,
44005,
'初診',
TO_DATE('2022-09-01','YYYY-MM-DD'),
'月經過多',
'超音波顯示肌瘤',
'子宮肌瘤',
'安排子宮切除手術',
'D25.2',
'建議術後定期追蹤'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600010,
3010,
45188,
'初診',
TO_DATE('2024-01-12','YYYY-MM-DD'),
'月經不規則',
'賀爾蒙檢查異常',
'荷爾蒙失調',
'開立荷爾蒙調節藥物',
'E28.9',
'建議三週後回診評估'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600011,
3011,
47554,
'初診',
TO_DATE('2024-11-25','YYYY-MM-DD'),
'肘部疼痛',
'關節活動受限',
'滑膜炎',
'安排關節鏡清創術',
'M65.9',
'建議術後物理治療'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600012,
3012,
48737,
'初診',
TO_DATE('2024-07-16','YYYY-MM-DD'),
'胃酸逆流',
'胃鏡顯示食道炎',
'胃食道逆流病',
'開立制酸劑並飲食調整',
'K21.0',
'建議減少刺激性食物'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600013,
3013,
49920,
'初診',
TO_DATE('2025-04-02','YYYY-MM-DD'),
'血尿',
'腎臟腫塊影像異常',
'腎臟病變疑似腫瘤',
'安排腎臟穿刺活檢',
'N28.9',
'建議住院進一步檢查'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600014,
3014,
51103,
'初診',
TO_DATE('2023-05-21','YYYY-MM-DD'),
'頻尿',
'尿液檢查正常',
'輕度膀胱過動症',
'開立抗膀胱收縮藥物',
'N32.81',
'建議觀察排尿頻率'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600015,
3015,
52286,
'初診',
TO_DATE('2022-12-22','YYYY-MM-DD'),
'右上腹腫塊',
'CT顯示肝腫瘤',
'肝臟腫瘤',
'安排肝臟部分切除手術',
'C22.0',
'建議術後監測肝功能'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600016,
3016,
53469,
'初診',
TO_DATE('2024-04-14','YYYY-MM-DD'),
'手部疼痛',
'關節腫脹',
'關節滑膜炎',
'安排關節鏡手術',
'M65.9',
'建議術後避免使用患側'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600017,
3017,
54652,
'初診',
TO_DATE('2024-03-12','YYYY-MM-DD'),
'疲倦、發燒',
'白血球偏低',
'疑似病毒感染',
'安排血液檢查與觀察',
'B34.9',
'建議補充水分並休息'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600018,
3018,
55835,
'初診',
TO_DATE('2024-01-28','YYYY-MM-DD'),
'腿部無力',
'肌力下降',
'神經傳導異常',
'安排復健治療',
'G62.9',
'建議物理治療三週'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600019,
3019,
57018,
'初診',
TO_DATE('2023-06-18','YYYY-MM-DD'),
'疲倦、貧血',
'血紅素偏低',
'疑似骨髓疾病',
'安排骨髓活檢',
'D64.9',
'建議住院進一步檢查'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600020,
3020,
58101,
'初診',
TO_DATE('2025-08-04','YYYY-MM-DD'),
'腹部腫塊',
'切片顯示良性病灶',
'腹部良性腫瘤',
'建議定期追蹤',
'D36.7',
'無需手術，門診觀察'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600021,
3021,
59284,
'初診',
TO_DATE('2022-03-03','YYYY-MM-DD'),
'手術前評估',
'血壓穩定',
'無麻醉禁忌',
'可安排手術',
'Z01.81',
'麻醉風險低，可進行手術'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600022,
3022,
60467,
'初診',
TO_DATE('2022-03-13','YYYY-MM-DD'),
'視力模糊',
'視力0.3/0.4',
'疑似白內障',
'安排眼科進一步檢查',
'H25.9',
'建議定期視力追蹤'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600023,
3023,
61650,
'初診',
TO_DATE('2024-10-27','YYYY-MM-DD'),
'喉嚨痛',
'咽部紅腫',
'急性咽喉炎',
'開立消炎藥與漱口水',
'J02.9',
'建議多喝水並避免刺激性食物'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600024,
3024,
62833,
'初診',
TO_DATE('2024-10-05','YYYY-MM-DD'),
'健康檢查',
'生理指數正常',
'無明顯異常',
'建議持續健康生活習慣',
'Z00.0',
'無需治療，定期追蹤即可'
);

INSERT INTO Diagnoses(
DIAGNOSISID,
RECORDID,
STAFFID,
RECORDTYPE,
DIAGNOSISDATE,
SUBJECTIVE,
OBJECTIVE,
ASSESSMENT,
PLAN,
ICDCODE,
DIAGNOSISNOTES
)
VALUES
(600025,
3025,
39673,
'初診',
TO_DATE('2025-09-02','YYYY-MM-DD'),
'鼻塞、打噴嚏',
'鼻黏膜腫脹',
'過敏性鼻炎',
'開立抗組織胺藥物',
'J30.1',
'建議避免接觸過敏原'
);

查詢整個資料表：
SELECT * FROM Diagnoses ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250925/20167787pntAXQNuC6.png
3. 處方籤表 - Prescriptions

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650001,
600001,
'硝酸甘油錠',
'每日三次，胸痛時服用',
7,
'M001',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650002,
600002,
'抗癲癇藥物',
'每日一次，睡前服用',
14,
'N002',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650003,
600003,
'止痛藥',
'每日兩次，飯後服用',
5,
'A003',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650004,
600004,
'顱壓調節劑',
'每日一次，早上服用',
10,
'N004',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650005,
600005,
'退燒藥',
'每六小時一次，體溫超過38°C服用',
3,
'P005',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650006,
600006,
'抗生素',
'每日兩次，飯後服用',
7,
'K006',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650007,
600007,
'抗組織胺藥物',
'每日一次，睡前服用',
5,
'D007',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650008,
600008,
'抗憂鬱藥物',
'每日一次，早上服用',
14,
'F008',
'口服藥',
'未領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650009,
600009,
'止血藥',
'每日三次，飯後服用',
7,
'G009',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650010,
600010,
'荷爾蒙調節劑',
'每日一次，固定時間服用',
21,
'E010',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650011,
600011,
'消炎止痛藥',
'每日兩次，飯後服用',
5,
'M011',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650012,
600012,
'制酸劑',
'每日三次，飯前服用',
7,
'G012',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650013,
600013,
'利尿劑',
'每日一次，早上服用',
5,
'N013',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650014,
600014,
'抗膀胱收縮藥物',
'每日兩次，飯後服用',
7,
'U014',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650015,
600015,
'肝功能保護劑',
'每日一次，飯後服用',
10,
'L015',
'口服藥',
'未領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650016,
600016,
'止痛藥',
'每日兩次，術後使用',
5,
'M0156',
'注射劑',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650017,
600017,
'維他命C補充劑',
'每日一次，飯後服用',
7,
'V017',
'口服藥',
'未領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650018,
600018,
'神經修復劑',
'每日一次，睡前服用',
14,
'N018',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650019,
600019,
'鐵劑',
'每日一次，飯後服用',
10,
'N019',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650020,
600020,
'無需藥物',
'無需服藥',
0,
'Z020',
'無',
'無'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650021,
600021,
'無需藥物',
'僅麻醉評估，無需服藥',
0,
'Z021',
'無',
'無'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650022,
600022,
'眼科維他命',
'每日一次，飯後服用',
7,
'E022',
'口服藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650023,
600023,
'抗生素漱口水',
'每日三次，飯後漱口',
5,
'J023',
'外用藥',
'已領藥'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650024,
600024,
'無需藥物',
'健康檢查，無需服藥',
0,
'Z024',
'無',
'無'
);

INSERT INTO Prescriptions(
PrescriptionID,
DiagnosisID,
MedicationName ,
Instruction ,
MedicationDays ,
MedicationCode ,
MedicationType ,
MedicationStatus
)
VALUES
(650025,
600025,
'抗組織胺藥物',
'每日一次，睡前服用',
5,
'A025',
'口服藥',
'已領藥'
);

查詢整個資料表：
SELECT * FROM Prescriptions ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250925/20167787pxVN8ARybi.png
4. 過敏記錄表 - AllergyRecords

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500001,
100342,
'花粉',
'打噴嚏、鼻塞',
TO_DATE('2015-03-16','YYYY-MM-DD'),
'輕度',
'春季過敏，建議配戴口罩。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500002,
13577,
'蝦類',
'嘔吐、皮膚紅疹',
TO_DATE('2019-07-13','YYYY-MM-DD'),
'中度',
'建議避免食用海鮮。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500003,
14620,
'花生',
'呼吸困難、喉嚨腫脹',
TO_DATE('2013-05-26','YYYY-MM-DD'),
'重度',
'已開立腎上腺素筆。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500004,
16988,
'灰塵',
'鼻子癢、眼睛癢',
TO_DATE('2020-08-19','YYYY-MM-DD'),
'輕度',
'建議加強居家清潔。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500005,
17241,
'藥物(青黴素)',
'發燒、皮膚紅疹',
TO_DATE('2017-12-29','YYYY-MM-DD'),
'重度',
'已註記藥物過敏警示。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500006,
19462,
'牛奶',
'腹瀉、脹氣',
TO_DATE('2012-06-17','YYYY-MM-DD'),
'中度',
'建議改用植物奶。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500007,
20513,
'鰻重',
'咳嗽、氣喘',
TO_DATE('2013-08-25','YYYY-MM-DD'),
'重度',
'建議使用防蟎寢具。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500008,
22735,
'藥物(止痛藥)',
'頭暈、皮膚紅疹',
TO_DATE('2016-01-02','YYYY-MM-DD'),
'中度',
'已註記藥物禁用。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500009,
23896,
'蛋白',
'嘔吐、腹痛',
TO_DATE('2017-04-22','YYYY-MM-DD'),
'中度',
'建議避免攝取蛋類製品。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500010,
26018,
'香水',
'頭痛、皮膚刺癢',
TO_DATE('2014-08-03','YYYY-MM-DD'),
'中度',
'建議避免使用香氛產品。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500011,
27179,
'芒果',
'嘴唇刺痛、紅腫',
TO_DATE('2016-06-04','YYYY-MM-DD'),
'輕度',
'建議避免生食芒果。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500012,
29401,
'蛋黃',
'嘔吐、腹瀉',
TO_DATE('2018-11-16','YYYY-MM-DD'),
'中度',
'建議改用蛋白替代。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500013,
30562,
'花粉',
'鼻塞、打噴嚏',
TO_DATE('2019-01-23','YYYY-MM-DD'),
'輕度',
'建議外出配戴口罩。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500014,
34528,
'藥物（阿斯匹靈）',
'頭暈、皮膚紅疹',
TO_DATE('2017-05-29','YYYY-MM-DD'),
'中度',
'已註記藥物禁用。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500015,
34850,
'蝦類',
'嘔吐、皮膚搔癢',
TO_DATE('2012-03-18','YYYY-MM-DD'),
'中度',
'建議避免食用海鮮。'
);

INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500016,
34911,
'藥物(止痛藥)',
'噁心、皮膚紅疹',
TO_DATE('2018-02-16','YYYY-MM-DD'),
'中度',
'已註記藥物過敏。'
);


INSERT INTO AllergyRecords(
AllergyID,
PatientID,
Allergen,
ReactionSymptoms,
OccurenceDate,
Severity,
AllergyNotes
)
VALUES
(500017,
13284,
'花生',
'呼吸困難、喉嚨腫脹',
TO_DATE('2011-09-27','YYYY-MM-DD'),
'重度',
'建議隨身攜帶急救藥物。'
);

查詢整個資料表：
SELECT * FROM AllergyRecords ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250925/20167787tGhfDjrVHD.png
5. 手術記錄表 - SurgeryRecords

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550001,
1023,
35102,
TO_DATE('2022-08-19','YYYY-MM-DD'),
'冠狀動脈支架置放術',
'心臟',
'心臟介入',
'局部麻醉',
90,
'無',
'術後需臥床6小時',
'血流恢復良好'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550002,
1056,
36215,
TO_DATE('2022-12-26','YYYY-MM-DD'),
'顱內電極植入術',
'頭部',
'神經外科',
'全身麻醉',
150,
'術後頭痛',
'術後觀察癲癇活動',
'電極位置精準'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550003,
1098,
38541,
TO_DATE('2025-09-21','YYYY-MM-DD'),
'腫瘤切除手術',
'腹部',
'一般外科',
'全身麻醉',
120,
'術中出血',
'術後需補充鐵劑',
'腫瘤邊緣清晰'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550004,
1132,
39673,
TO_DATE('2022-02-19','YYYY-MM-DD'),
'腦部核磁共振導引切除手術',
'頭部',
'神經外科',
'全身麻醉',
180,
'無',
'術後需神經功能評估',
'無神經損傷'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550005,
1175,
37488,
TO_DATE('2023-06-28','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'僅進行退燒與觀察，未安排手術。',
'小兒發燒，無手術適應症。'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550006,
1209,
40756,
TO_DATE('2023-11-11','YYYY-MM-DD'),
'腹腔鏡膽囊切除術',
'腹部',
'一般外科',
'全身麻醉',
90,
'術後腹脹',
'建議少量多餐',
'無膽管損傷'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550007,
1244,
41839,
TO_DATE('2022-07-05','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'僅進行藥物治療，未安排手術。',
'皮膚紅疹，無手術適應症。'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550008,
1287,
42922,
TO_DATE('2023-03-24','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'情緒評估後無需手術。',
'焦慮情緒，無手術處置。'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550009,
1321,
44005,
TO_DATE('2023-09-01','YYYY-MM-DD'),
'子宮鏡肌瘤切除手術',
'骨盆腔',
'婦科手術',
'全身麻醉',
75,
'術中出血',
'術後需補充鐵劑',
'建議定期追蹤'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550010,
1354,
45188,
TO_DATE('2024-01-12','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'調整荷爾蒙，無需手術。',
'月經不規則，無手術紀錄。'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550011,
1389,
47554,
TO_DATE('2024-11-25','YYYY-MM-DD'),
'關節鏡滑膜切除手術',
'肘部',
'骨科手術',
'局部麻醉',
45,
'術後腫脹',
'建議冰敷並避免重複動作',
'滑膜切除完整'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550012,
1423,
48737,
TO_DATE('2024-07-16','YYYY-MM-DD'),
'胃鏡下逆流修復手術',
'胃部',
'內視鏡手術',
'鎮靜麻醉',
40,
'無',
'術後禁食4小時',
'括約肌功能改善'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550013,
1456,
49920,
TO_DATE('2025-04-02','YYYY-MM-DD'),
'腎臟穿刺活檢術',
'腎臟',
'泌尿科',
'局部麻醉',
45,
'術後血尿',
'建議臥床並補充水分',
'樣本品質良好'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550014,
1490,
51103,
TO_DATE('2023-05-21','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'泌尿科評估後無需手術',
'頻尿，無手術紀錄'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550015,
1524,
52286,
TO_DATE('2022-12-22','YYYY-MM-DD'),
'肝臟腫瘤切除手術',
'肝臟',
'一般外科',
'全身麻醉',
150,
'術中出血',
'術後需密切監測肝功能',
'建議住院觀察'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550016,
1557,
53469,
TO_DATE('2024-04-14','YYYY-MM-DD'),
'關節鏡滑膜清創手術',
'手部',
'骨科外科',
'局部麻醉',
45,
'無',
'術後避免使用患側手',
'滑膜病灶已清除'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550017,
1591,
54652,
TO_DATE('2024-03-12','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'感染控制後無需手術',
'疑似感染，無手術紀錄'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550018,
1624,
55835,
TO_DATE('2024-01-28','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'僅進行復健，無手術處置',
'術後復健階段'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550019,
1658,
57018,
TO_DATE('2023-06-18','YYYY-MM-DD'),
'骨髓活檢術',
'骨盆腔',
'血液腫瘤科',
'局部麻醉',
30,
'無',
'術後需補充水分並臥床',
'樣本品質良好'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550020,
1692,
58101,
TO_DATE('2025-08-04','YYYY-MM-DD'),
'病理切片手術',
'腹部',
'一般外科',
'局部麻醉',
30,
'無',
'術後觀察傷口癒合',
'切片已送病理分析'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550021,
1725,
59284,
TO_DATE('2022-03-03','YYYY-MM-DD'),
'麻醉前評估處置',
'無',
'麻醉科',
'無',
0,
'無',
'評估完成，待安排手術',
'麻醉風險低，可手術'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550022,
1759,
60467,
TO_DATE('2022-03-13','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'視力模糊，安排眼科檢查',
'無手術處置'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550023,
1793,
61650,
TO_DATE('2024-10-27','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'喉嚨痛，無需手術',
'建議藥物治療'
);

INSERT INTO SurgeryRecords(
SurgeryID,
AppointmentID,
StaffID,
SurgeryDate,
SurgeryName,
SurgerySite,
SurgeryType,
AnesthesiaType,
DurationMinutes,
Complications,
OperativeInstructions,
StaffNotes
)
VALUES
(550024,
1826,
62833,
TO_DATE('2024-10-05','YYYY-MM-DD'),
'無',
'無',
'無',
'無',
0,
'無',
'健康檢查無異常，無手術紀錄',
'建議定期追蹤'
);

查詢整個資料表：
SELECT * FROM SurgeryRecords ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250925/20167787A0uCWjaRux.png

以上是我今天的分享 ~ 資料插入的部分終於終於終於結束了/images/emoticon/emoticon02.gif
明天會先做一個10天的小心得(小偷懶)然後接下來才會進行CRUD的功能測試！希望會順順利利啦 ~ 謝謝大家的觀看！


上一篇
Day11：資料插入(2/3)
下一篇
Day13：心得！
系列文
基於 Oracle 資料庫的醫院電子病歷系統設計與建置 共 13 篇
  1. 9
    Day09：資料插入所需的重要欄位資料
  2. 10
    Day10：資料插入(1/3)
  3. 11
    Day11：資料插入(2/3)
  4. 12
    Day12：資料插入(3/3)
  5. 13
    Day13：心得！
完整目錄
圖片
  熱門推薦
圖片
{{ item.channelVendor }} | {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

立即登入留言
iThome鐵人賽
iThome鐵人賽
參賽組數
902 組
團體組數
37 組
累計文章數
11646 篇
完賽人數
106 人
iT+看影片追技術 看影片追技術 看更多
熱門tag 看更多
15th鐵人賽 16th鐵人賽 13th鐵人賽 14th鐵人賽 12th鐵人賽 11th鐵人賽 鐵人賽 17th鐵人賽 2019鐵人賽 javascript 2018鐵人賽 python 2017鐵人賽 windows php c# windows server linux css react
熱門問題
熱門回答
熱門文章
IT邦幫忙