Each row identifies a file that can be downloaded.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| download_file_uuid | byte(16) | not null | The uuid of the downloadable file. |
| name | nvarchar(255) | with null | The name of the file. |
| download_url | nvarchar(1024) | with null | The fully qualified URL needed to download the file. |
| download_protocol | nchar(10) | with null | The value of this column is normally null. The download protocol can be extracted by parsing the URL if needed. |
| download_userid | nvarchar(64) | with null | The userid required to download the file. The value is null if none is needed. |
| download_password | nvarchar(64) | with null | The password required to download the file. The value is null if none is needed. The value is encrypted if present. |
| size_in_bytes | integer | with null | The size of the file in bytes. |
| stored_location | nvarchar(1024) | with null | This column is used by the UPM download manager to record the location of the file in the file system of the file after it has been downloaded. If the value is null, then the file has not yet been downloaded. |
| extraction_user_id | nvarchar(64) | with null | The userid required to extract data from the file. The value is null if none is needed. |
| extraction_password | nvarchar(64) | with null | The password required to extract data from the file. The value is null if none is needed. The value is encrypted if present. |
| extraction_command | nvarchar(30) | with null | The command line required to extract data from the file. The value is null if none is needed. |
| checksum | nvarchar(50) | with null | The MD5 checksum of the file. Used by the UPM download manager to verify the validity of the file after download. |
| install_pkg_uuid | byte(16) | with null | If this downloadable file is associated with a service pack or patch, this column will contain the uuid of the row in ca_install_package that represents the patch or service pack. It will null if the downloadable file is for some other purpose. |
| package_type_id | byte(16) | with null | The file type code associated with the downloadable file. See the package_type table. |
| creation_user | nvarchar(64) | with null | |
| credentials_required | integer1 | with null | 1 if credentials are required to download the file. 0 if not. |
| creation_date | integer | with null | |
| is_active | integer1 | not null | See ca_software_def.is_active |
| source_type_id | integer | not null | The type code identifying the source of data. See the ca_source_type table. |
| last_update_user | nvarchar(64) | with null | |
| last_update_date | integer | with null |
Product Name: Unicenter Patch Management
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| download_file_uuid | upm_download | download_file_uuid |