Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ResultID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each calculation result |
|
| fkConfigID | int | 4 | null |
|
|
Configuration reference - Links to CalculationConfig for the calculation definition |
||
| UserID | int | 4 | null |
|
|
User reference - Links to the user who requested or owns this calculation result |
||
| Result | decimal | 20,2 | ((0)) |
|
|
Calculated value - The computed result value from the calculation |
||
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update timestamp - Date and time when the result was last calculated |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion timestamp - Soft delete date for audit trail purposes |
|
| fkCalculationMarketId | int | 4 | √ | null |
|
|
Market reference - Links to market-specific calculation parameters |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SummaryResult | Primary key | Asc | ResultID |
| IX_CalculationMarketId | Performance | Asc | fkCalculationMarketId |
| IX_ConfigID | Performance | Asc | fkConfigID |
| IX_UserId | Performance | Asc | UserID |
Relationships
Close relationships within degrees of separation
