Shared Evidence ER Diagram#

This view captures reusable evidence-style records that appear across domains: policy acknowledgments and certificate evidence.

Included Tables#

%%{init: {"securityLevel":"loose"}}%% classDiagram direction LR class staff { staffID : Text description : Unknown firstName : Text lastName : Text } class initialPolicySignature { initialPolicySignatureID : Text staffID : Text policyID : Text } class policySignature { policySignatureID : Text staffID : Text policyID : Text } class certificateInventory { certificateInventoryID : Text description : Text createAccount : Text } class certificate { certificateID : Text certificateInventoryID : Text description : Text } initialPolicySignature --> staff : staffID = staffID policySignature --> staff : staffID = staffID certificate --> certificateInventory : certificateInventoryID = certificateInventoryID

Tables#

staff#

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

initialPolicySignature#

Fields#

Field Data Type Field Type
initialPolicySignatureID Text Normal
policyID Text Normal
staffID Text Normal
sort Number Normal
signatureDate Date Normal
staffSignatureName Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
includeOnDetailReport Number Normal
policyName Text Normal
staffSignatureMethod Text Normal

Relationships#

  • References staff on initialPolicySignature.staffID = staff.staffID.

policySignature#

Fields#

Field Data Type Field Type
policySignatureID Text Normal
policyID Text Normal
datePolicySignature Date Normal
staffSignatureName Text Normal
sort Number Normal
staffID Text Normal
includeOnDetailReport Number Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
isLocked Number Normal
year Number Normal
policyName Text Normal
staffSignatureMethod Text Normal

Relationships#

  • References staff on policySignature.staffID = staff.staffID.

certificateInventory#

Fields#

Field Data Type Field Type
certificateInventoryID Text Normal
description Text Normal
createAccount Text Normal
createTS TimeStamp Normal
modifyAccount Text Normal
modifyTS TimeStamp Normal
playspaceOrHealthSafety Text Normal
includeFromToDates Number Normal
descriptionCSS Text Calculated
certificateTypeID Number Normal

Relationships#

  • Referenced by certificate on certificate.certificateInventoryID = certificateInventory.certificateInventoryID.

certificate#

Fields#

Field Data Type Field Type
certificateID Text Normal
createTS TimeStamp Normal
createAccount Text Normal
modifyTS TimeStamp Normal
modifyAccount Text Normal
certificateInventoryID Text Normal
playspaceOrHealthSafety Text Normal
fromDate Date Normal
toDate Date Normal
issueDate Date Normal
campusID Number Normal
description Text Normal
notes Text Normal
hasNoncompliance Number Normal

Relationships#

  • References certificateInventory on certificate.certificateInventoryID = certificateInventory.certificateInventoryID.

Notes#

  • certificateInventory.certificateTypeID exists in the exported fields, but the current normalized relationship set does not expose a direct base-table relation to certificateType.
  • These tables are structurally shared, but the workflows that create them belong to business domains such as staff compliance and facilities.