Stores general patch data
Data model
Fields
| Field | Type | Description |
|---|---|---|
| architecture | VARCHAR (6) | Target operating system architecture (e.g., x86, x64) |
| created_date* | DATETIME | Registry Creation Date |
| description | VARCHAR (MAX) | Patch Description |
| external_patch_id* | UNIQUEIDENTIFIER | Unique external identifier of the patch provided by the vendor |
| id* | INT | Unique Patch Identifier |
| kb_id | VARCHAR (32) | Patch ID (KB) used by Microsoft |
| language | CHAR (5) | Patch language code |
| provider_id* | SMALLINT | Patch vendor identifier |
| publish_date | DATETIME | Patch Release Date |
| severity* | SMALLINT | Patch severity level (e.g., critical, high, medium, low) |
| size | BIGINT | Estimated patch size in bytes |
| title* | VARCHAR (1024) | Patch title |
| url_release_note | VARCHAR (1024) | URL with patch release notes |
| version | VARCHAR (20) | Patch Version |
Primary Key
| PK_APM_PATCH |
|---|
| id |