Database Models

The features yield the following requirements for data.

Config

• D17: schemaVersion

Users

Fields:

• D01: name (F27)
• D02: email (F03)
• D03: hash (F01)

Locations

Fields:

• D04: id
• D05: name (F07)
• D12: geom (F15)
• D13: layer (F14)
• D16: tags (F09, F30)

Indices:

• D14: D12 spatial index to implement quick F14 and F15
• D15: D13 index to implement quick F14
• D18: D16 tag index for F30. Maybe needed only with over million locations or so.

Events

Or LocationEvents. Needed because F18, F21, F22. Also a way to implement F28 if indexed on location id.

Fields:

• D06: time (F21)
• D07: locationId (F28)
• D08: type alias dataSchema
• D09: user (F22, F32)
• D19: data

Indices:

• D11: D06 order by time to implement F21
• D10: D07 order by location to implement F28