Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Dependencies | Unknown | 0 | null |
|
|
Dependencies - Other layers that this layer depends on |
||
| pkLayerID | int identity | 4 | √ | null |
|
|
Primary key - Layers unique identifier for each record |
|
| fkReportID | int | 4 | √ | null |
|
|
Foreign key reference - Reference to Report table for data relationships |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this layer is currently enabled |
||
| LayerName | varchar | 200 | null |
|
|
Layer name - Descriptive name of the application layer |
||
| LayerDesc | varchar | 500 | √ | null |
|
|
Description field - Detailed description or explanation of Layers information |
|
| pageName | varchar | 200 | √ | null |
|
|
Name field - Descriptive name or identifier for Layers records |
|
| criteriaStr | varchar | 5000 | √ | null |
|
|
Text field - criteriaStr text information for Layers records |
|
| sqlQuery | varchar | 1000 | √ | null |
|
|
Text field - sqlQuery text information for Layers records |
|
| htmlStr | ntext | 1073741823 | √ | null |
|
|
Text field - htmlStr text information for Layers records |
|
| Documentation | ntext | 1073741823 | √ | null |
|
|
Text field - Documentation text information for Layers records |
|
| DateCreated | smalldatetime | 16 | √ | (getdate()) |
|
|
Date/time field - Date and time when created occurred or was recorded |
|
| CreatedBy | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Layers records |
|
| DateUpdated | smalldatetime | 16 | √ | null |
|
|
Date/time field - Date and time when upd occurred or was recorded |
|
| UpdatedBy | int | 4 | √ | null |
|
|
Date/time field - Date and time when updby occurred or was recorded |
|
| Deleted | bit | 1 | √ | null |
|
|
Boolean flag - Indicates whether specific condition or feature is enabled/active |
|
| itemOrder | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Layers records |
|
| LayerDescription | Unknown | 0 | null |
|
|
Layer description - Detailed description of the layer’s functionality |
||
| LayerType | nvarchar | 6 | √ | ('SY') |
|
|
Layer type - Classification of the layer (UI, Business Logic, Data, etc.) |
|
| LoadOrder | Unknown | 0 | null |
|
|
Load order - Order in which layers should be loaded |
||
| TemplateId | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for Layers records |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Layers | Primary key | Asc | pkLayerID |