Table: dbo.Workpaper_N_File_Storage
This table contains links a workpaper to the many files it can be made up of.
Columns
NameTypeConstraintsDescription
file_storage_KEYint (4)NOT NULLPrimary key and foreign key to the File_Storage table.
workpaper_file_component_KEYint (4)NOT NULLForeign 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_KEYint (4)NOT NULLForeign key to the Workpaper table. This points to the workpaper we are linking a file to.
Primary key
NameColumnsDescription
PK_Workpaper_N_File_Storage$file_storage_KEYfile_storage_KEY
Unique constraints
NameColumnsDescription
UK_Workpaper_N_File_Storage$workpaper_KEY$workpaper_file_component_KEYworkpaper_KEY, workpaper_file_component_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Workpaper_N_File_Storage__File_Storage__file_storage_KEYfile_storage_KEYFile_Storage (file_storage_KEY)
FK_Workpaper_N_File_Storage__Workpaper__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)
FK_Workpaper_N_File_Storage__Workpaper_File_Component__workpaper_file_component_KEYworkpaper_file_component_KEYWorkpaper_File_Component (workpaper_file_component_KEY)

Schema diagram