Coflyr · Backend model field catalog

ElectronicTechLogSignature

public.ElectronicTechLogSignatures.

11 mapped fieldsUnder development4 field groupsGenerated 2026-10-06

Model class: coflyr.features.flightoperations.techlog.models.ElectronicTechLogSignature
Source: Features/FlightOperations/TechLog/Models/ElectronicTechLogSignature.cs
Table: public.ElectronicTechLogSignatures
Review: Under development as of 2026-10-07. Field review remains open.

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

1 fields

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

Relationships and references

3 fields

#	Field	EF type	Storage	Business purpose
1	`ElectronicTechLogDeviceId`	`Guid`	Required	Selects the related electronic tech log device record.
2	`ElectronicTechLogEntryId`	`Guid`	Required	Selects the related electronic tech log entry record.
3	`ElectronicTechLogSignatureCertificateId`	`Guid`	Required	Selects the related electronic tech log signature certificate record.

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

5 fields

#	Field	EF type	Storage	Business purpose
1	`PayloadSha256`	`string`	Required	Records payload sha256 for this electronic tech log signature.
2	`SignatureBase64`	`string`	Required	Records signature base64 for this electronic tech log signature.
3	`SignatureRole`	`int`	Required	Records signature role for this electronic tech log signature.
4	`SignedAt`	`DateTime`	Required	Records the signed at for this electronic tech log signature.
5	`SignedBy`	`string`	Required	Records signed by for this electronic tech log signature.