Subversion Repositories VORC

## View: v_survey_answer
#
# +----------+------------------+------+-----+---------+-------+
# | Field    | Type             | Null | Key | Default | Extra |
# +----------+------------------+------+-----+---------+-------+
# | aid      | int(10) unsigned | NO   |     | 0       |       |
# | classid  | int(10) unsigned | NO   |     | NULL    |       |
# | qid      | int(10) unsigned | NO   |     | NULL    |       |
# | RCid     | int(11) unsigned | NO   |     | NULL    |       |
# | response | varchar(1024)    | YES  |     | NULL    |       |
# | added    | datetime         | NO   |     | NULL    |       |
# +----------+------------------+------+-----+---------+-------+

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`)