Family And Household ER Diagram#

This view covers guardian linkage, relationship metadata, and parent-facing access configuration around the child.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class child { childID : Text primaryParentID : Number description : Unknown firstName : Text lastName : Text } class parent { parentID : Text firstName : Text lastName : Text } class childParent { childParentID : Text childID : Text parentID : Text familialRelationshipID : Text parentalRoleID : Text mobileAppPermissionLevelID : Text } class familialRelationship { familialRelationshipID : Text description : Text createTS : TimeStamp } class parentalRole { parentalRoleID : Text description : Text createAccount : Text } class mobileAppPermissionLevel { mobileAppPermissionLevelID : Text description : Text createTS : TimeStamp } class mobileAppUserAccount { mobileAppUserAccountID : Text parentID : Text accountName : Text } childParent --> child : childID = childID childParent --> parent : parentID = parentID child --> parent : primaryParentID = parentID childParent --> familialRelationship : familialRelationshipID = familialRelationshipID childParent --> parentalRole : parentalRoleID = parentalRoleID childParent --> mobileAppPermissionLevel : mobileAppPermissionLevelID = mobileAppPermissionLevelID mobileAppUserAccount --> parent : parentID = parentID mobileAppUserAccount --> childParent : parentID = parentID

Tables#

child#

Primary table details live in child under Children Domain ER Diagram.

parent#

Fields#

Field Data Type Field Type
bankAccount Text Normal
bankNumber Text Normal
bankTimestamp TimeStamp Normal
bankTransit Text Normal
businessName Text Normal
amountDue Number Calculated
amountNet Unknown Unknown
amountDueNoRound Number Calculated
autoCharge Number Calculated
bankAuthorization Unknown Unknown
childrenNameList Text Calculated
childNameFirstLast Unknown Unknown
nameFirstLast Text Calculated
firstName Text Normal
lastName Text Normal
processDate Date Calculated
taxAmount Number Calculated
amountReceivedSum Unknown Unknown
txnCode Text Calculated
txnType Text Calculated
amountNetSum Unknown Unknown
cellPhone Text Normal
email Text Normal
modifyTS TimeStamp Normal
constantPersonal Text Calculated
homeAddress Text Normal
homePhone Text Normal
homeProvince Text Normal
homeZip Text Normal
parentID Text Normal
nameOnTax Text Normal
taxYear Number Normal
workAddress Text Normal
workPhone Text Normal
workProvince Text Normal
workZip Text Normal
constantOne Number Calculated
taxYearStart Date Calculated
taxYearEnd Date Calculated
homeCity Text Normal
workCity Text Normal
amountToDate Number Calculated
number01Global Number Normal
taxNumber Number Calculated
referenceID Text Calculated
subsidyAmountDue Number Calculated
total Unknown Unknown
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
crossJoin Number Normal
date01Global Date Normal
date02Global Date Normal
dateList01Global Text Normal
cellPhoneNumeric Text Calculated
homePhoneNumeric Text Calculated
workPhoneNumeric Text Calculated
amountDueNoRoundAbs Number Calculated
processDateCredit Date Calculated

Relationships#

  • Referenced by childParent on childParent.parentID = parent.parentID.
  • Referenced by child on child.primaryParentID = parent.parentID.
  • Referenced by mobileAppUserAccount on mobileAppUserAccount.parentID = parent.parentID.

childParent#

Fields#

Field Data Type Field Type
childID Text Normal
parentID Text Normal
comment Text Normal
currBillableAmount Number Normal
modifyTS TimeStamp Normal
billableAmount Unknown Unknown
currBillableAmountSum Number Summary
childParentID Text Normal
relationship Text Normal
description Unknown Unknown
canPickup Number Normal
currDate Date Calculated
receiveEmail Number Normal
billDate Date Calculated
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
mobileAppPermissions Text Normal
role Text Normal
crossJoin Number Normal
familialRelationshipID Text Normal
mobileAppPermissionLevelID Text Normal
parentalRoleID Text Normal
billingZeroDate Date Normal

Relationships#

  • References child on childParent.childID = child.childID.
  • References parent on childParent.parentID = parent.parentID.
  • References familialRelationship on childParent.familialRelationshipID = familialRelationship.familialRelationshipID.
  • References parentalRole on childParent.parentalRoleID = parentalRole.parentalRoleID.
  • References mobileAppPermissionLevel on childParent.mobileAppPermissionLevelID = mobileAppPermissionLevel.mobileAppPermissionLevelID.
  • Referenced by mobileAppUserAccount on mobileAppUserAccount.parentID = childParent.parentID.

familialRelationship#

Fields#

Field Data Type Field Type
familialRelationshipID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
description Text Normal
sort Number Normal
descriptionCSS Text Calculated

Relationships#

  • Referenced by childParent on childParent.familialRelationshipID = familialRelationship.familialRelationshipID.

parentalRole#

Fields#

Field Data Type Field Type
createAccount Text Normal
createTS TimeStamp Normal
description Text Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
parentalRoleID Text Normal

Relationships#

  • Referenced by childParent on childParent.parentalRoleID = parentalRole.parentalRoleID.

mobileAppPermissionLevel#

Fields#

Field Data Type Field Type
mobileAppPermissionLevelID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
description Text Normal

Relationships#

  • Referenced by childParent on childParent.mobileAppPermissionLevelID = mobileAppPermissionLevel.mobileAppPermissionLevelID.

mobileAppUserAccount#

Fields#

Field Data Type Field Type
mobileAppUserAccountID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
accountName Text Normal
parentID Text Normal
registrationParentID Text Normal

Relationships#

  • References parent on mobileAppUserAccount.parentID = parent.parentID.
  • References childParent on mobileAppUserAccount.parentID = childParent.parentID.

Notes#

  • childParent is the core household bridge table in the legacy export.
  • Billing-related household tables such as parentAccount and subsidyAccount are shown in the finance diagram to keep this view focused on access and relationships.