ClientUsers (4.0SP25)

no changes

dbo-4.0

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers
Referenced by

Primary Key
Primary Key	Field Type
ID	int

Foreign Key Fields
Foreign Key	Field Type	Null	Notes
TimeZoneID	int	true	TimeZone.ID
CreateID	int	true	ClientUsers.ID
UpdateID	int	true	ClientUsers.ID
DefaultSiteID	int	true	ClientSites.ID

Fields
Field	Field Type	Null	Notes
Password	nvarchar(255)	true
UserName	nvarchar(50)	false
EMail	nchar	true
Active	bit	false	-1
LastName	nvarchar(50)	true
FirstName	nvarchar(50)	true
MiddleInitial	nvarchar(5)	true
InternalUser	bit	false	0
Guid	uniqueidentifier	true	(newid())
Deleted	bit	false	0
ClientsID	int	true
RegistrationNumber	nvarchar(50)	true
ReminderPhrase	nvarchar(150)	true
BackofficeRecordType	int	true	0
DateLastLogin	datetime	true
NumFailedAttempts	int	false	0
IsSupervisor	bit	true
MembershipRefreshedOn	datetime	true
CreateDate	datetime	true	getutcdate()
IsProvisional	bit	true
UpdateDate	datetime	false	getutcdate()
LockedOutTime	datetime	true
LinkedInProfileID	int	true	0

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
ix_ClientUsers_Deleted_Last_First_ID	Deleted LastName FirstName ID	False	False	False
IX_ClientUsers_ID	ID	False	False	True
IX_ClientUsers_ID_LastName_FirstName_MiddleInitial	ID LastName FirstName MiddleInitial	False	False	False
IX_ClientUsers	ClientsID UserName	True	False	False
PK_Users	ID	True	True	False

Triggers
Trigger Name	Description
TR_CLIENTUSERS_INSERT
TR_CLIENTUSERS_UPDATE

Referenced by
Referenced by	Field
Addressbook	UserID
AddressBookContacts	ClientUsersID
ADDRESSBOOKFAF	CLIENTUSERSID
ATHLETICS_TEAMS	PageCreatorClientUsersID
BackOfficeSystemUsers	ClientUsersID
BackOfficeUserImportErrRecords	ClientUsersId
BATCHEVENTSPONSORSHIP	ORIGINALCLIENTUSERID
CalendarEvent	CreatedUserID
CalendarEvent	ApprovedUserID
CapWizTransactions	AddedByUserID
ClassYearNotes	OwnerID
ClassYearNotes	ApprovedByID
ClientSites	OwnerID
ClientUserDashboardPanel	ClientUsersID
CLIENTUSERFEATURETOUR	CLIENTUSERID
CLIENTUSERIDENTITYINFO	CLIENTUSERID
ClientUserImages	ClientUsersID
ClientUserMailForwarding	CreateID
ClientUserMailForwarding	UpdateID
ClientUserPasswordHistory	UserID
ClientUserProfile	UserID
ClientUserReport	ClientUsersID
CLIENTUSERSCIPHER	CLIENTUSERSID
CLIENTUSERSCIPHERHISTORY	CLIENTUSERSID
CLIENTUSERSEXTENSION	CLIENTUSERID
CLIENTUSERSSALTCIPHER	CLIENTUSERSID
CLIENTUSERSSALTCIPHERHISTORY	CLIENTUSERSID
CLIENTUSERSTIPSSEEN	CLIENTUSERID
CMSREDIRECT	CLIENTUSERID
CMSUSERSALESORDER	CLIENTUSERID
CMSUSERSOCIALMEDIAACCOUNT	CLIENTUSERID
CMSUSERSOCIALPROFILE	CMSUSERID
CONDITIONALCONTENTRECIPIENT	USERID
ContactGroup	ClientUsersID
CustomFormElement	OwnerID
DiscussionPosts	ApprovedID
DiscussionTopics	ApprovedID
DONATIONBATCH	ORIGINALCLIENTUSERID
DonationTransactions	AddedByUserID
EmailJobStatus	UserID
EmailList_Subscription	UserID
EMAILSCHEDULE	CLIENTUSERSID
EventTransactions	AddedByUserID
FacebookClientUsers	ClientUsersID
FAFCOMMENTS	CLIENTUSERSID
FAFCOMMENTSAPPROVAL	CLIENTUSERSID
FAFCOMMUNICATIONSLOG	CLIENTUSERSID
FundRaiserSolicitors	ClientUsersID
JobPosts	ApprovedID
NetAccount	ClientUsersID
NetAccount	LockedUserID
NetAccount	DeletedUserID
NetGroup	DeletedUserID
NetGroup	LockedUserID
NewsStories	PostId
NewsStories	ApprovedID
NotificationSubscription	UserID
PARTICIPANTEMAILTEMPLATE	CLIENTUSERSID
ProfileUpdateTransactions	AddedByUserID
REGISTRANTBATCH	ORIGINALCLIENTUSERID
REVENUEOFFLINEDONATION	CLIENTUSERSID
ShoppingCart	ClientUsersID
SignupTransactions	UserID
SiteCopy	OwnerUserID
SiteCopy	RollbackUserID
UserMap	ClientUsersID
UserPagesEditors	ClientUsersID
UserRoles	ClientUsersID
VolunteerTransactions	AddedBy