Coflyr · Backend model field catalog
SafetyAction
SafetyManagement.SafetyActions.
27 mapped fieldsUnder development7 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
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | ActionNumber | string | Required | Records action number for this safety action. |
Relationships and references
11 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | HazardId | Guid? | Nullable | Selects the related hazard record. |
| 2 | ManagementOfChangeId | Guid? | Nullable | Selects the related management of change record. |
| 3 | ResponsibleDepartmentId | Guid? | Nullable | Selects the related responsible department record. |
| 4 | ResponsibleStaffMemberId | Guid? | Nullable | Selects the related responsible staff member record. |
| 5 | RiskAssessmentId | Guid? | Nullable | Selects the related risk assessment record. |
| 6 | SafetyControlId | Guid? | Nullable | Selects the related safety control record. |
| 7 | SafetyEmergencyExerciseId | Guid? | Nullable | Selects the related safety emergency exercise record. |
| 8 | SafetyManagementReviewId | Guid? | Nullable | Selects the related safety management review record. |
| 9 | SafetyReportId | Guid? | Nullable | Selects the related safety report record. |
| 10 | SafetyScopeId | Guid | Required | Selects the related safety scope record. |
| 11 | VerifiedByStaffMemberId | Guid? | Nullable | Selects the related verified by staff member record. |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | LegalHold | bool | Required | Indicates whether legal hold applies to this safety action. |
Dates and timing
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | DueAt | DateTimeOffset? | Nullable | Records the due at for this safety action. |
Descriptions and details
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ActionText | string | Required | Records action text for this safety action. |
Audit and revision
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | RelatedAuditCorrectiveActionId | Guid? | Nullable | Selects the related related audit corrective action record. |
| 2 | SystemAuditId | Guid? | Nullable | Links to system audit history when this model stores the reference. |
| 3 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
8 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ActionState | int | Required | Records action state for this safety action. |
| 2 | CompletedAt | DateTimeOffset? | Nullable | Records the completed at for this safety action. |
| 3 | CompletionEvidenceSummary | string | Nullable | Records completion evidence summary for this safety action. |
| 4 | RetainUntil | DateTimeOffset? | Nullable | Records retain until for this safety action. |
| 5 | RetentionCategory | string | Nullable | Records retention category for this safety action. |
| 6 | RootCauseAnalysis | string | Nullable | Records root cause analysis for this safety action. |
| 7 | RowVersionDB: xmin | uint | Required | Records row version for this safety action. |
| 8 | VerifiedAt | DateTimeOffset? | Nullable | Records the verified at for this safety action. |