Fluxograma
Hospital Relationship Entity Diagram
Conteúdo do fluxograma
Patient
PatientID: String, PK
SectorId: String, FK
FirstName: String
LastName: String
DateAdmitted: String
Age: Number
RoomID: String, FK
BedID: String, FK
Sector
SectorID: String, PK
RoomsListID: String, FK
DoctorsListID: String, FK
Doctors
DoctorListID: String, PK
DoctorId: String, FK
Doctor
DoctorID: String, PK
FirstName: String
LastName: String
YearsOfExperience: Number
SectorID: String, FK
BedListID: String, FK
Nurse
StaffID: String, PK
FirstName: String
LastName: String
YearsOfExperience: Number
BedListID: String, FK
Bed
BedID: String, PK
IsOccupied: Boolean
PatientId: String, FK
RoomID: String, FK
Beds
BedListID: String, PK
BedID: String, FK
Room
RoomID: String, PK
Floor: String
Building: String
NumOfBeds: Number
OccupiedBeds: Number
SectorID: String, FK
BedListID: String, FK
Rooms
RoomListID: String, PK
RoomID: String, FK
One to Many
One To One
One To Many
One To One
One To Many
One To One
One To One
Many to One
Many to One
One To One
One To Many
Many To Many
One To Many
Informações
- Descrição
- Hospital relationship entity diagram
- Criado por
- Kostas Diakogiannis
- Visualizações
- 2
- Avaliação
Mais sobre Entity-Relationship Model and Diagrams