databases
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
| databases [2018/06/28 18:37] – donpdonp | databases [2018/06/28 18:47] – donpdonp | ||
|---|---|---|---|
| Line 9: | Line 9: | ||
| * Location: id, user, point, time | * Location: id, user, point, time | ||
| - | * User: id | + | * User: id, username, email |
| * Fence: id, polygon | * Fence: id, polygon | ||
| - | | query | index | | + | | query | |
| | insert Location at time T | | | | insert Location at time T | | | ||
| - | | read Locations from time1 to time2 and user | time_and_user | + | | read Locations from time1 to time2 and user and inside polygon |
| | insert Fence | | | | insert Fence | | | ||
| | read Fences containing point and user | | | | read Fences containing point and user | | | ||
| + | | insert User | | | ||
| + | | read User containing username | username | | ||
databases.txt · Last modified: 2024/01/31 04:08 by 127.0.0.1