Table: dbo.File_Storage
This table contains information needed for storing files.
Columns
NameTypeConstraintsDescription
file_storage_KEYint (4)NOT NULLPrimary key. This points to file data.
file_namenvarchar (512)NOT NULLThe name of the file in storage, file name only, no path information, without extension.
file_storage_guiduniqueidentifier (16)NOT NULLThe unique identifier for the file data
file_extensionnvarchar (512)NOT NULLThis is the extension for the file without the period
Primary key
NameColumnsDescription
PK_File_Storagefile_storage_KEY
Unique constraints
NameColumnsDescription
UK_File_Storage$file_storage_guidfile_storage_guid
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_File_Storage_Data__File_Storage__file_storage_KEYfile_storage_KEYFile_Storage_Data
FK_Firm__File_Storage__firm_hosted_client_access__file_storage_KEYfirm_hosted_client_access__file_storage_KEYFirm
FK_Firm__File_Storage__tickmark_stamps__file_storage_KEYtickmark_stamps__file_storage_KEYFirm
FK_Workpaper_N_File_Storage__File_Storage__file_storage_KEYfile_storage_KEYWorkpaper_N_File_Storage
FK_Payable_Transaction__File_Storage__file_storage_KEYfile_storage_KEYPayable_Transaction

Schema diagram