Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | INT | 10 | √ | null |
|
|
||
| date | VARCHAR | 20 | √ | null |
|
|
||
| sap | VARCHAR | 10 | √ | null |
|
|
||
| program | VARCHAR | 50 | √ | null |
|
|
||
| pm | VARCHAR | 50 | √ | null |
|
|
||
| Q4 | VARCHAR | 30 | √ | null |
|
|
||
| Q5 | VARCHAR | 30 | √ | null |
|
|
||
| Q6 | VARCHAR | 30 | √ | null |
|
|
||
| Q7 | VARCHAR | 30 | √ | null |
|
|
||
| Q8 | VARCHAR | 30 | √ | null |
|
|
||
| Q9 | VARCHAR | 30 | √ | null |
|
|
||
| Q10 | VARCHAR | 30 | √ | null |
|
|
||
| Q11 | VARCHAR | 30 | √ | null |
|
|
||
| Q12 | VARCHAR | 30 | √ | null |
|
|
||
| Q13 | VARCHAR | 30 | √ | null |
|
|
||
| Q14 | VARCHAR | 30 | √ | null |
|
|
||
| Q15 | VARCHAR | 30 | √ | null |
|
|
||
| Q16 | VARCHAR | 30 | √ | null |
|
|
||
| Q17 | VARCHAR | 30 | √ | null |
|
|
||
| Q18 | VARCHAR | 30 | √ | null |
|
|
||
| Q19 | VARCHAR | 30 | √ | null |
|
|
||
| Q20 | VARCHAR | 30 | √ | null |
|
|
||
| notes | VARCHAR | 10000 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ix_rsm_survey_data_r_id | Performance | Asc | id |
| ix_rsm_survey_data_r_program | Performance | Asc/Asc | program + id |
Relationships
Close relationships within degrees of separation
