ClientUsers
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Password | nvarchar(255) | yes | ||
| UserName | nvarchar(50) | |||
| nchar | yes | |||
| Active | bit | Default = -1 | ||
| LastName | nvarchar(50) | yes | ||
| FirstName | nvarchar(50) | yes | ||
| MiddleInitial | nvarchar(5) | yes | ||
| InternalUser | bit | Default = 0 | ||
| Guid | uniqueidentifier | yes | Default = (newid()) | |
| Deleted | bit | Default = 0 | ||
| ClientsID | int | yes | ||
| RegistrationNumber | nvarchar(50) | yes | ||
| ReminderPhrase | nvarchar(150) | yes | ||
| BackofficeRecordType | int | yes | Default = 0 | |
| DateLastLogin | datetime | yes | ||
| NumFailedAttempts | int | Default = 0 | ||
| IsSupervisor | bit | yes | ||
| MembershipRefreshedOn | datetime | yes | ||
| CreateDate | datetime | yes | Default = getutcdate() | |
| IsProvisional | bit | yes | ||
| UpdateDate | datetime | Default = getutcdate() | ||
| LockedOutTime | datetime | yes | ||
| LinkedInProfileID | int | yes | Default = 0 | |
| LASTLOCKEDOUTTIME | datetime | yes | Default = NULL | |
| LASTMFALOGINDATETIME | datetime | yes | Default = NULL | |
| ISEMAILVERIFIED | bit | yes | Default = NULL | |
| ISGPCENABLED | bit | yes | Default = NULL |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| TimeZoneID | int | yes | TimeZone.ID | |
| CreateID | int | yes | ClientUsers.ID | |
| UpdateID | int | yes | ClientUsers.ID | |
| DefaultSiteID | int | yes | ClientSites.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| ix_ClientUsers_Deleted_Last_First_ID | Deleted, LastName, FirstName, ID | |||
| IX_ClientUsers_ID | ID | yes | ||
| IX_ClientUsers_ID_LastName_FirstName_MiddleInitial | ID, LastName, FirstName, MiddleInitial | |||
| IX_ClientUsers | ClientsID, UserName | yes | ||
| PK_Users | ID | yes | yes |
Triggers
| Trigger Name | Description |
|---|---|
| TR_CLIENTUSERS_INSERT | |
| TR_CLIENTUSERS_UPDATE |