seamdb_final 15th of April 2009
Previous topic Chapter index Next topic

Table: optimalfarmbehaviour

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

this is the optimal farm behaviour as calculated by the FSSIM model for one FSSIM farm. The optimal farm behaviour consists of choosing a number of Production Coefficients that are considered optimal according to the objective function and the constraints active on this farm.http://ontologies.seamless-ip.org/farmopt.owl#OptimalFarmBehaviour

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

amountofsubsidy

real

 

 

 

 

 

 

 

annuity

real

 

 

 

 

 

 

 

annuityshare

real

 

 

 

 

 

 

 

erosion

real

 

 

 

 

 

 

 

farmerincome

real

 

 

 

 

 

 

 

farmerincomeperhectare

real

 

 

 

 

 

 

 

grossproduction

real

 

 

 

 

 

 

 

grossproductionshare

real

 

 

 

 

 

 

 

fssimfarm

bigint

 

 

 

 

 

 

 

irrigationwaterrequirement

real

 

 

 

 

 

 

 

labour

real

 

 

 

 

 

 

 

nitrateleaching

real

 

 

 

 

 

 

 

nitrogenuse

real

 

 

 

 

 

 

 

nitrogenuseorganic

real

 

 

 

 

 

 

 

nitrogenvolatilization

real

 

 

 

 

 

 

 

pesticidepressure

real

 

 

 

 

 

 

 

soilorganicmatter

real

 

 

 

 

 

 

 

subsidiesshare

real

 

 

 

 

 

 

 

totalcosts

real

 

 

 

 

 

 

 

totalcostsshare

real

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table optimalfarmbehaviour

 

Checks

There are no check constraints for table optimalfarmbehaviour

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

optimalfarmbehaviour_id_key

btree

 

id

 

 

optimalfarmbehaviour_pkey

btree

 

id

 

 

Triggers

There are no triggers for table optimalfarmbehaviour

 

Rules

There are no rules for table optimalfarmbehaviour

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

optimalfarmbehaviourcalibrationterms

public

fk147562c2461d3b03

optimalfarmbehaviour_id

public.optimalfarmbehaviour

id

No Action

No Action

 

Immediate

 

optimalfarmbehaviouroptimalcroppingpattern

public

fka0d9891461d3b03

optimalfarmbehaviour_id

public.optimalfarmbehaviour

id

No Action

No Action

 

Immediate

 

optimalfarmbehaviouroptimallivestockactivity

public

fk6d46697c461d3b03

optimalfarmbehaviour_id

public.optimalfarmbehaviour

id

No Action

No Action

 

Immediate

 

optimalfarmbehavioursupplyresponses

public

fk51b9d27e461d3b03

optimalfarmbehaviour_id

public.optimalfarmbehaviour

id

No Action

No Action

 

Immediate

 

policyassessmentfssimfarmindicators

public

fk994d7650461d3b03

optimalfarmbehaviour_id

public.optimalfarmbehaviour

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

1096

Pages

13

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."optimalfarmbehaviour" (
 "id" BIGINT NOT NULL,
 "amountofsubsidy" REAL,
 "annuity" REAL,
 "annuityshare" REAL,
 "erosion" REAL,
 "farmerincome" REAL,
 "farmerincomeperhectare" REAL,
 "grossproduction" REAL,
 "grossproductionshare" REAL,
 "fssimfarm" BIGINT,
 "irrigationwaterrequirement" REAL,
 "labour" REAL,
 "nitrateleaching" REAL,
 "nitrogenuse" REAL,
 "nitrogenuseorganic" REAL,
 "nitrogenvolatilization" REAL,
 "pesticidepressure" REAL,
 "soilorganicmatter" REAL,
 "subsidiesshare" REAL,
 "totalcosts" REAL,
 "totalcostsshare" REAL,
 CONSTRAINT "optimalfarmbehaviour_id_key" UNIQUE("id"),
 CONSTRAINT "optimalfarmbehaviour_pkey" PRIMARY KEY("id")
) WITH OIDS;

COMMENT ON TABLE "public"."optimalfarmbehaviour"
IS 'this is the optimal farm behaviour as calculated by the FSSIM model for one FSSIM farm. The optimal farm behaviour consists of choosing a number of Production Coefficients that are considered optimal according to the objective function and the constraints active on this farm.http://ontologies.seamless-ip.org/farmopt.owl#OptimalFarmBehaviour';

This file was generated by Erling Andersen eran@life.ku.dk
Previous topic Chapter index Next topic