Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SubTabID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| SubTabName | varchar | 50 | √ | null |
|
|
Sub-tab name - Display name of the sub-tab |
||||
| SubTabDesc | varchar | 300 | √ | null |
|
|
Sub-tab description - Description of the sub-tab’s purpose and content |
||||
| Filename | varchar | 50 | √ | null |
|
|
File name - Associated file or page for the sub-tab |
||||
| TabID | int | 4 | √ | null |
|
|
Parent tab reference - Reference to the parent main tab |
||||
| DisplayOrder | int | 4 | √ | null |
|
|
Display order - Order in which sub-tabs are displayed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Subtab | Primary key | Asc | SubTabID |