Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| sap | VARCHAR | 6 | √ | null |
|
|
||
| complete | VARCHAR | 20 | √ | null |
|
|
||
| pm | VARCHAR | 20 | √ | null |
|
|
||
| type | VARCHAR | 20 | √ | null |
|
|
||
| budget | INT | 10 | √ | null |
|
|
||
| actual | INT | 10 | √ | null |
|
|
||
| gc_budget | INT | 10 | √ | null |
|
|
||
| rt_duration | INT | 10 | √ | null |
|
|
||
| nrt_duration | INT | 10 | √ | null |
|
|
||
| budget_score | DECIMAL | 3,1 | √ | null |
|
|
||
| rt_score | DECIMAL | 3,1 | √ | null |
|
|
||
| nrt_score | DECIMAL | 3,1 | √ | null |
|
|
||
| rsm_pm_score | DECIMAL | 3,1 | √ | null |
|
|
||
| rsm_gc_score | DECIMAL | 3,1 | √ | null |
|
|
||
| ave_score | DECIMAL | 3,1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_pm_kpi_pm | Performance | Asc/Asc/Asc | pm + type + sap |
| ix_pm_kpi_sap | Performance | Asc/Asc/Asc | sap + type + pm |
| ix_pm_kpi_type | Performance | Asc/Asc/Asc | type + pm + sap |
