Backend table independence: Open all-table review. TimeRequirements is first; other tables await individual review.
Coflyr · Backend model field catalog
All model classes
Search model classes and open their field catalogs.
625 model classes455 persisted170 other C# models16 reviewed9412 fields and properties+15 new event framework models · DB pending+15 new production framework models · DB pendingGenerated 2026-10-08
Persisted classes come from the current AppDbContext EF snapshot. Rows marked Dropped show the former physical table and its former field count; the linked model page shows the current shared-table mapping. Other classes are declared under a backend Models folder and use compiled C# property metadata. Enums and standalone structs are outside this class catalog. Purpose text is a prompt for business review.
WorkorderMaster: parent/child header consolidation · Legacy WorkpackageMaster and former WorkorderMaster marked Deprecated; WorkpackageOrder renamed WorkorderMaster. HTML review only; backend/DB pending.
Business coverage review: 34 component tables · 7 shared counterparts · 22 partial overlaps · 5 dedicated functions · Source review 2026-10-10.
Frontend form reviews
Separate GUI reviews with images of each declared tab, control inventories and decision notes. 80 live screenshots and 116 source layouts included; source-only and shared-reference tabs are explicitly marked.
- PartMaster frontend review — 57 tabs · GUI pending review
- ConfigurationMaster frontend review — 27 tabs · GUI pending review
- Configuration frontend review — 32 tabs · GUI pending review
Administration (16 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| Ata | Ata | 9 | Reviewed |
| AttachmentType | AttachmentTypes | 8 | Reviewed |
| CriticalEvent | CriticalEvents | 6 13 proposed fields · DB pending | Later review |
| DefectActionType | DefectActionTypes | 10 | Dropped |
| DefectCategory | DefectCategories | 8 | Dropped |
| DefectDamageType | DefectDamageTypes | 8 | Dropped |
| DefectDiscoveryContext | DefectDiscoveryContexts | 8 | Dropped |
| DefectDiscoveryStage | DefectDiscoveryStages | 8 | Dropped |
| DefectLocationType | DefectLocationTypes | 8 | Dropped |
| DefectMeasurementType | DefectMeasurementTypes | 8 | Dropped |
| DefectReferenceEntry | DefectReferenceValues | 10 | Reviewed |
| DefectReportingSource | DefectReportingSources | 8 | Dropped |
| DefectSeverity | DefectSeverities | 8 | Dropped |
| DefectSourceRelation | DefectSourceRelations | 8 | Dropped |
| MeasurementIdentifier | MeasurementIdentifiers | 14 | Reviewed |
| TaskControlProfile | TaskControlProfiles | 7 | Reviewed |
Audit (2 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| AuditLogEntry | AuditLogEntries | 26 | In review · DB applied |
| EntityAuditState | EntityAuditStates | 25 former | Deleted |
BusinessPartners (5 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| ContactAddress | ContactAddresses | 23 | Reviewed · FE / BE updated |
| BusinessPartner | BusinessPartners | 27 | Finished |
| BusinessPartnerCapability | BusinessPartnerCapabilities | 32 | Under development |
| Payment | Payments | 17 | Under development |
| Warranty | Warranties | 1 | Under development |
Common (3 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| Effectivity | Effectivities | 44 | — |
| EntityRemark | EntityRemarks | 6 | Reviewed |
| HumanResourceLink | HumanResourceLinks | 18 | — |
CompetencyTraining (11 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| Authorization | Authorizations | 18 | — |
| CompetencyDefinition | CompetencyDefinitions | 45 | — |
| CompetencyDefinitionFrequency | CompetencyDefinitionFrequencies | 37 | — |
| CompetencyEffectivity | CompetencyEffectivities | 5 | — |
| CompetencyTemplate | CompetencyTemplates | 68 | — |
| LearningActivity | LearningActivities | 27 | — |
| PlanningQualification | PlanningQualifications | 15 | — |
| TrainingNeedAnalysis | TrainingNeedAnalyses | 23 | — |
| TrainingNeedAnalysisGap | TrainingNeedAnalysisGaps | 36 | — |
| TrainingNeedAnalysisGapTarget | TrainingNeedAnalysisGapTargets | 8 | — |
| TrainingPlan | TrainingPlans | 9 | — |
DangerousGoods (4 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| DangerousGoodsHazardClassMaster | DangerousGoodsHazardClassesDangerousGoodsReferences | 7 | Dropped table |
| DangerousGoodsPackingGroupMaster | DangerousGoodsPackingGroupsDangerousGoodsReferences | 5 | Dropped table |
| DangerousGoodsReference | DangerousGoodsReferences | 9 | Reviewed |
| DangerousGoodsUnNumber | DangerousGoodsUnNumbersDangerousGoodsReferences | 6 | Dropped table |
HumanResources (14 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| Department | Departments | 17 | — |
| Designation | Designations | 22 | — |
| DesignationCompetency | DesignationCompetencies | 10 | — |
| PhysicalLocation | StoreLocations | 12 | — |
| ResourceClassification | ResourceClassifications | 8 | — |
| ShiftGroup | ShiftGroups | 10 | — |
| StaffCompetencyCompletion | StaffCompetencyCompletions | 20 | — |
| StaffCompetencyCompletionDocument | StaffCompetencyCompletionDocuments | 15 | — |
| StaffMember | StaffMembers | 29 | — |
| StaffQualification | StaffQualifications | 23 | — |
| StaffShiftAssignment | StaffShiftAssignments | 19 | — |
| StaffTimeBooking | StaffTimeBookings | 47 | — |
| StaffTrainingDocument | StaffTrainingDocuments | 15 | — |
| StaffTrainingRecord | StaffTrainingRecords | 22 | — |
Identity (12 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| ApplicationGroupSnapshot | Groups | 8 | — |
| ApplicationRoleSnapshot | Roles | 8 | — |
| ApplicationUserGroup | UserGroups | 5 | — |
| ApplicationUserIdentity | ApplicationUsers | 12 | — |
| ApplicationUserRole | UserRoles | 5 | — |
| CoflyrUser | CoflyrUsers | 10 | — |
| CoflyrUserEmail | CoflyrUserEmails | 7 | — |
| CoflyrUserGroup | CoflyrUserGroups | 5 | — |
| CoflyrUserRole | CoflyrUserRoles | 5 | — |
| DepartmentAccessGrant | DepartmentAccessGrants | 9 | Under development |
| PublicationTypeAccessGrant | PublicationTypeAccessGrants | 8 | Under development |
| RecordOwnershipRestriction | RecordOwnershipRestrictions | 7 | Under development |
Requirements · proposed three-table split
Requirements remains the combined source catalog. ResourceRequirements and EventRequirements remain HTML proposals. TimeRequirements now has an independent backend table verified in the local database, with 56 stored fields and 7 NotMapped fields. Owners and consumers will connect through EntityLinks; existing requirements, limits, due snapshots and counter tables remain unchanged.
| Model class | Proposed table | Fields | Review |
|---|---|---|---|
| ResourceRequirements | Maintenance.ResourceRequirements | 92 proposed active 3 dropped retained | Under development · HTML proposal · DB pending |
| TimeRequirements | Maintenance.TimeRequirements | 63 reviewed active 56 stored · 7 NotMapped · 142 dropped retained | Backend adopted · Independent local table · EntityLinks later |
| EventRequirements | Maintenance.EventRequirements | 89 proposed active 4 dropped retained | Under development · HTML proposal · DB pending |
Maintenance (49 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| ComponentReplacementEvent | ComponentReplacementEvents | 23 | — |
| DefectDamageDetail | DefectDamageDetails | 70 | — |
| DefectDamageReport | DefectDamageReports | 111 | Under development · DB pending |
| DeferralAuthority | DeferralAuthorities | 8 | — |
| DeferredDefectMaster | DeferredDefectMasters | 21 | — |
| DeferredDefectRecord | DeferredDefectRecords | 25 | — |
| DeferredMaintenanceMaster | DeferredMaintenanceItems | 12 | — |
| DeferredReferenceItem | DeferredReferenceItems | 29 | — |
| DeferredTaskDeferral | DeferredTaskDeferrals | 22 | — |
| EffectivityEvaluationAudit | EffectivityEvaluationAudits | 14 | — |
| MaintenanceAccomplishment | MaintenanceAccomplishments | 16 | — |
| MaintenanceEventDueLimit | MaintenanceEventDueLimits | 28 | Dropped · Merged into TimeRequirements · DB pending |
| MaintenanceEventProvenance | MaintenanceEventProvenance | 16 | — |
| MaintenanceHistory | MaintenanceHistories | 66 | — |
| MaintenanceProgramMaster | MaintenancePrograms | 62 | — |
| MaintenanceProgramPublicationLink | MaintenanceProgramPublicationLinks | 12 former | Dropped |
| MaintenanceTask | MaintenanceTasks | 63 | — |
| MaintenanceTaskProgrammeLink | MaintenanceTaskProgrammeLinks | 2 | — |
| ProgrammeSyncBatch | ProgrammeSyncBatches | 11 | Under development |
| ProgrammeSyncConfiguration | ProgrammeSyncConfigurations | 12 | Under development |
| ProgrammeSyncItem | ProgrammeSyncItems | 15 | Under development |
| RepositoryWorkStep | WorkStep | 20 | Dropped · Merged into WorkStep · DB pending |
| RepositoryWorkStepRevision | WorkStep | 27 | Dropped · Merged into WorkStep · DB pending |
| RequirementProgrammeLink | RequirementProgrammeLinks | 2 | — |
| Requirements | Requirements | 132 backend fields Split into ResourceRequirements / TimeRequirements / EventRequirements | Dropped · Split proposed · DB pending |
| TaskCard | TaskCard | 71 | — |
| TaskCardControlLink | TaskCardControlLinks | 6 | — |
| TimeRequirementLimit | TimeRequirementLimits | 20 | Dropped · Merged into TimeRequirements · DB pending |
| WorkorderExecutionEntry | WorkStep | 65 | Dropped · Merged into WorkStep · DB pending |
| WorkorderGroupMaster | WorkorderGroupMaster | 1 | Under development · DB pending |
| WorkorderMaster (legacy) | WorkorderMaster | 53 | Deprecated · Consolidated into WorkorderMaster · DB pending |
| WorkpackageAuthority | WorkpackageAuthorities | 2 | — |
| WorkpackageBusinessPartnerLink | WorkpackageBusinessPartnerLinks | 3 | — |
| WorkpackageMaster | WorkpackageMaster | 71 | Deprecated · Consolidated into WorkorderMaster · DB pending |
| WorkorderMaster | WorkpackageOrder → WorkorderMaster (proposed) | 110 | Reviewed · Backend/DB pending |
| WorkStep | WorkStep | 152 105 proposed combined fields | Under development · One-model merge pending |
| WorkStepComponentSelection | WorkStep | 19 | Dropped · Merged into WorkStep · DB pending |
| WorkStepExecutionOccurrence | WorkStepExecutionOccurrences | 20 | Dropped · Merged into WorkStep · DB pending |
| WorkStepMeasurementDefinition | WorkStep | 28 | Dropped · Merged into WorkStep · DB pending |
| WorkStepPhase | WorkStepPhases | 9 | Dropped · Merged into WorkStep · DB pending |
| WorkStepRecord | WorkStep | 14 | Dropped · Merged into WorkStep · DB pending |
| WorkStepReferenceDetails | WorkStepReferenceDetails | 7 | Dropped · Merged into WorkStep · DB pending |
| WorkStepResourceAssignment | WorkStepResourceAssignments | 21 | Dropped · Merged into WorkStep · DB pending |
| WorkStepResourceRequest | WorkStep | 28 | Dropped · Merged into WorkStep · DB pending |
| WorkStepSoftwareChangePlan | WorkStep | 17 | Dropped · Merged into WorkStep · DB pending |
| WorkTemplate | WorkTemplates | 23 9 fields marked Dropped | Dropped · Merged into WorkTemplateMaster · DB pending |
| WorkTemplateMaster | WorkTemplateMastersUnified template master | 58 proposed active 57 dropped retained | Under development · HTML proposal · DB pending |
| WorkTemplateItem | WorkTemplateItems | 11 | Dropped · Merged into WorkStep · DB pending |
| WorkTemplateLink | WorkTemplateLinks | 8 | — |
| WorkTemplateRevision | WorkTemplateRevisions | 18 | Under development |
| WorkStepMaterialDemand | WorkStep | 25 | Dropped · Merged into WorkStep · DB pending |
MasterData (16 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| AircraftTypeMaster | FAType | 7 | — |
| AirportCodeMaster | AirportCodes | 7 | — |
| CommodityCode | CommodityCode | 7 | — |
| ComplianceTypeDefinition | ComplianceTypeDefinitions | 7 | — |
| CountryMaster | Countries | 6 | — |
| CurrencyMaster | Currencies | 6 | — |
| CustomsEndUse | CustomsEndUses | 6 | — |
| MaterialType | MaterialType | 7 | — |
| MeasureUnit | MeasureUnits | 15 | Reviewed |
| MeasureUnitConversionFactor | ConversionFactors | 9 | — |
| PartCertificationFormDefinition | PartCertificationFormDefinitions | 6 | — |
| RequirementTypeDefinition | RequirementTypeDefinitions | 10 | — |
| RotableCondition | RotableCondition | 6 | — |
| RotableRepairStatus | RotableRepairStatus | 6 | — |
| TaskClassification | TaskClassifications | 10 | — |
| WasteCode | WasteCodes | 8 | — |
Other C# models (170 classes)
Part (1 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| PartDangerousGoods | PartDangerousGoods | 5 | Dropped |
Parts (17 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| CertificationRecord | CertificationRecords | 21 | — |
| Configuration | Configurations | 35 | Reviewed |
| ConfigurationMaster | ConfigurationMasters | 15 | Reviewed |
| ConfigurationSubConfigurationAllowance | ConfigurationSubConfigurationAllowances | 13 | Under development |
| PartBOM | PartBOM | 11 | — |
| PartLink | PartLink | 15 | — |
| PartLocation | PartLocation | 10 | — |
| PartMaster | PartMaster | 47 | Reviewed |
| PartMasterModification | PartMasterModifications | 10 | — |
| PartShelfLifeLogistics | PartShelfLifeLogistics | 16 | — |
| PartStockPlanning | PartStockPlanning | 25 | — |
| PartVendor | PartVendor | 10 | — |
| RotableFinancialRecord | RotableFinancialRecords | 18 | Under development |
| RotableHierarchy | RotableHierarchies | 17 | — |
| RotableMaintenanceRecord | RotableMaintenanceRecords | 21 | — |
| RotableMaster | RotableMasters | 102 | Reviewed |
| RotableMovementRecord | RotableMovementRecords | 28 | Under development |
Publications (2 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| PublicationChapter | PublicationChapters | 15 | — |
| PublicationEntry | PublicationEntries | 21 | — |
PublicationsReferences (13 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| LessonPresentation | LessonPresentations | 12 | — |
| LocationReference | LocationReferences | 28 | — |
| LocationReferenceAssociation | LocationReferenceAssociations | 5 | — |
| ManualPage | ManualPages | 17 | — |
| Mod | Mod | 45 | — |
| Modifications | Modifications | 11 | — |
| OperationSpecification | OperationSpecifications | 16 | — |
| ProcurementWorkflow | ProcurementWorkflows | 34 | — |
| PublicationConditionalSection | PublicationConditionalSections | 10 | — |
| PublicationLink | PublicationLinks | 15 | — |
| PublicationMaster | Publications | 29 | — |
| PublicationReference | PublicationReferences | 15 | — |
| PublicationRelatedPublicationLink | PublicationRelatedPublicationLinks | 8 | — |
QualitySystem (7 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| AuditChecklistResponse | AuditChecklistResponses | 12 | — |
| AuditCorrectiveAction | AuditCorrectiveActions | 19 | — |
| AuditFinding | AuditFindings | 18 | — |
| ChecklistQuestion | ChecklistQuestions | 14 | — |
| ChecklistSection | ChecklistSections | 9 | — |
| ChecklistTemplate | ChecklistTemplates | 15 | — |
| QualityAudit | QualityAudits | 22 | — |
Relationships (3 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| EntityLink | EntityLinks | 12 | — |
| EntityLinkDefinition | EntityLinkDefinitions | 14 | — |
| EntityNode | EntityNodes | 6 | — |
Revision (1 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| EntityRevisionState | EntityRevisionStates | 16 | — |
SafetyManagement (25 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| ChangeRiskAssessment | ChangeRiskAssessments | 10 | Under development |
| Hazard | Hazards | 17 | Under development |
| ManagementOfChange | ManagementOfChanges | 23 | Under development |
| ManagementOfChangeReadinessItem | ManagementOfChangeReadinessItems | 20 | Under development |
| RiskAssessment | RiskAssessments | 30 | Under development |
| RiskAssessmentControl | RiskAssessmentControls | 12 | Under development |
| RiskDecision | RiskDecisions | 16 | Under development |
| RiskMethodVersion | RiskMethodVersions | 14 | Under development |
| SafetyAction | SafetyActions | 27 | Under development |
| SafetyCommunication | SafetyCommunications | 20 | Under development |
| SafetyControl | SafetyControls | 14 | Under development |
| SafetyEffectivenessReview | SafetyEffectivenessReviews | 14 | Under development |
| SafetyEmergencyExercise | SafetyEmergencyExercises | 16 | Under development |
| SafetyIndicatorDefinition | SafetyIndicatorDefinitions | 20 | Under development |
| SafetyIndicatorObservation | SafetyIndicatorObservations | 23 | Under development |
| SafetyInvestigation | SafetyInvestigations | 20 | Under development |
| SafetyManagementReview | SafetyManagementReviews | 17 | Under development |
| SafetyOperationalImpact | SafetyOperationalImpacts | 20 | Under development |
| SafetyRegulatorySubmission | SafetyRegulatorySubmissions | 19 | Under development |
| SafetyReport | SafetyReports | 41 | Under development |
| SafetyReporterIdentity | SafetyReporterIdentities | 12 | Under development |
| SafetyReportHazard | SafetyReportHazards | 11 | Under development |
| SafetyRequirementEvidence | SafetyRequirementEvidence | 13 | Under development |
| SafetyRoleAssignment | SafetyRoleAssignments | 15 | Under development |
| SafetyScope | SafetyScopes | 14 | Under development |
Shared (2 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| Attachment | Attachments | 11 | — |
| AttachmentLink | AttachmentLinks | 6 | — |
Text (2 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| TextDocument | TextDocuments | 5 | — |
| TextSegment | TextSegments | 9 | — |
public (249 classes)
| Model class | Table | Fields | Review |
|---|---|---|---|
| AircraftCodeDefinition | AircraftCodeDefinitions | 14 | Under development |
| AircraftConfigurationAssignment | AircraftConfigurationAssignments | 27 | Under development |
| AircraftGroup | AircraftGroups | 5 | Under development |
| AircraftGroupMember | AircraftGroupMembers | 7 | Under development |
| AircraftLink | AircraftLinks | 12 | Under development |
| AircraftReportRequest | AircraftReportRequests | 15 | Under development |
| AircraftStatusReportProfile | AircraftStatusReportProfiles | 19 | Under development |
| AircraftTail | AircraftTails | 43 | — |
| AircraftTransferRecord | AircraftTransferRecords | 26 | Under development |
| AircraftTransferSnapshotItem | AircraftTransferSnapshotItems | 11 | Under development |
| AircraftWeighingDetail | AircraftWeighingDetails | 14 | Under development |
| AircraftWeightAndBalance | AircraftWeightAndBalances | 29 | Under development |
| ApprovalWorkflow | ApprovalWorkflows | 29 | — |
| AssetCounter | CounterRecords | 16 | Dropped · Merged into TimeRequirements · DB pending |
| AviationContract | AviationContracts | 14 | Under development |
| BillingLineItem | BillingLineItems | 20 | Under development |
| BillingPackage | BillingPackages | 22 | Under development |
| BillingPackageBill | BillingPackageBills | 12 | Under development |
| BillingPackageDownPayment | BillingPackageDownPayments | 9 | Under development |
| BudgetAdministration | BudgetAdministrations | 13 | Under development |
| ChartOfAccounts | ChartOfAccounts | 9 | Under development |
| CheckControlRecord | CheckControlRecords | 26 | Under development |
| CheckPackageItem | CheckPackageItems | 19 | Under development |
| CommercialCombinedPriceSource | CommercialCombinedPriceSources | 9 | Under development |
| CommercialManHourEntry | CommercialManHourEntries | 17 | Under development |
| CommercialManHourRate | CommercialManHourRates | 11 | Under development |
| CommercialManHourRevision | CommercialManHourRevisions | 10 | Under development |
| CommercialPriceCondition | CommercialPriceConditions | 27 | Under development |
| CommercialPriceList | CommercialPriceLists | 15 | Under development |
| CommercialQuotation | CommercialQuotations | 24 | Under development |
| CommercialQuotationActivity | CommercialQuotationActivities | 8 | Under development |
| CommercialQuotationLine | CommercialQuotationLines | 16 | Under development |
| ComponentBlankLabelPrintJob | ComponentBlankLabelPrintJobs | 12 | — |
| ComponentMaintenancePartition | ComponentMaintenancePartitions | 34 | — |
| ComponentMaintenanceProject | ComponentMaintenanceProjects | 15 | — |
| ComponentMaintenanceTaskGroup | ComponentMaintenanceTaskGroups | 8 | Dropped |
| ComponentMaintenanceTemplateTask | ComponentMaintenanceTemplateTasks | 7 | — |
| ComponentMoclRevision | ComponentMoclRevisions | 12 | — |
| ComponentMoclRevisionItem | ComponentMoclRevisionItems | 14 | — |
| ComponentModificationStatus | ComponentModificationStatuses | 34 | — |
| ComponentPlanningRecord | ComponentPlanningRecords | 61 | — |
| ComponentProductionGroup | ComponentProductionGroups | 7 | — |
| ComponentProductionGroupPart | ComponentProductionGroupParts | 10 | — |
| ComponentProductionGroupPartSeries | ComponentProductionGroupPartSeries | 27 | — |
| ComponentProductionGroupQualification | ComponentProductionGroupQualifications | 7 | — |
| ComponentShopProductionCapacity | ComponentShopProductionCapacities | 24 | — |
| ComponentShopProductionPlan | ComponentShopProductionPlans | 13 | — |
| ComponentShopProductionPlanItem | ComponentShopProductionPlanItems | 29 | — |
| ComponentShopProductionPlanLink | ComponentShopProductionPlanLinks | 7 | — |
| ComponentShopProductionPlanTemplate | ComponentShopProductionPlanTemplates | 18 | — |
| ComponentShopProductionPlanTemplateItem | ComponentShopProductionPlanTemplateItems | 24 | — |
| ComponentShopProductionPlanVersion | ComponentShopProductionPlanVersions | 13 | — |
| ComponentSwapLog | ComponentSwapLogs | 11 | — |
| ComponentTaskFormula | ComponentTaskFormulas | 9 | — |
| ComponentTaskLink | ComponentTaskLinks | 9 | — |
| ComponentTaskMeasurement | ComponentTaskMeasurements | 13 | — |
| ComponentTreeLabelBooking | ComponentTreeLabelBookings | 24 | — |
| ComponentTreeLabelBookingItem | ComponentTreeLabelBookingItems | 32 | — |
| ComponentTreeLabelBookingTransaction | ComponentTreeLabelBookingTransactions | 28 | — |
| ComponentWorkpackageDamage | ComponentWorkpackageDamages | 12 | Under development · reporting merge pending |
| ComponentWorkpackageEvent | ComponentWorkpackageEvents | 39 | — |
| ComponentWorkpackageFinding | ComponentWorkpackageFindings | 12 | Under development · reporting merge pending |
| ComponentWorkpackageLink | ComponentWorkpackageLinks | 9 | — |
| ComponentWorkpackageModificationStatus | ComponentWorkpackageModificationStatuses | 12 | — |
| ComponentWorkpackageNode | ComponentWorkpackageNodes | 29 | — |
| ComponentWorkpackageRevision | ComponentWorkpackageRevisions | 11 | — |
| ConfigurationDiscrepancy | ConfigurationDiscrepancies | 35 | — |
| ConfigurationFunctionalPositionAlias | ConfigurationFunctionalPositionAliases | 7 | — |
| ConfigurationFunctionalPositionLink | ConfigurationFunctionalPositionLinks | 7 | — |
| ConfigurationPartNumberAllowance | ConfigurationPartNumberAllowances | 14 | — |
| ConfigurationPositionBooking | ConfigurationPositionBookings | 14 | — |
| ContractCoverage | ContractCoverage | 9 | — |
| ContractPriceBookEntry | ContractPriceBookEntries | 11 | — |
| CostCenterAllocation | CostCenterAllocations | 10 | — |
| CounterDefinition | CounterRecords | 18 | Dropped · Merged into TimeRequirements · DB pending |
| CounterReading | CounterRecords | 10 | Dropped · Merged into TimeRequirements · DB pending |
| CounterRecord | CounterRecords | 4 | Dropped · Merged into TimeRequirements · DB pending |
| CounterTemplate | CounterRecords | 12 | Dropped · Merged into TimeRequirements · DB pending |
| CounterTemplateGroup | CounterRecords | 5 | Dropped · Merged into TimeRequirements · DB pending |
| CounterTemplateGroupAssignment | CounterRecords | 5 | Dropped · Merged into TimeRequirements · DB pending |
| CrmActivity | CrmActivities | 11 | Under development |
| CrmActivityGroup | CrmActivityGroups | 6 | Under development |
| CrmCampaign | CrmCampaigns | 11 | Under development |
| CrmConfiguration | CrmConfigurations | 9 | Under development |
| CrmContact | CrmContacts | 10 | Under development |
| CrmCustomerLead | CrmCustomerLeads | 18 | Under development |
| CrmRelatedRecord | CrmRelatedRecords | 10 | Under development |
| CrmVisit | CrmVisits | 10 | Under development |
| CustomsEndUseDeclaration | CustomsEndUseDeclarations | 13 | Under development |
| CustomsRegion | CustomsRegions | 9 | Under development |
| DangerousGoodsDeclaration | DangerousGoodsDeclarations | 11 | — |
| DeferredItemsReportRequest | DeferredItemsReportRequests | 24 | — |
| DocumentConfirmationReportRequest | DocumentConfirmationReportRequests | 8 | — |
| ElectronicPendingShelf | ElectronicPendingShelves | 10 | Under development |
| ElectronicTechLogCabinItem | ElectronicTechLogCabinItems | 13 | Under development |
| ElectronicTechLogConfiguration | ElectronicTechLogConfigurations | 10 | Under development |
| ElectronicTechLogDefect | ElectronicTechLogDefects | 15 | Under development |
| ElectronicTechLogDevice | ElectronicTechLogDevices | 16 | Under development |
| ElectronicTechLogEntry | ElectronicTechLogEntries | 17 | Under development |
| ElectronicTechLogParameter | ElectronicTechLogParameters | 9 | Under development |
| ElectronicTechLogSignature | ElectronicTechLogSignatures | 11 | Under development |
| ElectronicTechLogSignatureCertificate | ElectronicTechLogSignatureCertificates | 10 | Under development |
| ElectronicTechLogSyncBatch | ElectronicTechLogSyncBatches | 15 | Under development |
| EngineeringOrder | EngineeringOrders | 90 | Dropped · WorkTemplateMaster type EngineeringOrder · DB pending |
| EngineeringOrderCompliance | EngineeringOrderCompliances | 11 | — |
| EngineEventLog | EngineEventLogs | 14 | — |
| ExternalDemand | ExternalDemands | 16 | — |
| ExternalDemandErrorCode | ExternalDemandErrorCodes | 7 | — |
| ExternalDemandTransferAttempt | ExternalDemandTransferAttempts | 15 | — |
| ExternalIntegrationJob | ExternalIntegrationJobs | 22 | — |
| ExternalLabelBooking | ExternalLabelBookings | 9 | — |
| ExternallyAllocatedPart | ExternallyAllocatedParts | 9 | — |
| ExternalServiceDefinition | ExternalServiceDefinitions | 9 | — |
| FinancialActivity | FinancialActivities | 12 | — |
| FinancialProject | FinancialProjects | 12 | — |
| FinancialTransactionDefinition | FinancialTransactionDefinitions | 10 | — |
| FleetTrackerConfiguration | FleetTrackerConfigurations | 10 | — |
| FleetTrackerStatus | FleetTrackerStatuses | 9 | — |
| FlightCrewSchedule | FlightCrewSchedules | 10 | — |
| FlightLog | FlightLogs | 49 | — |
| FlightLogbookConfiguration | FlightLogbookConfigurations | 7 | — |
| FlightLogSupplement | FlightLogSupplements | 17 | — |
| GeneralCondition | GeneralConditions | 35 | Under development |
| GeneralLedgerJournal | GeneralLedgerJournals | 14 | Under development |
| GeneralLedgerJournalEntry | GeneralLedgerJournalEntries | 10 | Under development |
| GoodsReceipt | GoodsReceipts | 21 | Under development |
| HangarSlot | HangarSlots | 11 | — |
| IndirectJobOrder | IndirectJobOrders | 23 | — |
| LabelBookingCorrection | LabelBookingCorrections | 9 | — |
| LabelBookingLedger | LabelBookingLedgers | 8 | — |
| LineTurnaroundCheck | LineTurnaroundChecks | 14 | — |
| LogisticsConfiguration | LogisticsConfigurations | 10 | — |
| LongTermPlanningSlot | LongTermPlanningSlots | 10 | — |
| MaintenanceCalendarRule | MaintenanceCalendarRules | 10 | — |
| MaintenanceControlEvent | MaintenanceControlEvents | 23 | — |
| MaintenanceCoordinationCase | MaintenanceCoordinationCases | 11 | — |
| MaintenanceEventMaster | MaintenanceEventMasters | 76 | Under development · DB pending |
| MaintenanceForecastRecord | MaintenanceForecastRecords | 32 | Under development · DB pending |
| MaintenancePlanningConfiguration | MaintenancePlanningConfigurations | 9 | — |
| MaintenanceSpecialReportDefinition | MaintenanceSpecialReportDefinitions | 12 | — |
| MaintenanceTeam | MaintenanceTeams | 9 | — |
| MaterialFlowDefinition | MaterialFlowDefinitions | 10 | — |
| MaterialFlowEvent | MaterialFlowEvents | 11 | — |
| MaterialPartRequest | MaterialPartRequests | 28 | Under development · DB pending |
| MaterialSalesPriceList | MaterialSalesPriceLists | 21 | — |
| MelAnalysisRecord | MelAnalysisRecords | 10 | — |
| ModificationActivityReportRequest | ModificationActivityReportRequests | 24 | — |
| ModificationStatusReportRequest | ModificationStatusReportRequests | 48 | — |
| MsaContractAgreement | MsaContractAgreements | 10 | — |
| NonTechnicalTaskForecast | NonTechnicalTaskForecasts | 9 | — |
| OemDocumentRecord | OemDocumentRecords | 13 | — |
| OilConsumptionReading | OilConsumptionReadings | 10 | — |
| OrderTatConfiguration | OrderTatConfigurations | 9 | — |
| OutboundShipment | OutboundShipments | 14 | — |
| PartConsumptionForecast | PartConsumptionForecasts | 11 | — |
| PartSignOffGroup | PartSignOffGroups | 8 | — |
| PbhContract | PbhContracts | 12 | — |
| PdfOverlayArtifact | PdfOverlayArtifacts | 26 | — |
| PdfOverlayConfiguration | PdfOverlayConfigurations | 9 | — |
| PdfOverlayDocument | PdfOverlayDocuments | 23 | — |
| PdfOverlayElement | PdfOverlayElements | 27 | — |
| PickingListOrder | PickingListOrders | 15 | — |
| PickslipRequest | PickslipRequests | 28 | — |
| PickslipRequestItem | PickslipRequestItems | 17 | — |
| PilotFlightLogbookEntry | PilotFlightLogbookEntries | 27 | — |
| PoolAgreement | PoolAgreements | 10 | — |
| PoolParticipant | PoolParticipants | 9 | — |
| PoolRequest | PoolRequests | 11 | — |
| PoolSettlement | PoolSettlements | 11 | — |
| PowerplantAsset | PowerplantAssets | 10 | — |
| PowerplantEvent | PowerplantEvents | 10 | — |
| PredictedUnscheduledWorkload | PredictedUnscheduledWorkloads | 9 | — |
| ProductionConflictRule | ProductionConflictRules | 8 | — |
| ProductionControl | ProductionControls | 23 | — |
| ProductionControlDashboard | ProductionControlDashboards | 23 | — |
| ProductionFinding | ProductionFindings | 18 | Under development · reporting merge pending |
| ProductionPlan | ProductionPlans | 41 | Under development · DB pending |
| ProductionPlanAssignment | ProductionPlanAssignments | 15 | — |
| ProductionPlanCapacity | ProductionPlanCapacities | 28 | Under development · DB pending |
| ProductionPlanElement | ProductionPlanElements | 42 | Under development · DB pending |
| ProductionPlanLink | ProductionPlanLinks | 7 | Under development · DB pending |
| ProductionPlanningConfiguration | ProductionPlanningConfigurations | 12 | — |
| ProductionPlanningMatrixProperty | ProductionPlanningMatrixProperties | 6 | — |
| ProductionPlanningPriorityRule | ProductionPlanningPriorityRules | 7 | — |
| ProductionPlanSnapshot | ProductionPlanSnapshots | 11 | — |
| ProductionPlanTemplate | ProductionPlanTemplates | 28 | Under development · DB pending |
| PublicationAcknowledgement | PublicationAcknowledgements | 11 | — |
| PublicationDrawing | PublicationDrawings | 9 | — |
| PublicationExperienceSheet | PublicationExperienceSheets | 10 | — |
| PublicationFingerprint | PublicationFingerprints | 9 | — |
| PublicationLocationAssignment | PublicationLocationAssignments | 9 | — |
| PurchaseOrder | PurchaseOrders | 23 | Under development |
| PurchaseOrderItem | PurchaseOrderItems | 16 | Under development |
| PurchaseRequisition | PurchaseRequisitions | 15 | — |
| PurchaseRequisitionItem | PurchaseRequisitionItems | 13 | — |
| ReleaseCertificateEasaForm1 | ReleaseCertificateEasaForm1s | 22 | — |
| ReliabilityReport | ReliabilityReports | 16 | — |
| ReliabilityReportDefinition | ReliabilityReportDefinitions | 8 | — |
| ReorderProposalPolicy | ReorderProposalPolicies | 10 | — |
| ResourceAllocation | ResourceAllocations | 9 | — |
| RogueUnitTracker | RogueUnitTrackers | 10 | — |
| RotableExchangeOrder | RotableExchangeOrders | 13 | — |
| RotableLogbookHistory | RotableLogbookHistories | 14 | — |
| SeatLoadConfiguration | SeatLoadConfigurations | 10 | — |
| SeverityFactorCalculation | SeverityFactorCalculations | 10 | — |
| SeverityFactorCalculationInput | SeverityFactorCalculationInputs | 19 | — |
| SeverityFactorConfiguration | SeverityFactorConfigurations | 12 | — |
| ShipmentMilestone | ShipmentMilestones | 9 | — |
| ShipmentTrackingConfiguration | ShipmentTrackingConfigurations | 9 | — |
| SoftwareBooking | SoftwareBookings | 11 | — |
| SoftwareInstallation | SoftwareInstallations | 13 | — |
| SoftwareMediaRecord | SoftwareMediaRecords | 12 | — |
| StockItem | StockItems | 18 | — |
| StockTransaction | StockTransactions | 13 | — |
| StoreConfiguration | StoreConfigurations | 10 | — |
| StoreKit | StoreKits | 6 | — |
| StoreKitComponent | StoreKitComponents | 6 | — |
| StoreReceivingPartition | StoreReceivingPartitions | 10 | — |
| StructuralDamageRecord | StructuralDamageRecords | 70 | — |
| SupplierPriceBookEntry | SupplierPriceBookEntries | 11 | Under development |
| SupplierRating | SupplierRatings | 10 | Under development |
| TechnicalCaseAssessment | TechnicalCaseAssessments | 14 | Under development |
| TechnicalCaseLogEntry | TechnicalCaseLogEntries | 8 | Under development |
| TechnicalCaseManager | TechnicalCaseManagers | 27 | Under development |
| TechnicalCaseOperationalImpact | TechnicalCaseOperationalImpacts | 12 | Under development |
| TechnicalCaseReference | TechnicalCaseReferences | 12 | Under development |
| TechnicalCaseRootCause | TechnicalCaseRootCauses | 16 | Under development |
| TechnicalCaseRootCauseAssignment | TechnicalCaseRootCauseAssignments | 7 | Under development |
| TechnicalCaseRootCauseEventAssignment | TechnicalCaseRootCauseEventAssignments | 8 | Under development |
| TechnicalCaseSolution | TechnicalCaseSolutions | 44 | Under development |
| TechnicalDelayRecord | TechnicalDelayRecords | 37 | Under development |
| ToolHandoverLog | ToolHandoverLogs | 32 | Under development |
| ToolRegistration | ToolRegistrations | 9 | Under development |
| UnscheduledGroundTime | UnscheduledGroundTimes | 14 | Under development |
| VendorRepairOrder | VendorRepairOrders | 18 | Under development |
| VoucherModeDefinition | VoucherModeDefinitions | 9 | Under development |
| WarrantyClaimItem | WarrantyClaimItems | 20 | Under development |
| WarrantyClaimRecord | WarrantyClaimRecords | 24 | Under development |
| WeightBalanceCabinConfiguration | WeightBalanceCabinConfigurations | 12 | Under development |
| WeightBalanceConfigurationItem | WeightBalanceConfigurationItems | 11 | Under development |
| WeightBalanceFleetConfiguration | WeightBalanceFleetConfigurations | 30 | Under development |
| WorkorderInformationQuery | WorkorderInformationQueries | 50 | Under development |
| WorkorderNumberRange | WorkorderNumberRanges | 15 | Under development |
| WorkorderPrintJob | WorkorderPrintJobs | 21 | Under development |
| WorkorderReference | WorkorderReferences | 17 | Under development |
| WorkorderReportRequest | WorkorderReportRequests | 23 | Under development |
| WorkpackageConfiguration | WorkpackageConfigurations | 9 | Under development |
| WorkTimeProgressReportRequest | WorkTimeProgressReportRequests | 25 | Under development |
| WorkTimeTrackingSession | WorkTimeTrackingSessions | 25 | Under development |
Common maintenance planning framework (9 shared classes)
Aircraft and component planning use these common models. Existing classes are expanded or reused; this section does not indicate that new physical tables were created. Database migration and legacy component-table removal remain pending the complete project review. Framework details and class fields.
| Model class | Table | Shared purpose | Component replacement / coverage | Implementation |
|---|---|---|---|---|
| MaintenanceEventMaster | MaintenanceEventMasters | Shared demand, due limits and scheduling for aircraft or component assets. | ComponentPlanningRecords; planning context of ComponentWorkpackageEvents | BE updated · DB pending |
| MaintenanceEventDueLimit | MaintenanceEventDueLimits | Structured counter/calendar limits and baselines. | ComponentPlanningRecord counter dimension, DueAt, ToGo and Interval | Dropped · Merged into TimeRequirements · DB pending |
| MaintenanceForecastRecord | MaintenanceForecastRecords | Calculated forecast with aircraft/rotable/part context; future availability results. | ComponentPlanningRecords forecast results | BE updated · DB pending |
| ProductionPlan | ProductionPlans | Package-owned aircraft/component schedule, optionally scoped to one order; planning, production and snapshot versions are rows in this table. | ComponentShopProductionPlans + ComponentShopProductionPlanVersions | BE updated · DB pending |
| ProductionPlanTemplate | ProductionPlanTemplates | Common scheduling templates with asset-type applicability and part/facility scope metadata. | ComponentShopProductionPlanTemplates | BE updated · DB pending |
| ProductionPlanElement | ProductionPlanElements | Schedule/template items, groups and milestones; direct order/WorkStep references. | ComponentShopProductionPlanItems + ComponentShopProductionPlanTemplateItems | BE updated · DB pending |
| ProductionPlanLink | ProductionPlanLinks | Finish/start dependencies with lag; graph validation and scheduling. | ComponentShopProductionPlanLinks | BE updated · DB pending |
| ProductionPlanCapacity | ProductionPlanCapacities | Common supply capacity by facility, qualification, shift, skill and recurrence; effective staffing may be fractional. | ComponentShopProductionCapacities | BE updated · DB pending |
| ProductionPlanAssignment | ProductionPlanAssignments | Shared order assignment and production lifecycle. | Component order allocation uses the same assignment class | Existing shared support |
Common event framework (7 new table models + 8 C# models)
Shared events across aircraft, components and every project domain. Requirements are part of each occurrence. Backend and EF mappings added; physical database migration and activation pending complete project review. Design, examples and suggested common frameworks.
| Model class | Table | Fields | Review |
|---|---|---|---|
| EventDefinition | Events.EventDefinitions | 9 | Under development · DB pending |
| ProjectEvent | Events.ProjectEvents | 16 | Under development · DB pending |
| EventSubject | Events.EventSubjects | 7 | Under development · DB pending |
| EventRequirement | Events.EventRequirements | 15 | Under development · DB pending |
| EventDependency | Events.EventDependencies | 6 | Under development · DB pending |
| EventEvidence | Events.EventEvidence | 10 | Under development · DB pending |
| EventTransition | Events.EventTransitions | 10 | Under development · DB pending |
| CreateEventDefinitionRequest | C# model | 5 | Under development · DB pending |
| CreateProjectEventRequest | C# model | 10 | Under development · DB pending |
| AddEventSubjectRequest | C# model | 4 | Under development · DB pending |
| AddEventDependencyRequest | C# model | 3 | Under development · DB pending |
| RecordEventEvidenceRequest | C# model | 5 | Under development · DB pending |
| ResolveEventRequirementRequest | C# model | 4 | Under development · DB pending |
| TransitionProjectEventRequest | C# model | 3 | Under development · DB pending |
| DomainEventProjection | C# model | 9 | Under development · DB pending |
Reusable requirement definitions: Requirements now includes EventDefinitionId and Scope = Event. Requirement and TimeLimit definitions are reused.
Dropped component execution tables (6 former tables)
The backend uses the shared replacements below for new execution demand. Legacy component resource/part records currently stored in Requirements need migration to WorkStep children; their compatibility reads remain until that migration. Dropped is the table retirement review status; physical database deletion remains pending complete project review. Component package header retirement does not retire its nodes, findings, damage, events, revision or planning extensions. WorkStep consolidation and remaining candidates.
| Former model | Former table | Shared replacement | Review |
|---|---|---|---|
| ComponentShopWorkOrder | ComponentShopWorkOrders | WorkorderMaster Unified replacement review; backend adoption pending | Dropped · DB pending |
| ComponentWorkpackage | ComponentWorkpackages | WorkorderMaster parent Updated replacement review; backend adoption pending | Dropped · DB pending |
| ComponentWorkpackageTask | ComponentWorkpackageTasks | WorkStep | Dropped · DB pending |
| ComponentWorkStepAction | ComponentWorkStepActions | WorkStep | Dropped · DB pending |
| ComponentTaskResourceRequirement | ComponentTaskResourceRequirements | WorkStep | Dropped · DB pending |
| ComponentTaskPartRequirement | ComponentTaskPartRequirements | WorkStep | Dropped · DB pending |
Common production framework (7 new table models + 8 C# models)
One execution framework for aircraft and components with the reviewed hierarchy Parent WorkorderMaster → Child WorkorderMaster → WorkStep. Current backend still uses package/order links pending adoption. Backend added; database migration and activation pending complete project review. Framework, performance definitions and operational flow. WorkStep parent/child consolidation and further candidates. Common maintenance defect/damage reporting. Dropped component execution tables.
| Model class | Table | Fields | Review |
|---|---|---|---|
| ProductionExecution | Production.ProductionExecutions | 13 | Under development · DB pending |
| ProductionExecutionTask | Production.ProductionExecutionTasks | 10 | Under development · DB pending |
| ProductionHold | Production.ProductionHolds | 13 | Under development · DB pending |
| ProductionResourceUsage | Production.ProductionResourceUsages | 12 | Under development · DB pending |
| ProductionQualityGate | Production.ProductionQualityGates | 7 | Under development · DB pending |
| ProductionReleaseRecord | Production.ProductionReleaseRecords | 9 | Under development · DB pending |
| ProductionPerformanceSnapshot | Production.ProductionPerformanceSnapshots | 22 | Under development · DB pending |
| OpenProductionExecutionRequest | C# model | 4 | Under development · DB pending |
| TransitionProductionExecutionRequest | C# model | 3 | Under development · DB pending |
| AddProductionHoldRequest | C# model | 5 | Under development · DB pending |
| ClearProductionHoldRequest | C# model | 2 | Under development · DB pending |
| RecordProductionResourceUsageRequest | C# model | 8 | Under development · DB pending |
| AddProductionQualityGateRequest | C# model | 4 | Under development · DB pending |
| AcceptProductionExecutionRequest | C# model | 4 | Under development · DB pending |
| CaptureProductionPerformanceRequest | C# model | 1 | Under development · DB pending |
Existing shared maintenance and production models reused
| Model class | Purpose in this framework |
|---|---|
| WorkorderMaster | Renamed WorkorderMaster in the review: one header model/table with parent rows replacing packages and child rows holding executable work. Backend/database consolidation pending. |
| WorkpackageMaster | Deprecated in the review; replaced by parent WorkorderMaster rows. Current backend mapping remains until adoption. |
| WorkorderMaster (legacy) | Deprecated in the review; replaced by child WorkorderMaster rows in the unified model. Current backend mapping remains until adoption. |
| WorkStep | One reviewed WorkStep model with 105 combined fields covering execution, repository/revisions, entries, occurrences, resources, material demand, definitions, phases and references. Other WorkStep definitions are Dropped; backend/database completion remains pending review. |
| StaffTimeBooking | Actual staff labor, live bookings, productivity and corrections. Partial merge candidate for step-bound bookings; general bookings remain shared. |
| DefectDamageReport | Common defect/damage occurrence reporting, including direct maintenance origin through WorkStepId. Separate legacy finding/damage workflow retirement remains pending lifecycle reconciliation. |
| ProductionPlan | Common package schedule and versions. |
| ProductionPlanElement | Order/step scheduling, baseline manpower and dependencies. |
Deleted and moved fields
Deleted means the old field no longer exists. Moved means its value remains in the replacement table.
| Former model | Field | Status | Replacement or note |
|---|---|---|---|
| DefectActionType | ParentId | Deleted | Parent relationships use EntityLinks. |
| DefectActionType | IsActive | Deleted | Active state is read directly from current AuditLogEntries. |
| DefectActionType | SortOrder | Deleted | Use SequenceNumber. |
| DefectActionType | Id, Code, Name, Description, DomainQualifiers, Priority, RequiresAction, SequenceNumber, SystemAuditId, UpdateId | Moved | Retained on DefectReferenceValues rows for ReferenceType = DefectActionType; DomainQualifiers is stored as ActionDomainQualifiers. |
| DefectAttachmentType | ParentId | Deleted | No parent relationship was carried to standard AttachmentType. |
| DefectAttachmentType | DomainQualifiers | Deleted | Standard AttachmentType has no defect domain qualifier field. |
| DefectAttachmentType | Id, Code, Name, Description, IsActive, SortOrder | Moved | Values use standard AttachmentTypes; SortOrder maps to SequenceNumber. |