Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | nvarchar | 100 | null |
|
|
Setting ID - Unique identifier for each system setting |
||
| Name | nvarchar | 1000 | √ | null |
|
|
Setting name - Descriptive name of the configuration setting |
|
| Description | nvarchar | 1073741823 | √ | null |
|
|
Setting description - Detailed description of what the setting controls |
|
| IsDelete | bit | 1 | null |
|
|
Deletion flag - Boolean indicating if this setting is marked for deletion |
||
| IsTurnOn | bit | 1 | ((1)) |
|
|
Enabled flag - Boolean indicating if this setting is currently enabled |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ChecklistSetting | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
