Coflyr · Backend model field catalog
SafetyCommunication
SafetyManagement.SafetyCommunications.
20 mapped fieldsUnder development5 field groupsGenerated 2026-10-06
Every mapped scalar field appears once. Types and nullability come from the current EF model snapshot. Navigation properties and unmapped DTO fields are outside this page. Purpose text is inferred from names and should be checked against the feature workflow.
Identity and naming
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | CommunicationNumber | string | Required | Records communication number for this safety communication. |
| 3 | Title | string | Required | Records title for this safety communication. |
Relationships and references
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | HazardId | Guid? | Nullable | Selects the related hazard record. |
| 2 | LearningActivityId | Guid? | Nullable | Selects the related learning activity record. |
| 3 | PublicationMasterId | Guid? | Nullable | Selects the related publication master record. |
| 4 | RecipientBusinessPartnerId | Guid? | Nullable | Selects the related recipient business partner record. |
| 5 | SafetyScopeId | Guid | Required | Selects the related safety scope record. |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | LegalHold | bool | Required | Indicates whether legal hold applies to this safety communication. |
Audit and revision
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | SystemAuditId | Guid? | Nullable | Links to system audit history when this model stores the reference. |
| 2 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
9 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AcknowledgedAt | DateTimeOffset? | Nullable | Records the acknowledged at for this safety communication. |
| 2 | DeidentifiedContent | string | Required | Records deidentified content for this safety communication. |
| 3 | EffectivenessEvaluation | string | Nullable | Records effectiveness evaluation for this safety communication. |
| 4 | IntendedAudience | string | Required | Records intended audience for this safety communication. |
| 5 | PublishedAt | DateTimeOffset? | Nullable | Records the published at for this safety communication. |
| 6 | RetainUntil | DateTimeOffset? | Nullable | Records retain until for this safety communication. |
| 7 | RetentionCategory | string | Nullable | Records retention category for this safety communication. |
| 8 | RowVersionDB: xmin | uint | Required | Records row version for this safety communication. |
| 9 | SentAt | DateTimeOffset? | Nullable | Records the sent at for this safety communication. |