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

Table: cropinformation

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

Crop Information holds all the information in FADN related to crops (area, production and outputs)http://ontologies.seamless-ip.org/farm.owl#CropInformation

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

arableland

real

 

 

 

 

 

 

 

areabarley

real

 

 

 

 

 

 

 

areacitrusfruitorchards

real

 

 

 

 

 

 

 

areacommonwheatandspelt

real

 

 

 

 

 

 

 

areadrypulses

real

 

 

 

 

 

 

 

areadurumwheat

real

 

 

 

 

 

 

 

areafallowsandsetaside

real

 

 

 

 

 

 

 

areafieldscalefreshvegetables

real

 

 

 

 

 

 

 

areaflax

real

 

 

 

 

 

 

 

areaflowersopen

real

 

 

 

 

 

 

 

areaflowerssheltered

real

 

 

 

 

 

 

 

areafodderrootsandbrassicas

real

 

 

 

 

 

 

 

areafreshvegetablesopen

real

 

 

 

 

 

 

 

areafreshvegetablessheltered

real

 

 

 

 

 

 

 

areafruitandberryorchards

real

 

 

 

 

 

 

 

areagrainmaize

real

 

 

 

 

 

 

 

areagrassseeds

real

 

 

 

 

 

 

 

areagrowthyoungplantations

real

 

 

 

 

 

 

 

areaherbaceousoilseedscrops

real

 

 

 

 

 

 

 

areahops

real

 

 

 

 

 

 

 

arealandreadyforsowingleasedtoothers

real

 

 

 

 

 

 

 

arealentilschickpeaswetches

real

 

 

 

 

 

 

 

areameadowsandpermanentpastures

real

 

 

 

 

 

 

 

areamushrooms

real

 

 

 

 

 

 

 

areanurseries

real

 

 

 

 

 

 

 

areaoats

real

 

 

 

 

 

 

 

areaolivegroves

real

 

 

 

 

 

 

 

areaotherarablecrops

real

 

 

 

 

 

 

 

areaothercereals

real

 

 

 

 

 

 

 

areaothercrops

real

 

 

 

 

 

 

 

areaotherfodderplants

real

 

 

 

 

 

 

 

areaotherindustrialcrops

real

 

 

 

 

 

 

 

areaotherpermanentcrops

real

 

 

 

 

 

 

 

areaotherproteincrops

real

 

 

 

 

 

 

 

areaotherseeds

real

 

 

 

 

 

 

 

areapeasfieldbeans

real

 

 

 

 

 

 

 

areapermanentcrops

real

 

 

 

 

 

 

 

areapermanentcropssheltered

real

 

 

 

 

 

 

 

areapotatoes

real

 

 

 

 

 

 

 

arearapes

real

 

 

 

 

 

 

 

arearice

real

 

 

 

 

 

 

 

arearoughgrassland

real

 

 

 

 

 

 

 

arearye

real

 

 

 

 

 

 

 

areasoya

real

 

 

 

 

 

 

 

areasugarbeet

real

 

 

 

 

 

 

 

areasummercerealsmixes

real

 

 

 

 

 

 

 

areasunflower

real

 

 

 

 

 

 

 

areatemporarygrass

real

 

 

 

 

 

 

 

areatobacco

real

 

 

 

 

 

 

 

areaunderglassorplastic

real

 

 

 

 

 

 

 

areavines

real

 

 

 

 

 

 

 

averagecropprotectioncostperhectare

real

 

 

 

 

 

 

 

averagecropprotectioncostperhectaremax

real

 

 

 

 

 

 

 

averagecropprotectioncostperhectaremin

real

 

 

 

 

 

 

 

averagecropprotectioncostperhectaresd

real

 

 

 

 

 

 

 

averagefertilisercostsperhectare

real

 

 

 

 

 

 

 

averagefertilisercostsperhectaremax

real

 

 

 

 

 

 

 

averagefertilisercostsperhectaremin

real

 

 

 

 

 

 

 

averagefertilisercostsperhectaresd

real

 

 

 

 

 

 

 

averageshareofuaainarable

real

 

 

 

 

 

 

 

averageshareofuaainarablemax

real

 

 

 

 

 

 

 

averageshareofuaainarablemin

real

 

 

 

 

 

 

 

averageshareofuaainarablesd

real

 

 

 

 

 

 

 

