Skip to content

Table: agriculture_product

Description (EN): This table represents agriculture products. In the database's inheritance architecture, it acts as a direct sub-type of the component table. It does not store redundant descriptive columns; instead, it uses a shared primary key to inherit all high-level attributes (such as name, location, management type, and geometry) from its parent component record.

Column Structure

Column Data type Definition Example value Constraint? Geometry? Comments
id BIGINT Unique identifier for the agriculture product 42 PK, FK No Primary key that also acts as a Foreign Key referencing component.id
average_invested BIGINT [...] [...] - No [...]
expected_yield BIGINT [...] [...] - No [...]
gate_price BIGINT [...] [...] - No [...]
year_production BIGINT [...] [...] - No [...]
subtype VARCHAR [...] [...] - No [...]

Relationships

  • Inherits from (Sub-type of): component. The agriculture_product table is a specialized extension of the component table.
  • Has Sub-types (Inheritance): The following tables inherit from agriculture_product and share its id:
  • Belongs to: enterprise (A component sub-type is linked to one enterprise)
  • Has many: damage (A component sub-type can be affected by multiple damage over time)

!!! tip "Where is the rest of the data?" To find the name, geographical location (geometry, town, country), or ownership details of an agriculture product, you must join this table with the component record that shares the exact same id.

Example Query

Retrieve a list of all agriculture product, including their names, towns, and spatial coordinates, by joining the table with its parent enterprise entity:

SELECT 
    ap.id, 
    c.name, 
    c.town, 
    ST_AsText(c.geometry) as coordinates 
FROM 
    agriculture_product ap
JOIN 
    component c ON ap.id = c.id
WHERE 
    c.component_kind  = 'AGRICULTURE_PRODUCT';