Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| DateUpdated | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when upd occurred or was recorded |
|
| DateDeleted | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when deleted occurred or was recorded |
|
| DisplayOrder | Unknown | 0 | null |
|
|
Display order - Order in which values appear in the dropdown |
||
| DropdownName | Unknown | 0 | null |
|
|
Dropdown name - Name of the dropdown list this value belongs to |
||
| ID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| IsActive | Unknown | 0 | null |
|
|
Active status - Whether this value is currently available for selection |
||
| Type | nvarchar | 200 | √ | null |
|
|
Type classification - Category or classification type for DropdownValue records |
|
| Value | nvarchar | 1073741823 | √ | null |
|
|
Text field - Value text information for DropdownValue records |
|
| DateCreated | datetime | 16,3 | √ | null |
|
|
Date/time field - Date and time when created occurred or was recorded |
|
| Order | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for DropdownValue records |
|
| ValueCode | Unknown | 0 | null |
|
|
Value code - Internal code or identifier for the value |
||
| ValueID | Unknown | 0 | null |
|
|
Primary key - DropdownValue unique identifier for each dropdown value |
||
| ValueText | Unknown | 0 | null |
|
|
Value text - Display text shown to users |