Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| AssociationId | Unknown | 0 | null |
|
|
Primary key - IDTypesInProgramType unique identifier for each association |
|||||
| fkIDTypeID | Unknown | 0 | null |
|
|
ID type reference - Reference to the identifier type |
|||||
| fkProgramTypeID | Unknown | 0 | null |
|
|
Program type reference - Reference to the program type |
|||||
| IDTypeID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| IsRequired | Unknown | 0 | null |
|
|
Required flag - Whether this ID type is mandatory for this program |
|||||
| programID | int | 4 | √ | null |
|
|
Reference identifier - Foreign key reference to related entity or lookup table |
||||
| Lock | int | 4 | √ | null |
|
|
Numeric value - Quantity, count, or numeric measurement for IDTypesInProgramType records |
||||
| ValidationRules | Unknown | 0 | null |
|
|
Validation rules - Rules for validating identifiers of this type |