Daily Care And Attendance ER Diagram#
This view captures the live operational records created during the child’s day in care.
Included Tables#
%%{init: {"securityLevel":"loose"}}%%
classDiagram
direction LR
class child {
childID : Text
description : Unknown
firstName : Text
lastName : Text
}
class room {
roomID : Number
name : Text
attendanceDateGlobal : Date
}
class mealSchedule {
mealScheduleID : Text
mealDate : Date
campusID : Number
}
class childAttendance {
childAttendanceID : Text
childID : Text
roomID : Number
}
class childEating {
childEatingID : Text
childID : Text
effectiveDate : Date
name : Unknown
calendarEventName : Unknown
}
class childSleep {
childSleepID : Text
childID : Text
roomID : Number
}
class childDiaper {
childDiaperID : Text
childID : Text
timestampChanged : TimeStamp
}
class childAbsentDay {
childAbsentDayID : Text
childID : Text
roomID : Number
}
class childIncident {
childIncidentID : Text
childID : Text
roomID : Number
description : Unknown
dateOccurred : Date
}
class childIllness {
childIllnessID : Text
childID : Text
roomID : Number
message : Unknown
dateOccurred : Date
}
childAttendance --> child : childID = childID
childAttendance --> room : roomID = roomID
childEating --> child : childID = childID
childEating --> mealSchedule : effectiveDate = mealDate
childSleep --> child : childID = childID
childSleep --> room : roomID = roomID
childDiaper --> child : childID = childID
childAbsentDay --> child : childID = childID
childAbsentDay --> room : roomID = roomID
childIncident --> child : childID = childID
childIncident --> room : roomID = roomID
childIllness --> child : childID = childID
childIllness --> room : roomID = roomID
Tables#
child#
Primary table details live in child under Children Domain ER Diagram.
room#
Primary table details live in room under Organization And Capacity ER Diagram.
mealSchedule#
Fields#
| Field |
Data Type |
Field Type |
| campusID |
Number |
Normal |
| mealDate |
Date |
Normal |
| mealScheduleID |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| childAllergenIDList |
Text |
Normal |
| childFoodRestrictionIDList |
Text |
Normal |
| listLastUpdateDate |
Date |
Normal |
Relationships#
- Referenced by childEating on
childEating.effectiveDate = mealSchedule.mealDate.
childAttendance#
Fields#
| Field |
Data Type |
Field Type |
| currDate |
Date |
Calculated |
| error |
Number |
Calculated |
| timestampOut |
TimeStamp |
Normal |
| dateIn |
Date |
Calculated |
| timestampIn |
TimeStamp |
Normal |
| childID |
Text |
Normal |
| notes |
Text |
Normal |
| childNameFirstLast |
Unknown |
Unknown |
| passedHealthCheckIn |
Number |
Normal |
| roomID |
Number |
Normal |
| constantOne |
Number |
Calculated |
| timestampOutMax |
TimeStamp |
Calculated |
| childAttendanceID |
Text |
Normal |
| passedHealthCheckInDisplay |
Text |
Calculated |
| timeOut |
Time |
Calculated |
| campusID |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| dateInUnix |
Text |
Calculated |
| timeIn |
Time |
Calculated |
Relationships#
- References child on
childAttendance.childID = child.childID.
- References room on
childAttendance.roomID = room.roomID.
childEating#
Fields#
| Field |
Data Type |
Field Type |
| currDate |
Date |
Calculated |
| childID |
Text |
Normal |
| effectiveDate |
Date |
Normal |
| milkUnits |
Text |
Normal |
| comments |
Text |
Normal |
| activityIDList |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| programTaskAreaID |
Unknown |
Unknown |
| waterUnits |
Text |
Normal |
| frenchComments |
Text |
Normal |
| jumparooComments |
Text |
Normal |
| mondayDate |
Date |
Calculated |
| stemComments |
Text |
Normal |
| childEatingID |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| effectiveDateUnix |
Text |
Calculated |
| activityDescriptionList |
Text |
Calculated |
| name |
Unknown |
Unknown |
| calendarEventName |
Unknown |
Unknown |
| emergencyAction |
Unknown |
Unknown |
| calendarEventIDList |
Text |
Normal |
| calendarEventID |
Unknown |
Unknown |
| emergencyActionIDList |
Text |
Normal |
| emergencyActionID |
Unknown |
Unknown |
Relationships#
- References child on
childEating.childID = child.childID.
- References mealSchedule on
childEating.effectiveDate = mealSchedule.mealDate.
childSleep#
Fields#
| Field |
Data Type |
Field Type |
| childID |
Text |
Normal |
| sleepTimestamp |
TimeStamp |
Normal |
| wakeTimestamp |
TimeStamp |
Normal |
| currDate |
Date |
Calculated |
| sleepDate |
Date |
Calculated |
| sleepDuration |
Time |
Calculated |
| roomID |
Number |
Normal |
| constantOne |
Number |
Calculated |
| wakeTimestampMax |
TimeStamp |
Calculated |
| comments |
Text |
Normal |
| constantOneCount |
Number |
Summary |
| childSleepID |
Text |
Normal |
| nameFirstLast |
Text |
Normal |
| childNameFirstLast |
Unknown |
Unknown |
| commentOnly |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| sleepDateUnix |
Text |
Calculated |
Relationships#
- References child on
childSleep.childID = child.childID.
- References room on
childSleep.roomID = room.roomID.
childDiaper#
Fields#
| Field |
Data Type |
Field Type |
| childID |
Text |
Normal |
| timestampChanged |
TimeStamp |
Normal |
| wetOrBM |
Text |
Normal |
| currDate |
Date |
Calculated |
| dateChanged |
Date |
Calculated |
| timeChanged |
Time |
Calculated |
| childDiaperID |
Text |
Normal |
| creamType |
Text |
Normal |
| creamApplied |
Number |
Normal |
| text01Global |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| dateChangedUnix |
Text |
Calculated |
| crossJoin |
Number |
Normal |
| staffSignatureMethod |
Text |
Normal |
| staffSignatureName |
Text |
Normal |
| isLocked |
Number |
Normal |
Relationships#
- References child on
childDiaper.childID = child.childID.
childAbsentDay#
Fields#
| Field |
Data Type |
Field Type |
| childID |
Text |
Normal |
| dateAbsent |
Date |
Normal |
| notes |
Text |
Normal |
| dateAbsentCount |
Number |
Summary |
| roomID |
Number |
Normal |
| homeRoomID |
Unknown |
Unknown |
| reason |
Text |
Normal |
| dateAbsentYear |
Number |
Calculated |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| dateAbsentUnix |
Text |
Calculated |
| childAbsentDayID |
Text |
Normal |
| reasonIsUnresolved |
Number |
Calculated |
| showAsUnresolved |
Number |
Normal |
| childAbsentReasonID |
Text |
Normal |
Relationships#
- References child on
childAbsentDay.childID = child.childID.
- References room on
childAbsentDay.roomID = room.roomID.
childIncident#
Fields#
| Field |
Data Type |
Field Type |
| actionTaken |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| childIncidentActionTakenID |
Unknown |
Unknown |
| childIncidentActionTakenIDList |
Text |
Normal |
| actionTakenOther |
Text |
Normal |
| awakeChildren |
Number |
Normal |
| complete |
Number |
Normal |
| staffCheckedIn |
Number |
Normal |
| totalChildrenCheckedIn |
Number |
Normal |
| childID |
Text |
Normal |
| comments |
Text |
Normal |
| completeEMailSent |
Number |
Normal |
| equipment |
Text |
Normal |
| childIncidentEquipmentID |
Unknown |
Unknown |
| childIncidentEquipmentIDList |
Text |
Normal |
| equipmentOther |
Text |
Normal |
| endDateGlobal |
Date |
Normal |
| startDateGlobal |
Date |
Normal |
| incident |
Text |
Normal |
| description |
Unknown |
Unknown |
| childIncidentDescriptionID |
Unknown |
Unknown |
| childIncidentDescriptionIDList |
Text |
Normal |
| incidentOther |
Text |
Normal |
| location |
Text |
Normal |
| locationOther |
Text |
Normal |
| roomID |
Number |
Normal |
| seriousOccurrence |
Number |
Normal |
| timestampOccurred |
TimeStamp |
Normal |
| constantOne |
Number |
Calculated |
| inComplete |
Number |
Calculated |
| constantOneCount |
Number |
Summary |
| childIncidentID |
Text |
Normal |
| dateOccurred |
Date |
Calculated |
| dateCompleted |
Date |
Normal |
| yearOccurred |
Number |
Calculated |
| incidentPlusDate |
Text |
Calculated |
| incidentComplete |
Text |
Calculated |
| actionTakenComplete |
Text |
Calculated |
| locationComplete |
Text |
Calculated |
| isPlayground |
Number |
Calculated |
| childIncidentLocationID |
Text |
Normal |
| isLocked |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| initialEMailSent |
Number |
Normal |
| followUp |
Text |
Normal |
| childIncidentFollowUpID |
Unknown |
Unknown |
| childIncidentFollowUpIDList |
Text |
Normal |
| followUpOther |
Text |
Normal |
| incidentList |
Text |
Calculated |
| locationList |
Text |
Calculated |
| dateCreated |
Date |
Calculated |
| crossJoin |
Number |
Normal |
| dateOccurredUnix |
Text |
Calculated |
| signedBySupervisor |
Number |
Calculated |
| supervisorSignatureName |
Text |
Normal |
| staffSignatureMethod |
Text |
Normal |
| staffSignatureName |
Text |
Normal |
| supervisorSignatureMethod |
Text |
Normal |
Relationships#
- References child on
childIncident.childID = child.childID.
- References room on
childIncident.roomID = room.roomID.
childIllness#
Fields#
| Field |
Data Type |
Field Type |
| actionTaken |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| childIllnessActionTakenID |
Unknown |
Unknown |
| childIllnessActionTakenIDList |
Text |
Normal |
| actionTakenOther |
Text |
Normal |
| complete |
Number |
Normal |
| childID |
Text |
Normal |
| detail |
Text |
Normal |
| completeEMailSent |
Number |
Normal |
| endDateGlobal |
Date |
Normal |
| startDateGlobal |
Date |
Normal |
| illnessObserved |
Text |
Normal |
| symptom |
Unknown |
Unknown |
| childIllnessSymptomID |
Unknown |
Unknown |
| childIllnessSymptomIDList |
Text |
Normal |
| illnessObservedOther |
Text |
Normal |
| pickupChild |
Number |
Normal |
| roomID |
Number |
Normal |
| seriousOccurrence |
Number |
Normal |
| timestampOccurred |
TimeStamp |
Normal |
| constantOne |
Number |
Calculated |
| inComplete |
Number |
Calculated |
| constantOneCount |
Number |
Summary |
| childIllnessID |
Text |
Normal |
| temperatureList |
Text |
Calculated |
| temperature |
Unknown |
Unknown |
| dateOccurred |
Date |
Calculated |
| dateCompleted |
Date |
Normal |
| isLocked |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| initialEMailSent |
Number |
Normal |
| illnessObservedList |
Text |
Calculated |
| dateCreated |
Date |
Calculated |
| crossJoin |
Number |
Normal |
| actionTakenList |
Text |
Calculated |
| dateOccurredUnix |
Text |
Calculated |
| signedBySupervisor |
Number |
Calculated |
| supervisorSignatureName |
Text |
Normal |
| detailCSS |
Text |
Calculated |
| message |
Unknown |
Unknown |
| staffSignatureMethod |
Text |
Normal |
| staffSignatureName |
Text |
Normal |
| supervisorSignatureMethod |
Text |
Normal |
Relationships#
- References child on
childIllness.childID = child.childID.
- References room on
childIllness.roomID = room.roomID.
Notes#
- The operational model uses additional filtered occurrences for date windows, room occupancy, and unresolved-status views. Those were intentionally collapsed here.
childEating is linked to mealSchedule through the exported date-based relationship, which is why the edge label uses both fields.