Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkAppLayerID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each app layer configuration, auto-incrementing integer |
||||
| fkAppID | int | 4 | null |
|
|
Application reference - Foreign key linking to Apps.pkAppID for the application being configured (required field) |
|||||
| fkLayerID | int | 4 | null |
|
|
Layer reference - Foreign key linking to layer/section definition for placement configuration (required field) |
|||||
| itemOrder | int | 4 | √ | null |
|
|
Display order - Numeric sequence for ordering applications within the layer for consistent presentation |
||||
| CreateByAgency | int | 4 | √ | ((0)) |
|
|
Creating agency - Reference to agency that configured this layer assignment for multi-tenant customization |
||||
| IsShow | bit | 1 | ((0)) |
|
|
Visibility flag - Boolean controlling whether application is visible in this layer (required field, defaults to false) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AppLayers | Primary key | Asc | pkAppLayerID |
| IX_LayerAppOrder | Performance | Asc/Asc/Asc | fkAppID + fkLayerID + itemOrder |