averageshareofuaaingrass

real

 

 

 

 

 

 

 

averageshareofuaaingrassmax

real

 

 

 

 

 

 

 

averageshareofuaaingrassmin

real

 

 

 

 

 

 

 

averageshareofuaaingrasssd

real

 

 

 

 

 

 

 

averageshareofuaainpermanentandroughgrass

real

 

 

 

 

 

 

 

averageshareofuaainpermanentandroughgrassmax

real

 

 

 

 

 

 

 

averageshareofuaainpermanentandroughgrassmin

real

 

 

 

 

 

 

 

averageshareofuaainpermanentandroughgrasssd

real

 

 

 

 

 

 

 

averageshareofuaainpermanentcrops

real

 

 

 

 

 

 

 

averageshareofuaainpermanentcropsmax

real

 

 

 

 

 

 

 

averageshareofuaainpermanentcropsmin

real

 

 

 

 

 

 

 

averageshareofuaainpermanentcropssd

real

 

 

 

 

 

 

 

averageyieldmaizeperhectare

real

 

 

 

 

 

 

 

averageyieldmaizeperhectaremax

real

 

 

 

 

 

 

 

averageyieldmaizeperhectaremin

real

 

 

 

 

 

 

 

averageyieldmaizeperhectaresd

real

 

 

 

 

 

 

 

averageyieldwheatperhectare

real

 

 

 

 

 

 

 

averageyieldwheatperhectaremax

real

 

 

 

 

 

 

 

averageyieldwheatperhectaremin

real

 

 

 

 

 

 

 

averageyieldwheatperhectaresd

real

 

 

 

 

 

 

 

cropprotection

real

 

 

 

 

 

 

 

fertilisercosts

real

 

 

 

 

 

 

 

fertlisers

real

 

 

 

 

 

 

 

irrigatedarea

real

 

 

 

 

 

 

 

irrigatedareabarley

real

 

 

 

 

 

 

 

irrigatedareacitrusfruitorchards

real

 

 

 

 

 

 

 

irrigatedareacommonwheatspelt

real

 

 

 

 

 

 

 

irrigatedareadurumwheat

real

 

 

 

 

 

 

 

irrigatedareafieldscalefreshvegetables

real

 

 

 

 

 

 

 

irrigatedareafruitberryorchards

real

 

 

 

 

 

 

 

irrigatedareagrainmaize

real

 

 

 

 

 

 

 

irrigatedareaherbaciousoilseeds

real

 

 

 

 

 

 

 

irrigatedareahops

real

 

 

 

 

 

 

 

irrigatedareaotherfodderplants

real

 

 

 

 

 

 

 

irrigatedareaotherindustrialcrops

real

 

 

 

 

 

 

 

irrigatedareapotatoes

real

 

 

 

 

 

 

 

irrigatedarearice

real

 

 

 

 

 

 

 

irrigatedareasugarbeet

real

 

 

 

 

 

 

 

irrigatedareatobacco

real

 

 

 

 

 

 

 

othercropspecificinputs

real

 

 

 

 

 

 

 

othercropsubsidies

real

 

 

 

 

 

 

 

outputarablecrops

real

 

 

 

 

 

 

 

outputbarley

real

 

 

 

 

 

 

 

outputcitrusfruitorchards

real

 

 

 

 

 

 

 

outputcommonwheatspelt

real

 

 

 

 

 

 

 

outputcropsandcropproducts

real

 

 

 

 

 

 

 

outputcropscereals

real

 

 

 

 

 

 

 

outputcropsforage

real

 

 

 

 

 

 

 

outputcropsindusrtrialcrops

real

 

 

 

 

 

 

 

outputcropsothercropproducts

real

 

 

 

 

 

 

 

outputcropsvegetablesflowers

real

 

 

 

 

 

 

 

outputdrypulses

real

 

 

 

 

 

 

 

outputdurumwheat

real

 

 

 

 

 

 

 

outputfallowssetaside

real

 

 

 

 

 

 

 

outputfieldscalevegetables

real

 

 

 

 

 

 

 

outputflax

real

 

 

 

 

 

 

 

outputflowersopen

real

 

 

 

 

 

 

 

outputflowerssheltered

real

 

 

 

 

 

 

 

outputfodderrootsbrassicas

real

 

 

 

 

 

 

 

outputfreshvegetablesopen

