Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AppLayerId | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each application layer configuration |
|
| AppId | int | 4 | null |
|
|
Application reference - Links to the specific application this layer belongs to |
||
| LayerId | int | 4 | null |
|
|
Layer reference - Links to the specific layer definition |
||
| IsShow | bit | 1 | null |
|
|
Show flag - Boolean indicating if this layer should be displayed |
||
| OrderNumber | int | 4 | ((50)) |
|
|
Order number - Numeric order for displaying layers in the application |
||
| IsLayerClient | bit | 1 | √ | null |
|
|
Client layer flag - Boolean indicating if this is a client-side layer |
|
| LayerType | nvarchar | 6 | √ | null |
|
|
Layer type - Type classification of the layer (UI, Data, Business, etc.) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AppLayer | Primary key | Asc | AppLayerId |
| IX_AppLayerID | Performance | Asc/Asc/Asc | AppId + LayerId + OrderNumber |
Relationships
Close relationships within degrees of separation
