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 |