Update Data Schema authored by Wes Li (wel191)'s avatar Wes Li (wel191)
...@@ -366,66 +366,8 @@ Acceptance Tests:<br> ...@@ -366,66 +366,8 @@ Acceptance Tests:<br>
**Database Schema** **Database Schema**
----------------------------- -----------------------------
**Database Schema** ![data_schema_template](uploads/c07d9039fa9e1b43821f97234b51fb7e/data_schema_template.gif)
This needs to be revised
<br>
<br>
Flight Route Schema:
<br>
<br>
Saskatoon——><———Toronto
Saskatoon———><——— Montreal
Saskatoon———><———Vancouver
Saskatoon———><———Los Angeles
*<Saskatoon——-><———Calgary>* [Departure Flight]
(**Calgary** is the connection airport for most international destinations)<br>
Calgary———><————-Seattle
Calgary——><——-Los Angeles
Calgary———><———Houston
Calgary————><———Yellowknife
Calgary———><———Chicago
Calgary——><———New York
Calgary——><——-Miami
Calgary——><——-Mexico City
Calgary——><——Cancun
Calgary——><——Paris
Calgary----><—-Frankfurt
Calgary——><—— London
Calgary———><———Barcelona
Calgary———><———Prague
Calgary——-><——Amsterdam
Calgary——><——Stockholm
Calgary——><——Rome
Calgary—><—-Munich
Calgary—-><—— Beijing
*<Calgary——><——Saskatoon>* [Return Flight to Calgary then back to Saskatoon]
<br>
... ...
......