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:35] – donpdonp | databases [2024/01/31 04:08] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| 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 | | + | == Queries |
| - | | insert Location at time T | | | + | |
| - | | read Location at latest time | time | | + | | insert Location at time T | |
| - | | insert Fence | | | + | | read Locations in timespan and is user | |
| - | | read Fences containing point | | | + | | insert Fence | |
| + | | read Fences containing point and is user | | ||
| + | | insert User | | ||
| + | | read User is username | ||
databases.1530210955.txt.gz · Last modified: 2024/01/31 04:08 (external edit)