실습과제

테이블 (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