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