Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkSuppOpt | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each support level option |
||||
| fkSuppLevelType | int | 4 | √ | null |
|
|
Support level type reference - Links to the type of support level |
||||
| SuppDesc | varchar | 100 | √ | null |
|
|
Support description - Description of the support level and its features |
||||
| DefaultNewUser | int | 4 | √ | null |
|
|
Default for new users - Indicates if this is the default support level for new users |
||||
| UserIncluded | int | 4 | √ | null |
|
|
Users included - Number of users included in this support level |
||||
| UserMax | int | 4 | √ | null |
|
|
Maximum users - Maximum number of users allowed for this support level |
||||
| UserFeePerMon | money | 21,4 | √ | null |
|
|
Monthly fee per user - Monthly fee charged per user for this support level |
||||
| IncludeFile | varchar | 50 | √ | null |
|
|
Include file - File or module included with this support level |
||||
| IncludeOrder | int | 4 | √ | null |
|
|
Include order - Order in which features are included or displayed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__SupportLevel__5A90F20B | Primary key | Asc | pkSuppOpt |
Relationships
Close relationships within degrees of separation
