Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ConfigID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for the calculation configuration |
|
| fkReportID | int | 4 | null |
|
|
Report foreign key - Links to the report this calculation configuration applies to |
||
| ColumnName | varchar | 50 | null |
|
|
Column name - Name of the report column this calculation applies to |
||
| SummaryType | int | 4 | null |
|
|
Summary type - Type of calculation (Sum, Average, Count, Min, Max, etc.) |
||
| CreatedDate | datetime | 16,3 | √ | null |
|
|
Creation date - Date when the calculation configuration was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Created by user - User ID of the person who created the configuration |
|
| UpdatedDate | datetime | 16,3 | √ | null |
|
|
Update date - Date when the calculation configuration was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - User ID of the person who last modified the configuration |
|
| DeletedDate | datetime | 16,3 | √ | null |
|
|
Deletion date - Date when the configuration was deleted (soft delete) |
|
| GroupByUser | bit | 1 | ((0)) |
|
|
Group by user flag - Indicates if calculations should be grouped by user |
||
| PinToApp | bit | 1 | ((0)) |
|
|
Pin to application flag - Indicates if this configuration is pinned to specific application |
||
| DecimalMark | varchar | 10 | √ | null |
|
|
Decimal mark - Character used for decimal separator in calculations |
|
| TextLocation | varchar | 10 | √ | null |
|
|
Text location - Position where calculated text should appear |
|
| TextValue | varchar | 50 | √ | null |
|
|
Text value - Static text value to display with calculations |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_SummaryConfig | Primary key | Asc | ConfigID |
| IX_ReportCreated | Performance | Asc/Asc/Asc | fkReportID + ColumnName + CreatedDate |
| IX_UndeletedPinCalculationConfig | Performance | Asc/Asc/Asc | DeletedDate + PinToApp + GroupByUser |
Relationships
Close relationships within degrees of separation
