Coflyr · Backend model field catalog
WorkTemplateRevision
Maintenance.WorkTemplateRevisions.
18 mapped fields5 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.
← All model classes · AMOS Workpackage example
Retained Under development. Its owner becomes WorkTemplateMaster; redirect the current WorkTemplateId relationship (proposed name WorkTemplateMasterId). Issued work and compliance retain their exact revision. Backend/database adoption pending.
Identity and naming
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | SourceRevisionNumber | string | Nullable | Records source revision number for this work template revision. |
Relationships and references
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | WorkTemplateId | Guid | Required | Selects the related work template record. |
Status and controls
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AutoActivate | bool | Required | Indicates whether auto activate applies to this work template revision. |
| 2 | CommercialDataOutdated | bool | Required | Indicates whether commercial data outdated applies to this work template revision. |
| 3 | ElectronicWorkInstructionDraftCreated | bool | Required | Indicates whether electronic work instruction draft created applies to this work template revision. |
| 4 | ExecutableCustomerRequirement | bool | Required | Indicates whether executable customer requirement applies to this work template revision. |
| 5 | HasCommercialData | bool | Required | Indicates whether commercial data applies to this work template revision. |
Audit and revision
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Revision | int | Required | Records revision for this work template revision. |
| 2 | RevisionStatus | int | Required | Tracks the revision status of this work template revision. |
| 3 | SourceRevisionDate | DateTime? | Nullable | Records the source revision date for this work template revision. |
| 4 | SystemAuditId | Guid? | Nullable | Links to system audit history when this model stores the reference. |
| 5 | UpdateId | Guid? | Nullable | Links to the preceding revision or update record. |
Other fields
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ActivatedAt | DateTime? | Nullable | Records the activated at for this work template revision. |
| 2 | CommercialDataJson | string | Nullable | Records commercial data json for this work template revision. |
| 3 | HeaderHtml | string | Nullable | Records header html for this work template revision. |
| 4 | MetadataJson | string | Nullable | Records metadata json for this work template revision. |
| 5 | WorkEstimatesJson | string | Nullable | Records work estimates json for this work template revision. |