| 208 |
- |
1 |
## View: v_coaches
|
|
|
2 |
#
|
|
|
3 |
# +---------------+------------------------+------+-----+---------+-------+
|
|
|
4 |
# | Field | Type | Null | Key | Default | Extra |
|
|
|
5 |
# +---------------+------------------------+------+-----+---------+-------+
|
|
|
6 |
# | RCid | int(11) | NO | | 0 | |
|
|
|
7 |
# | derby_name | varchar(45) | NO | | NULL | |
|
|
|
8 |
# | email | varchar(45) | NO | | NULL | |
|
|
|
9 |
# | real_name | varchar(45) | NO | | NULL | |
|
|
|
10 |
# | level | enum('AA','A','B','C') | NO | | NULL | |
|
|
|
11 |
# | phone | varchar(45) | YES | | NULL | |
|
|
|
12 |
# | password | varchar(45) | NO | | NULL | |
|
|
|
13 |
# | access | tinyint(5) | NO | | NULL | |
|
|
|
14 |
# | department | varchar(150) | YES | | NULL | |
|
|
|
15 |
# | MVPid | varchar(24) | YES | | NULL | |
|
|
|
16 |
# | discount_code | varchar(10) | YES | | NULL | |
|
|
|
17 |
# | tshirt | varchar(5) | YES | | NULL | |
|
|
|
18 |
# | pronouns | varchar(20) | YES | | NULL | |
|
|
|
19 |
# | timeformat | enum('24hr','ampm') | NO | | 24hr | |
|
|
|
20 |
# | last_login | datetime | YES | | NULL | |
|
|
|
21 |
# | added | datetime | YES | | NULL | |
|
|
|
22 |
# +---------------+------------------------+------+-----+---------+-------+
|
|
|
23 |
|
|
|
24 |
CREATE OR REPLACE VIEW `v_coaches` AS select `v_official`.`RCid` AS `RCid`,`v_official`.`derby_name` AS `derby_name`,`v_official`.`email` AS `email`,`v_official`.`real_name` AS `real_name`,`v_official`.`level` AS `level`,`v_official`.`phone` AS `phone`,`v_official`.`password` AS `password`,`v_official`.`access` AS `access`,`v_official`.`department` AS `department`,`v_official`.`MVPid` AS `MVPid`,`v_official`.`discount_code` AS `discount_code`,`v_official`.`tshirt` AS `tshirt`,`v_official`.`pronouns` AS `pronouns`,`v_official`.`timeformat` AS `timeformat`,`v_official`.`last_login` AS `last_login`,`v_official`.`added` AS `added` from `v_official` where ((`v_official`.`department` like '%COA-%') and (not((`v_official`.`department` like '%COA-0%'))))
|