Getting started with SQLite (Android)
- by Tarmon
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.