Scheduling-Databases: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==Introduction== Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security. The next db added was the Pool Lay...") |
m (1 revision imported: Hopefully full import) |
(No difference)
| |
Latest revision as of 00:25, 21 June 2023
Introduction
Scheduling system started off without dbs, the first db support added was just login support to provide some minimal security. The next db added was the Pool Layout DB in Fall 2012 to add in support for larger pools using the much improved pool layout system. Also in Fall 2012, added support for another database "sched". This db has several tables:
- tm - slightly manipulated version of the teams report exported from Rainier.
- ev - slightly manipulated version of the events report exported from Rainier.
- gm - This is a games table derived from the xml files that references tmid and evid keys from the tm and ev tables.
Examples
sqlite> select tmid,name from tm where program = 'Goleta'; 132|Team 01 133|Team 03 134|Team 04 135|Team 05 sqlite> select * from gm inner join ev on ev.evid=gm.evid inner join tm on gm.tmid1=tm.tmid or gm.tmid2=tm.tmid where tm.tmid='135'; 493|135||262|3|1|11-12|10:10 AM-10:30 AM|262|Fall 2012|Goleta|Games|Sep 29, 2012|2012-09-29|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 496|135||262|3|2|11-12|10:35 AM-10:55 AM|262|Fall 2012|Goleta|Games|Sep 29, 2012|2012-09-29|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 499|135||266|3|1|11-12|10:10 AM-10:30 AM|266|Fall 2012|Goleta|Games|Oct 13, 2012|2012-10-13|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 502|135||266|3|2|11-12|10:35 AM-10:55 AM|266|Fall 2012|Goleta|Games|Oct 13, 2012|2012-10-13|10:00 AM|11:00 AM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 505|135||272|3|1|11-12|10:10 AM-10:30 AM|272|Fall 2012|Goleta|Games|Nov 03, 2012|2012-11-03|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 508|135||272|3|2|11-12|10:35 AM-10:55 AM|272|Fall 2012|Goleta|Games|Nov 03, 2012|2012-11-03|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 2427|307|135|584|6|1||10:10 AM-10:30 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 2430|135|308|584|7|2||10:35 AM-10:55 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 2432|135|301|584|7|3||11:00 AM-11:20 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 2433|307|135|584|6|4||11:25 AM-11:45 AM|584|Fall 2012|Oxnard|Intersite Game Day Home Game vs. Ojai & Goleta|Oct 06, 2012|2012-10-06|10:00 AM|12:00 PM|Sat|Oxnard Beach Park||Oxnard|CA|93030|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 3223|301|135|268|3|1||10:10 AM-10:30 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 3224|301|135|268|3|2||10:35 AM-10:55 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 3225|301|135|268|3|3||11:00 AM-11:20 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 3226|301|135|268|3|4||11:25 AM-11:45 AM|268|Fall 2012|Goleta|Intersite Game Day Home Game vs. Ojai|Oct 20, 2012|2012-10-20|10:00 AM|12:00 PM|Sat|Girsh Park||GOLETA|CA|93117|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 4380|135|504|974|7|1||10:10 AM-10:30 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 4382|503|135|974|6|2||10:35 AM-10:55 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 4387|135|502|974|8|3||11:00 AM-11:20 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3|| 4390|135|505|974|8|4||11:25 AM-11:45 AM|974|Fall 2012|Ventura|Intersite Game Day Home Game vs. Goleta & Ojai|Oct 27, 2012|2012-10-27|10:00 AM|12:00 PM|Sat|Arroyo Verde Park||Ventura|CA|93003|135|Fall 2012|Goleta|5|Team 05|11-12|3||