Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkAppLayerID | int identity | 4 | √ | null |
|
|
Primary key - AppLayers unique identifier for each record |
||||
| fkAppID | int | 4 | null |
|
|
Application reference - Reference to the application (foreign key to Apps.pkAppID) |
|||||
| fkLayerID | int | 4 | null |
|
|
Layer reference - Reference to the layer component (foreign key to Layers.pkLayerID) |
|||||
| itemOrder | int | 4 | √ | null |
|
|
Display order - Order in which layers should be displayed or processed |
||||
| CreateByAgency | int | 4 | √ | ((0)) |
|
|
Created by agency - Reference to the agency that created this layer association |
||||
| IsShow | bit | 1 | ((0)) |
|
|
Visibility flag - Whether this layer is visible to users |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_AppLayers | Primary key | Asc | pkAppLayerID |