Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| UserID | int identity | 4 | null |
|
|
User identifier - Unique identifier for the user account |
||
| FirstName | varchar | 50 | √ | null |
|
|
User first name - First name of the user |
|
| LastName | varchar | 50 | √ | null |
|
|
User last name - Last name of the user |
|
| IDValue | varchar | 30 | √ | null |
|
|
ID value - The actual identification number or credential value |
|
| InternalID | int | 4 | √ | null |
|
|
Internal ID type - Internal identifier for the type of identification |
|
| IDType | varchar | 30 | √ | null |
|
|
ID type description - Description of the identification type |
|
| DateID | datetime | 16,3 | √ | null |
|
|
ID date - Date when the identification was issued or verified |
|
| fkStatusID | int | 4 | √ | null |
|
|
Status reference - Links to the status of the identification |
|
| StatusDesc | varchar | 50 | √ | null |
|
|
Status description - Description of the identification status |
|
| Comments | varchar | 500 | √ | null |
|
|
ID comments - Additional comments about the identification |
Relationships
Close relationships within degrees of separation
