Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IDTypeID | int identity | 4 | null |
|
|
ID type identifier - Unique identifier for each ID type configuration |
||
| IDType | varchar | 30 | √ | null |
|
|
ID type name - Descriptive name of the identifier type |
|
| MaxLength | int | 4 | √ | null |
|
|
Maximum length - Maximum character length allowed for this identifier type |
|
| FormName | varchar | 30 | √ | null |
|
|
Form name - Name of the form associated with this ID type |
|
| programID | int | 4 | √ | null |
|
|
Program identifier - Links to program type that uses this ID type |
|
| patientID | int | 4 | √ | null |
|
|
Patient identifier - Links to patient who has this identifier type |
|
| IDValue | varchar | 30 | √ | null |
|
|
Identifier value - The actual identifier value for the patient |
Relationships
Close relationships within degrees of separation
