이걸내가왜하지
테이블 (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