Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| LayerId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each data layer configuration |
|
| LayerName | nvarchar | 400 | √ | null |
|
|
Layer name - Descriptive name for the data layer configuration |
|
| LayerDesc | nvarchar | 6000 | √ | null |
|
|
Layer description - Detailed description of the data layer purpose and functionality |
|
| CriteriaStr | nvarchar | 8000 | √ | null |
|
|
Filter criteria - SQL or configuration string defining the data filtering criteria |
|
| Type | nvarchar | 200 | √ | null |
|
|
Layer type - Classification of the data layer type (e.g., ‘Report’, ‘Dashboard’, ‘Filter’) |
|
| DateCreated | date | 20 | √ | null |
|
|
Creation date - Date when the data layer was created |
|
| CreatedBy | int | 4 | √ | null |
|
|
Creator reference - Links to AccessUser table for the user who created the layer |
|
| DateUpdated | date | 20 | √ | null |
|
|
Update date - Date when the data layer was last modified |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Updater reference - Links to AccessUser table for the user who last updated the layer |
|
| Deleted | bit | 1 | √ | null |
|
|
Deletion flag - Boolean indicator whether the data layer has been deleted |
|
| itemOrder | int | 4 | √ | null |
|
|
Item order - Numeric order for displaying or processing the data layer |
|
| IsShowing | bit | 1 | √ | null |
|
|
Display flag - Boolean indicating whether the data layer is currently visible or active |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_LayerClient | Primary key | Asc | LayerId |
Relationships
Close relationships within degrees of separation
