Table: dbo.File_Storage
This table contains information needed for storing files.
Columns
Name | Type | Constraints | Description
file_storage_KEY | int (4) | NOT NULL | Primary key. This points to file data.
file_name | nvarchar (512) | NOT NULL | The name of the file in storage, file name only, no path information, without extension.
file_storage_guid | uniqueidentifier (16) | NOT NULL | The unique identifier for the file data
file_extension | nvarchar (512) | NOT NULL | This is the extension for the file without the period

Primary key
Name | Columns | Description
PK_File_Storage | file_storage_KEY |
Unique constraints
Name | Columns | Description
UK_File_Storage$file_storage_guid | file_storage_guid |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_File_Storage_Data__File_Storage__file_storage_KEY | file_storage_KEY | File_Storage_Data |
FK_Firm__File_Storage__firm_hosted_client_access__file_storage_KEY | firm_hosted_client_access__file_storage_KEY | Firm |
FK_Firm__File_Storage__tickmark_stamps__file_storage_KEY | tickmark_stamps__file_storage_KEY | Firm |
FK_Workpaper_N_File_Storage__File_Storage__file_storage_KEY | file_storage_KEY | Workpaper_N_File_Storage |
FK_Payable_Transaction__File_Storage__file_storage_KEY | file_storage_KEY | Payable_Transaction |