| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| survey_id |
int |
10 |
|
|
0 |
|
|
| obj_fi |
int |
10 |
|
|
0 |
|
|
| author |
varchar |
50 |
√ |
|
null |
|
|
| introduction |
longtext |
2147483647 |
√ |
|
null |
|
|
| outro |
longtext |
2147483647 |
√ |
|
null |
|
|
| status |
varchar |
1 |
√ |
|
1 |
|
|
| evaluation_access |
varchar |
1 |
√ |
|
0 |
|
|
| invitation |
varchar |
1 |
√ |
|
0 |
|
|
| invitation_mode |
varchar |
1 |
√ |
|
1 |
|
|
| complete |
varchar |
1 |
√ |
|
0 |
|
|
| anonymize |
varchar |
1 |
√ |
|
0 |
|
|
| show_question_titles |
varchar |
1 |
√ |
|
1 |
|
|
| tstamp |
int |
10 |
|
|
0 |
|
|
| created |
int |
10 |
|
|
0 |
|
|
| mailnotification |
tinyint |
3 |
√ |
|
null |
|
|
| startdate |
varchar |
14 |
√ |
|
null |
|
|
| enddate |
varchar |
14 |
√ |
|
null |
|
|
| mailaddresses |
varchar |
2000 |
√ |
|
null |
|
|
| mailparticipantdata |
varchar |
4000 |
√ |
|
null |
|
|
| template_id |
int |
10 |
√ |
|
null |
|
|
| pool_usage |
tinyint |
3 |
√ |
|
null |
|
|
| mode_360 |
tinyint |
3 |
|
|
0 |
|
|
| mode_360_self_eval |
tinyint |
3 |
|
|
0 |
|
|
| mode_360_self_rate |
tinyint |
3 |
|
|
0 |
|
|
| mode_360_self_appr |
tinyint |
3 |
|
|
0 |
|
|
| mode_360_results |
tinyint |
3 |
|
|
0 |
|
|
| mode_360_skill_service |
tinyint |
3 |
|
|
0 |
|
|
| reminder_status |
tinyint |
3 |
|
|
0 |
|
|
| reminder_start |
datetime |
19 |
√ |
|
null |
|
|
| reminder_end |
datetime |
19 |
√ |
|
null |
|
|
| reminder_frequency |
smallint |
5 |
|
|
0 |
|
|
| reminder_target |
tinyint |
3 |
|
|
0 |
|
|
| tutor_ntf_status |
tinyint |
3 |
|
|
0 |
|
|
| tutor_ntf_reci |
varchar |
2000 |
√ |
|
null |
|
|
| tutor_ntf_target |
tinyint |
3 |
|
|
0 |
|
|
| reminder_last_sent |
datetime |
19 |
√ |
|
null |
|
|
Table contained 0 rows at Wed Apr 27 21:48 CEST 2016
|