Organization And Capacity ER Diagram#

This view focuses on campus and room structure, active program grouping, and room-linked calendar artifacts.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class room { roomID : Number campusID : Number currentProgramGroupID : Number name : Text } class programGroup { programGroupID : Number name : Text modifyTS : TimeStamp } class roomProgram { roomProgramID : Text roomID : Number mondayDate : Date } class roomProgramGroup { roomProgramGroupID : Text roomID : Number programGroupID : Number name : Unknown } class calendarEvent { calendarEventID : Text name : Unknown calendarEventName : Text } class calendarEventRoom { calendarEventRoomID : Text calendarEventID : Text roomID : Number } class calendarMonthRoom { calendarMonthRoomID : Text roomID : Number createTS : TimeStamp } room --> campus : campusID = campusID room --> programGroup : currentProgramGroupID = programGroupID roomProgram --> room : roomID = roomID roomProgramGroup --> room : roomID = roomID roomProgramGroup --> programGroup : programGroupID = programGroupID calendarEventRoom --> calendarEvent : calendarEventID = calendarEventID calendarEventRoom --> room : roomID = roomID calendarMonthRoom --> room : roomID = roomID

Tables#

campus#

Fields#

Field Data Type Field Type
accountNumber Text Normal
address Text Normal
branchNumber Text Normal
currDate Date Calculated
processDate Text Calculated
processDateDate Date Calculated
eftDate Date Normal
name Text Normal
totalAmount Number Normal
transitNumber Text Normal
campusType Text Calculated
campusTypeTrans Number Calculated
currAccountName Text Calculated
constantOne Number Calculated
currPrivilegeSet Text Calculated
currTimestamp TimeStamp Calculated
campusID Number Normal
text01Global Text Normal
unreconciledSubsidyImportCount Number Normal
emailMode Text Normal
deleteEmailAfter Number Normal
date01Global Date Normal
date01GlobalWeekStart Date Calculated
date01GlobalWeekEnd Date Calculated
staffQualificationReportHeader Text Normal
date02Global Date Normal
number01Global Number Normal
devModeEmailAddress Text Normal
testModeEmailAddress Text Normal
date01GlobalMonth Number Calculated
allFailedToggle Text Normal
constantQuality Text Calculated
disallowSiblingDiscount Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
capacityForecastMonths Number Normal
registrationFeeSibling Number Normal
date03Global Date Normal
masterCampus Number Normal
maxGoodAboveRatioPct Number Normal
maxCautionAboveRatioPct Number Normal
maxUnpaidLeaveDays Number Normal
dateList01Global Text Normal
allowNonHomeRoomLogin Number Normal
crossJoin Number Normal
minGoodUtilizationPct Number Normal
minCautionUtilizationPct Number Normal
maxHealthScreeningMins Number Normal
requireHealthScreening Text Normal
phone Text Normal
website Text Normal
facilityType Text Normal
drinkingWaterSystemNo Text Normal
defaultEmailName Text Normal
companyNameShort Text Normal
companyNameLong Text Normal
billingAnchorDate Date Normal
emailCSS Text Normal
emailHeader Text Normal
emailHeaderImageURL Text Normal
emailFooter Text Normal
emailFooterImageURL Text Normal
healthCheckPromptHealthy Text Normal
healthCheckPromptNotHealthy Text Normal
disableDailyReportEmailPrompt Number Normal
daysOfOperation Text Normal
allowMobileParentUpdate Number Normal
allowMobileMessaging Number Normal
registrationFeeRegular Number Normal
maxFoodFromKitchenToClassroomTime Number Normal
daysToPerformWaterFlush Text Normal
disableDashboardEntryForNewChildRegistration Number Normal
clearNewRegistrationDashboardEntriesAfterDays Number Normal
deleteCommunicationsAfter Number Normal
twilioAccountSID Text Normal
twilioMessagingServiceSID Text Normal
twilioAuthToken Text Normal
twilioPhoneNumber Text Normal
applyCWELCCAdjustment Number Normal
allowVacationDiscounts Number Normal
massEmailPrivSetList Text Normal
minExpectedHours Number Normal
maxExpectedHours Number Normal
minTimeOffRequestLeadDays Number Normal
allowWebStaffUpdate Number Normal
eftProvider Text Normal
scotiaBankCustomerRef Text Normal
chefSpecialIngredientDeleteDays Number Normal

Relationships#

  • Referenced by room on room.campusID = campus.campusID.

room#

Fields#