real

 

 

 

 

 

 

 

outputfreshvegetablessheltered

real

 

 

 

 

 

 

 

outputfruitberryorchards

real

 

 

 

 

 

 

 

outputgrainmaize

real

 

 

 

 

 

 

 

outputgrassseeds

real

 

 

 

 

 

 

 

outputherbaceousoilseeds

real

 

 

 

 

 

 

 

outputhops

real

 

 

 

 

 

 

 

outputlandreadysowing

real

 

 

 

 

 

 

 

outputlentilschickpeaswetches

real

 

 

 

 

 

 

 

outputmeadowspermanentpasture

real

 

 

 

 

 

 

 

outputmushrooms

real

 

 

 

 

 

 

 

outputnurseries

real

 

 

 

 

 

 

 

outputoats

real

 

 

 

 

 

 

 

outputolivegroves

real

 

 

 

 

 

 

 

outputother

real

 

 

 

 

 

 

 

outputotherarablecrops

real

 

 

 

 

 

 

 

outputothercereals

real

 

 

 

 

 

 

 

outputotherfodderplants

real

 

 

 

 

 

 

 

outputotherindustrialcrops

real

 

 

 

 

 

 

 

outputotherpermanentcrops

real

 

 

 

 

 

 

 

outputotherproteincrops

real

 

 

 

 

 

 

 

outputotherseeds

real

 

 

 

 

 

 

 

outputpeasandfieldbeans

real

 

 

 

 

 

 

 

outputpermanentcropssheltered

real

 

 

 

 

 

 

 

outputpotatoes

real

 

 

 

 

 

 

 

outputrapes

real

 

 

 

 

 

 

 

outputrice

real

 

 

 

 

 

 

 

outputroughgrassland

real

 

 

 

 

 

 

 

outputrye

real

 

 

 

 

 

 

 

outputsoya

real

 

 

 

 

 

 

 

outputsugarbeet

real

 

 

 

 

 

 

 

outputsummercerealsandmixes

real

 

 

 

 

 

 

 

outputsunflower

real

 

 

 

 

 

 

 

outputtemporarygrassland

real

 

 

 

 

 

 

 

outputtobacco

real

 

 

 

 

 

 

 

outputvinesandgrapes

real

 

 

 

 

 

 

 

outputyoungplantations

real

 

 

 

 

 

 

 

productionbarley

real

 

 

 

 

 

 

 

productioncitrusfruitorchards

real

 

 

 

 

 

 

 

productioncommonwheatandspelt

real

 

 

 

 

 

 

 

productiondrypulses

real

 

 

 

 

 

 

 

productiondurumwheat

real

 

 

 

 

 

 

 

productionfallowssetaside

real

 

 

 

 

 

 

 

productionfieldscalevegetables

real

 

 

 

 

 

 

 

productionflax

real

 

 

 

 

 

 

 

productionflowersopen

real

 

 

 

 

 

 

 

productionflowerssheltered

real

 

 

 

 

 

 

 

productionfodderrootsbrassicas

real

 

 

 

 

 

 

 

productionfreshvegetablesopen

real

 

 

 

 

 

 

 

productionfreshvegetablessheltered

real

 

 

 

 

 

 

 

productionfruitberryorchards

real

 

 

 

 

 

 

 

productiongrainmaize

real

 

 

 

 

 

 

 

productiongrassseeds

real

 

 

 

 

 

 

 

productionherbaceousoilseeds

real

 

 

 

 

 

 

 

productionhops

real

 

 

 

 

 

 

 

productionlandreadysowing

real

 

 

 

 

 

 

 

productionlentilschickpeaswetches

real

 

 

 

 

 

 

 

productionmeadowspermanentpasture

real

 

 

 

 

 

 

 

productionmushrooms

real

 

 

 

 

 

 

 

productionnurseries

real

 

 

 

 

 

 

 

productionoats

real

 

 

 

 

 

 

 

productionolivegroves

real

 

 

 

 

 

 

 

productionother

real

 

 

 

 

 

 

 

productionotherarablecrops

real

 

 

 

 

 

 

 

productionothercereals

real

 

 

 

 

 

 

 

productionotherfodderplants

real

 

 

 

 

 

 

 

productionotherindustrialcrops

real

 

 

 

 

 

 

 

productionotherpermanentcrops

