Subversion Repositories VORC

## View: v_class_coach_assistants
#
# +------------+-------------+------+-----+---------+-------+
# | Field      | Type        | Null | Key | Default | Extra |
# +------------+-------------+------+-----+---------+-------+
# | date       | date        | YES  |     | NULL    |       |
# | start_time | time        | YES  |     | NULL    |       |
# | location   | varchar(45) | YES  |     | NULL    |       |
# | assistants | text        | YES  |     | NULL    |       |
# | aRCids     | text        | YES  |     | NULL    |       |
# +------------+-------------+------+-----+---------+-------+

CREATE OR REPLACE VIEW `v_class_coach_assistants` AS select `v_shift`.`date` AS `date`,`v_shift`.`start_time` AS `start_time`,`v_shift`.`location` AS `location`,group_concat(`v_shift`.`derby_name` separator ' & ') AS `assistants`,group_concat(`v_shift`.`RCid` separator ' & ') AS `aRCids` from `v_shift` where ((`v_shift`.`dept` = 'COA') and ((`v_shift`.`role` = 'Assistant (TA)') or (`v_shift`.`role` = 'Assistant Coach')) and (isnull(`v_shift`.`derby_name`) = 0) and (`v_shift`.`derby_name` <> '')) group by `v_shift`.`location`,`v_shift`.`start_time`,`v_shift`.`date`