BackOfficeSystemUsers

Primary Key

Primary Key Field Type
ID int

Fields

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

Foreign Keys

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

Indexes

Index Name Fields Unique Primary Clustered
IX_BackOfficeSystemUsers_BackOfficePeopleID_Current_ClientUsersID BackofficePeopleID, Current, ClientUsersID
IX_BackOfficeSystemUsers_ClientUsersID_BackOfficePeopleID_ID ClientUsersID, BackofficePeopleID, ID
PK_BackOfficeSystemUsers ID yes yes