Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IDType | varchar | 30 | √ | null |
|
|
Type classification - Category or classification type for UserIDTypes records |
|
| IDTypeId | Unknown | 0 | null |
|
|
Primary key - UserIDTypes unique identifier for each user ID type |
||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this ID type is required |
||
| TypeDescription | Unknown | 0 | null |
|
|
Type description - Description of the user ID type |
||
| TypeName | Unknown | 0 | null |
|
|
Type name - Name of the user ID type |
||
| userIDTypeID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
|
| ValidationPattern | Unknown | 0 | null |
|
|
Validation pattern - Pattern for validating this ID type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__UserIDTypes__0B1D841F | Primary key | Asc | userIDTypeID |