Field Data Type Field Type
attendanceDateGlobal Date Normal
currDate Date Calculated
email Text Normal
roomID Number Normal
maxCapacity Number Calculated
capacity Unknown Unknown
name Text Normal
modifyTS TimeStamp Normal
zeros Number Normal
attendingChildIDList Text Calculated
constantOne Number Calculated
currTimestamp TimeStamp Calculated
timestampFloor TimeStamp Calculated
campusID Number Normal
currentProgramGroupID Number Calculated
programGroupID Unknown Unknown
childIDGlobal Text Normal
mealIDGlobal Text Normal
date01Global Date Normal
timestamp01Global TimeStamp Normal
timestamp02Global TimeStamp Normal
capacityEndDateGlobal Date Normal
capacityStartDateGlobal Date Normal
timestampListGlobal Text Normal
time01Global Time Normal
monday Number Calculated
childID Unknown Unknown
tuesday Number Calculated
wednesday Number Calculated
thursday Number Calculated
friday Number Calculated
mondayMax Number Calculated
tuesdayMax Number Calculated
wednesdayMax Number Calculated
thursdayMax Number Calculated
fridayMax Number Calculated
childDiaperIDGlobal Text Normal
childSleepIDGlobal Text Normal
childItemRequestIDGlobal Text Normal
currTime Time Calculated
staffCheckedIn Number Calculated
childrenCheckedIn Number Calculated
programSpecialtyGlobal Text Normal
text01Global Text Normal
date02Global Date Normal
crossJoin Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
childRoom Number Normal
childRoomValue Text Calculated
maxStaff Number Normal
constantYes Text Calculated
dateList01Global Text Normal
checkedInChildIDList Text Calculated
assignedCheckedInChildIDList Text Calculated
number01Global Number Normal
phoneExtension Text Normal
reqdStaff Number Normal
roomShiftResponsibilityShiftList Text Normal
currentDayName Text Calculated
constantChildNotice Text Calculated
constantParent Text Calculated
constantEducator Text Calculated
constantSupervisor Text Calculated
roomIDPlusZero Text Calculated
saturday Number Calculated
saturdayMax Number Calculated
sunday Number Calculated
sundayMax Number Calculated
date01GlobalMonth Number Calculated
roomIDListGlobal Text Normal
sort Number Normal
calendarMonthIDGlobal Text Normal
childrenSleeping Number Calculated
roomTransferID Text Normal
hideOnOrgChart Number Normal

Relationships#

  • References campus on room.campusID = campus.campusID.
  • References programGroup on room.currentProgramGroupID = programGroup.programGroupID.
  • Referenced by roomProgram on roomProgram.roomID = room.roomID.
  • Referenced by roomProgramGroup on roomProgramGroup.roomID = room.roomID.
  • Referenced by calendarEventRoom on calendarEventRoom.roomID = room.roomID.
  • Referenced by calendarMonthRoom on calendarMonthRoom.roomID = room.roomID.

programGroup#

Fields#

Field Data Type Field Type
programGroupID Number Normal
name Text Normal
modifyTS TimeStamp Normal
numRooms Number Normal
sleepCheckInterval Time Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
transitionEmailInventoryID Text Normal
minAgeInMonths Number Normal
maxAgeInMonths Number Normal
date01Global Date Normal
date02Global Date Normal
prevAgeGroupProgramGroupID Number Normal
number01Global Number Normal
number02Global Number Normal
followUpEmailInventoryID Text Normal
dateList01Global Text Normal
omitFromForecast Number Normal
hideInScheduleDetail Number Normal
nameNotHidden Text Calculated
requireSleepCheck Number Normal
constantOne Number Calculated
infoSessionEmailInventoryID Text Normal

Relationships#

  • Referenced by room on room.currentProgramGroupID = programGroup.programGroupID.
  • Referenced by roomProgramGroup on roomProgramGroup.programGroupID = programGroup.programGroupID.

roomProgram#

Fields#

Field Data Type Field Type
roomID Number Normal
mondayDate Date Normal
educatorInstructionsGlobal Text Normal
targetGlobal Text Normal
goalGlobal Text Normal
wordOfTheWeek Text Normal
roomProgramID Text Normal
programTaskAreaIDGlobal Text Normal
fridayDate Date Calculated
thursdayDate Date Calculated
tuesdayDate Date Calculated
wednesdayDate Date Calculated
interestTopic Text Normal
roomProgramElectDomainIDGlobal Text Normal
programObjectiveAreaIDGlobal Text Normal
programGroupID Number Normal
currentProgramGroupID Unknown Unknown
programSelectorGlobal Text Normal
parentsParticipate Text Normal
roomProgramElectIDGlobal Text Normal
crossJoin Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
roomProgramElectGoalIDGlobal Text Normal

Relationships#

  • References room on roomProgram.roomID = room.roomID.

roomProgramGroup#

Fields#

Field Data Type Field Type
roomProgramGroupID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
roomID Number Normal
programGroupID Number Normal
startDate Date Normal
endDate Date Normal
capacity Number Normal
programGroupNameStartDateEndDateDisplay Text Calculated
name Unknown Unknown

Relationships#

  • References room on roomProgramGroup.roomID = room.roomID.
  • References programGroup on roomProgramGroup.programGroupID = programGroup.programGroupID.

calendarEvent#

Fields#

Field Data Type Field Type
calendarEventID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
crossJoin Number Normal
startDate Date Normal
endDate Date Normal
calendarEventName Text Normal
startTime Time Normal
endTime Time Normal
allDay Number Normal
calendarEventNotes Text Normal
roomNameList Text Calculated
name Unknown Unknown
startDateTimeEndDateTimeDisplay Text Calculated

Relationships#

  • Referenced by calendarEventRoom on calendarEventRoom.calendarEventID = calendarEvent.calendarEventID.

calendarEventRoom#

Fields#

Field Data Type Field Type
calendarEventRoomID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
calendarEventID Text Normal
roomID Number Normal

Relationships#

  • References calendarEvent on calendarEventRoom.calendarEventID = calendarEvent.calendarEventID.
  • References room on calendarEventRoom.roomID = room.roomID.

calendarMonthRoom#

Fields#

Field Data Type Field Type
calendarMonthRoomID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
calendarMonthID Text Normal
roomID Number Normal
classroomHighlights Text Normal

Relationships#

  • References room on calendarMonthRoom.roomID = room.roomID.

Notes#

  • The legacy graph also contains many report-oriented room occurrences and date-filtered variants. They were excluded here to keep the structural organization model readable.
  • roomProgramGroup carries the time-bounded room-to-program assignment logic through startDate and endDate.