Health And Authorizations ER Diagram#
This view focuses on allergies, medical conditions, authorizations, medication administration, and health-linked child context.
Included Tables#
%%{init: {"securityLevel":"loose"}}%%
classDiagram
direction LR
class child {
childID : Text
primaryDoctorID : Text
description : Unknown
firstName : Text
lastName : Text
}
class doctor {
doctorID : Text
firstName : Text
lastName : Text
}
class allergen {
allergenID : Text
allergenName : Text
modifyTS : TimeStamp
}
class childAllergy {
childAllergyID : Text
childID : Text
allergenID : Text
}
class childMedicalCondition {
childMedicalConditionID : Text
childID : Text
description : Unknown
}
class childMedAuthorization {
childMedAuthorizationID : Text
childID : Text
administrationInstruction : Text
}
class childMedAdministration {
childMedAdministrationID : Text
childMedAuthorizationID : Number
staffID : Text
}
class childSpecialNeed {
childSpecialNeedID : Text
childID : Text
description : Unknown
}
class staff {
staffID : Text
description : Unknown
firstName : Text
lastName : Text
}
child --> doctor : primaryDoctorID = doctorID
childAllergy --> child : childID = childID
childAllergy --> allergen : allergenID = allergenID
childMedicalCondition --> child : childID = childID
childSpecialNeed --> child : childID = childID
childMedAuthorization --> child : childID = childID
childMedAdministration --> childMedAuthorization : childMedAuthorizationID = childMedAuthorizationID
childMedAdministration --> staff : staffID = staffID
Tables#
child#
Primary table details live in child under Children Domain ER Diagram.
doctor#
Fields#
| Field |
Data Type |
Field Type |
| doctorID |
Text |
Normal |
| fullName |
Text |
Calculated |
| firstName |
Text |
Normal |
| lastName |
Text |
Normal |
| address |
Text |
Normal |
| city |
Text |
Normal |
| province |
Text |
Normal |
| zip |
Text |
Normal |
| workPhone |
Text |
Normal |
| email |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| workPhoneNumeric |
Text |
Calculated |
| addressCSS |
Text |
Calculated |
| cityCSS |
Text |
Calculated |
| emailCSS |
Text |
Calculated |
| firstNameCSS |
Text |
Calculated |
| lastNameCSS |
Text |
Calculated |
| provinceCSS |
Text |
Calculated |
| workPhoneCSS |
Text |
Calculated |
| zipCSS |
Text |
Calculated |
Relationships#
- Referenced by child on
child.primaryDoctorID = doctor.doctorID.
allergen#
Fields#
| Field |
Data Type |
Field Type |
| allergenID |
Text |
Normal |
| allergenName |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| isFoodRelated |
Number |
Normal |
| allergenNameFood |
Text |
Calculated |
| allowSubstitute |
Number |
Normal |
| allergenNameCSS |
Text |
Calculated |
| useForMilk |
Number |
Normal |
Relationships#
- Referenced by childAllergy on
childAllergy.allergenID = allergen.allergenID.
childAllergy#
Fields#
| Field |
Data Type |
Field Type |
| allergenID |
Text |
Normal |
| allergen |
Text |
Normal |
| allergenName |
Unknown |
Unknown |
| childID |
Text |
Normal |
| details |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| strategyToReduceRisk |
Unknown |
Unknown |
| constantOne |
Number |
Calculated |
| currDate |
Date |
Calculated |
| severity |
Text |
Normal |
| childAllergyID |
Text |
Normal |
| childIDListOf |
Text |
Summary |
| childSymptomIDGlobal |
Text |
Normal |
| childAllergySymptomIDGlobal |
Text |
Normal |
| childMedAuthorizationIDGlobal |
Text |
Normal |
| symptomList |
Text |
Calculated |
| symptom |
Unknown |
Unknown |
| crossJoin |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| constantIAP |
Text |
Calculated |
| isFoodRelated |
Number |
Normal |
| allergenNamePlusSubstitute |
Text |
Calculated |
| foodAndAllergySubstitute |
Unknown |
Unknown |
| allergenPlusActions |
Text |
Calculated |
| emergencyActionList |
Text |
Calculated |
| childAllergyCausativeAgentIDGlobal |
Text |
Normal |
| milk |
Number |
Normal |
| useForMilk |
Unknown |
Unknown |
| foodSubstituteDisplay |
Text |
Calculated |
| childAllergySubstituteID |
Unknown |
Unknown |
Relationships#
- References child on
childAllergy.childID = child.childID.
- References allergen on
childAllergy.allergenID = allergen.allergenID.
childMedicalCondition#
Fields#
| Field |
Data Type |
Field Type |
| medicalConditionID |
Text |
Normal |
| childID |
Text |
Normal |
| details |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| strategyToReduceRisk |
Unknown |
Unknown |
| constantOne |
Number |
Calculated |
| childMedicalConditionID |
Text |
Normal |
| symptomList |
Text |
Calculated |
| symptom |
Unknown |
Unknown |
| comments |
Text |
Normal |
| severity |
Text |
Normal |
| medicalCondition |
Text |
Normal |
| description |
Unknown |
Unknown |
| childMedicalConditionSymptomIDGlobal |
Text |
Normal |
| childMedAuthorizationIDGlobal |
Text |
Normal |
| childSymptomIDGlobal |
Text |
Normal |
| crossJoin |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| constantIMP |
Text |
Calculated |
| childMedicalConditionCausativeAgentIDGlobal |
Text |
Normal |
Relationships#
- References child on
childMedicalCondition.childID = child.childID.
childMedAuthorization#
Fields#
| Field |
Data Type |
Field Type |
| administrationInstruction |
Text |
Normal |
| complete |
Number |
Normal |
| parentSignatureName |
Text |
Normal |
| supervisorSignatureName |
Text |
Normal |
| finished |
Number |
Normal |
| childID |
Text |
Normal |
| doctor |
Text |
Normal |
| doctorAddress |
Text |
Normal |
| dosageAmount |
Text |
Normal |
| endDate |
Date |
Normal |
| endDateGlobal |
Date |
Normal |
| startDateGlobal |
Date |
Normal |
| childMedAuthorizationID |
Text |
Normal |
| medication |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| medicationName |
Unknown |
Unknown |
| parentTakeMedHomeDaily |
Text |
Normal |
| prescription |
Number |
Normal |
| startDate |
Date |
Normal |
| storageInstruction |
Text |
Normal |
| storageInstructionOther |
Text |
Normal |
| constantOne |
Number |
Calculated |
| inComplete |
Number |
Calculated |
| constantOneCount |
Number |
Summary |
| nextTimestampDue |
TimeStamp |
Normal |
| approved |
Number |
Normal |
| currTime |
Time |
Calculated |
| expiryDate |
Date |
Normal |
| adminTimeList |
Text |
Calculated |
| dosageAdminTime |
Unknown |
Unknown |
| storageInstructionCombined |
Text |
Calculated |
| dateCompleted |
Date |
Normal |
| childIDListOf |
Text |
Summary |
| injectLocation |
Text |
Normal |
| childMedAuthorizationMedicationID |
Text |
Normal |
| isLocked |
Number |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| initialEMailSent |
Number |
Normal |
| dateCreated |
Date |
Calculated |
| crossJoin |
Number |
Normal |
| approvalDate |
Date |
Normal |
| activeValueListTitle |
Text |
Calculated |
| medicationPlusEndDate |
Text |
Calculated |
| expiryDateMax |
Date |
Calculated |
| signedBySupervisor |
Number |
Calculated |
| planSourceList |
Text |
Normal |
| attachedToPlan |
Text |
Calculated |
| childMedAdministrationIDGlobal |
Text |
Normal |
| supervisorSignatureMethod |
Text |
Normal |
| parentSignatureMethod |
Text |
Normal |
Relationships#
- References child on
childMedAuthorization.childID = child.childID.
- Referenced by childMedAdministration on
childMedAdministration.childMedAuthorizationID = childMedAuthorization.childMedAuthorizationID.
childMedAdministration#
Fields#
| Field |
Data Type |
Field Type |
| childMedAuthorizationID |
Number |
Normal |
| timestampAdministered |
TimeStamp |
Normal |
| dosageAdministered |
Text |
Normal |
| dosageAmount |
Unknown |
Unknown |
| staffID |
Text |
Normal |
| emailSent |
Number |
Normal |
| childMedAdministrationID |
Text |
Normal |
| notes |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| isLocked |
Number |
Normal |
| dateAdministered |
Date |
Calculated |
| crossJoin |
Number |
Normal |
| staffSignatureMethod |
Text |
Normal |
| staffSignatureName |
Text |
Normal |
Relationships#
- References childMedAuthorization on
childMedAdministration.childMedAuthorizationID = childMedAuthorization.childMedAuthorizationID.
- References staff on
childMedAdministration.staffID = staff.staffID.
childSpecialNeed#
Fields#
| Field |
Data Type |
Field Type |
| specialNeedID |
Text |
Normal |
| childID |
Text |
Normal |
| constantOne |
Number |
Calculated |
| childSpecialNeedID |
Text |
Normal |
| symptomList |
Text |
Calculated |
| symptom |
Unknown |
Unknown |
| comments |
Text |
Normal |
| severity |
Text |
Normal |
| specialNeed |
Text |
Normal |
| description |
Unknown |
Unknown |
| stepsToReduceWorsening |
Text |
Normal |
| modifyTS |
TimeStamp |
Normal |
| strategyToReduceRisk |
Unknown |
Unknown |
| crossJoin |
Number |
Normal |
| childSymptomIDGlobal |
Text |
Normal |
| childSpecialNeedSymptomIDGlobal |
Text |
Normal |
| childMedAuthorizationIDGlobal |
Text |
Normal |
| createAccount |
Text |
Normal |
| createTS |
TimeStamp |
Normal |
| modifyAccount |
Text |
Normal |
| childSupportISPID |
Text |
Normal |
| constantISP |
Text |
Calculated |
| childSpecialNeedCausativeAgentIDGlobal |
Text |
Normal |
Relationships#
- References child on
childSpecialNeed.childID = child.childID.
staff#
Primary table details live in staff under Workforce And Reviews ER Diagram.
Notes#
- The export contains many filtered health relations for draft, archive, and approval-state variants. This diagram shows the stable operational records only.
- Several authorization workflows also branch to symptom and emergency-action tables that are omitted here for readability.