SoilWise Geopackage

Is Based On Soil Body

Definition

The isbasedonsoilbody table defines a many-to-many relationship between soil-derived objects and soil bodies, linking the soilderivedobject and soilbody tables. This relationship allows soil-derived objects to be based on one or more soil bodies and, conversely, enables a single soil body to contribute to multiple derived objects.

 

TABELLA SOILSITE EXP


 

Table: isbasedonsoilbody

Columns

Name Type Constraints Description
id INTEGER PRIMARY KEY Primary Key of the Table.
guid_soilderivedobject TEXT NOT NULL Foreign key to the SoilDerivedObject table, guid field.
guid_soilbody TEXT NOT NULL Foreign key to the SoilBody table, guid field.

Relationships (as child)

  • isbasedonsoilbody.guid_soilbody → soilbody.guid (ON UPDATE CASCADE, ON DELETE CASCADE)
    • Note: delete on soilbody cascades to isbasedonsoilbody.
  • isbasedonsoilbody.guid_soilderivedobject → soilderivedobject.guid (ON UPDATE CASCADE, ON DELETE CASCADE)
    • Note: delete on soilderivedobject cascades to isbasedonsoilbody.

Referenced by (as parent)

  • None

Indexes

  • None

Triggers

  • None