Runscanner is a OCR app using ML Kit Text Recognition model.
This app helps runner going to Club 16.
- Scan your running from picture.
- Record your running with card.
- Take statistics of your running
- Roboto Condensed
- Character
- Eczar
- Numerical character
- Primary
- #1EB980
- PrimaryVariant
- #045D56
- Secondary
- 3B4859
- Background
- #37474f
- Surface
- #455a64
- OnPrimary
- #FFFFFF
- OnSecondary
- #000000
- OnBackground
- #FFFFFF
- OnSurface
- #FFFFFF
No. | Column name | Type | Unit |
---|---|---|---|
1 | __id | ||
2 | uuid | ||
3 | distance | REAL | meter |
4 | calorie | INTEGER | kcal |
5 | duration | INTEGER | second |
6 | average_pace | INTEGER | second/mile |
7 | average_heart_rate | INTEGER | bpm |
8 | date | INTEGER | millisecond(unix time) |
No. | Attribute name | Type | Unit | Meaning |
---|---|---|---|---|
1 | mId | UUID | uuid | |
2 | mDistance | double | meter | run distance |
3 | mCalorie | int | kcal | used calories |
4 | mDuration | long | second | running time |
5 | mAvePace | long | second/mile | average pace |
6 | mAveHeartRate | int | bpm | average heart rate |
7 | mDate | long | millisecond(unix time) | taken date |
- select
- full search
select * from runs;
- with where clause
- from ${BEGIN}
select * from runs where date >= ${BEGIN};
- before ${END}
select * from runs where date < ${END};
- from ${BEGIN} and before ${BEGIN}
select * from runs where date >= ${BEGIN} and date < ${END};
- from ${BEGIN}
- full search
- count
- full count
select count(*) from runs;
- with where clause
- from ${BEGIN}
select count(*) from runs where date >= ${BEGIN};
- before ${END}
select count(*) from runs where date < ${END};
- from ${BEGIN} and before ${BEGIN}
select count(*) from runs where date >= ${END} and date < ${BEGIN};
- from ${BEGIN}
- full count
- total
- full total
total(${COLUMN NAME})
- with where clause
- from ${BEGIN}
select total(${COLUMN NAME}) from runs where date >= ${BEGIN};
- before ${END}
select total(${COLUMN NAME}) from runs where date < ${BEGIN};
- from ${BEGIN} and before ${BEGIN}
select total(${COLUMN NAME}) from runs where date >= ${END} and date < ${BEGIN};
- from ${BEGIN}
- full total
- insert
insert into runs(uuid, distance, calorie, duration, average_pace, average_heart_rate, date) values('${UUID}', ${DISTANCE}, ${CALORIE}, ${DURATION}, ${AVERAGE_PACE}, ${AVERAGE_HEART_RATE}, ${DATE});