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#
- `parent`
- `childParent`
- `familialRelationship`
- `parentalRole`
- `mobileAppPermissionLevel`
- `mobileAppUserAccount`
- `staff`
- `staffPortalPermissionLevel`
- `staffPortalUserAccount`
- `staffPortalUserVerificationCode`
%%{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#
mobileAppUserVerificationCodeexists 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.