SQLite: Difference between revisions
From Wildsong
Jump to navigationJump to search
Brian Wilson (talk | contribs) mNo edit summary |
Brian Wilson (talk | contribs) mNo edit summary |
||
| Line 1: | Line 1: | ||
I am using SQLite for a web + Android app that will track and map my MPGs. | I am using SQLite for a web + Android app that will track and map my [[Yaris]] MPGs. | ||
== Schema == | == Schema == | ||
| Line 33: | Line 33: | ||
mpg | mpg | ||
average mpg | average mpg | ||
[[Category: Android]] | |||
Revision as of 19:30, 16 January 2013
I am using SQLite for a web + Android app that will track and map my Yaris MPGs.
Schema
log
id key date datetime odometer decimal(7,1) mileage decimal(5,1) distance traveled since last fillup gallons decimal(5,3) price decimal(6,3) price per gallon cost decimal(6,2) total purchase lat text lon text comment text ex: gas station name and address
journal
id key date datetime odometer decimal(7,1) weight int(11) comment text
trip
id key date datetime start decimal(7,1) stop decimal(7,1) comment text
Reports
Calculated
mpg average mpg
