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
NameTypeConstraintsDescription
copy_from_vo_destination_path_KEYint (4)NOT NULLPrimary key.
user_preference_KEYint (4)NOT NULLForeign key to User_Preference table.
copy_from_vo_source_type_KEYint (4)NOT NULLForeign key to Copy_From_VO_Source_Type table.
destination_folder_pathnvarchar (520)NOT NULLThe destination folder path.
Primary key
NameColumnsDescription
PK_Copy_From_VO_Destination_Pathcopy_from_vo_destination_path_KEY
Unique constraints
NameColumnsDescription
UK_Copy_From_VO_Destination_Path$copy_from_vo_source_type_KEY$user_preference_KEYcopy_from_vo_source_type_KEY, user_preference_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Copy_From_VO_Destination_Path__Copy_From_VO_Source_Type__copy_from_vo_source_type_KEYcopy_from_vo_source_type_KEYCopy_From_VO_Source_Type (copy_from_vo_source_type_KEY)
FK_Copy_From_VO_Destination_Path__User_Preference__user_preference_KEYuser_preference_KEYUser_Preference (user_preference_KEY)

Schema diagram