Table: dbo.Copy_From_VO_Destination_Path | |||
This table will hold the destination paths selected by each user for each file type when using Copy Files. | |||
Columns | |||
Name | Type | Constraints | Description |
copy_from_vo_destination_path_KEY | int (4) | NOT NULL | Primary key. |
user_preference_KEY | int (4) | NOT NULL | Foreign key to User_Preference table. |
copy_from_vo_source_type_KEY | int (4) | NOT NULL | Foreign key to Copy_From_VO_Source_Type table. |
destination_folder_path | nvarchar (520) | NOT NULL | The destination folder path. |
Primary key | |||
Name | Columns | Description | |
PK_Copy_From_VO_Destination_Path | copy_from_vo_destination_path_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Copy_From_VO_Destination_Path$copy_from_vo_source_type_KEY$user_preference_KEY | copy_from_vo_source_type_KEY, user_preference_KEY |