Coflyr · Backend model field catalog
TimeRequirementLimit
Maintenance.TimeRequirementLimits.
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
The earlier separate TimeRequirementLimit child-table proposal is superseded. Its fields become LimitDefinition-role rows in the single TimeRequirements table. Original backend relationships remain visible below pending migration.
Dropped · Merged into TimeRequirements · 2026-10-11. This source table/model is retired in the single-table TimeRequirements HTML proposal. All source fields remain visible here for review and explicit migration mapping. Counter concrete types become row roles in that proposed table. Backend and physical database unchanged; implementation and migration pending complete review.
Identity and naming
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Id | Guid | Required | Stable identifier for this record. |
| 2 | GroupNumber | int | Required | Records group number for this time requirement limit. |
Relationships and references
3 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | CounterDefinitionId | Guid? | Nullable | Selects the related counter definition record. |
| 2 | RangeMeasureUnitId | Guid? | Nullable | Selects the related range measure unit record. |
| 3 | RequirementId | Guid | Required | Existing required lookup to Requirements. In the reviewed split proposal, this child belongs to TimeRequirements only. Remap RequirementId through the explicit legacy-to-timing identity map; backend/database adoption pending. |
Status and controls
2 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | ApplyTolerance | bool | Required | Indicates whether apply tolerance applies to this time requirement limit. |
| 2 | TerminatesInterval | bool | Required | Indicates whether terminates interval applies to this time requirement limit. |
Dates and timing
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | NextDueCalculationStrategy | int? | Nullable | Records the next due calculation strategy for this time requirement limit. |
Amounts and measurements
1 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | Amount | decimal | Required | Stores the amount used by this time requirement limit. |
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
9 fields| # | Field | EF type | Storage | Business purpose |
|---|---|---|---|---|
| 1 | BaselineType | int? | Nullable | Records baseline type for this time requirement limit. |
| 2 | Dimension | int | Required | Records dimension for this time requirement limit. |
| 3 | GroupLogic | int? | Nullable | Records group logic for this time requirement limit. |
| 4 | LimitType | int | Required | Records limit type for this time requirement limit. |
| 5 | LowerRangeValue | decimal? | Nullable | Records lower range value for this time requirement limit. |
| 6 | Sequence | int | Required | Records sequence for this time requirement limit. |
| 7 | ToleranceNegative | decimal? | Nullable | Records tolerance negative for this time requirement limit. |
| 8 | TolerancePositive | decimal? | Nullable | Records tolerance positive for this time requirement limit. |
| 9 | UpperRangeValue | decimal? | Nullable | Records upper range value for this time requirement limit. |