hotfixdata

526 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
HotFixID VARCHAR 40 null
kbID VARCHAR 30 null
Title VARCHAR 255 null
Category INT 10 null
DownloadURL VARCHAR 1000 null
FileName VARCHAR 255 null
Switches VARCHAR 255 null
Restart INT 10 null
OS VARCHAR 100 null
Date_Added DATETIME 19 null
Description VARCHAR 1024 null
SupportURL VARCHAR 255 null
Severity VARCHAR 50 null
CategoryName VARCHAR 255 null
PatchType VARCHAR 25 null
Uninstall INT 10 0
Ignore INT 10 null
Discovered INT 10 null
Missing INT 10 null
LabTechApproved INT 10 null
CommunityApproved INT 10 null
UserApproved INT 10 null
CVSS DOUBLE 22 null
IsThirdParty INT 10 null
Bulletin VARCHAR 255 null
SoftwareDefinition TEXT 65535 null
Manufacturer VARCHAR 255 Microsoft
Version VARCHAR 100 null
ApprovalPolicyCount INT 10 null
Availability INT 10 null
LTProductKey VARCHAR 36 null
IsOperatingSystemPatch INT 10 null
OS_Build VARCHAR 100 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc HotFixID + OS
CategoryName Performance Asc CategoryName
Discovered Performance Asc Discovered
HotFixDataIsThirdParty Performance Asc IsThirdParty
HotFixDataLTProductKey Performance Asc LTProductKey
Missing Performance Asc Missing
OS Performance Asc OS
Severity Performance Asc Severity
Title Performance Asc Title

Diagram producer might be missing

No diagrams were produced please see application output for any errors