Table: dbo.BS_Workpaper__Staff__assigned_to_staff
Tracks an outgoing reference to staff data in FK_Workpaper__Staff__assigned_to__staff_KEY. Backup and restore uses this to link a restored client to data in the staff.
Columns
NameTypeConstraintsDescription
workpaper_KEYint (4)NOT NULLThe primary key, referencing the record that in turn references the FK that this table is tracking.
contact_guiduniqueidentifier (16)NOT NULLThe referenced item, staff's contact-guid, unique across all databases.
Primary key
NameColumnsDescription
PK_BS_Workpaper__Staff__assigned_to_staff$workpaper_KEYworkpaper_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_BS_Workpaper__Staff__assigned_to_staff__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)Foreign key that references the workpaper_KEY column of the Workpaper table

Schema diagram