Coflyr · Backend model field catalog
ComponentShopProductionCapacity
public.ComponentShopProductionCapacities.
24 mapped fields8 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
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
Relationships and references
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ComponentShopProductionPlanId | Guid | Required | Selects the related component shop production plan record. |
| 2 | FacilityId | Guid? | Nullable | Selects the related facility record. |
Status and controls
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Active | bool | Required | Indicates whether active applies to this component shop production capacity. |
Dates and timing
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | EndAt | DateTime | Required | Records the end at for this component shop production capacity. |
| 2 | StartAt | DateTime | Required | Records the start at for this component shop production capacity. |
Amounts and measurements
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AvailableManHours | decimal | Required | Records available man hours for this component shop production capacity. |
Descriptions and details
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CapacityDescription | string | Required | Records capacity description for this component shop production capacity. |
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
14 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AircraftModelCode | string | Nullable | Records aircraft model code for this component shop production capacity. |
| 2 | AircraftSubTypeCode | string | Nullable | Records aircraft sub type code for this component shop production capacity. |
| 3 | AircraftTypeCode | string | Nullable | Records aircraft type code for this component shop production capacity. |
| 4 | CapacityType | int | Required | Records capacity type for this component shop production capacity. |
| 5 | ClassificationCode | string | Nullable | Records classification code for this component shop production capacity. |
| 6 | EmployeeCount | decimal | Required | Records employee count for this component shop production capacity. |
| 7 | QualificationCode | string | Nullable | Records qualification code for this component shop production capacity. |
| 8 | RecurrenceData | string | Nullable | Records recurrence data for this component shop production capacity. |
| 9 | RecurrenceMode | int | Required | Records recurrence mode for this component shop production capacity. |
| 10 | ResourceTypeCode | string | Nullable | Records resource type code for this component shop production capacity. |
| 11 | ShiftCode | string | Nullable | Records shift code for this component shop production capacity. |
| 12 | ShiftGroupCode | string | Nullable | Records shift group code for this component shop production capacity. |
| 13 | SkillCode | string | Nullable | Records skill code for this component shop production capacity. |
| 14 | StationCode | string | Nullable | Records station code for this component shop production capacity. |