실습과제
테이블 (13)
Copy Of Untitled (Room)
- Key (Room_num) — number(10) — 기본 키 — NOT NULL
- Field (In_date) — varchar2(10)
- Field (Out_date) — varchar2(10)
Copy Of Untitled10 (Question)
- Key (Question_ID) — number(10) — 기본 키 — NOT NULL
- Field (Text) — varchar2(100)
- Field (Question_Date) — date
- Key (Pati_ID) — number(10) — 외래 키 → Copy Of 환자 정보.Key — NOT NULL
- Key (Doc_id) — number(10) — 외래 키 → Copy Of Untitled2.Key — NOT NULL
Copy Of Untitled11 (ConvRecord)
- Key (Conversation_ID) — number(10) — 기본 키 — NOT NULL
- Field (Conversation_Date) — date
- Key (Quest_ID) — number(10) — 외래 키 → Copy Of Untitled10.Key — NOT NULL
- Key (Ans_ID) — number(10) — 외래 키 → Copy Of Untitled12.Key — NOT NULL
Copy Of Untitled12 (Answer)
- Key (Answer_ID) — number(10) — 기본 키 — NOT NULL
- Field (Answer_Text) — varvhar2(100)
- Field (Answer_Date) — date
- Key (Ques_ID) — number(10) — 외래 키 → Copy Of Untitled10.Key — NOT NULL
Copy Of Untitled2 (Doctor)
- Key (Doctor_ID) — number(10) — 기본 키 — NOT NULL
- Field (Doctor_Name) — varchar2(50)
- Field (Doctor_Phone) — varchar2(30)
- Field (Doctor_Gender) — varchar2(10)
- Field (Doctor_Birth) — varchar2(10)
- Key (S_id) — number(10) — 외래 키 → Copy Of Untitled5.Key — NOT NULL
Copy Of Untitled3 (Paper)
- Key (Paper_ID) — number(10) — 기본 키 — NOT NULL
- Field (Topic) — varchar2(50)
- Field (Publish_Date) — date
- Field (Content) — varchar2(100)
Copy Of Untitled4 (PaperDoctor)
- Key (P_ID) — number(10) — 외래 키 → Copy Of Untitled3.Key — NOT NULL
- Key (Doc_ID) — number(10) — 외래 키 → Copy Of Untitled2.Key — NOT NULL
Copy Of Untitled5 (Speciality)
- Key (Speciality_ID) — number(10) — 기본 키 — NOT NULL
- Field (Speciality_Name) — number(10)
Copy Of Untitled6 (ClinicalTrials)
- Key (Trial_ID) — number(10) — 기본 키 — NOT NULL
- Field (Title) — varchar2(20)
- Field (Conditon) — varchar2(30)
- Field (Treat) — varchar2(50)
- Field (Status) — varchar2(20)
- Field (Result) — varchar2(30)
- Field — varchar2(30)
- Field2 (Start_Date) — date
- Field2 (End_Date) — date
Copy Of Untitled7 (DoctorTrials)
- Key (T_ID) — number(10) — 외래 키 → Copy Of Untitled6.Key — NOT NULL
- Key (D_ID) — number(10) — 외래 키 → Copy Of Untitled2.Key — NOT NULL
Copy Of Untitled8 (MedicalRecord)
- Key (Record_ID) — number(10) — 기본 키 — NOT NULL
- Field (Diagnosis) — varchar2(50)
- Field (Symptoms) — varchar2(50)
- Field (Treatment) — varchar2(50)
- Field (Notes) — varchar2(50)
- Field (Record_Date) — date
- Key (Patient_id) — number(10) — 외래 키 → Copy Of 환자 정보.Key — NOT NULL
- Key (Doct_ID) — number(10) — 외래 키 → Copy Of Untitled2.Key — NOT NULL
Copy Of Untitled9 (Image)
- Key (Image_ID) — number — 기본 키 — NOT NULL
- Field (Image_Type) — varchar2(20)
- Field2 (Caption) — varchar2(20)
- Field (Image_Path) — varchar2(50)
- Field (Film_Date) — varchar2(10)
- Key (R_ID) — number(10) — 외래 키 → Copy Of Untitled8.Key — NOT NULL
- Key (Pat_ID) — number(10) — 외래 키 → Copy Of 환자 정보.Key — NOT NULL
Copy Of 환자 정보 (Patient)
- Key (Patient_ID) — number(10) — 기본 키 — NOT NULL
- Field (Patient_name) — varchar2(30)
- Field (Address) — varchar2(50)
- Field (Phone) — varchar2(30)
- Field (Birth) — varchar2(10)
- Field (Gender) — varchar2(10)
- Key (Room_num) — number(10) — 외래 키 → Copy Of Untitled.Key — NOT NULL
- Key (Doctor_id) — number(10) — 외래 키 → Copy Of Untitled2.Key — NOT NULL