Coflyr · Backend model field catalog
RiskAssessment
SafetyManagement.RiskAssessments.
30 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 | AssessmentNumber | string | Required | Records assessment number for this risk assessment. |
| 3 | VersionNumber | int | Required | Records version number for this risk assessment. |
Relationships and references
6 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AssessorStaffMemberId | Guid? | Nullable | Selects the related assessor staff member record. |
| 2 | HazardId | Guid | Required | Selects the related hazard record. |
| 3 | ReviewerStaffMemberId | Guid? | Nullable | Selects the related reviewer staff member record. |
| 4 | RiskMethodVersionId | Guid | Required | Selects the related risk method version record. |
| 5 | SafetyScopeId | Guid | Required | Selects the related safety scope record. |
| 6 | SupersedesAssessmentId | Guid? | Nullable | Selects the related supersedes assessment record. |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | LegalHold | bool | Required | Indicates whether legal hold applies to this risk assessment. |
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
18 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AssessedAt | DateTimeOffset? | Nullable | Records the assessed at for this risk assessment. |
| 2 | AssessmentRationale | string | Nullable | Records assessment rationale for this risk assessment. |
| 3 | AssessmentState | int | Required | Records assessment state for this risk assessment. |
| 4 | ConsequenceScenario | string | Required | Records consequence scenario for this risk assessment. |
| 5 | ExposureAndAssumptions | string | Required | Records exposure and assumptions for this risk assessment. |
| 6 | InitialLikelihoodCode | string | Nullable | Records initial likelihood code for this risk assessment. |
| 7 | InitialRiskClassCode | string | Nullable | Records initial risk class code for this risk assessment. |
| 8 | InitialRiskIndexCode | string | Nullable | Records initial risk index code for this risk assessment. |
| 9 | InitialSeverityCode | string | Nullable | Records initial severity code for this risk assessment. |
| 10 | NextReviewAt | DateTimeOffset? | Nullable | Records the next review at for this risk assessment. |
| 11 | ResidualLikelihoodCode | string | Nullable | Records residual likelihood code for this risk assessment. |
| 12 | ResidualRiskBasis | int | Required | Records residual risk basis for this risk assessment. |
| 13 | ResidualRiskClassCode | string | Nullable | Records residual risk class code for this risk assessment. |
| 14 | ResidualRiskIndexCode | string | Nullable | Records residual risk index code for this risk assessment. |
| 15 | ResidualSeverityCode | string | Nullable | Records residual severity code for this risk assessment. |
| 16 | RetainUntil | DateTimeOffset? | Nullable | Records retain until for this risk assessment. |
| 17 | RetentionCategory | string | Nullable | Records retention category for this risk assessment. |
| 18 | RowVersionDB: xmin | uint | Required | Records row version for this risk assessment. |