@startuml
hide circle
skinparam linetype ortho

entity "Account" as account {
  id : number << generated >>
  --
  name : text
  address : text
  birth_date : datetime
  phone_number : text
  pager_number : text
}

entity "Bed" as beds {
  id : number << generated >>
  --
  bed_number : number
  room_number : number
}

entity "CareCentre" as care_centres {
  id : number << generated >>
  --
  name : text
  location : text
}

entity "Consumption" as consumptions {
  id : number << generated >>
  --
  consumed_at : datetime
  quantity : integer
  total_cost : decimal
}

entity "HoursWorked" as hours_worked {
  id : number << generated >>
  --
  started_at : datetime
  ended_at : datetime
}

entity "Item" as items {
  id : number << generated >>
  --
  number : number
  description : text
  unit_cost : decimal
}

entity "Laboratory" as laboratories {
  id : number << generated >>
  --
  location : text
}

entity "Nurse" as nurses {
}

entity "Patient" as patients {
  id : number << generated >>
  --
  type : varchar
  contacted_at : datetime
}

entity "Physician" as physicians {
}

entity "OutPatient" as out_patients {
}

entity "Qualification" as qualifications {
  id : number << generated >>
  --
  name : varchar
}

entity "Resident" as residents {
}

entity "Staff" as staff {
  id : number << generated >>
  --
  type : varchar
  hired_at : datetime
}

entity "Technician" as technicians {
}

entity "Treatment" as treatments {
  id : number << generated >>
  --
  number : number
  name : text
  occurred_at : datetime
  results : text
}

entity "Visit" as visits {
  id : number << generated >>
  --
  comments : text
  scheduled_at : datetime
}

entity "Volunteer" as volunteers {
}

' relationships
' Zero or One   |o--
' Exactly One   ||--
' Zero or Many  }o--
' One or Many   }|--

beds ||--o| patients
beds }|--|| care_centres
care_centres ||--|{ hours_worked
care_centres ||--|| nurses
consumptions }o--|| items
consumptions }o--|| patients
laboratories ||--|{ staff
patients }o--|| physicians
qualifications }|--|| staff
staff ||--o{ hours_worked
treatments }o--|| patients
treatments }o--|| physicians
visits }|--|| patients

account ||--|| patients
account ||--|| staff
patients <|-- out_patients
patients <|-- residents
staff <|-- nurses
staff <|-- physicians
staff <|-- technicians
staff <|-- volunteers
@enduml