Skip to content

Move sensor-related data structures to a sensor schema #5

Description

@monica-pwd

Complete the notional separation from the fieldwork app and separate sensor-related structures from the fieldwork schema

  • fieldwork.tbl_inventory_sensors
  • fieldwork.tbl_sensor_issue_lookup
  • fieldwork.tbl_sensor_model_lookup
  • fieldwork.tbl_sensor_purpose_lookup
  • fieldwork.tbl_sensor_status_log
  • fieldwork.tbl_sensor_status_lookup
  • fieldwork.tbl_sensor_test_type_lookup
  • fieldwork.tbl_sensor_tests
  • fieldwork.tbl_sensortest_status_lookup (also rename this?)
  • fieldwork.viw_sensor_current_status
  • fieldwork.viw_sensor_recent_tests
  • fieldwork.viw_sensor_tests_full

Modify to work with new schema:

  • fieldwork.fun_sensor_isnt_deployed()

Create a sensors schema and move these there, completing any data structure cleanup as necessary, and ensuring continuity with other apps that touch these objects.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions