Table: dbo.Workpaper_File_Component
This table contains the known types of files a workpaper may contain (i.e. preview, original, etc...).
Columns
NameTypeConstraintsDescription
workpaper_file_component_KEYint (4)NOT NULLPrimary key. This points to the type of file a workpaper contains.
descriptionnvarchar (60)NOT NULLThe name of the workpaper component
Primary key
NameColumnsDescription
PK_Workpaper_File_Componentworkpaper_file_component_KEY
Unique constraints
NameColumnsDescription
UK_Workpaper_File_Component$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Workpaper_N_File_Storage__Workpaper_File_Component__workpaper_file_component_KEYworkpaper_file_component_KEYWorkpaper_N_File_Storage

Schema diagram