이걸내가왜하지

테이블 (10)

Admission (입원)

  • AdmissionDate (입원일자) — NOT NULL
  • DischargeDate (퇴원일자) — NOT NULL
  • Field3
  • Field4
  • Field5

Department (부서)

  • Department_ID (부서ID) — NUMBER(2) — 기본 키 — NOT NULL — Primary Key
  • Department_Names (부서 이름) — CHAR(8BYTE) — NOT NULL
  • Phone_numbers (부서직원 전화번호) — CHAR(8BYTE) — NOT NULL

Diagnosis (진단서)

  • Doctor_ID (의사ID) — CHAR(8BYTE) — 외래 키 → Doctor.Doctor_ID — NOT NULL — Primary Key
  • PatientStatus (환자상태) — CHAR(8BYTE) — NOT NULL
  • PatientDisease (병명) — CHAR(8BYTE) — NOT NULL
  • TreatmentContent (치료내용) — CHAR(8BYTE) — NOT NULL
  • HospitalizationRequired (입원필요) — CHAR(8BYTE) — NOT NULL
  • ReturnRequired (집에가도됨) — CHAR(8BYTE) — NOT NULL

Doctor (의사)

  • Doctor_ID (의사ID) — CHAR(8BYTE) — 기본 키 — NOT NULL — Primary Key
  • Department_ID (부서ID) — NUMBER(2) — 외래 키 → Department.Department_ID — NOT NULL — Primary Key
  • Doctor_Social_Security_Numbers (주민등록번호) — CHAR(8BYTE) — NOT NULL
  • Doctor_Phone_Number (전화번호) — CHAR(8BYTE) — NOT NULL
  • Major_names (전공명) — CHAR(8BYTE) — NOT NULL
  • Doctor_e-mail (이메일) — CHAR(8BYTE)
  • Docctor_names (의사이름) — NCHAR(6) — NOT NULL
  • Gender (성별) — CHAR(8BYTE) — NOT NULL

Hospital Room (병실)

  • Key — 기본 키 — NOT NULL
  • Patient_ID (환자ID) — CHAR(8BYTE) — 외래 키 → Patient.Patient_ID — NOT NULL — Primary Key
  • Employee_ID (직원ID) — CHAR(8BYTE) — 외래 키 → Patient.Employee_ID — NOT NULL — Primary Key
  • Capacitys (수용인원) — CHAR(8BYTE) — NOT NULL
  • Room_classifications (병실구분) — CHAR(8BYTE) — NOT NULL
  • Location (병실위치) — CHAR(8BYTE) — NOT NULL

Medicine (약)

  • MedicineID (의학ID?) — CHAR(8BYTE) — NOT NULL
  • DosageForm (복용량) — CHAR(8BYTE) — NOT NULL
  • DailyDosage (일일 복용량) — CHAR(8BYTE) — NOT NULL
  • MedicineDuration (약품 기간) — CHAR(8BYTE) — NOT NULL
  • MedicinePrescriptionRequired (의약품처방전필요?) — CHAR(8BYTE) — NOT NULL
  • MedicineName (약이름) — CHAR(8BYTE) — NOT NULL

Nurse (간호사)

  • Nuser_ID (간호사ID) — CHAR(8BYTE) — 기본 키 — NOT NULL — Primary key
  • Department_ID (부서ID) — NUMBER(2) — 외래 키 → Department.Department_ID — NOT NULL — Primary Key
  • Nurse_name (간호사이름) — CHAR(8BYTE) — NOT NULL
  • Gender (성별) — CHAR(8BYTE) — NOT NULL
  • Social_Security_Numbers (주민등록번호) — CHAR(8BYTE) — NOT NULL
  • Phone_number (전화번호) — CHAR(8BYTE) — NOT NULL
  • e-mail (이메일) — CHAR(8BYTE) — NOT NULL

Patient (환자)

  • Patient_ID (환자ID) — CHAR(8BYTE) — 기본 키 — NOT NULL — Primary Key
  • Doctor_ID (의사ID) — CHAR(8BYTE) — 외래 키 → Doctor.Doctor_ID — NOT NULL — Primary Key
  • Department_ID (부서ID) — NUMBER(2) — 외래 키 → Department.Department_ID — NOT NULL — Primary Key
  • Employee_ID (직원ID) — CHAR(8BYTE) — 외래 키 → Storage.Employee_ID — NOT NULL — Primary Key
  • Patient_name (환자이름) — CHAR(8BYTE) — NOT NULL
  • Social Security Number (주민등록번호) — CHAR(8BYTE) — NOT NULL
  • Phone_number (전화번호) — CHAR(8BYTE) — NOT NULL
  • Address (주소) — CHAR(8BYTE) — NOT NULL
  • Gender (성별) — CHAR(8BYTE) — NOT NULL
  • Nuser_ID (간호사ID) — CHAR(8BYTE) — 외래 키 → Nurse.Nuser_ID — NOT NULL — Primary key

Storage (수납처)

  • Employee_ID (직원ID) — CHAR(8BYTE) — 기본 키 — NOT NULL — Primary Key
  • Employee_phone _number (전화번호) — CHAR(8BYTE) — NOT NULL
  • Employee_name (직원이름) — NCHAR(6) — NOT NULL

Treatment (진료)

  • Key — 기본 키 — NOT NULL
  • TreatmentDatetime (진료시간) — CAHR(8BYTE) — NOT NULL
  • Field2