| 208 |
- |
1 |
## View: v_class_coach_assistants
|
|
|
2 |
#
|
|
|
3 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
6 |
# | date | date | YES | | NULL | |
|
|
|
7 |
# | start_time | time | YES | | NULL | |
|
|
|
8 |
# | location | varchar(45) | YES | | NULL | |
|
|
|
9 |
# | assistants | text | YES | | NULL | |
|
|
|
10 |
# | aRCids | text | YES | | NULL | |
|
|
|
11 |
# +------------+-------------+------+-----+---------+-------+
|
|
|
12 |
|
|
|
13 |
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`
|