-
Notifications
You must be signed in to change notification settings - Fork 4
Release 1.0 Data Model
Generated with schemacrawler with the command
bash schemacrawler-14.19.01-distribution/examples/diagram/sqlite_diagram.sh <path to sqlite.db>
At a high level the data entities are:
Organisation: The organisation responsible for the event response (e.g. {State} Emergency Service).
User: The user with a login/password, a person participating in events and submitting their availability.
Capability: The capability of a particular user (e.g. Flood Rescue 1).
Group: A way to organise users together (for purposes of responding to events).
Schedule: A pattern of availability applied to a group.
TimeSegment: The forecast availability for a particular user (either available, unavailable or tentative)
Tag: A label for categorising Organisation, User, Group.
Event: The event that needs actioning by a group (e.g. tree down at X location).
EventResponse: The details about a user responding to an event.
EventLocation: Places of interest for an event (scene, HQ or a meeting point), as well as the destination the user is attending
Device: The details about a user's device.
The availability application is designed to be either standalone (complete data model above) or integrated into an organisation's emergency response system.
In an integrated system, any combination of data for Users (including Capability), Events, Groups & Schedules.