Table: dbo.Workpaper_N_File_Storage
This table contains links a workpaper to the many files it can be made up of.
Columns
Name | Type | Constraints | Description
file_storage_KEY | int (4) | NOT NULL | Primary key and foreign key to the File_Storage table.
workpaper_file_component_KEY | int (4) | NOT NULL | Foreign key to the Workpaper_File_Component table. This describes the relationship the file has to the workpaper (i.e. is this file the original copy of the workpaper, or is it the display copy of the workpaper.
workpaper_KEY | int (4) | NOT NULL | Foreign key to the Workpaper table. This points to the workpaper we are linking a file to.

Primary key
Name | Columns | Description
PK_Workpaper_N_File_Storage$file_storage_KEY | file_storage_KEY |
Unique constraints
Name | Columns | Description
UK_Workpaper_N_File_Storage$workpaper_KEY$workpaper_file_component_KEY | workpaper_KEY, workpaper_file_component_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Workpaper_N_File_Storage__File_Storage__file_storage_KEY | file_storage_KEY | File_Storage (file_storage_KEY) |
FK_Workpaper_N_File_Storage__Workpaper__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |
FK_Workpaper_N_File_Storage__Workpaper_File_Component__workpaper_file_component_KEY | workpaper_file_component_KEY | Workpaper_File_Component (workpaper_file_component_KEY) |