| 208 |
- |
1 |
## View: v_class_survey_summary
|
|
|
2 |
#
|
|
|
3 |
# +-----------+------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +-----------+------------------+------+-----+---------+-------+
|
|
|
6 |
# | id | int(10) unsigned | NO | | 0 | |
|
|
|
7 |
# | name | varchar(128) | YES | | NULL | |
|
|
|
8 |
# | coach | varchar(45) | YES | | NULL | |
|
|
|
9 |
# | date | date | YES | | NULL | |
|
|
|
10 |
# | location | varchar(45) | YES | | NULL | |
|
|
|
11 |
# | time | varchar(23) | YES | | NULL | |
|
|
|
12 |
# | count | bigint(21) | NO | | 0 | |
|
|
|
13 |
# | Overall | double | YES | | NULL | |
|
|
|
14 |
# | responses | bigint(21) | YES | | 0 | |
|
|
|
15 |
# +-----------+------------------+------+-----+---------+-------+
|
|
|
16 |
|
|
|
17 |
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))))
|