Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int | 4 | ('') |
|
|
|||
| LoginName | varchar | 50 | ('') |
|
|
|||
| FileType | varchar | 5 | ('A') |
|
|
|||
| FileYear | smallint | 2 | ((0)) |
|
|
|||
| FileSemester | smallint | 2 | ((0)) |
|
|
|||
| DropDownMenuFlag | bit | 1 | ((1)) |
|
|
|||
| InitialEditFlag | bit | 1 | ((0)) |
|
|
|||
| InititalIDSearchFlag | bit | 1 | ((0)) |
|
|
|||
| MenuToolbarStyle | tinyint | 1 | ('1') |
|
|
|||
| MenuToolbarCaptionsFlag | bit | 1 | ((1)) |
|
|
|||
| DialogBeepFlag | bit | 1 | ((0)) |
|
|
|||
| SpellCheckerCode | varchar | 10 | ('') |
|
|
|||
| DefaultCampus | varchar | 3 | ('') |
|
|
|||
| AutoShowFavouriteReportsFlag | bit | 1 | ((1)) |
|
|
|||
| OverrideAutoShutdownFlag | bit | 1 | ((0)) |
|
|
|||
| OverrideAutoShutdownMinutes | int | 4 | ((0)) |
|
|
|||
| LastLoginDate | datetime | 16,3 | √ | null |
|
|
||
| LastPasswordChangeDate | datetime | 16,3 | √ | null |
|
|
||
| PasswordChangeNextLoginFlag | bit | 1 | ((0)) |
|
|
|||
| PasswordNeverExpiresFlag | bit | 1 | ((1)) |
|
|
|||
| PasswordExpiryDate | datetime | 16,3 | √ | null |
|
|
||
| DefaultCampusEnforcedFlag | bit | 1 | ((0)) |
|
|
|||
| StudentSearchDefaultActiveFlag | bit | 1 | ((0)) |
|
|
|||
| DefaultStartTime | datetime | 16,3 | √ | null |
|
|
||
| SynWebStartPage | varchar | 200 | ('') |
|
|
|||
| AllowOutlookDragDropFlag | bit | 1 | ((0)) |
|
|
|||
| OverrideDefaultDocumentClassificationFlag | bit | 1 | ((0)) |
|
|
|||
| DefaultDocumentClassificationCode | varchar | 15 | ('') |
|
|
|||
| AutoSpellCheckEmail | varchar | 15 | ('') |
|
|
|||
| ShowInitialEmailEditor | varchar | 15 | ('') |
|
|
|||
| MenuToolbarImages | tinyint | 1 | ((0)) |
|
|
|||
| TOTPEnabledFlag | bit | 1 | ((0)) |
|
|
|||
| TOTPVerifiedFlag | bit | 1 | ((0)) |
|
|
|||
| TOTPKey | varchar | 32 | ('') |
|
|
|||
| GridEnhancementsAutoOnFlag | bit | 1 | ((0)) |
|
|
|||
| ActionMessageSubscriptionChecksum | int | 4 | √ | null |
|
|
||
| DefaultSubSchool | varchar | 15 | ('') |
|
|
|||
| OldStyleGridsFlag | bit | 1 | ((0)) |
|
|
|||
| LookupSearchMethod | tinyint | 1 | ((1)) |
|
|
|||
| GridAlternateRowColourFlag | bit | 1 | ((1)) |
|
|
|||
| GridAlternateRowColour | varchar | 30 | ('') |
|
|
|||
| GridHorizontalLineFlag | bit | 1 | ((0)) |
|
|
|||
| GridVerticalLineFlag | bit | 1 | ((1)) |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_ConfigUsers | Primary key | Asc | ID |
| AK_ConfigUsers_LoginName | Must be unique | Asc | LoginName |