| 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 | |||
| Name | Type | Constraints | Description |
| workpaper_KEY | int (4) | NOT NULL | The primary key, referencing the record that in turn references the FK that this table is tracking. |
| contact_guid | uniqueidentifier (16) | NOT NULL | The referenced item, staff's contact-guid, unique across all databases. |
| Primary key | |||
| Name | Columns | Description | |
| PK_BS_Workpaper__Staff__assigned_to_staff$workpaper_KEY | workpaper_KEY | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| FK_BS_Workpaper__Staff__assigned_to_staff__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) | Foreign key that references the workpaper_KEY column of the Workpaper table |