Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ClientID | INT | 10 | 0 |
|
|
|||||
| DateGenerated | DATE | 10 | √ | null |
|
|
||||
| GroupDate | VARCHAR | 8 | √ | null |
|
|
||||
| HealthCheckGUID | CHAR | 36 | null |
|
|
|||||
| CheckCategoryID | INT | 10 | null |
|
|
|||||
| CheckName | VARCHAR | 255 | null |
|
|
|||||
| CheckOrder | INT | 10 | null |
|
|
|||||
| StraightScore | DECIMAL | 14 | √ | null |
|
|
||||
| WeightedScore | DECIMAL | 36 | √ | null |
|
|
||||
| ScoringMethod | VARCHAR | 55 | √ | null |
|
|
||||
| GreenMin | DOUBLE | 23 | √ | null |
|
|
||||
| YellowMin | DOUBLE | 23 | √ | null |
|
|
||||
| YellowIsUnhealthy | DOUBLE | 23 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
