Coflyr · Backend model field catalog
ComponentShopProductionPlanTemplateItem
public.ComponentShopProductionPlanTemplateItems.
24 mapped fields7 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 | RowNumber | int | Required | Records row number for this component shop production plan template item. |
| 3 | Title | string | Required | Records title for this component shop production plan template item. |
Relationships and references
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ComponentMaintenanceTaskId | Guid? | Nullable | Selects the related component maintenance task record. |
| 2 | ComponentShopProductionPlanTemplateId | Guid | Required | Selects the related component shop production plan template record. |
| 3 | ParentItemId | Guid? | Nullable | Selects the related parent item record. |
Status and controls
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | IsCritical | bool | Required | Indicates whether critical applies to this component shop production plan template item. |
| 2 | IsDefaultFindingGroup | bool | Required | Indicates whether default finding group applies to this component shop production plan template item. |
| 3 | IsInternalMilestone | bool | Required | Indicates whether internal milestone applies to this component shop production plan template item. |
Dates and timing
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | StartOffsetMinutes | int | Required | Records start offset minutes for this component shop production plan template item. |
Amounts and measurements
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | DurationMinutes | int | Required | Records duration minutes for this component shop production plan template item. |
| 2 | EstimatedManHours | decimal | Required | Records estimated man hours for this component shop production plan template item. |
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
10 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AreaCode | string | Nullable | Records area code for this component shop production plan template item. |
| 2 | AtaChapter | string | Nullable | Records the ata chapter for this component shop production plan template item. |
| 3 | Colour | string | Nullable | Records colour for this component shop production plan template item. |
| 4 | ItemType | int | Required | Records item type for this component shop production plan template item. |
| 5 | PanelCode | string | Nullable | Records panel code for this component shop production plan template item. |
| 6 | PhaseCode | string | Nullable | Records phase code for this component shop production plan template item. |
| 7 | QualificationCode | string | Nullable | Records qualification code for this component shop production plan template item. |
| 8 | Sequence | int | Required | Records sequence for this component shop production plan template item. |
| 9 | ShopRequestCode | string | Nullable | Records shop request code for this component shop production plan template item. |
| 10 | SpecialCode | string | Nullable | Records special code for this component shop production plan template item. |