Timeline for MySQL Database Schema for Train Timetables
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 19, 2023 at 8:33 | comment | added | Prageeth Liyanage | @ChrisSaxon What is the difference between the operating day and date on Schedule Day table? Trains are categories as Daily trains, Not On Sunday, Not on Saturday like wise...How we add the records to the tables? Thank you | |
| Sep 5, 2023 at 15:24 | comment | added | Chris Saxon |
@PrageethLiyanage schedule_days stores a row for every day a schedule runs on; you could possibly combine train schedules and schedule days. It's still worth having a table with a row/day/schedule independent of stations to make queries/day easier though.
|
|
| Sep 5, 2023 at 8:59 | comment | added | Prageeth Liyanage | I dont understand the usage of schedule days table Chris. For scheduling purpose Can we use only station table, Train table, Schedule Stations...But in last one you have to include date and train id.. | |
| Apr 3, 2020 at 15:24 | comment | added | Chris Saxon | You can infer the direction from the arrival/departure times for the stations in a schedule | |
| Apr 3, 2020 at 6:23 | comment | added | theTypan | What if you want to introduce a an aspect of direction? The schedule table does say from which station the train comes from | |
| May 10, 2016 at 16:21 | review | Suggested edits | |||
| May 10, 2016 at 16:42 | |||||
| Sep 20, 2012 at 19:43 | history | answered | Chris Saxon | CC BY-SA 3.0 |