Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| pkAddonID | int identity | 4 | √ | null |
|
|
Primary key - Addons unique identifier for each record |
|||||||
| AddonName | nvarchar | 200 | null |
|
|
Add-on name - Descriptive name of the add-on module or feature |
||||||||
| ParentAddon | int | 4 | √ | null |
|
|
Parent add-on - Reference to parent add-on if this is a sub-module (foreign key to Addons.pkAddonID) |
|||||||
| AddonDesc | nvarchar | 400 | √ | null |
|
|
Add-on description - Detailed description of the add-on’s functionality and purpose |
|||||||
| src | varchar | 200 | √ | null |
|
|
Source path - File path or source location for the add-on implementation |
|||||||
| OrderNumber | int | 4 | √ | null |
|
|
Display order - Numeric order for displaying add-ons in user interfaces |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_Addon | Primary key | Asc | pkAddonID |