Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
TargetType | INT | 10 | null |
|
|
|||||
TargetID | INT | 10 | null |
|
|
|||||
HealthCheckGUID | CHAR | 36 | null |
|
|
|||||
CheckName | VARCHAR | 255 | null |
|
|
|||||
CheckCategoryID | INT | 10 | null |
|
|
|||||
CheckOrder | INT | 10 | null |
|
|
|||||
GroupCheckOrder | INT | 10 | null |
|
|
|||||
TargetHealthScore | INT | 10 | null |
|
|
|||||
TargetHealthScoreMax | INT | 10 | null |
|
|
|||||
TargetStraightScore | INT | 10 | null |
|
|
|||||
TargetWeightedScore | INT | 10 | null |
|
|
|||||
ScoringMethod | INT | 10 | null |
|
|
|||||
TargetGroupData | VARCHAR | 23 | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
ReportCheckResults | Must be unique | Asc/Asc/Asc | TargetType + TargetID + HealthCheckGUID |