real

 

 

 

 

 

 

 

productionotherproteincrops

real

 

 

 

 

 

 

 

productionotherseeds

real

 

 

 

 

 

 

 

productionpeasandfieldbeans

real

 

 

 

 

 

 

 

productionpermanentcropssheltered

real

 

 

 

 

 

 

 

productionpotatoes

real

 

 

 

 

 

 

 

productionrapes

real

 

 

 

 

 

 

 

productionrice

real

 

 

 

 

 

 

 

productionroughgrazing

real

 

 

 

 

 

 

 

productionrye

real

 

 

 

 

 

 

 

productionsoya

real

 

 

 

 

 

 

 

productionsugarbeet

real

 

 

 

 

 

 

 

productionsummercerealsandmixes

real

 

 

 

 

 

 

 

productionsunflower

real

 

 

 

 

 

 

 

productiontemporarygrassland

real

 

 

 

 

 

 

 

productiontobacco

real

 

 

 

 

 

 

 

productionvines

real

 

 

 

 

 

 

 

productionyoungplantations

real

 

 

 

 

 

 

 

seedsandplants

real

 

 

 

 

 

 

 

seedsandseedlingspurchased

real

 

 

 

 

 

 

 

seedshomegrown

real

 

 

 

 

 

 

 

setasidepremiums

real

 

 

 

 

 

 

 

subsidiescrops

real

 

 

 

 

 

 

 

utilisedagriculturalareacereals

real

 

 

 

 

 

 

 

utilisedagriculturalareafallows

real

 

 

 

 

 

 

 

utilisedagriculturalareaforagecrops

real

 

 

 

 

 

 

 

utilisedagriculturalareaothercrops

real

 

 

 

 

 

 

 

utilisedagriculturalareapermanentcrops

real

 

 

 

 

 

 

 

utilisedagriculturalareasetaside

real

 

 

 

 

 

 

 

utilisedagriculturalareavegetablesflowers

real

 

 

 

 

 

 

 

utilisedagriculturalareavineyards

real

 

 

 

 

 

 

 

woodlandarea

real

 

 

 

 

 

 

 

yieldmaize

real

 

 

 

 

 

 

 

yieldwheat

real

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table cropinformation

 

Checks

There are no check constraints for table cropinformation

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

cropinformation_id_key

btree

 

id

 

 

cropinformation_pkey

btree

 

id

 

 

Triggers

There are no triggers for table cropinformation

 

Rules

There are no rules for table cropinformation

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

representativefarm

public

fk34b54b93f9858038

cropinformation

public.cropinformation

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

90303

Pages

