Coflyr · Backend model field catalog
RepositoryWorkStepRevision
Maintenance.WorkStep.
27 mapped fields7 field groupsGenerated 2026-10-10
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.
Reviewed changes
- Latest WorkStep review decision: consolidate all mapped WorkStep models/field sets into the single WorkStep model and table, including phase and reference details. Mark the other model/table definitions Dropped. Preserve RecordKind, ownership, separate historical/child rows and role-specific validation. HTML only; backend/database implementation remains pending complete review.
← All model classes · AMOS Workpackage example
Dropped · Merge every field into WorkStep. This page retains the source inventory for review; backend/model retirement and physical migration are pending complete review.
Identity and naming
1 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | Id | Guid | Required | Merge into the shared WorkStep.Id. | Merged To WorkStep.Id · pending |
Relationships and references
6 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | ComponentTaskFormulaId | Guid? | Nullable | Drop ComponentTaskFormulaId from the unified WorkStep proposal. Review common formula definitions, taskcard-based calculation and formula-result traceability in future, together with the deferred CalculatedValue design. Backend/database removal deferred until complete project review. | Dropped Removal pending complete review |
| 2 | ComponentTaskMeasurementId | Guid?Requested: Guid? | Nullable | Merge into the shared WorkStep.MeasurementIdentifierId. Replace the component-specific link through the common WorkStep measurement framework and existing MeasurementIdentifierId. Map legacy measurement definitions and preserve result types, limits, units, reporting/calibration settings; custom-answer links need explicit mapping. Backend/database adoption deferred. | Merged To WorkStep.MeasurementIdentifierId · pending |
| 3 | ConfigurationId | Guid? | Nullable | Merge into the shared WorkStep.ConfigurationId. | Merged To WorkStep.ConfigurationId · pending |
| 4 | FromPartId | Guid? | Nullable | Drop FromPartId. Use PartId on a separate source WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 5 | ToPartId | Guid? | Nullable | Drop ToPartId. Use PartId on a separate destination WorkStep row linked to the same owning action through OwnerRecordId and WorkStepId. ComponentActionRole distinguishes source/destination or removed/installed rows. Preserve both sides and their history as separate rows during deferred backend/database adoption. | Dropped Removal pending complete review |
| 6 | RepositoryWorkStepId | Guid | Required | Drop RepositoryWorkStepId from the unified WorkStep proposal. Currently, repository revision rows use it to identify their template owner and linked executable rows use it to identify their source template. Preserve revision ownership, linked-template provenance and historical relationships; review a replacement relationship and adapt repository revision queries, linked-step creation and synchronization before retiring storage. AppliedRepositoryRevisionId remains unchanged; its existing meaning does not automatically replace revision-to-template ownership. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | RequiresIndependentInspection | Boolean | Required | Move RequiresIndependentInspection from the unified WorkStep proposal to CriticalEvent as a required Boolean category flag, default false. Select the applicable category through WorkStep.CriticalEventId. Preserve existing per-step or per-revision requirements and reconcile category combinations during later adoption. Preserve historical independent-inspection and operational requirements when reusable categories change. Backend/database adoption remains pending complete review. | Dropped · Moved to CriticalEvent |
Amounts and measurements
1 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | EstimatedManHours | Decimal? | Nullable | Merge into the shared WorkStep.EstimatedManHours. | Merged To WorkStep.EstimatedManHours · pending |
Descriptions and details
2 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | TextValue | String | Nullable | Merge into the shared WorkStep.TextValue. | Merged To WorkStep.TextValue · pending |
| 2 | ActionText | String | Nullable | Merge into the shared WorkStep.ActionText. | Merged To WorkStep.ActionText · pending |
Audit and revision
4 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | SystemAuditId | Guid? | Nullable | Merge into the shared WorkStep.SystemAuditId. | Merged To WorkStep.SystemAuditId · pending |
| 2 | UpdateId | Guid? | Nullable | Merge into the shared WorkStep.UpdateId. | Merged To WorkStep.UpdateId · pending |
| 3 | Revision | Int32 | Required | Drop Revision from the unified WorkStep proposal. Preserve existing repository revision numbers, immutable revision identities and the association of executable steps with the version applied. Review replacement version identification and adapt revision allocation, display, queries and history before retiring storage. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
| 4 | RevisionStatus | RepositoryRevisionStatus | Required | Drop RevisionStatus from the unified WorkStep proposal. Preserve existing New, Active, Inactive and Superseded meanings and historical states. Review replacement lifecycle control and adapt activation, previous-version supersession and active-revision selection before retiring storage. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
Other fields
12 fields| # | Field | EF type | Storage | Business purpose | Review |
|---|---|---|---|---|---|
| 1 | CalculatedValue | Decimal? | Nullable | Drop CalculatedValue from the unified WorkStep proposal. Formula calculation, result storage and limit evaluation remain under review before backend/database adoption. | Dropped Removal pending complete review |
| 2 | NumericValue | Decimal? | Nullable | Records numeric value for this repository work step revision. | — |
| 3 | PassFailValue | Boolean? | Nullable | Records pass fail value for this repository work step revision. | — |
| 4 | RecordKind | WorkStepRecordKind | Required | Merge into the shared WorkStep.RecordKind. | Merged To WorkStep.RecordKind · pending |
| 5 | WithinLimits | Boolean? | Nullable | Drop the standalone WithinLimits property from the unified WorkStep proposal. Assess each recorded measurement against the applicable MeasurementIdentifier limit type, lower/upper limits and unit through MeasurementIdentifierId. The outcome belongs to that individual reading; do not store one shared WithinLimits flag on the reusable identifier. Preserve existing true/false/null assessments, the measured value and the original definition/version used, and reconcile historical cases without silently recalculating them against changed master limits. Define how missing results, absent limits and custom/discrete answers are assessed; preserve an unknown/not-evaluated state when an assessment cannot be made. Measurement-result storage and validation remain pending complete review; backend/database unchanged. | Dropped Removal pending complete review |
| 6 | ActionTitle | String | Required | Merge into the shared WorkStep.ActionTitle. | Merged To WorkStep.ActionTitle · pending |
| 7 | ActivatedAt | DateTime? | Nullable | Merge into the shared WorkStep.ActivatedAt. | Merged To WorkStep.ActivatedAt · pending |
| 8 | MeasurementsJson | String | Nullable | Records measurements json for this repository work step revision. | — |
| 9 | MetadataJson | String | Nullable | Merge into the shared WorkStep.MetadataJson. | Merged To WorkStep.MetadataJson · pending |
| 10 | PartRequestsJson | String | Nullable | Records part requests json for this repository work step revision. | — |
| 11 | ResourceRequestsJson | String | Nullable | Drop ResourceRequestsJson from the unified WorkStep proposal. Preserve existing resource-request payloads and their repository revision context, including resource types, quantities, requested windows and other planning details. Review carrying these through structured resource-request records and adapt repository revision creation, planning copy and synchronization before retiring JSON storage. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |
| 12 | SoftwareChangesJson | String | Nullable | Drop SoftwareChangesJson from the unified WorkStep proposal. Preserve existing software-change payloads and their repository revision context, including target software/part references, change references and planning details. Review carrying these through structured software-change plan records and adapt repository revision creation, planning copy and synchronization before retiring JSON storage. Backend/database adoption remains pending complete review. | Dropped Removal pending complete review |