Coflyr · Backend model field catalog
ToolHandoverLog
public.ToolHandoverLogs.
32 mapped fieldsUnder development7 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
5 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | HandoverNumber | string | Required | Records handover number for this tool handover log. |
| 3 | MaintenanceEventNumber | string | Nullable | Records maintenance event number for this tool handover log. |
| 4 | ToolSerialNumber | string | Required | Records tool serial number for this tool handover log. |
| 5 | WorkorderNumber | string | Nullable | Records workorder number for this tool handover log. |
Relationships and references
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | IncomingStaffId | Guid | Required | Selects the related incoming staff record. |
| 2 | OutgoingStaffId | Guid | Required | Selects the related outgoing staff record. |
| 3 | ToolPartId | Guid | Required | Selects the related tool part record. |
Status and controls
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AlwaysAskForCoinTag | bool | Required | Indicates whether always ask for coin tag applies to this tool handover log. |
| 2 | HandoverStatus | string | Required | Tracks the handover status of this tool handover log. |
| 3 | IncomingUserConfirmed | bool | Required | Indicates whether incoming user confirmed applies to this tool handover log. |
| 4 | OutgoingUserConfirmed | bool | Required | Indicates whether outgoing user confirmed applies to this tool handover log. |
Dates and timing
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | HandoverTimestamp | DateTime | Required | Records the handover timestamp for this tool handover log. |
| 2 | ToolExpiresAt | DateTime? | Nullable | Records the tool expires at for this tool handover log. |
Amounts and measurements
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Quantity | decimal | Required | Stores the quantity used by this tool handover 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
15 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AircraftRegistration | string | Nullable | Records aircraft registration for this tool handover log. |
| 2 | CompletedAt | DateTime? | Nullable | Records the completed at for this tool handover log. |
| 3 | CompletedBy | string | Nullable | Records completed by for this tool handover log. |
| 4 | ConditionCode | string | Nullable | Records condition code for this tool handover log. |
| 5 | EventType | string | Required | Records event type for this tool handover log. |
| 6 | IncomingCoinTag | string | Nullable | Records incoming coin tag for this tool handover log. |
| 7 | IncomingUserSign | string | Nullable | Records incoming user sign for this tool handover log. |
| 8 | LocationCode | string | Nullable | Records location code for this tool handover log. |
| 9 | MaterialClass | string | Nullable | Records material class for this tool handover log. |
| 10 | OutgoingCoinTag | string | Nullable | Records outgoing coin tag for this tool handover log. |
| 11 | OutgoingUserSign | string | Nullable | Records outgoing user sign for this tool handover log. |
| 12 | StationCode | string | Required | Records station code for this tool handover log. |
| 13 | StoreCode | string | Nullable | Records store code for this tool handover log. |
| 14 | ToolReceivedAt | DateTime? | Nullable | Records the tool received at for this tool handover log. |
| 15 | WorkflowMessage | string | Nullable | Records workflow message for this tool handover log. |