Facilities And Kitchen ER Diagram#

This view focuses on repair, safety meeting, checklist, and meal-schedule tables that support center readiness and facility operations.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class campus { campusID : Number name : Text accountNumber : Text } class room { roomID : Number name : Text attendanceDateGlobal : Date } class staff { staffID : Text description : Unknown firstName : Text lastName : Text } class repairOrder { repairOrderID : Text campusID : Number roomID : Number reportedByStaffID : Text name : Unknown description : Unknown } class healthSafetyMeeting { healthSafetyMeetingID : Text campusID : Number callToOrderTimestamp : TimeStamp } class healthSafetyMeetingStaff { healthSafetyMeetingStaffID : Text healthSafetyMeetingID : Text staffID : Text } class healthSafetyChecklist { healthSafetyChecklistID : Text campusID : Number checklistFrequency : Text } class healthSafetyChecklistItem { healthSafetyChecklistItemID : Text healthSafetyChecklistID : Text repairOrderID : Text description : Text } class mealSchedule { mealScheduleID : Text campusID : Number mealDate : Date } repairOrder --> campus : campusID = campusID repairOrder --> room : roomID = roomID repairOrder --> staff : reportedByStaffID = staffID healthSafetyMeeting --> campus : campusID = campusID healthSafetyMeetingStaff --> healthSafetyMeeting : healthSafetyMeetingID = healthSafetyMeetingID healthSafetyMeetingStaff --> staff : staffID = staffID healthSafetyChecklist --> campus : campusID = campusID healthSafetyChecklistItem --> healthSafetyChecklist : healthSafetyChecklistID = healthSafetyChecklistID healthSafetyChecklistItem --> repairOrder : repairOrderID = repairOrderID mealSchedule --> campus : campusID = campusID

Tables#

campus#

Primary table details live in campus under Organization And Capacity ER Diagram.

room#

Primary table details live in room under Organization And Capacity ER Diagram.

staff#

Primary table details live in staff under Workforce And Reviews ER Diagram.

repairOrder#

Fields#

Field Data Type Field Type
reportedByStaffID Text Normal
reportedTo Text Normal
timestampReported TimeStamp Normal
detail Text Normal
actionPlan Text Normal
timeLine Text Normal
dateCompleted Date Normal
location Text Normal
description Unknown Unknown
campusID Number Normal
repairOrderID Text Normal
yearReported Number Calculated
emailSentToMaintenance Date Normal
complete Number Calculated
healthSafetyChecklistItemIDGlobal Text Normal
crossJoin Number Normal
playspaceID Text Normal
roomID Number Normal
completedBy Text Normal
room Text Normal
name Unknown Unknown
roomOtherFlag Number Normal
allergenName Unknown Unknown
playspace Text Normal
playspaceName Unknown Unknown
playspaceOtherFlag Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
checkedByStaffName Text Normal
playspaceInventoryID Text Normal
maintenanceChecklistInventoryID Text Normal
locationDetail Text Normal
repairOrderLocationID Text Normal
locationPlusDetail Text Calculated

Relationships#

  • References campus on repairOrder.campusID = campus.campusID.
  • References room on repairOrder.roomID = room.roomID.
  • References staff on repairOrder.reportedByStaffID = staff.staffID.
  • Referenced by healthSafetyChecklistItem on healthSafetyChecklistItem.repairOrderID = repairOrder.repairOrderID.

healthSafetyMeeting#

Fields#

Field Data Type Field Type
campusID Number Normal
callToOrderTimestamp TimeStamp Normal
adoptionOfAgenda Text Normal
meetingAdjournedAtDate Date Normal
nextMeetingDate Date Normal
nextMeetingLocation Text Normal
meetingTime Time Normal
meetingLocation Text Normal
meetingDate Date Normal
oldBusiness Text Normal
healthSafetyMeetingID Text Normal
constantOne Number Calculated
monthYearDisplay Text Calculated
previousHealthSafetyMeetingIDGlobal Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
nextMeetingTime Time Normal
meetingAdjournedAtTime Time Normal
crossJoin Number Normal

Relationships#

  • References campus on healthSafetyMeeting.campusID = campus.campusID.
  • Referenced by healthSafetyMeetingStaff on healthSafetyMeetingStaff.healthSafetyMeetingID = healthSafetyMeeting.healthSafetyMeetingID.

healthSafetyMeetingStaff#

Fields#

Field Data Type Field Type
healthSafetyMeetingID Text Normal
healthSafetyMeetingStaffID Text Normal
staffID Text Normal
response Text Normal
dateApproved Date Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
staffOtherFlag Number Normal
staffName Text Normal
staffNameFirstMiddleLast Unknown Unknown

Relationships#

  • References healthSafetyMeeting on healthSafetyMeetingStaff.healthSafetyMeetingID = healthSafetyMeeting.healthSafetyMeetingID.
  • References staff on healthSafetyMeetingStaff.staffID = staff.staffID.

healthSafetyChecklist#

Fields#

Field Data Type Field Type
healthSafetyChecklistID Text Normal
checklistFrequency Text Normal
checkDate Date Normal
comments Text Normal
campusID Number Normal
timestampCompleted TimeStamp Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
staffSignatureMethod Text Normal
staffSignatureName Text Normal

Relationships#

  • References campus on healthSafetyChecklist.campusID = campus.campusID.
  • Referenced by healthSafetyChecklistItem on healthSafetyChecklistItem.healthSafetyChecklistID = healthSafetyChecklist.healthSafetyChecklistID.

healthSafetyChecklistItem#

Fields#

Field Data Type Field Type
healthSafetyChecklistItemID Text Normal
healthSafetyInventoryID Text Normal
issues Text Normal
healthSafetyChecklistID Text Normal
isOkay Number Normal
healthSafetyAreaID Text Normal
repairOrderCreated Number Calculated
repairOrderID Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
constantHealthSafety Text Calculated
description Text Normal
crossJoin Number Normal

Relationships#

  • References healthSafetyChecklist on healthSafetyChecklistItem.healthSafetyChecklistID = healthSafetyChecklist.healthSafetyChecklistID.
  • References repairOrder on healthSafetyChecklistItem.repairOrderID = repairOrder.repairOrderID.

mealSchedule#

Primary table details live in mealSchedule under Daily Care And Attendance ER Diagram.

Notes#

  • The facilities graph also contains inventory, area, and certificate evidence tables. This view stays on the operational remediation path from checklist item to repair order.
  • mealSchedule is included here because it is owned with campus-level kitchen operations in the target domain documentation.