demo

Tables (3)

Untitled (Room)

  • Key (Room_num) — number(10) — Primary key — NOT NULL
  • Field (In_date) — date
  • Field (Out_date) — date

Untitled (Patient)

  • Key (Patient_ID) — number(10) — Primary key — NOT NULL
  • Field (Patient_Name) — varchar2(20)
  • Field2 (Address) — varchar2(50)
  • Field3 (Phone) — varchar2(20)
  • Field4 (Birth) — varchar2(10)
  • Field (Gender) — varchar2(10)
  • Key (room_num) — number(10) — Foreign key → Untitled.Key — NOT NULL

Untitled (Doctor)