Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| IDTypeID | int identity | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| IDType | varchar | 30 | √ | null |
|
|
Type classification - Category or classification type for PatientIDTypes records |
||||
| FormName | varchar | 30 | √ | null |
|
|
Name field - Descriptive name or identifier for PatientIDTypes records |
||||
| IDTypeDescription | Unknown | 0 | null |
|
|
ID type description - Description of the identifier type |
|||||
| IDTypeName | Unknown | 0 | null |
|
|
ID type name - Name of the patient identifier type |
|||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this ID type is required |
|||||
| MaxLength | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for PatientIDTypes records |
||||
| ValidationPattern | Unknown | 0 | null |
|
|
Validation pattern - Regular expression for validating this ID type |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__IDTypes__65CC03DF | Primary key | Asc | IDTypeID |