Primary Key Field Type
 ID int

Field Field Type Null Notes Description
 BackofficeRecordID int  

Foreign Key Field Type Null Notes Description
 BackOfficeSystemID int   BackOfficeSystems.ID

Index Name Field(s) Unique Primary Clustered
 IX_BackOfficeSystemPeople_ID_BackOfficeSystemID_BackOfficeRecordID ID, BackOfficeSystemID, BackofficeRecordID      
 PK_BackOfficeSystemPeople ID  
 UK_BackOfficeSystemPeople_1 BackOfficeSystemID, BackofficeRecordID    

Referenced by Field
 ClassYearNotes BackOfficeSystemPeopleID
 ClientUserFieldPrivacy BackOfficeSystemPeopleID
 CONDITIONALCONTENTRECIPIENT BOSPID
 NotificationSubscription BackOfficeSystemPeopleID

Entity-Relationship diagram of this table