Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 BackofficePeopleID int  
 Current bit Default = 1

Foreign Key Field Type Null Notes Description
 ClientUsersID int   ClientUsers.ID

Index Name Field(s) Unique Primary Clustered
 IX_BackOfficeSystemUsers_BackOfficePeopleID_Current_ClientUsersID BackofficePeopleID, Current, ClientUsersID      
 IX_BackOfficeSystemUsers_ClientUsersID_BackOfficePeopleID_ID ClientUsersID, BackofficePeopleID, ID      
 PK_BackOfficeSystemUsers ID  

Entity-Relationship diagram of this table