d
Tables (4)
building
- buildingName — varchar2(10) — Primary key — NOT NULL
hospital
- name — varchar2(20) — Primary key — NOT NULL
- number — long — Foreign key → patient.number — NOT NULL
patient
- number — long — Primary key — NOT NULL
- patientName — varchar2(20)
- time — date
- disease — boolean
visit
- date — date — Primary key — NOT NULL
- station — varchar2(5) — Primary key — NOT NULL
- number — long — Foreign key → patient.number — NOT NULL
- buildingName — varchar2(10) — Foreign key → building.buildingName — NOT NULL