Coflyr · Backend model field catalog

FlightLog

public.FlightLogs.

49 mapped fields8 field groupsGenerated 2026-10-06

Model class: coflyr.features.engineering.fleet.models.FlightLog
Source: Features/Engineering/Fleet/Models/FlightLog.cs
Table: public.FlightLogs
Review: Not marked

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.

← All model classes · AMOS Workpackage example

Identity and naming

4 fields

#	Field	EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.
2	`DailySequenceNumber`	`int`	Required	Records daily sequence number for this flight log.
3	`FlightLogNumber`	`string`	Nullable	Records flight log number for this flight log.
4	`FlightNumber`	`string`	Required	Records flight number for this flight log.

Relationships and references

4 fields

#	Field	EF type	Storage	Business purpose
1	`AircraftTailId`	`Guid`	Required	Selects the related aircraft tail record.
2	`ArrivalAirportId`	`Guid?`	Nullable	Selects the related arrival airport record.
3	`DepartureAirportId`	`Guid?`	Nullable	Selects the related departure airport record.
4	`LinkedOperationalFlightReference`	`string`	Nullable	Records linked operational flight reference for this flight log.

Status and controls

10 fields

#	Field	EF type	Storage	Business purpose
1	`FlightStatus`	`string`	Nullable	Tracks the flight status of this flight log.
2	`HasAircraftAcceptance`	`bool`	Required	Indicates whether aircraft acceptance applies to this flight log.
3	`HasAircraftRelease`	`bool`	Required	Indicates whether aircraft release applies to this flight log.
4	`HasFlightClosing`	`bool`	Required	Indicates whether flight closing applies to this flight log.
5	`IsCounterUpdated`	`bool`	Required	Indicates whether counter updated applies to this flight log.
6	`IsLinkedToOperationalFlight`	`bool`	Required	Indicates whether linked to operational flight applies to this flight log.
7	`IsNullLeg`	`bool`	Required	Indicates whether null leg applies to this flight log.
8	`IsNullLegConfirmed`	`bool`	Required	Indicates whether null leg confirmed applies to this flight log.
9	`IsRevenueFlight`	`bool`	Required	Indicates whether revenue flight applies to this flight log.
10	`WasManuallyChanged`	`bool`	Required	Indicates whether was manually changed applies to this flight log.

Dates and timing

5 fields

#	Field	EF type	Storage	Business purpose
1	`BlockOffTime`	`DateTime`	Required	Records the block off time for this flight log.
2	`BlockOnTime`	`DateTime`	Required	Records the block on time for this flight log.
3	`LandingTime`	`DateTime`	Required	Records the landing time for this flight log.
4	`LogbookDate`	`DateTime`	Required	Records the logbook date for this flight log.
5	`TakeoffTime`	`DateTime`	Required	Records the takeoff time for this flight log.

Amounts and measurements

12 fields

#	Field	EF type	Storage	Business purpose
1	`ApuCycles`	`int`	Required	Records apu cycles for this flight log.
2	`ApuHours`	`decimal`	Required	Records apu hours for this flight log.
3	`BlockHours`	`decimal`	Required	Records block hours for this flight log.
4	`EtopsHours`	`decimal`	Required	Records etops hours for this flight log.
5	`FlightCycles`	`int`	Required	Records flight cycles for this flight log.
6	`FlightHours`	`decimal`	Required	Records flight hours for this flight log.
7	`IfrHours`	`decimal`	Required	Records ifr hours for this flight log.
8	`NightVfrHours`	`decimal`	Required	Records night vfr hours for this flight log.
9	`NvgHours`	`decimal`	Required	Records nvg hours for this flight log.
10	`TotalAircraftCyclesAfterLeg`	`long`	Required	Records total aircraft cycles after leg for this flight log.
11	`TotalAircraftHoursAfterLeg`	`decimal`	Required	Records total aircraft hours after leg for this flight log.
12	`VfrHours`	`decimal`	Required	Records vfr hours for this flight log.

Descriptions and details

1 fields

#	Field	EF type	Storage	Business purpose
1	`UtilizationRemarks`	`string`	Nullable	Records utilization remarks for this flight log.

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

11 fields

#	Field	EF type	Storage	Business purpose
1	`DayLandings`	`int`	Required	Records day landings for this flight log.
2	`FlightRule`	`int`	Required	Records flight rule for this flight log.
3	`FuelBurnedKg`	`decimal`	Required	Records fuel burned kg for this flight log.
4	`Landings`	`int`	Required	Records landings for this flight log.
5	`NightLandings`	`int`	Required	Records night landings for this flight log.
6	`NvgLandings`	`int`	Required	Records nvg landings for this flight log.
7	`OilAddedEngine1Quarts`	`decimal`	Required	Records oil added engine1 quarts for this flight log.
8	`OilAddedEngine2Quarts`	`decimal`	Required	Records oil added engine2 quarts for this flight log.
9	`OperatorCode`	`string`	Nullable	Records operator code for this flight log.
10	`ResendRequestedAt`	`DateTime?`	Nullable	Records the resend requested at for this flight log.
11	`ServiceTypeCode`	`string`	Nullable	Records service type code for this flight log.