Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| pkUIDTypes | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each user ID record |
||||
| userID | int | 4 | √ | null |
|
|
User reference - Links to the user account (AccessUser.UserID) |
||||
| IDvalue | varchar | 30 | √ | null |
|
|
ID value - The actual identification number or credential value |
||||
| IDTypeID | int | 4 | √ | null |
|
|
ID type reference - Links to the type of identification (license, certification, etc.) |
||||
| 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 (Active, Expired, etc.) |
||||
| Comments | varchar | 500 | √ | null |
|
|
ID comments - Additional comments about the identification |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK__UserIDList__336C37F2 | Primary key | Asc | pkUIDTypes |
| IX_UserId_IDTypeID | Performance | Asc/Asc | userID + IDTypeID |
Relationships
Close relationships within degrees of separation
