Project Assignment 8 - App Description and Database Schema

Posted on

Documents

Initial App Description

Final App Description

1/19/21 Interview Notes

1/26/21 Interview Notes

System & Devices, Stakeholders, Personas, Environments, and Scenarios

Hierarchical Task Analysis

Database schema:

List of Domain Classes:

  • TrailReport - a report of conditions on the trail
  • Trail - a model representing a single trail
  • SensorDataPoint - a datapoint automatically recorded from sensors along the trail

Domain Class: TrailReport

  • trail - Trail, foreign key into Trails table
  • latitude - double?, latitude coordinate of incident
  • longitude - double?, longitude coordinate of incident
  • condition - double, percentage rating of the current conditions
  • notes - text?, comment field
  • needsAttention - boolean=false, marks particular location or trail as in need of special attention
  • createdAt - DateTime=now(), user-editable but defaults to current time

Domain Class: Trail

  • name - string, trail name

Domain Class: Sensor

  • latitude - double, latitude coordinate of sensor
  • longitude - double, longitude coordinate of sensor
  • name - string, sensor name
  • trail - Trail?, optional association with a row in the Trails table

Domain Class: SensorDataPoint

  • sensor - Sensor, foreign key into Sensors table
  • ph - float, water pH level
  • dissolvedOxygen - float
  • conductivity - float
  • temperature - float
  • streamGauge - float
  • daysSincePercipitation - int