Table that stores the details of a patch download
Data model
Fields
| Field | Type | Description |
|---|---|---|
| automatic_install | BIT | Flag indicating whether to perform automatic installation of a patch |
| download_date | DATETIME | Download Date |
| download_status_id* | INT | Identifier of the associated download status, reference to the APM_DOWNLOAD_STATUS.id table |
| id* | INT | Integer Type Primary Key |
| language_id* | INT | Identifier of the associated language, reference to the APM_LANGUAGE.id table |
| patch_detail_id | INT | Associated patch detail ID, reference to APM_PATCH_DETAIL.id table |
| scheduled_date | DATETIME | Date when the download was scheduled |
| service_pack_id | INT | Associated service pack detail ID, reference to APM_SERVICE_PACK_DETAIL.id table |
| shavlik_file_name | VARCHAR (100) | Patch file name |
| size* | BIGINT | Patch size |
| url* | VARCHAR (1024) | Patch download url |
Primary Key
| PK_APM_DOWNLOAD_DETAIL |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| download_status_id* | Bod. APM_DOWNLOAD_STATUS | id | FK04_APM_DOWNLOAD_DETAIL |
| language_id* | Bod. APM_LANGUAGE | id | FK01_APM_DOWNLOAD_DETAIL |
| patch_detail_id | dbo.APM_PATCH_DETAIL | id | FK02_APM_DOWNLOAD_DETAIL |
| service_pack_id | Bod. APM_SERVICE_PACK_DETAIL | id | FK03_APM_DOWNLOAD_DETAIL |