Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each dropdown value |
|
| Type | nvarchar | 100 | null |
|
|
Dropdown type - Category or type of dropdown this value belongs to |
||
| Value | nvarchar | 1073741823 | null |
|
|
Dropdown value - The actual value or text for the dropdown option |
||
| CreatedBy | int | 4 | null |
|
|
Created by user - UserID of the person who created this dropdown value |
||
| DateCreated | datetime | 16,3 | null |
|
|
Creation date - Date when the dropdown value was created |
||
| UpdatedBy | int | 4 | √ | null |
|
|
Updated by user - UserID of the person who last updated this value |
|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Update date - Date when the dropdown value was last updated |
|
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Deletion date - Soft delete timestamp for audit trail purposes |
|
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Numeric order for displaying values in the dropdown |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__Dropdown__3214EC2756734CD2 | Primary key | Asc | ID |
Relationships
Close relationships within degrees of separation
