EN
Español
English
Português
    APM_PATCH_DETAIL

    Store detailed patch information

    Data model

    Fields

    Field Type Description
    bulletin_id* INT Unique identifier of the newsletter related to the patch
    cve_ids VARCHAR (MAX) Describes the categorization of patch vulnerabilities
    date_released DATETIME2 Patch release date
    date_updated DATETIME Updated patch detail date
    guid VARCHAR (100) Unique Patch Identifier
    id* INT Table ID
    informational_comment VARCHAR (MAX) Additional patch detail information
    is_deployable* BIT Indicates whether the patch is deployable
    is_downloadable* BIT Indicates if the patch can be downloaded
    is_signed_by_vendor* BIT Indicates whether the patch has been signed
    kb_number VARCHAR (100) Number of KBs the patch has
    name* VARCHAR (100) Patch Name
    patch_type_id INT Describe the type of patch
    severity_id INT Patch severity id
    uninstallable* BIT Indicates whether the patch can be uninstalled

    Primary Key

    PK_APM_PATCH_DETAIL
    id

    References

    Column Referenced Table Referenced column Name
    bulletin_id* Bod. APM_BULLETIN_DETAIL id FK01_APM_PATCH_DETAIL
    patch_type_id Bod. APM_PATCH_TYPE id FK03_APM_PATCH_DETAIL
    severity_id Bod. APM_SEVERITY id FK02_APM_PATCH_DETAIL