Coflyr · Backend model field catalog

ProductionPlan

public.ProductionPlans.

41 mapped fields7 field groupsGenerated 2026-10-08

Model class: coflyr.features.production.planning.models.ProductionPlan
Source: Features/Production/Planning/Models/ProductionPlanProgramModels.cs
Table: public.ProductionPlans
Review: Under development · marked 2026-10-08 · Shared aircraft/component planning backend class updated. Database migration and legacy component table retirement remain pending until complete project review. Field listing reflects current backend EF model, not the unchanged database snapshot.

Every mapped scalar field appears once. Types and nullability come from the updated backend EF model. Database migration is pending. 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

Backend updated; database pending. Fields on this page reflect the common aircraft/component planning classes. They are not a claim that the existing database schema has been migrated.

Identity and naming

5 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`PlanName`	`string`	Required	Records plan name for this production plan.
3	`PlanNumber`	`string`	Required	Records plan number for this production plan.
4	`VersionNumber`	`int`	Required	Records version number for this production plan.
5	`WorkpackageNumber`	`string`	Nullable	Records workpackage number for this production plan.

Relationships and references

6 fields

#	Field	EF type	Storage	Business purpose
1	`FacilityId`	`Guid?`	Nullable	Selects the related facility record.
2	`InitialPlanId`	`Guid?`	Nullable	Selects the related initial plan record.
3	`SourceTemplateId`	`Guid?`	Nullable	Selects the related source template record.
4	`SourceVersionId`	`Guid?`	Nullable	Selects the related source version record.
5	`WorkorderId`	`Guid?`	Nullable	Selects the related workorder record.
6	`WorkpackageId`	`Guid`	Required	Selects the related workpackage record.

Status and controls

11 fields

#	Field	EF type	Storage	Business purpose
1	`ActiveForWorkpackage`	`bool`	Required	Indicates whether active for workpackage applies to this production plan.
2	`CompressLines`	`bool`	Required	Indicates whether compress lines applies to this production plan.
3	`GroupMode`	`bool`	Required	Indicates whether group mode applies to this production plan.
4	`HideEvents`	`bool`	Required	Indicates whether hide events applies to this production plan.
5	`NestedGroups`	`bool`	Required	Indicates whether nested groups applies to this production plan.
6	`OnlyWorkSteps`	`bool`	Required	Indicates whether only work steps applies to this production plan.
7	`PlanStatus`	`ProductionPlanStatus`	Required	Tracks the plan status of this production plan.
8	`ShowAllConnections`	`bool`	Required	Indicates whether show all connections applies to this production plan.
9	`ShowCriticalPath`	`bool`	Required	Indicates whether show critical path applies to this production plan.
10	`ShowInternalMilestones`	`bool`	Required	Indicates whether show internal milestones applies to this production plan.
11	`ShowTechnicalQueries`	`bool`	Required	Indicates whether show technical queries applies to this production plan.

Dates and timing

3 fields

#	Field	EF type	Storage	Business purpose
1	`OffsetFromWorkpackageStartHours`	`decimal`	Required	Records offset from workpackage start hours for this production plan.
2	`PlannedEnd`	`DateTime`	Required	Records planned end for this production plan.
3	`PlannedStart`	`DateTime`	Required	Records planned start for this production plan.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`VersionDescription`	`string`	Nullable	Records version description for this production plan.

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

13 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftRegistration`	`string`	Nullable	Records aircraft registration for this production plan.
2	`AircraftType`	`string`	Nullable	Records aircraft type for this production plan.
3	`AssetType`	`WorkpackageAssetType`	Required	Records asset type for this production plan.
4	`ConflictCount`	`int`	Required	Records conflict count for this production plan.
5	`ConflictsComputedAt`	`DateTime?`	Nullable	Records the conflicts computed at for this production plan.
6	`EmptyRowsBetweenTasks`	`int`	Required	Records empty rows between tasks for this production plan.
7	`GroupByCriteria`	`string`	Nullable	Records group by criteria for this production plan.
8	`LastAutoGeneratedAt`	`DateTime?`	Nullable	Records the last auto generated at for this production plan.
9	`LastStaggeredAt`	`DateTime?`	Nullable	Records the last staggered at for this production plan.
10	`ReleasedAt`	`DateTime?`	Nullable	Records the released at for this production plan.
11	`ReleasedBy`	`string`	Nullable	Records released by for this production plan.
12	`SnapTo`	`ProductionPlanSnapUnit`	Required	Records snap to for this production plan.
13	`VersionRole`	`ProductionPlanVersionRole`	Required	Records version role for this production plan.