Platform And Identity ER Diagram#

This domain-focused view highlights the legacy identity, access, and channel-account tables that back parent mobile and staff portal access.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class parent { parentID : Text firstName : Text lastName : Text } class childParent { childParentID : Text parentID : Text familialRelationshipID : Text parentalRoleID : Text mobileAppPermissionLevelID : Text description : Unknown } 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 } class staff { staffID : Text staffPortalPermissionLevelID : Text description : Unknown firstName : Text lastName : Text } class staffPortalPermissionLevel { staffPortalPermissionLevelID : Text description : Text createTS : TimeStamp } class staffPortalUserAccount { staffPortalUserAccountID : Text staffID : Text accountName : Text } class staffPortalUserVerificationCode { staffPortalUserVerificationCodeID : Text staffID : Text createTS : TimeStamp } childParent --> parent : parentID = parentID childParent --> familialRelationship : familialRelationshipID = familialRelationshipID childParent --> parentalRole : parentalRoleID = parentalRoleID childParent --> mobileAppPermissionLevel : mobileAppPermissionLevelID = mobileAppPermissionLevelID mobileAppUserAccount --> parent : parentID = parentID mobileAppUserAccount --> childParent : parentID = parentID staff --> staffPortalPermissionLevel : staffPortalPermissionLevelID = staffPortalPermissionLevelID staffPortalUserAccount --> staff : staffID = staffID staffPortalUserVerificationCode --> staff : staffID = staffID

Tables#

parent#

Primary table details live in parent under Family And Household ER Diagram.

childParent#

Primary table details live in childParent under Family And Household ER Diagram.

familialRelationship#

Primary table details live in familialRelationship under Family And Household ER Diagram.

parentalRole#

Primary table details live in parentalRole under Family And Household ER Diagram.

mobileAppPermissionLevel#

Primary table details live in mobileAppPermissionLevel under Family And Household ER Diagram.

mobileAppUserAccount#

Primary table details live in mobileAppUserAccount under Family And Household ER Diagram.

staff#

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

staffPortalPermissionLevel#

Fields#

Field Data Type Field Type
staffPortalPermissionLevelID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
description Text Normal
descriptionCSS Text Calculated

Relationships#

  • Referenced by staff on staff.staffPortalPermissionLevelID = staffPortalPermissionLevel.staffPortalPermissionLevelID.

staffPortalUserAccount#

Fields#

Field Data Type Field Type
staffPortalUserAccountID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
accountName Text Normal
staffID Text Normal
newHireID Text Normal

Relationships#

  • References staff on staffPortalUserAccount.staffID = staff.staffID.

staffPortalUserVerificationCode#

Fields#

Field Data Type Field Type
staffPortalUserVerificationCodeID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
staffID Text Normal
newHireID Text Normal
verificationCode Binary Normal

Relationships#

  • References staff on staffPortalUserVerificationCode.staffID = staff.staffID.

Notes#

  • mobileAppUserVerificationCode exists in the export but does not expose a resolved base-table relationship beyond connector-style occurrences, so it is shown as a staff-facing credential artifact rather than a fully joined path.
  • The same source data still carries legacy shared-account patterns. This diagram shows the table-level reality, not the recommended target identity design.