erDiagram
JOB {
ReferenceNumber String
JobTitle String
ActiveTo DateTimeOffset
Id Guid
ActiveFrom DateTimeOffset
}
OCCUPANCY {
JobId Guid
EndDate DateTimeOffset
EmployeeId Guid
Id Guid
StartDate DateTimeOffset
}
EMPLOYEE {
FirstName String
LastName String
PersonalReference String
FullName String
Id Guid
}
CHECKINMANAGER {
FirstName String
LastName String
PersonalReference String
CheckInManagerType String
FullName String
Id Guid
}
CHECKIN {
CheckInManagerType String
ClosedDate DateTimeOffset
OccupancyId Guid
CheckInType String
EmployeeId Guid
Id Guid
EmployeeCreated Boolean
ManagerId Guid
State String
OtherAttendees String
StarRating Int32
CheckInDate DateTimeOffset
}
Resource_Paths {
checkInManagers URL
occupancies URL
checkIns URL
jobs URL
employees URL
}
OCCUPANCY o{--|| EMPLOYEE : Employee
OCCUPANCY o{--|| JOB : Job
CHECKIN o{--|| EMPLOYEE : Employee
CHECKIN o{--|| CHECKINMANAGER : CheckInManager