Hey Everyone,

I have limited SQL background, basically a small amount of manipulation through HTML and mostly with pre-existing databases. What I am trying to do is set up a database that will store time information for bus routes. So basically I have different routes with stops for each route and then a list of times that the bus arrives at each stop. Here is an example of a table of times from their website: Link.

I am wondering what would be the best way to layout my database/tables?

Also what is the purpose of the _id field in each table?

Thanks, Rob!

P.S. Sorry if my lack of knowledge on the subject has caused me to post a duplicate question.