| 208 |
- |
1 |
## View: v_survey_answer
|
|
|
2 |
#
|
|
|
3 |
# +----------+------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +----------+------------------+------+-----+---------+-------+
|
|
|
6 |
# | aid | int(10) unsigned | NO | | 0 | |
|
|
|
7 |
# | classid | int(10) unsigned | NO | | NULL | |
|
|
|
8 |
# | qid | int(10) unsigned | NO | | NULL | |
|
|
|
9 |
# | RCid | int(11) unsigned | NO | | NULL | |
|
|
|
10 |
# | response | varchar(1024) | YES | | NULL | |
|
|
|
11 |
# | added | datetime | NO | | NULL | |
|
|
|
12 |
# +----------+------------------+------+-----+---------+-------+
|
|
|
13 |
|
|
|
14 |
CREATE OR REPLACE VIEW `v_survey_answer` AS select `survey_answer`.`aid` AS `aid`,`survey_answer`.`classid` AS `classid`,`survey_answer`.`qid` AS `qid`,`survey_answer`.`RCid` AS `RCid`,`survey_answer`.`response` AS `response`,`survey_answer`.`added` AS `added` from `survey_answer` where (`survey_answer`.`page` = `survey_answer`.`maxpage`)
|