plugin_sap_healthresults

1841 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
reportresultid INT 10 null
TargetType INT 10 null
TargetId INT 10 null
ClientID INT 10 null
LocationID INT 10 null
DateGenerated DATE 10 null
HealthCheckGuid CHAR 36 null
plugin_sap_healthchecks.HealthCheckGuid Implied ConstraintR
HealthScore INT 10 null
HealthMaxScore INT 10 null
HealthImpact INT 10 null
HealthMessage TEXT 65535 null
HealthCalculation TEXT 65535 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc reportresultid
Daily_HealthResult Must be unique Asc/Asc/Asc/Asc TargetType + TargetId + DateGenerated + HealthCheckGuid

Relationships