Coflyr · Backend model field catalog
TechnicalCaseManager
public.TechnicalCaseManagers.
27 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
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | CaseNumber | string | Required | Records case number for this technical case manager. |
Relationships and references
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AircraftTailId | Guid? | Nullable | Selects the related aircraft tail record. |
Status and controls
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CaseStatus | int | Required | Tracks the case status of this technical case manager. |
| 2 | RootCauseAnalysisRequired | bool | Required | Indicates whether root cause analysis required applies to this technical case manager. |
| 3 | SpecialMonitoring | bool | Required | Indicates whether special monitoring applies to this technical case manager. |
Dates and timing
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ClosedDate | DateTime? | Nullable | Records the closed date for this technical case manager. |
| 2 | OpenedDate | DateTime | Required | Records the opened date for this technical case manager. |
| 3 | ReviewDate | DateTime? | Nullable | Records the review date for this technical case manager. |
Descriptions and details
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CaseDescription | string | Nullable | Records case description for this technical case manager. |
| 2 | ClosureReason | string | Nullable | Records closure reason for this technical case manager. |
| 3 | RootCauseDescription | string | Required | Records root cause description for this technical case manager. |
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 | AircraftTypeCode | string | Nullable | Records aircraft type code for this technical case manager. |
| 2 | AtaChapter | string | Nullable | Records the ata chapter for this technical case manager. |
| 3 | CaseOwnerCode | string | Nullable | Records case owner code for this technical case manager. |
| 4 | CaseTitle | string | Required | Records case title for this technical case manager. |
| 5 | CaseTrigger | string | Nullable | Records case trigger for this technical case manager. |
| 6 | CaseType | int | Required | Records case type for this technical case manager. |
| 7 | ControlledByCode | string | Nullable | Records controlled by code for this technical case manager. |
| 8 | CorrectiveActionPlan | string | Required | Records corrective action plan for this technical case manager. |
| 9 | LastSeverityCalculatedAt | DateTime? | Nullable | Records the last severity calculated at for this technical case manager. |
| 10 | LongTermSeverityFactor | decimal? | Nullable | Records long term severity factor for this technical case manager. |
| 11 | OperatorCode | string | Nullable | Records operator code for this technical case manager. |
| 12 | SeverityFactor | decimal | Required | Records severity factor for this technical case manager. |
| 13 | ShortTermSeverityFactor | decimal? | Nullable | Records short term severity factor for this technical case manager. |