iT邦幫忙

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

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

Day11：資料插入(3/3)

17th鐵人賽
22 瀏覽

  • 分享至 

  • xImage
    •  

大家好 ~ 今天是進行輸入25筆資料至各個資料表的第三天！也是我鐵人發文的第十一天！
雖然資料插入是較簡單的一部分，但因為我的每張表有太多欄位了，造成欄位的ID會搞錯等等的問題...
那就話不多說繼續我今天的文章分享！！！

  1. 病患基本資訊表 - Patients
    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (25525,
    'Taylor Emma',
    'F',
    TO_DATE('2005/04/02','YYYY-MM-DD'),
    'O',
    '0970660917',
    'New Taipei City',
    'F230259',
    'Mother',
    'Taylor Olivia',
    '0925081592');
    
    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (10342,
    'Smith Ethan',
    'M',
    TO_DATE('2004/07/15','YYYY-MM-DD'),
    'B',
    '0918765432',
    'Tainan City',
    'A123456',
    'Father',
    'Smith David',
    '0934567890');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (12491,
    'Johnson Ava',
    'F',
    TO_DATE('2003/11/02','YYYY-MM-DD'),
    'O',
    '0911122334',
    'Hualien City',
    'C345678',
    'Sister',
    'Johnson Grace',
    '0945678901');
    
    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (13577,
    'Lee Noah',
    'M',
    TO_DATE('2002/09/30','YYYY-MM-DD'),
    'AB',
    '0919988776',
    'Taichung City',
    'D456789',
    'Father',
    'Lee Daniel',
    '0956789012');
    
    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (14620,
    'Brown Mia',
    'F',
    TO_DATE('2001/12/25','YYYY-MM-DD'),
    'O',
    '0912233445',
    'Kaohsiung City',
    'E567890',
    'Mother',
    'Brown Lily',
    '0967890123');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (15834,
    'Davis Liam',
    'M',
    TO_DATE('2005/06/18','YYYY-MM-DD'),
    'A',
    '0913344556',
    'Yilan City',
    'F678901',
    'Father',
    'Davis Henry',
    '0978901234');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (16988,
    'Wilson Isabella',
    'F',
    TO_DATE('2004/03/09','YYYY-MM-DD'),
    'B',
    '0914455667',
    'Taipei City',
    'G789012',
    'Sister',
    'Wilson Emily',
    '0989012345');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (17241,
    'Martinez James',
    'M',
    TO_DATE('2003/08/21','YYYY-MM-DD'),
    'AB',
    '0915566778',
    'Chiayi City',
    'H890123',
    'Brother',
    'Martinez Lucas',
    '0990123456');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (18395,
    'Anderson Charlotte',
    'F',
    TO_DATE('2002/05/30','YYYY-MM-DD'),
    'O',
    '0916677889',
    'Nantou City',
    'I901234',
    'Mother',
    'Anderson Amelia',
    '0911234567');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (19462,
    'Thomas Benjamin',
    'M',
    TO_DATE('2001/10/10','YYYY-MM-DD'),
    'O',
    '0917788990',
    'Miaoli City',
    'J012345',
    'Father',
    'Thomas William	',
    '0922345678');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (20513,
    'Jackson Harper',
    'F',
    TO_DATE('2005/01/01','YYYY-MM-DD'),
    'O',
    '0918899001',
    'Tainan City',
    'K123456',
    'Sister',
    'Jackson Ella',
    '0933456789');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (21674,
    'White Alexander',
    'M',
    TO_DATE('2005/02/14','YYYY-MM-DD'),
    'O',
    '0919900112',
    'Tainan City',
    'L234567',
    'Brother',
    'White Samuel',
    '0944567890');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (22735,
    'Harris Evelyn',
    'F',
    TO_DATE('2003/03/22','YYYY-MM-DD'),
    'AB',
    '0911011223',
    'Hualien City',
    'M345678',
    'Mother',
    'Harris Victoria',
    '0955678901');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (23896,
    'Clark Logan',
    'M',
    TO_DATE('2002/04/30','YYYY-MM-DD'),
    'A',
    '0912122334',
    'Taichung City',
    'N456789',
    'Father',
    'Clark Joseph',
    '0966789012');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (24957,
    'Lewis Abigail',
    'F',
    TO_DATE('2001/06/08','YYYY-MM-DD'),
    'B',
    '0913233445',
    'Kaohsiung City',
    'O567890',
    'Sister',
    'Lewis Natalie',
    '0977890123');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (26018,
    'Robinson Jacob',
    'M',
    TO_DATE('2005/07/06','YYYY-MM-DD'),
    'B',
    '0914344556',
    'Yilan City',
    'P678901',
    'Father',
    'Robinson Ryan',
    '0988901234');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (27179,
    'Walker Sofia',
    'F',
    TO_DATE('2004/08/26','YYYY-MM-DD'),
    'O',
    '0915455667',
    'Taipei City',
    'Q789012',
    'Mother',
    'Walker Hannah',
    '0999012345');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (28340,
    'Young Daniel',
    'M',
    TO_DATE('2003/09/16','YYYY-MM-DD'),
    'A',
    '0916566778',
    'Chiayi City',
    'R890123',
    'Father',
    'Young Matthew',
    '0910123456');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (29401,
    'Allen Scarlett',
    'F',
    TO_DATE('2002/11/12','YYYY-MM-DD'),
    'AB',
    '0917677889',
    'Miaoli City',
    'S901234',
    'Sister',
    'Allen Zoe',
    '0921234567');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (30562,
    'King William',
    'M',
    TO_DATE('1999/12/22','YYYY-MM-DD'),
    'O',
    '0918788990',
    'Nantou City',
    'T012345',
    'Father',
    'Scott George',
    '0954567890');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (34528,
    'Nelson Jack',
    'M',
    TO_DATE('2005/05/17','YYYY-MM-DD'),
    'A',
    '0914344556',
    'Yilan City',
    'Z678901',
    'Father',
    'Nelson Charles',
    '0998901234');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (34689,
    'Hill Zoey',
    'F',
    TO_DATE('2008/05/28','YYYY-MM-DD'),
    'A',
    '0915455667',
    'New Taipei City',
    'A789012',
    'Father',
    'Hill Hack',
    '0919012345');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (34850,
    'Ramirez Luke',
    'M',
    TO_DATE('2003/07/19','YYYY-MM-DD'),
    'AB',
    '0916566778',
    'New Taipei City',
    'B890123',
    'Mother',
    'Ramirez Sarah',
    '0920123456');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (34911,
    'Mitchell Isaac',
    'M',
    TO_DATE('2001/09/20','YYYY-MM-DD'),
    'o',
    '0918788990',
    'Nantou City',
    'D012345',
    'Father',
    'Mitchell Tom',
    '0942345678');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation)
    VALUES
    (34999,
    'Campbell Aria',
    'F',
    TO_DATE('2002/08/31','YYYY-MM-DD'),
    'o',
    '0917677889',
    'Miaoli City',
    'C901234',
    'Mother',
    'Campbell Hazel',
    '0931234567');

    INSERT INTO Patients (
    PatientID,
    PatientName,
    PatientGender,
    PatientBirth,
    BloodType,
    PatientPhone,
    PatientAddress,
    PatientIdentityNumber,
    EmergencyName,
    EmergencyPhone,
    EmergencyRelation )
    VALUES
    (13284,
    'Morgan Olivia',
    'F',
    TO_DATE('2004/06/23','YYYY-MM-DD'),
    'B',
    '0918234567',
    'Taichung City',
    'M456789',
    'Mother',
    'Morgan Lily',
    '0923456789');

