Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| Domain | varchar | 200 | null |
|
|
|||||
| userPrincipalName | varchar | 200 | null |
|
|
|||||
| samAccountName | varchar | 100 | null |
|
|
|||||
| distinguishedName | varchar | 1000 | null |
|
|
|||||
| title | varchar | 200 | √ | null |
|
|
||||
| varchar | 200 | √ | null |
|
|
|||||
| department | varchar | 200 | √ | null |
|
|
||||
| userAccountControl | int | 4 | √ | null |
|
|
||||
| cn | varchar | 200 | √ | null |
|
|
||||
| GivenName | varchar | 100 | √ | null |
|
|
||||
| sn | varchar | 100 | √ | null |
|
|
||||
| DisplayName | varchar | 250 | √ | null |
|
|
||||
| Disabled | varchar | 1 | √ | null |
|
|
||||
| varchar | 1 | √ | null |
|
|
|||||
| Locked | varchar | 1 | √ | null |
|
|
||||
| NoPwdExpiry | varchar | 1 | √ | null |
|
|
||||
| LastLogin | datetime | 16,3 | √ | null |
|
|
||||
| Created | datetime2 | 16 | √ | null |
|
|
||||
| Modified | datetime2 | 16 | √ | null |
|
|
||||
| WebPage | varchar | 500 | √ | null |
|
|
||||
| Description | varchar | 2000 | √ | null |
|
|
||||
| MonthEnd | date | 6 | null |
|
|
|||||
| AVA_insdate | datetime2 | 16 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
