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