10034

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."cropinformation" (
 "id" BIGINT NOT NULL,
 "arableland" REAL,
 "areabarley" REAL,
 "areacitrusfruitorchards" REAL,
 "areacommonwheatandspelt" REAL,
 "areadrypulses" REAL,
 "areadurumwheat" REAL,
 "areafallowsandsetaside" REAL,
 "areafieldscalefreshvegetables" REAL,
 "areaflax" REAL,
 "areaflowersopen" REAL,
 "areaflowerssheltered" REAL,
 "areafodderrootsandbrassicas" REAL,
 "areafreshvegetablesopen" REAL,
 "areafreshvegetablessheltered" REAL,
 "areafruitandberryorchards" REAL,
 "areagrainmaize" REAL,
 "areagrassseeds" REAL,
 "areagrowthyoungplantations" REAL,
 "areaherbaceousoilseedscrops" REAL,
 "areahops" REAL,
 "arealandreadyforsowingleasedtoothers" REAL,
 "arealentilschickpeaswetches" REAL,
 "areameadowsandpermanentpastures" REAL,
 "areamushrooms" REAL,
 "areanurseries" REAL,
 "areaoats" REAL,
 "areaolivegroves" REAL,
 "areaotherarablecrops" REAL,
 "areaothercereals" REAL,
 "areaothercrops" REAL,
 "areaotherfodderplants" REAL,
 "areaotherindustrialcrops" REAL,
 "areaotherpermanentcrops" REAL,
 "areaotherproteincrops" REAL,
 "areaotherseeds" REAL,
 "areapeasfieldbeans" REAL,
 "areapermanentcrops" REAL,
 "areapermanentcropssheltered" REAL,
 "areapotatoes" REAL,
 "arearapes" REAL,
 "arearice" REAL,
 "arearoughgrassland" REAL,
 "arearye" REAL,
 "areasoya" REAL,
 "areasugarbeet" REAL,
 "areasummercerealsmixes" REAL,
 "areasunflower" REAL,
 "areatemporarygrass" REAL,
 "areatobacco" REAL,
 "areaunderglassorplastic" REAL,
 "areavines" REAL,
 "averagecropprotectioncostperhectare" REAL,
 "averagecropprotectioncostperhectaremax" REAL,
 "averagecropprotectioncostperhectaremin" REAL,
 "averagecropprotectioncostperhectaresd" REAL,
 "averagefertilisercostsperhectare" REAL,
 "averagefertilisercostsperhectaremax" REAL,
 "averagefertilisercostsperhectaremin" REAL,
 "averagefertilisercostsperhectaresd" REAL,
 "averageshareofuaainarable" REAL,
 "averageshareofuaainarablemax" REAL,
 "averageshareofuaainarablemin" REAL,
 "averageshareofuaainarablesd" REAL,
 "averageshareofuaaingrass" REAL,
 "averageshareofuaaingrassmax" REAL,
 "averageshareofuaaingrassmin" REAL,
 "averageshareofuaaingrasssd" REAL,
 "averageshareofuaainpermanentandroughgrass" REAL,
 "averageshareofuaainpermanentandroughgrassmax" REAL,
 "averageshareofuaainpermanentandroughgrassmin" REAL,
 "averageshareofuaainpermanentandroughgrasssd" REAL,
 "averageshareofuaainpermanentcrops" REAL,
 "averageshareofuaainpermanentcropsmax" REAL,
 "averageshareofuaainpermanentcropsmin" REAL,
 "averageshareofuaainpermanentcropssd" REAL,
 "averageyieldmaizeperhectare" REAL,
 "averageyieldmaizeperhectaremax" REAL,
 "averageyieldmaizeperhectaremin" REAL,
 "averageyieldmaizeperhectaresd" REAL,
 "averageyieldwheatperhectare" REAL,
 "averageyieldwheatperhectaremax" REAL,
 "averageyieldwheatperhectaremin" REAL,
 "averageyieldwheatperhectaresd" REAL,
 "cropprotection" REAL,
 "fertilisercosts" REAL,
 "fertlisers" REAL,
 "irrigatedarea" REAL,
 "irrigatedareabarley" REAL,
 "irrigatedareacitrusfruitorchards" REAL,
 "irrigatedareacommonwheatspelt" REAL,
 "irrigatedareadurumwheat" REAL,
 "irrigatedareafieldscalefreshvegetables" REAL,
 "irrigatedareafruitberryorchards" REAL,
 "irrigatedareagrainmaize" REAL,
 "irrigatedareaherbaciousoilseeds" REAL,
 "irrigatedareahops" REAL,
 "irrigatedareaotherfodderplants" REAL,
 "irrigatedareaotherindustrialcrops" REAL,
 "irrigatedareapotatoes" REAL,
 "irrigatedarearice" REAL,
 "irrigatedareasugarbeet" REAL,
 "irrigatedareatobacco" REAL,
 "othercropspecificinputs" REAL,
 "othercropsubsidies" REAL,
 "outputarablecrops" REAL,
 "outputbarley" REAL,
 "outputcitrusfruitorchards" REAL,
 "outputcommonwheatspelt" REAL,
 "outputcropsandcropproducts" REAL,
 "outputcropscereals" REAL,
 "outputcropsforage" REAL,
 "outputcropsindusrtrialcrops" REAL,
 "outputcropsothercropproducts" REAL,
 "outputcropsvegetablesflowers" REAL,
 "outputdrypulses" REAL,
 "outputdurumwheat" REAL,
 "outputfallowssetaside" REAL,
 "outputfieldscalevegetables" REAL,
 "outputflax" REAL,
 "outputflowersopen" REAL,
 "outputflowerssheltered" REAL,
 "outputfodderrootsbrassicas" REAL,
 "outputfreshvegetablesopen" REAL,
 "outputfreshvegetablessheltered" REAL,
 "outputfruitberryorchards" REAL,
 "outputgrainmaize" REAL,
 "outputgrassseeds" REAL,
 "outputherbaceousoilseeds" REAL,
 "outputhops" REAL,
 "outputlandreadysowing" REAL,
 "outputlentilschickpeaswetches" REAL,
 "outputmeadowspermanentpasture" REAL,
 "outputmushrooms" REAL,
 "outputnurseries" REAL,
 "outputoats" REAL,
 "outputolivegroves" REAL,
 "outputother" REAL,
 "outputotherarablecrops" REAL,
 "outputothercereals" REAL,
 "outputotherfodderplants" REAL,
 "outputotherindustrialcrops" REAL,
 "outputotherpermanentcrops" REAL,
 "outputotherproteincrops" REAL,
 "outputotherseeds" REAL,
 "outputpeasandfieldbeans" REAL,
 "outputpermanentcropssheltered" REAL,
 "outputpotatoes" REAL,
 "outputrapes" REAL,
 "outputrice" REAL,
 "outputroughgrassland" REAL,
 "outputrye" REAL,
 "outputsoya" REAL,
 "outputsugarbeet" REAL,
 "outputsummercerealsandmixes" REAL,
 "outputsunflower" REAL,
 "outputtemporarygrassland" REAL,
 "outputtobacco" REAL,
 "outputvinesandgrapes" REAL,
 "outputyoungplantations" REAL,
 "productionbarley" REAL,
 "productioncitrusfruitorchards" REAL,
 "productioncommonwheatandspelt" REAL,
 "productiondrypulses" REAL,
 "productiondurumwheat" REAL,
 "productionfallowssetaside" REAL,
 "productionfieldscalevegetables" REAL,
 "productionflax" REAL,
 "productionflowersopen" REAL,
 "productionflowerssheltered" REAL,
 "productionfodderrootsbrassicas" REAL,
 "productionfreshvegetablesopen" REAL,
 "productionfreshvegetablessheltered" REAL,
 "productionfruitberryorchards" REAL,
 "productiongrainmaize" REAL,
 "productiongrassseeds" REAL,
 "productionherbaceousoilseeds" REAL,
 "productionhops" REAL,
 "productionlandreadysowing" REAL,
 "productionlentilschickpeaswetches" REAL,
 "productionmeadowspermanentpasture" REAL,
 "productionmushrooms" REAL,
 "productionnurseries" REAL,
 "productionoats" REAL,
 "productionolivegroves" REAL,
 "productionother" REAL,
 "productionotherarablecrops" REAL,
 "productionothercereals" REAL,
 "productionotherfodderplants" REAL,
 "productionotherindustrialcrops" REAL,
 "productionotherpermanentcrops" REAL,
 "productionotherproteincrops" REAL,
 "productionotherseeds" REAL,
 "productionpeasandfieldbeans" REAL,
 "productionpermanentcropssheltered" REAL,
 "productionpotatoes" REAL,
 "productionrapes" REAL,
 "productionrice" REAL,
 "productionroughgrazing" REAL,
 "productionrye" REAL,
 "productionsoya" REAL,
 "productionsugarbeet" REAL,
 "productionsummercerealsandmixes" REAL,
 "productionsunflower" REAL,
 "productiontemporarygrassland" REAL,
 "productiontobacco" REAL,
 "productionvines" REAL,
 "productionyoungplantations" REAL,
 "seedsandplants" REAL,
 "seedsandseedlingspurchased" REAL,
 "seedshomegrown" REAL,
 "setasidepremiums" REAL,
 "subsidiescrops" REAL,
 "utilisedagriculturalareacereals" REAL,
 "utilisedagriculturalareafallows" REAL,
 "utilisedagriculturalareaforagecrops" REAL,
 "utilisedagriculturalareaothercrops" REAL,
 "utilisedagriculturalareapermanentcrops" REAL,
 "utilisedagriculturalareasetaside" REAL,
 "utilisedagriculturalareavegetablesflowers" REAL,
 "utilisedagriculturalareavineyards" REAL,
 "woodlandarea" REAL,
 "yieldmaize" REAL,
 "yieldwheat" REAL,
 CONSTRAINT "cropinformation_id_key" UNIQUE("id"),
 CONSTRAINT "cropinformation_pkey" PRIMARY KEY("id")
) WITH OIDS;

COMMENT ON TABLE "public"."cropinformation"
IS 'Crop Information holds all the information in FADN related to crops (area, production and outputs)http://ontologies.seamless-ip.org/farm.owl#CropInformation';

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