| 208 |
- |
1 |
## View: v_official
|
|
|
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 |
# | activation | varchar(32) | NO | | NULL | |
|
|
|
13 |
# | password | varchar(45) | NO | | NULL | |
|
|
|
14 |
# | access | tinyint(5) | NO | | NULL | |
|
|
|
15 |
# | department | varchar(150) | YES | | NULL | |
|
|
|
16 |
# | emt_verified | int(1) | YES | | NULL | |
|
|
|
17 |
# | MVPid | varchar(24) | YES | | NULL | |
|
|
|
18 |
# | discount_code | varchar(10) | YES | | NULL | |
|
|
|
19 |
# | tshirt | varchar(5) | YES | | NULL | |
|
|
|
20 |
# | pronouns | varchar(20) | YES | | NULL | |
|
|
|
21 |
# | timeformat | enum('24hr','ampm') | NO | | 24hr | |
|
|
|
22 |
# | showme | tinyint(4) | NO | | 0 | |
|
|
|
23 |
# | last_login | datetime | YES | | NULL | |
|
|
|
24 |
# | added | datetime | YES | | NULL | |
|
|
|
25 |
# +---------------+------------------------+------+-----+---------+-------+
|
|
|
26 |
|
|
|
27 |
CREATE OR REPLACE VIEW `v_official` AS select `official`.`RCid` AS `RCid`,`official`.`derby_name` AS `derby_name`,`official`.`email` AS `email`,`official`.`real_name` AS `real_name`,`official`.`level` AS `level`,`official`.`phone` AS `phone`,`official`.`activation` AS `activation`,`official`.`password` AS `password`,`official`.`access` AS `access`,`official`.`department` AS `department`,if((locate('EMT',`official`.`department`) > 0),if(isnull(`emt_credential_verified`.`date`),0,1),NULL) AS `emt_verified`,`RCid_ticket_link`.`MVPid` AS `MVPid`,`official`.`discount_code` AS `discount_code`,`official`.`tshirt` AS `tshirt`,`official`.`pronouns` AS `pronouns`,`official`.`timeformat` AS `timeformat`,`official`.`showme` AS `showme`,`official`.`last_login` AS `last_login`,`official`.`added` AS `added` from ((`official` left join `RCid_ticket_link` on(((`official`.`RCid` = `RCid_ticket_link`.`RCid`) and (`RCid_ticket_link`.`year` = year(now()))))) left join `emt_credential_verified` on(((`official`.`RCid` = `emt_credential_verified`.`RCid`) and (year(`emt_credential_verified`.`date`) = year(now())))))
|