Coflyr · Backend model field catalog
ApprovalWorkflow
public.ApprovalWorkflows.
29 mapped fields6 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
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
Relationships and references
4 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | MaintenanceProgramMasterId | Guid? | Nullable | Selects the related maintenance program master record. |
| 2 | MaintenanceTaskId | Guid? | Nullable | Selects the related maintenance task record. |
| 3 | ProcessingResponsibleBusinessPartnerId | Guid? | Nullable | Selects the related processing responsible business partner record. |
| 4 | PublicationMasterId | Guid? | Nullable | Selects the related publication master record. |
Status and controls
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Acknowledged | bool | Required | Indicates whether acknowledged applies to this approval workflow. |
| 2 | ApprovalSign | string | Nullable | Records approval sign for this approval workflow. |
| 3 | Declined | bool | Required | Indicates whether declined applies to this approval workflow. |
Dates and timing
9 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | AssessmentEndDate | DateTime? | Nullable | Records the assessment end date for this approval workflow. |
| 2 | AssessmentStartDate | DateTime? | Nullable | Records the assessment start date for this approval workflow. |
| 3 | ClosedDate | DateTime? | Nullable | Records the closed date for this approval workflow. |
| 4 | DueDate | DateTime? | Nullable | Records the due date for this approval workflow. |
| 5 | EndTime | DateTime? | Nullable | Records the end time for this approval workflow. |
| 6 | LogDate | DateTime? | Nullable | Records the log date for this approval workflow. |
| 7 | ProcessingDueDate | DateTime? | Nullable | Records the processing due date for this approval workflow. |
| 8 | StartTime | DateTime? | Nullable | Records the start time for this approval workflow. |
| 9 | TotalTimeMinutes | int? | Nullable | Records the total time minutes for this approval workflow. |
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
10 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Department | string | Nullable | Records department for this approval workflow. |
| 2 | LoginSign | string | Nullable | Records login sign for this approval workflow. |
| 3 | ProcessingDepartment | string | Nullable | Records processing department for this approval workflow. |
| 4 | ProcessingResponsible | string | Nullable | Records processing responsible for this approval workflow. |
| 5 | ProcessingState | int? | Nullable | Records processing state for this approval workflow. |
| 6 | RealUsername | string | Nullable | Records real username for this approval workflow. |
| 7 | Responsible | string | Nullable | Records responsible for this approval workflow. |
| 8 | State | int | Required | Records state for this approval workflow. |
| 9 | TargetType | int | Required | Records target type for this approval workflow. |
| 10 | VerificationSign | string | Nullable | Records verification sign for this approval workflow. |