Subversion Repositories VORC

## View: v_class_survey_summary
#
# +-----------+------------------+------+-----+---------+-------+
# | Field     | Type             | Null | Key | Default | Extra |
# +-----------+------------------+------+-----+---------+-------+
# | id        | int(10) unsigned | NO   |     | 0       |       |
# | name      | varchar(128)     | YES  |     | NULL    |       |
# | coach     | varchar(45)      | YES  |     | NULL    |       |
# | date      | date             | YES  |     | NULL    |       |
# | location  | varchar(45)      | YES  |     | NULL    |       |
# | time      | varchar(23)      | YES  |     | NULL    |       |
# | count     | bigint(21)       | NO   |     | 0       |       |
# | Overall   | double           | YES  |     | NULL    |       |
# | responses | bigint(21)       | YES  |     | 0       |       |
# +-----------+------------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_class_survey_summary` AS select `v_class`.`id` AS `id`,`v_class`.`name` AS `name`,`v_class`.`coach` AS `coach`,`v_class`.`date` AS `date`,`v_class`.`location` AS `location`,`v_class`.`time` AS `time`,`v_class`.`count` AS `count`,`v_survey_results`.`average` AS `Overall`,`v_survey_results`.`count` AS `responses` from (`v_class` left join `v_survey_results` on(((`v_survey_results`.`classid` = `v_class`.`id`) and (`v_survey_results`.`qid` = 8))))