查詢整個資料表：
SELECT * FROM Patients ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/20167787R8xYkyoCua.png
2. 就診/掛號記錄 - Appointments

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1023,
    10342,
    023,
    35102,
    '已預約',
    '胸悶胸痛',
    TO_DATE('2022-08-19','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1056,
    12491,
    001,
    36215,
    '已完成',
    '癲癇發作',
    TO_DATE('2022-12-26','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1098,
    13577,
    006,
    38541,
    '已預約',
    '腫瘤評估',
    TO_DATE('2025-09-21','YYYY-MM-DD'),
    '未到診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1132,
    14620,
    008,
    39673,
    '已取消',
    '安排核磁共診檢查',
    TO_DATE('2022-02-19','YYYY-MM-DD'),
    '已改期'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1175,
    15834,
    004,
    37488,
    '已完成',
    '小兒發燒',
    TO_DATE('2023-06-28','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1209,
    16988,
    010,
    40756,
    '已預約',
    '急性腹痛',
    TO_DATE('2023-11-11','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1244,
    17241,
    012,
    41839,
    '已完成',
    '皮膚紅疹',
    TO_DATE('2022-07-05','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1287,
    18395,
    015,
    42922,
    '已預約',
    '焦慮情緒',
    TO_DATE('2023-03-24','YYYY-MM-DD'),
    '未到診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1321,
    19462,
    017,
    44005,
    '已完成',
    '產前檢查',
    TO_DATE('2023-09-01','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1354,
    20513,
    019,
    45188,
    '已預約',
    '月經不規則',
    TO_DATE('2024-01-12','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1389,
    21674,
    027,
    47554,
    '已完成',
    '關節疼痛',
    TO_DATE('2024-11-25','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1423,
    22735,
    029,
    48737,
    '已取消',
    '胃食道逆流',
    TO_DATE('2024-07-16','YYYY-MM-DD'),
    '已改期'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1456,
    23896,
    031,
    49920,
    '已預約',
    '腎功能檢查',
    TO_DATE('2025-04-02','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1490,
    24957,
    034,
    51103,
    '已完成',
    '頻尿',
    TO_DATE('2023-05-21','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1524,
    26018,
    036,
    52286,
    '已預約',
    '呼吸困難',
    TO_DATE('2022-12-22','YYYY-MM-DD'),
    '未到診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1557,
    27179,
    038,
    53469,
    '已完成',
    '關節腫脹',
    TO_DATE('2024-04-14','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1591,
    28340,
    040,
    54652,
    '已預約',
    '疑似感染',
    TO_DATE('2024-03-12','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1624,
    29401,
    042,
    55835,
    '已完成',
    '術後復健',
    TO_DATE('2024-01-28','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1658,
    30562,
    045,
    57018,
    '已預約',
    '貧血檢查',
    TO_DATE('2023-06-18','YYYY-MM-DD'),
    '未到診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1692,
    34528,
    047,
    58101,
    '已完成',
    '病理報告諮詢',
    TO_DATE('2025-08-04','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1725,
    34689,
    049,
    59284,
    '已預約',
    '手術前麻醉評估',
    TO_DATE('2022-03-03','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1759,
    34850,
    051,
    60467,
    '已完成',
    '視力模糊',
    TO_DATE('2022-03-13','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1793,
    34911,
    053,
    61650,
    '已取消',
    '喉嚨痛',
    TO_DATE('2024-10-27','YYYY-MM-DD'),
    '已改期'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1826,
    13284,
    055,
    62833,
    '已預約',
    '健康檢查',
    TO_DATE('2024-10-05','YYYY-MM-DD'),
    '已就診'
    );

    INSERT INTO Appointments(
    APPOINTMENTID,
    PATIENTID,
    DEPARTMENTID,
    STAFFID,
    APPOINTMENTSTATUS,
    CHIEFCOMPLAINT,
    VISITDATE,
    VISITSTATUS
    )
    VALUES
    (1860,
    34999,
    008,
    39673,
    '已完成',
    '電腦斷層追蹤檢查',
    TO_DATE('2025-09-02','YYYY-MM-DD'),
    '已就診'
    );

查詢整個資料表：
SELECT * FROM Appointments ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/20167787yRv8YHx5FR.png
3. 醫護人員資訊表 - Staff

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (35102,
    '023',
    'Carter Emily',
    'F',
    'Nurse',
    '71234',
    '0912345678',
    '5');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (36215,
    '001',
    'Smith James',
    'M',
    'Doctor',
    '85912',
    '0918765432',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (38541,
    '006',
    'Lee William',
    'M',
    'Technician',
    '79832',
    '0919988776',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (39673,
    '008',
    'Johnson Olivia',
    'F',
    'Therapist',
    '93045',
    '0911122334',
    '3');
    
    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (37488,
    '004',
    'Brown Sophia',
    'F',
    'Nurse',
    '81204',
    '0912233445',
    '5');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (40756,
    '010',
    'Davis Benjamin',
    'M',
    'Doctor',
    '94567',
    '0913344556',
    '3');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (41839,
    '012',
    'Wilson Isabella',
    'F',
    'Pharmacist',
    '97890',
    '0914455667',
    '3');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (42922,
    '015',
    'Martinez Noah',
    'M',
    'Nurse',
    '82345',
    '0915566778',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (44005,
    '017',
    'Anderson Mia',
    'F',
    'Therapist',
    '86789',
    '0916677889',
    '4');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (45188,
    '019',
    'Thomas Logan',
    'M',
    'Doctor',
    '89012',
    '0917788990',
    '7');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (46371,
    '025',
    'Jackson Lily',
    'F',
    'Nurse',
    '83456',
    '0918899001',
    '7');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (47554,
    '027',
    'White Daniel',
    'M',
    'Technician',
    '97891',
    '0919900112',
    '2');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (48737,
    '029',
    'Harris Grace',
    'F',
    'Pharmacist',
    '81234',
    '0911011223',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (49920,
    '031',
    'Clark Henry',
    'M',
    'Doctor',
    '95678',
    '0912122334',
    '3');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (51103,
    '034',
    'Lewis Ava',
    'F',
    'Nurse',
    '79012',
    '0913233445',
    '6');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (52286,
    '036',
    'Robinson Jack',
    'M',
    'Therapist',
    '84321',
    '0914344556',
    '2');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (53469,
    '038',
    'Walker Ella',
    'F',
    'Nurse',
    '98765',
    '0915455667',
    '2');
    
    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (54652,
    '040',
    'Young David',
    'M',
    'Doctor',
    '82109',
    '0916566778',
    '8');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (55835,
    '042',
    'Allen Scarlett',
    'F',
    'Technician',
    '96543',
    '0917677889',
    '2');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (57018,
    '045',
    'King Andrew',
    'M',
    'Pharmacist',
    '80987',
    '0918788990',
    '3');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (58101,
    '047',
    'Wright Zoe',
    'F',
    'Nurse',
    '87654',
    '0919899001',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (59284,
    '049',
    'Scott Matthew',
    'M',
    'Doctor',
    '83210',
    '0910900112',
    '1');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (60467,
    '051',
    'Green Nora',
    'F',
    'Therapist',
    '96543',
    '0911011223',
    '3');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (61650,
    '053',
    'Adams Claire',
    'F',
    'Pharmacist',
    '94321',
    '0913233445',
    '2');

    INSERT INTO Staff (
    StaffID,
    DepartmentID,
    StaffName,
    StaffGender,
    StaffRole,
    StaffLicnesenum,
    StaffPhone,
    YearsOfExperience)
    VALUES
    (62833,
    '055',
    'Baker Thomas',
    'M',
    'Nurse',
    '98765',
    '0912122334',
    '5');

查詢整個資料表：
SELECT * FROM Staff ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/20167787K0rFxoqjvE.png
4. 時間排程表 - Schedules

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7012,
    35102,
    023,
    TO_DATE('2025-09-24','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7045,
    36215,
    001,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7083,
    38541,
    006,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7127,
    39673,
    008,
    TO_DATE('2025-09-26','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7159,
    37488,
    004,
    TO_DATE('2025-09-27','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7194,
    40756,
    010,
    TO_DATE('2025-09-27','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7231,
    41839,
    012,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7268,
    42922,
    015,
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7302,
    44005,
    017,
    TO_DATE('2025-09-29','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7337,
    45188,
    019,
    TO_DATE('2025-09-30','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7374,
    47554,
    027,
    TO_DATE('2025-09-29','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7409,
    48737,
    029,
    TO_DATE('2025-09-30','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7446,
    49920,
    031,
    TO_DATE('2025-09-30','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7483,
    51103,
    034,
    TO_DATE('2025-10-02','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7517,
    52286,
    036,
    TO_DATE('2025-10-02','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7552,
    53469,
    038,
    TO_DATE('2025-10-01','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7589,
    54652,
    040,
    TO_DATE('2025-10-03','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7624,
    55835,
    042,
    TO_DATE('2025-10-05','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7659,
    57018,
    045,
    TO_DATE('2025-10-04','YYYY-MM-DD'),
    '早診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7694,
    58101,
    047,
    TO_DATE('2025-10-02','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7729,
    59284,
    049,
    TO_DATE('2025-09-29','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7764,
    60467,
    051,
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    '晚診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7799,
    61650,
    053,
    TO_DATE('2025-09-30','YYYY-MM-DD'),
    '午診');

    INSERT INTO Schedules(
    SCHEDULEID,
    STAFFID,
    DEPARTMENTID,
    SCHEDULEDATE,
    TIMESLOT
    )
    VALUES
    (7834,
    62833,
    055,
    TO_DATE('2025-10-02','YYYY-MM-DD'),
    '早診');

查詢整個資料表：
SELECT * FROM Schedules ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/20167787YKqKX2uc4V.png
5. 科別表 - Departments

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (023,
    'Cardiology',
    '負責心臟疾病的診斷與治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (001,
    'Neurology',
    '處理神經系統相關疾病');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (004,
    'Pediatrics',
    '提供兒童健康照護與疾病治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (006,
    'Oncology',
    '專門治療各類癌症');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (008,
    'Radiology',
    '進行影像檢查如X光、MRI等');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (010,
    'Emergency Medicine',
    '處理急診病患與緊急醫療狀況');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (012,
    'Dermatology',
    '治療皮膚、毛髮與指甲相關問題');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (015,
    'Psychiatry',
    '提供心理健康與精神疾病治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (017,
    'Obstetrics',
    '負責孕婦照護與分娩相關醫療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (019,
    'Gynecology',
    '女性生殖系統疾病診斷與治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (025,
    'Orthopedics',
    '骨骼與關節疾病的診斷與手術治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (027,
    'Urology',
    '處理泌尿系統與男性生殖器相關疾病');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (029,
    'Gastroenterology',
    '專注於腸胃道疾病的診斷與治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (031,
    'Nephrology',
    '腎臟疾病的診斷與長期照護');
    
    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (034,
    'Endocrinology',
    '治療內分泌系統疾病如糖尿病、甲狀腺問題');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (036,
    'Pulmonology',
    '處理肺部與呼吸系統疾病');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (038,
    'Rheumatology',
    '治療關節炎與自體免疫疾病');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (040,
    'Infectious Diseases',
    '專門處理傳染性疾病與防疫');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (042,
    'Rehabilitation',
    '提供復健治療與功能恢復訓練');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (045,
    'Hematology',
    '血液疾病的診斷與治療');

INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (047,
    'Pathology',
    '進行病理檢查與疾病診斷支援');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (049,
    'Anesthesiology',
    '負責麻醉與疼痛控制');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (051,
    'Ophthalmology',
    '眼科疾病診斷與視力治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (053,
    'Otolaryngology',
    '耳鼻喉相關疾病的診斷與治療');

    INSERT INTO Departments(
    DepartmentID,
    DepartmentName,
    DepartmentDescription)
    VALUES
    (055,
    'Family Medicine',
    '提供全人照護與家庭健康管理');

查詢整個資料表：
SELECT * FROM Departments ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/20167787VD0vzSxTPr.png
6. 住院紀錄表 - HospitalizationRecords

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100501,
    1056,
    001,
    36215,
    TO_DATE('2025-09-03','YYYY-MM-DD'),
    6,
    TO_DATE('2025-09-09','YYYY-MM-DD'),
    TO_DATE('2025-09-09','YYYY-MM-DD'),
    'A07',
    'B05',
    'C18',
    '癲癇發作',
    '症狀穩定，持續服藥',
    '已出院',
    TO_DATE('2025-09-02','YYYY-MM-DD'),
    '建議神經科門診追蹤',
    '注意作息與藥物依從性'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100502,
    1098,
    006,
    38541,
    TO_DATE('2025-09-05','YYYY-MM-DD'),
    5,
    TO_DATE('2025-09-10','YYYY-MM-DD'),
    TO_DATE('2025-09-10','YYYY-MM-DD'),
    'A12',
    'B19',
    'C33',
    '腫瘤評估',
    '無惡性病變，門診追蹤',
    '已出院',
    TO_DATE('2025-09-04','YYYY-MM-DD'),
    '建議定期影像檢查',
    '注意身體變化'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100503,
    1175,
    010,
    40753,
    TO_DATE('2025-09-07','YYYY-MM-DD'),
    4,
    TO_DATE('2025-09-11','YYYY-MM-DD'),
    TO_DATE('2025-09-11','YYYY-MM-DD'),
    'A19',
    'B08',
    'C27',
    '小兒發燒',
    '病毒感染緩解',
    '已出院',
    TO_DATE('2025-09-06','YYYY-MM-DD'),
    '建議居家照護',
    '注意體溫與水分補充'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100504,
    1209,
    015,
    41905,
    TO_DATE('2025-09-09','YYYY-MM-DD'),
    6,
    TO_DATE('2025-09-15','YYYY-MM-DD'),
    TO_DATE('2025-09-15','YYYY-MM-DD'),
    'A02',
    'B11',
    'C14',
    '急性腹痛',
    '急性腸胃炎痊癒',
    '已出院',
    TO_DATE('2025-09-08','YYYY-MM-DD'),
    '飲食需注意',
    '建議清淡飲食與休息'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100505,
    1244,
    017,
    43056,
    TO_DATE('2025-09-11','YYYY-MM-DD'),
    5,
    TO_DATE('2025-09-16','YYYY-MM-DD'),
    TO_DATE('2025-09-16','YYYY-MM-DD'),
    'A09',
    'B16',
    'C21',
    '皮膚紅疹',
    '輕度過敏反應改善',
    '已出院',
    TO_DATE('2025-09-10','YYYY-MM-DD'),
    '無需住院追蹤',
    '建議避免接觸過敏源'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100506,
    1287,
    019,
    44208,
    TO_DATE('2025-09-13','YYYY-MM-DD'),
    7,
    TO_DATE('2025-09-20','YYYY-MM-DD'),
    TO_DATE('2025-09-20','YYYY-MM-DD'),
    'A14',
    'B03',
    'C29',
    '焦慮情緒',
    '情緒穩定，持續追蹤',
    '已出院',
    TO_DATE('2025-09-12','YYYY-MM-DD'),
    '建議心理諮詢',
    '注意壓力管理與睡眠品質'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100507,
    1321,
    021,
    45360,
    TO_DATE('2025-09-15','YYYY-MM-DD'),
    3,
    TO_DATE('2025-09-18','YYYY-MM-DD'),
    TO_DATE('2025-09-18','YYYY-MM-DD'),
    'A06',
    'B22',
    'C06',
    '產前檢查',
    '檢查正常，無併發症',
    '已出院',
    TO_DATE('2025-09-14','YYYY-MM-DD'),
    '建議定期產檢',
    '注意營養與胎動觀察'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100508,
    1354,
    024,
    46512,
    TO_DATE('2025-09-17','YYYY-MM-DD'),
    5,
    TO_DATE('2025-09-22','YYYY-MM-DD'),
    TO_DATE('2025-09-22','YYYY-MM-DD'),
    'A17',
    'B09',
    'C10',
    '月經不規則',
    '荷爾蒙調整後穩定',
    '已出院',
    TO_DATE('2025-09-16','YYYY-MM-DD'),
    '建議婦科門診追蹤',
    '注意作息與壓力'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100509,
    1389,
    029,
    47663,
    TO_DATE('2025-09-19','YYYY-MM-DD'),
    6,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    'A01',
    'B14',
    'C25',
    '關節疼痛',
    '關節炎控制穩定',
    '已出院',
    TO_DATE('2025-09-18','YYYY-MM-DD'),
    '建議復健治療',
    '注意關節活動與保暖'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100510,
    1423,
    031,
    48703,
    TO_DATE('2025-09-21','YYYY-MM-DD'),
    4,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    'A11',
    'B06',
    'C30',
    '胃食道逆流',
    '症狀改善，持續服藥',
    '已出院',
    TO_DATE('2025-09-20','YYYY-MM-DD'),
    '飲食需調整',
    '建議避免刺激性食物'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100511,
    1456,
    033,
    49854,
    TO_DATE('2025-09-23','YYYY-MM-DD'),
    5,
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    'A08',
    'B17',
    'C04',
    '腎功能檢查',
    '腎功能穩定，門診追蹤',
    '已出院',
    TO_DATE('2025-09-22','YYYY-MM-DD'),
    '建議定期抽血檢查',
    '注意水分攝取與藥物使用'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100512,
    1490,
    036,
    52205,
    TO_DATE('2025-09-25','YYYY-MM-DD'),
    3,
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    'A13',
    'B20',
    'C12',
    '頻尿',
    '泌尿道感染痊癒',
    '已出院',
    TO_DATE('2025-09-24','YYYY-MM-DD'),
    '無需住院追蹤',
    '建議多喝水與注意衛生'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100513,
    1524,
    038,
    53357,
    TO_DATE('2025-09-27','YYYY-MM-DD'),
    6,
    TO_DATE('2025-10-03','YYYY-MM-DD'),
    TO_DATE('2025-10-03','YYYY-MM-DD'),
    'A04',
    'B01',
    'C16',
    '呼吸困難',
    '輕度氣喘控制良好',
    '已出院',
    TO_DATE('2025-09-26','YYYY-MM-DD'),
    '建議使用吸入劑',
    '注意過敏源與空氣品質'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100514,
    1591,
    040,
    54509,
    TO_DATE('2025-09-29','YYYY-MM-DD'),
    5,
    TO_DATE('2025-10-04','YYYY-MM-DD'),
    TO_DATE('2025-10-04','YYYY-MM-DD'),
    'A16',
    'B13',
    'C08',
    '疑似感染',
    '細菌感染已控制',
    '已出院',
    TO_DATE('2025-09-28','YYYY-MM-DD'),
    '建議門診追蹤',
    '注意體溫與服藥紀律'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100515,
    1692,
    043,
    55660,
    TO_DATE('2025-10-01','YYYY-MM-DD'),
    4,
    TO_DATE('2025-10-05','YYYY-MM-DD'),
    TO_DATE('2025-10-05','YYYY-MM-DD'),
    'A10',
    'B07',
    'C20',
    '病理報告諮詢',
    '結果已說明，無需住院',
    '已出院',
    TO_DATE('2025-09-30','YYYY-MM-DD'),
    '建議門診報告解釋',
    '注意後續檢查安排'
    );

    INSERT INTO hospitalizationrecords(
    "HospitalizationID",
    "AppointmentID",
    "DepartmentID",
    "StaffID",
    "AdmissionDate",
    "LengthOfStay",
    "ExpectedDischargeDate",
    "ActualDischargeDate",
    "WardArea",
    "RoomNum",
    "BedNum",
    "AdmissionDiagnosis",
    "DischargeDiagnosis",
    "HospitalizationStatus",
    "HospitalCreateTime",
    "DischargeSummary",
    "HospitalNotes"
    )
    VALUES
    (100503,
    1175,
    010,
    40753,
    TO_DATE('2025-09-07','YYYY-MM-DD'),
    4,
    TO_DATE('2025-09-11','YYYY-MM-DD'),
    TO_DATE('2025-09-11','YYYY-MM-DD'),
    'A19',
    'B08',
    'C27',
    '小兒發燒',
    '病毒感染緩解',
    '已出院',
    TO_DATE('2025-09-06','YYYY-MM-DD'),
    '建議居家照護',
    '注意體溫與水分補充'
    );

查詢整個資料表：
SELECT * FROM HospitalizationRecords ;
結果：
https://ithelp.ithome.com.tw/upload/images/20250923/201677872yujbnPX1p.jpg

以上是我今天的分享！謝謝大家的觀看！
雖然內容有點多有點複雜的感覺，但其實只需要花時間與心力去做，步驟都是一樣的 ~ /images/emoticon/emoticon41.gif


上一篇
Day10：資料插入(2/3)
系列文
基於 Oracle 資料庫的醫院電子病歷系統設計與建置 共 11 篇
  1. 7
    Day07：實體關聯圖繪製、資料表間關聯的補充說明
  2. 8
    Day08：資料表轉SQL
  3. 9
    Day09：資料插入(1/3)
  4. 10
    Day10：資料插入(2/3)
  5. 11
    Day11：資料插入(3/3)
完整目錄
圖片
  熱門推薦
圖片
{{ item.channelVendor }} | {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

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