databases
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
databases [2018/06/28 18:32] – donpdonp | databases [2024/01/31 04:08] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 8: | Line 8: | ||
* https:// | * https:// | ||
- | Record: id, user, lat, lng, time | + | * Location: id, user, point, time |
+ | * User: id, username, email | ||
+ | * Fence: id, polygon | ||
+ | |||
+ | == Queries | ||
+ | |||
+ | | insert Location at time T | | ||
+ | | read Locations in timespan and is user | | ||
+ | | insert Fence | | ||
+ | | read Fences containing point and is user | | ||
+ | | insert User | | ||
+ | | read User is username | | ||
- | | query | index | | ||
- | | insert record at time 1 | | | ||
- | | read record at latest time | time | | ||
databases.1530210776.txt.gz · Last modified: 2024/01/31 04:08 (external edit)