SoilWise Geopackage

Observed Procedure - Sensor

Definition

The obsprocedure_sensor table defines a many-to-many relationship between observing procedures and sensors, linking the observingprocedure and sensor tables. This relationship allows a single observing procedure to be associated with one or more sensors and, conversely, enables the same sensor to participate in multiple observing procedures.

 

TABELLA SOILSITE EXP


 

Table: obsprocedure_sensor

Columns

Name Type Constraints Description
id INTEGER PRIMARY KEY A unique, read-only attribute that serves as an identifier for the entity.
guid_observingprocedure TEXT NOT NULL Foreign key to the Procedure table, guid field.
guid_sensor TEXT NOT NULL Foreign key to the Sensor table, guid field.

Relationships (as child)

  • obsprocedure_sensor.guid_sensor → sensor.guid (ON UPDATE CASCADE, ON DELETE RESTRICT)
  • obsprocedure_sensor.guid_observingprocedure → observingprocedure.guid (ON UPDATE CASCADE, ON DELETE CASCADE)
    • Note: delete on observingprocedure cascades to obsprocedure_sensor.

Referenced by (as parent)

  • None

Indexes

  • None

Triggers

  • None