Coflyr · Backend model field catalog

ProductionResourceUsage

Production.ProductionResourceUsages.

12 mapped fields6 field groupsGenerated 2026-10-08

Model class: coflyr.features.production.execution.models.ProductionResourceUsage
Source: Features/Production/Execution/Models/ProductionExecutionModels.cs
Table: Production.ProductionResourceUsages
Review: Under development · marked 2026-10-08 · Common production backend/EF mapping added. Physical schema migration, backfill, frontend and activation remain pending complete project review.

Every mapped scalar field appears once. Types and nullability come from current backend EF metadata; physical database migration is pending. 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

Under development · DB pending. Actual tool, facility or aircraft occupancy; staff labor remains in StaffTimeBooking. Common production framework.

Identity and naming

1 fields

#	Field	Model / EF type	Storage	Business purpose
1	`Id`	`Guid`	Required	Stable identifier for this record.

Relationships and references

4 fields

#	Field	Model / EF type	Storage	Business purpose
1	`ExecutionId`	`Guid`	Required	Production run owning this scope, hold, usage, quality, acceptance or performance record.
2	`ExecutionTaskId`	`Guid`	Required	Run task owning this record. For holds/quality gates, null means package-wide scope; a composite foreign key prevents cross-run references.
3	`ResourceAssignmentId`	`Guid?`	Nullable	Optional existing WorkStepResourceAssignment for the same step and resource.
4	`ResourceNodeId`	`Guid`	Required	EntityNode of the actual resource. Its entity type must match ResourceKind.

Dates and timing

2 fields

#	Field	Model / EF type	Storage	Business purpose
1	`EndedAt`	`DateTime`	Required	Actual UTC hold clearance/resource usage end. Usage intervals must have a positive duration.
2	`StartedAt`	`DateTime`	Required	First actual production start time. Staff labor metrics include finalized bookings starting at or after this time.

Descriptions and details

1 fields

#	Field	Model / EF type	Storage	Business purpose
1	`UsageRemarks`	`string?`	Nullable	Explanation of actual resource use.

Audit and revision

2 fields

#	Field	Model / 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

2 fields

#	Field	Model / EF type	Storage	Business purpose
1	`RecordedBy`	`string`	Required	Server-recorded actor recording actual usage or a performance snapshot.
2	`ResourceKind`	`ProductionResourceKind { Tool, Facility, Aircraft }` EF: ProductionResourceKind	Required	Tool, Facility or Aircraft. Staff labor is recorded in the existing StaffTimeBooking table.