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

Indices

 

Index

Table

Schema

Tablespace

Type

Function

Fields

Primary Key

Unique

Description

activitygroup_pkey

activitygroup

public

(default)

btree

 

id

 

activitygrouppremiumgrouppremiumgroups_pkey

activitygrouppremiumgrouppremiumgroups

public

(default)

btree

 

activitygroup_id, premiumgroup_id

 

agriculturalactivityperfarm_pkey

agriculturalactivityperfarm

public

(default)

btree

 

id

 

agriculturalactivityperfarmagriculturalactivities_pkey

agriculturalactivityperfarmagriculturalactivities

public

(default)

btree

 

agriculturalactivityperfarm_id, agriculturalactivity_id

 

agrienvironmentalzone_id_key

agrienvironmentalzone

public

(default)

btree

 

id

 

 

agrienvironmentalzone_pkey

agrienvironmentalzone

public

(default)

btree

 

id

 

agromanagementconfiguration_id_key

agromanagementconfiguration

public

(default)

btree

 

id

 

 

agromanagementconfiguration_pkey

agromanagementconfiguration

public

(default)

btree

 

id

 

agromanagementconfigurationcropmanagementrules_pkey

agromanagementconfigurationcropmanagementrules

public

(default)

btree

 

agromanagementconfiguration_id, cropmanagementrule_id

 

airtemperaturethreshold_id_key

airtemperaturethreshold

public

(default)

btree

 

id

 

 

airtemperaturethreshold_pkey

airtemperaturethreshold

public

(default)

btree

 

id

 

alternativearableactivity_id_key

alternativearableactivity

public

(default)

btree

 

id

 

 

alternativearableactivity_pkey

alternativearableactivity

public

(default)

btree

 

id

 

alternativearableactivitycropyearmanagements_pkey

alternativearableactivitycropyearmanagements

public

(default)

btree

 

alternativearableactivity_id, cropyearmanagement_id

 

alternativebeefoption_id_key

alternativebeefoption

public

(default)

btree

 

id

 

 

alternativebeefoption_pkey

alternativebeefoption

public

(default)

btree

 

id

 

alternativedairyoption_id_key

alternativedairyoption

public

(default)

btree

 

id

 

 

alternativedairyoption_pkey

alternativedairyoption

public

(default)

btree

 

id

 

animalactivity_id_key

animalactivity

public

(default)

btree

 

id

 

 

animalactivity_pkey

animalactivity

public

(default)

btree

 

id

 

animalactivityanimalproduction_pkey

animalactivityanimalproduction

public

(default)

btree

 

animalactivity_id, animalproduction_id

 

animalactivityanimalshares_pkey

animalactivityanimalshares

public

(default)

btree

 

animalactivity_id, animalshares_id

 

animalproduct_id_key

animalproduct

public

(default)

btree

 

id

 

 

animalproduct_pkey

animalproduct

public

(default)

btree

 

id

 

animalproduction_id_key

animalproduction

public

(default)

btree

 

id

 

 

animalproduction_pkey

animalproduction

public

(default)

btree

 

id

 

animalshares_id_key

animalshares

public

(default)

btree

 

id

 

 

animalshares_pkey

animalshares

public

(default)

btree

 

id

 

applicationrole_id_key

applicationrole

public

(default)

btree

 

id

 

 

applicationrole_pkey

applicationrole

public

(default)

btree

 

id

 

arableactivity_id_key

arableactivity

public

(default)

btree

 

id

 

 

arableactivity_pkey

arableactivity

public

(default)

btree

 

id

 

arableactivitycropyearmanagements_pkey

arableactivitycropyearmanagements

public

(default)

btree

 

arableactivity_id, cropyearmanagement_id

 

basicpremium_id_key

basicpremium

public

(default)

btree

 

id

 

 

basicpremium_pkey

basicpremium

public

(default)

btree

 

id

 

beefcalve_id_key

beefcalve

public

(default)

btree

 

id

 

 

beefcalve_pkey

beefcalve

public

(default)

btree

 

id

 

beefcattle_id_key

beefcattle

public

(default)

btree

 

id

 

 

beefcattle_pkey

beefcattle

public

(default)

btree

 

id

 

beefmanagement_id_key

beefmanagement

public

(default)

btree

 

id

 

 

beefmanagement_pkey

beefmanagement

public

(default)

btree

 

id

 

beefmanagementalternativebeefoptions_pkey

beefmanagementalternativebeefoptions

public

(default)

btree

 

beefmanagement_id, alternativebeefoption_id

 

bilateraltariff_id_key

bilateraltariff

public

(default)

btree

 

id

 

 

bilateraltariff_pkey

bilateraltariff

public

(default)

btree

 

id

 

biofueldemand_id_key

biofueldemand

public

(default)

btree

 

id

 

 

biofueldemand_pkey

biofueldemand

public

(default)

btree

 

id

 

biomassthreshold_id_key

biomassthreshold

public

(default)

btree

 

id

 

 

biomassthreshold_pkey

biomassthreshold

public

(default)

btree

 

id

 

biophysicalsimulation_id_key

biophysicalsimulation

public

(default)

btree

 

id

 

 

biophysicalsimulation_pkey

biophysicalsimulation

public

(default)

btree

 

id

 

biophysicalsimulationcalculatedproductioncoefficients_pkey

biophysicalsimulationcalculatedproductioncoefficients

public

(default)

btree

 

biophysicalsimulation_id, productionactivityperfssimfarm_id

 

bull_id_key

bull

public

(default)

btree

 

id

 

 

bull_pkey

bull

public

(default)

btree

 

id

 

calibrationterm_id_key

calibrationterm

public

(default)

btree

 

id

 

 

calibrationterm_pkey

calibrationterm

public

(default)

btree

 

id

 

capriparameter_id_key

capriparameter

public

(default)

btree

 

id

 

 

capriparameter_pkey

capriparameter

public

(default)

btree

 

id

 

climatezone_id_key

climatezone

public

(default)

btree

 

id

 

 

climatezone_pkey

climatezone

public

(default)

btree

 

id

 

climatezonedailyclimate_pkey

climatezonedailyclimate

public

(default)

btree

 

climatezone_id, dailyclimate_id

 

clippingharvestimplement_id_key

clippingharvestimplement

public

(default)

btree

 

id

 

 

clippingharvestimplement_pkey

clippingharvestimplement

public

(default)

btree

 

id

 

clippingoperation_id_key

clippingoperation

public

(default)

btree

 

id

 

 

clippingoperation_pkey

clippingoperation

public

(default)

btree

 

id

 

concentratedfeeds_id_key

concentratedfeeds

public

(default)

btree

 

id

 

 

concentratedfeeds_pkey

concentratedfeeds

public

(default)

btree

 

id

 

conservationmanagement_id_key

conservationmanagement

public

(default)

btree

 

id

 

 

conservationmanagement_pkey

conservationmanagement

public

(default)

btree

 

id

 

conservationmanagementconservationoptions_pkey

conservationmanagementconservationoptions

public

(default)

btree

 

conservationmanagement_id, conservationoptions_id

 

conservationoptionscrops_pkey

conservationoptionscrops

public

(default)

btree

 

conservationoptions_id, crop_id

 

constraints__id_key

constraints_

public

(default)

btree

 

id

 

 

constraints__pkey

constraints_

public

(default)

btree

 

id

 

context_id_key

context

public

(default)

btree

 

id

 

 

context_pkey

context

public

(default)

btree

 

id

 

contextproductionorientation_pkey

contextproductionorientation

public

(default)

btree

 

context_id, productionorientation_id

 

contextproducts_pkey

contextproducts

public

(default)

btree

 

context_id, productsforregion_id

 

contextregion_pkey

contextregion

public

(default)

btree

 

context_id, nutsregion_id

 

contextregionalwages_pkey

contextregionalwages

public

(default)

btree

 

context_id, regionalwage_id

 

contextrepresentativefarm_pkey

contextrepresentativefarm

public

(default)

btree

 

context_id, representativefarm_id

 

costandlabourperregionalzone_id_key

costandlabourperregionalzone

public

(default)

btree

 

id

 

 

costandlabourperregionalzone_pkey

costandlabourperregionalzone

public

(default)

btree

 

id

 

country_id_key

country

public

(default)

btree

 

id

 

 

country_pkey

country

public

(default)

btree

 

id

 

countryaggregate_id_key

countryaggregate

public

(default)

btree

 

id

 

 

countryaggregate_pkey

countryaggregate

public

(default)

btree

 

id

 

countryaggregatesetofcountries_pkey

countryaggregatesetofcountries

public

(default)

btree

 

countryaggregate_id, country_id

 

couplingdegree_id_key

couplingdegree

public

(default)

btree

 

id

 

 

couplingdegree_pkey

couplingdegree

public

(default)

btree

 

id

 

crop_id_key

crop

public

(default)

btree

 

id

 

 

crop_pkey

crop

public

(default)

btree

 

id

 

croparea_id_key

croparea

public

(default)

btree

 

id

 

 

croparea_pkey

croparea

public

(default)

btree

 

id

 

cropclimaterequirements_id_key

cropclimaterequirements

public

(default)

btree

 

id

 

 

cropclimaterequirements_pkey

cropclimaterequirements

public

(default)

btree

 

id

 

cropgroupcropsetofcrops_pkey

cropgroupcropsetofcrops

public

(default)

btree

 

cropgroup_id, crop_id

 

cropgrouprotationrequirements_id_key

cropgrouprotationrequirements

public

(default)

btree

 

id

 

 

cropgrouprotationrequirements_pkey

cropgrouprotationrequirements

public

(default)

btree

 

id

 

cropinformation_id_key

cropinformation

public

(default)

btree

 

id

 

 

cropinformation_pkey

cropinformation

public

(default)

btree

 

id

 

cropmanagementrule_id_key

cropmanagementrule

public

(default)

btree

 

id

 

 

cropmanagementrule_pkey

cropmanagementrule

public

(default)

btree

 

id

 

cropmanagementruledefaultimplements_pkey

cropmanagementruledefaultimplements

public

(default)

btree

 

cropmanagementrule_id, defaultimplements_id

 

cropmanagementrulefertilisersplits_pkey

cropmanagementrulefertilisersplits

public

(default)

btree

 

cropmanagementrule_id, fertilisersplit_id

 

cropmanagementruleirrigationwindows_pkey

cropmanagementruleirrigationwindows

public

(default)

btree

 

cropmanagementrule_id, irrigationwindow_id

 

cropnitrogenrecoveries_pkey

cropnitrogenrecoveries

public

(default)

btree

 

crop_id, cropnitrogenrecovery_id

 

cropnitrogenrecovery_id_key

cropnitrogenrecovery

public

(default)

btree

 

id

 

 

cropnitrogenrecovery_pkey

cropnitrogenrecovery

public

(default)

btree

 

id

 

cropperyear_id_key

cropperyear

public

(default)

btree

 

id

 

 

cropperyear_pkey

cropperyear

public

(default)

btree

 

id

 

cropphenologicalstage_id_key

cropphenologicalstage

public

(default)

btree

 

id

 

 

cropphenologicalstage_pkey

cropphenologicalstage

public

(default)

btree

 

id

 

cropphenologicalstagetemperaturethreshold_id_key

cropphenologicalstagetemperaturethreshold

public

(default)

btree

 

id

 

 

cropphenologicalstagetemperaturethreshold_pkey

cropphenologicalstagetemperaturethreshold

public

(default)

btree

 

id

 

cropphenologicalstagethreshold_id_key

cropphenologicalstagethreshold

public

(default)

btree

 

id

 

 

cropphenologicalstagethreshold_pkey

cropphenologicalstagethreshold

public

(default)

btree

 

id

 

cropproduct_id_key

cropproduct

public

(default)

btree

 

id

 

 

cropproduct_pkey

cropproduct

public

(default)

btree

 

id

 

cropproductinyear_id_key

cropproductinyear

public

(default)

btree

 

id

 

 

cropproductinyear_pkey

cropproductinyear

public

(default)

btree

 

id

 

cropproduction_id_key

cropproduction

public

(default)

btree

 

id

 

 

cropproduction_pkey

cropproduction

public

(default)

btree

 

id

 

cropresiduemanagement_id_key

cropresiduemanagement

public

(default)

btree

 

id

 

 

cropresiduemanagement_pkey

cropresiduemanagement

public

(default)

btree

 

id

 

croprotationrequirements_id_key

croprotationrequirements

public

(default)

btree

 

id

 

 

croprotationrequirements_pkey

croprotationrequirements

public

(default)

btree

 

id

 

croprotationrequirementsnotpossiblepreviouscrops_pkey

croprotationrequirementsnotpossiblepreviouscrops

public

(default)

btree

 

croprotationrequirements_id, crop_id

 

cropsoilrequirements_id_key

cropsoilrequirements

public

(default)

btree

 

id

 

 

cropsoilrequirements_pkey

cropsoilrequirements

public

(default)

btree

 

id

 

cropyearmanagement_id_key

cropyearmanagement

public

(default)

btree

 

id

 

 

cropyearmanagement_pkey

cropyearmanagement

public

(default)

btree

 

id

 

crucialinstitutionalaspect_id_key

crucialinstitutionalaspect

public

(default)

btree

 

id

 

 

crucialinstitutionalaspect_pkey

crucialinstitutionalaspect

public

(default)

btree

 

id

 

crucialinstitutionalaspectnaturalresourcefoci_pkey

crucialinstitutionalaspectnaturalresourcefoci

public

(default)

btree

 

crucialinstitutionalaspect_id, naturalresourcefocus_id

 

crucialinstitutionalaspectpolicytypes_pkey

crucialinstitutionalaspectpolicytypes

public

(default)

btree

 

crucialinstitutionalaspect_id, policytype_id

 

crucialinstitutionalaspectpropertyrightschanges_pkey

crucialinstitutionalaspectpropertyrightschanges

public

(default)

btree

 

crucialinstitutionalaspect_id, propertyrightschanges_id

 

currentarableactivity_id_key

currentarableactivity

public

(default)

btree

 

id

 

 

currentarableactivity_pkey

currentarableactivity

public

(default)

btree

 

id

 

currentarableactivitycropyearmanagements_pkey

currentarableactivitycropyearmanagements

public

(default)

btree

 

currentarableactivity_id, cropyearmanagement_id

 

currentarableactivityproductinyear_pkey

currentarableactivityproductinyear

public

(default)

btree

 

currentarableactivity_id, cropproductinyear_id

 

cutfactorsubsidies_id_key

cutfactorsubsidies

public

(default)

btree

 

id

 

 

cutfactorsubsidies_pkey

cutfactorsubsidies

public

(default)

btree

 

id

 

dailyclimate_id_key

dailyclimate

public

(default)

btree

 

id

 

 

dailyclimate_pkey

dailyclimate

public

(default)

btree

 

id

 

dairycalve_id_key

dairycalve

public

(default)

btree

 

id

 

 

dairycalve_pkey

dairycalve

public

(default)

btree

 

id

 

dairycow_id_key

dairycow

public

(default)

btree

 

id

 

 

dairycow_pkey

dairycow

public

(default)

btree

 

id

 

dairyheifer_id_key

dairyheifer

public

(default)

btree

 

id

 

 

dairyheifer_pkey

dairyheifer

public

(default)

btree

 

id

 

dairymanagement_id_key

dairymanagement

public

(default)

btree

 

id

 

 

dairymanagement_pkey

dairymanagement

public

(default)

btree

 

id

 

dairymanagementalternativedairyoptions_pkey

dairymanagementalternativedairyoptions

public

(default)

btree

 

dairymanagement_id, alternativedairyoption_id

 

dayswithoutraincropphenologicalstagethreshold_id_key

dayswithoutraincropphenologicalstagethreshold

public

(default)

btree

 

id

 

 

dayswithoutraincropphenologicalstagethreshold_pkey

dayswithoutraincropphenologicalstagethreshold

public

(default)

btree

 

id

 

dayswithoutrainrepetitionthreshold_id_key

dayswithoutrainrepetitionthreshold

public

(default)

btree

 

id

 

 

dayswithoutrainrepetitionthreshold_pkey

dayswithoutrainrepetitionthreshold

public

(default)

btree

 

id

 

dayswithoutrainthreshold_id_key

dayswithoutrainthreshold

public

(default)

btree

 

id

 

 

dayswithoutrainthreshold_pkey

dayswithoutrainthreshold

public

(default)

btree

 

id

 

defaultimplements_id_key

defaultimplements

public

(default)

btree

 

id

 

 

defaultimplements_pkey

defaultimplements

public

(default)

btree

 

id

 

demandshift_id_key

demandshift

public

(default)

btree

 

id

 

 

demandshift_pkey

demandshift

public

(default)

btree

 

id

 

detailedcropmanagement_id_key

detailedcropmanagement

public

(default)

btree

 

id

 

 

detailedcropmanagement_pkey

detailedcropmanagement

public

(default)

btree

 

id

 

detailedcropmanagementevents_pkey

detailedcropmanagementevents

public

(default)

btree

 

detailedcropmanagement_id, event_id

 

dimension_id_key

dimension

public

(default)

btree

 

id

 

 

dimension_pkey

dimension

public

(default)

btree

 

id

 

domain__id_key

domain_

public

(default)

btree

 

id

 

 

domain__pkey

domain_

public

(default)

btree

 

id

 

endorsedindicator_id_key

endorsedindicator

public

(default)

btree

 

id

 

 

endorsedindicator_pkey

endorsedindicator

public

(default)

btree

 

id

 

endorsedindicatorinformativemodelvariables_pkey

endorsedindicatorinformativemodelvariables

public

(default)

btree

 

endorsedindicator_id, modelvariable_id

 

energyprice_id_key

energyprice

public

(default)

btree

 

id

 

 

energyprice_pkey

energyprice

public

(default)

btree

 

id

 

environmentaleffects_id_key

environmentaleffects

public

(default)

btree

 

id

 

 

environmentaleffects_pkey

environmentaleffects

public

(default)

btree

 

id

 

environmentalzone_id_key

environmentalzone

public

(default)

btree

 

id

 

 

environmentalzone_pkey

environmentalzone

public

(default)

btree

 

id

 

equilibriumprice_id_key

equilibriumprice

public

(default)

btree

 

id

 

 

equilibriumprice_pkey

equilibriumprice

public

(default)

btree

 

id

 

event_id_key

event

public

(default)

btree

 

id

 

 

event_pkey

event

public

(default)

btree

 

id

 

ewe_id_key

ewe

public

(default)

btree

 

id

 

 

ewe_pkey

ewe

public

(default)

btree

 

id

 

exchangerates_id_key

exchangerates

public

(default)

btree

 

id

 

 

exchangerates_pkey

exchangerates

public

(default)

btree

 

id

 

expectedimpact_id_key

expectedimpact

public

(default)

btree

 

id

 

 

expectedimpact_pkey

expectedimpact

public

(default)

btree

 

id

 

experiment_id_key

experiment

public

(default)

btree

 

id

 

 

experiment_pkey

experiment

public

(default)

btree

 

id

 

experimentplan_id_key

experimentplan

public

(default)

btree

 

id

 

 

experimentplan_pkey

experimentplan

public

(default)

btree

 

id

 

experimentplantwoexperiments_pkey

experimentplantwoexperiments

public

(default)

btree

 

experimentplan_id, experiment_id

 

experimentqueue_id_key

experimentqueue

public

(default)

btree

 

id

 

 

experimentqueue_pkey

experimentqueue

public

(default)

btree

 

id

 

experimentqueueexperimentruns_pkey

experimentqueueexperimentruns

public

(default)

btree

 

experimentqueue_id, experimentrun_id

 

experimentrun_id_key

experimentrun

public

(default)

btree

 

id

 

 

experimentrun_pkey

experimentrun

public

(default)

btree

 

id

 

fadnregion_id_key

fadnregion

public

(default)

btree

 

id

 

 

fadnregion_pkey

fadnregion

public

(default)

btree

 

id

 

farmareaperagrienvironmentalzone_id_key

farmareaperagrienvironmentalzone

public

(default)

btree

 

id

 

 

farmareaperagrienvironmentalzone_pkey

farmareaperagrienvironmentalzone

public

(default)

btree

 

id

 

farmconstraint_id_key

farmconstraint

public

(default)

btree

 

id

 

 

farmconstraint_pkey

farmconstraint

public

(default)

btree

 

id

 

farmintensity_id_key

farmintensity

public

(default)

btree

 

id

 

 

farmintensity_pkey

farmintensity

public

(default)

btree

 

id

 

farmquota_id_key

farmquota

public

(default)

btree

 

id

 

 

farmquota_pkey

farmquota

public

(default)

btree

 

id

 

farmsize_id_key

farmsize

public

(default)

btree

 

id

 

 

farmsize_pkey

farmsize

public

(default)

btree

 

id

 

farmspecialization_id_key

farmspecialization

public

(default)

btree

 

id

 

 

farmspecialization_pkey

farmspecialization

public

(default)

btree

 

id

 

fertiliser_id_key

fertiliser

public

(default)

btree

 

id

 

 

fertiliser_pkey

fertiliser

public

(default)

btree

 

id

 

fertiliserapplicationmethod_id_key

fertiliserapplicationmethod

public

(default)

btree

 

id

 

 

fertiliserapplicationmethod_pkey

fertiliserapplicationmethod

public

(default)

btree

 

id

 

fertilisersplit_id_key

fertilisersplit

public

(default)

btree

 

id

 

 

fertilisersplit_pkey

fertilisersplit

public

(default)

btree

 

id

 

fieldborders_id_key

fieldborders

public

(default)

btree

 

id

 

 

fieldborders_pkey

fieldborders

public

(default)

btree

 

id

 

fssimarablefarm_id_key

fssimarablefarm

public

(default)

btree

 

id

 

 

fssimarablefarm_pkey

fssimarablefarm

public

(default)

btree

 

id

 

fssimfarmfarmareaperagrienvironmentalzone_pkey

fssimfarmfarmareaperagrienvironmentalzone

public

(default)

btree

 

fssimfarm_id, farmareaperagrienvironmentalzone_id

 

fssimfarmobservedcroppattern_pkey

fssimfarmobservedcroppattern

public

(default)

btree

 

fssimfarm_id, croparea_id

 

fssimlivestockfarm_id_key

fssimlivestockfarm

public

(default)

btree

 

id

 

 

fssimlivestockfarm_pkey

fssimlivestockfarm

public

(default)

btree

 

id

 

fssimlivestockfarmobservedanimallevels_pkey

fssimlivestockfarmobservedanimallevels

public

(default)

btree

 

fssimlivestockfarm_id, observedanimallevels_id

 

generictheme_id_key

generictheme

public

(default)

btree

 

id

 

 

generictheme_pkey

generictheme

public

(default)

btree

 

id

 

globaltariff_id_key

globaltariff

public

(default)

btree

 

id

 

 

globaltariff_pkey

globaltariff

public

(default)

btree

 

id

 

goat_id_key

goat

public

(default)

btree

 

id

 

 

goat_pkey

goat

public

(default)

btree

 

id

 

goatling_id_key

goatling

public

(default)

btree

 

id

 

 

goatling_pkey

goatling

public

(default)

btree

 

id

 

grassfeeds_id_key

grassfeeds

public

(default)

btree

 

id

 

 

grassfeeds_pkey

grassfeeds

public

(default)

btree

 

id

 

grasslandactivity_id_key

grasslandactivity

public

(default)

btree

 

id

 

 

grasslandactivity_pkey

grasslandactivity

public

(default)

btree

 

id

 

grasslandactivitygrassproductions_pkey

grasslandactivitygrassproductions

public

(default)

btree

 

grasslandactivity_id, grassproduction_id

 

grassmanagement_id_key

grassmanagement

public

(default)

btree

 

id

 

 

grassmanagement_pkey

grassmanagement

public

(default)

btree

 

id

 

grassmanagementalternative_id_key

grassmanagementalternative

public

(default)

btree

 

id

 

 

grassmanagementalternative_pkey

grassmanagementalternative

public

(default)

btree

 

id

 

grassmanagementalternativealternativegrassmanagement_pkey

grassmanagementalternativealternativegrassmanagement

public

(default)

btree

 

grassmanagementalternative_id, grassmanagement_id

 

grassproduction_id_key

grassproduction

public

(default)

btree

 

id

 

 

grassproduction_pkey

grassproduction

public

(default)

btree

 

id

 

helptopic_id_key

helptopic

public

(default)

btree

 

id

 

 

helptopic_pkey

helptopic

public

(default)

btree

 

id

 

image_id_key

image

public

(default)

btree

 

id

 

 

image_pkey

image

public

(default)

btree

 

id

 

implement_id_key

implement

public

(default)

btree

 

id

 

 

implement_pkey

implement

public

(default)

btree

 

id

 

indicatorgroup_id_key

indicatorgroup

public

(default)

btree

 

id

 

 

indicatorgroup_pkey

indicatorgroup

public

(default)

btree

 

id

 

indicatorgroupdimensions_pkey

indicatorgroupdimensions

public

(default)

btree

 

indicatorgroup_id, dimension_id

 

indicatorgroupdomains_pkey

indicatorgroupdomains

public

(default)

btree

 

indicatorgroup_id, domain__id

 

indicatorgroupsubthemes_pkey

indicatorgroupsubthemes

public

(default)

btree

 

indicatorgroup_id, subtheme_id

 

indicatorgrouptradeoff_pkey

indicatorgrouptradeoff

public

(default)

btree

 

indicatorgroup_id, indicatorgroup_id1

 

indicatorvalueactivity_id_key

indicatorvalueactivity

public

(default)

btree

 

id

 

 

indicatorvalueactivity_pkey

indicatorvalueactivity

public

(default)

btree

 

id

 

indicatorvalueactivitygroupcountry_id_key

indicatorvalueactivitygroupcountry

public

(default)

btree

 

id

 

 

indicatorvalueactivitygroupcountry_pkey

indicatorvalueactivitygroupcountry

public

(default)

btree

 

id

 

indicatorvalueactivitygroupcountryaggregate_id_key

indicatorvalueactivitygroupcountryaggregate

public

(default)

btree

 

id

 

 

indicatorvalueactivitygroupcountryaggregate_pkey

indicatorvalueactivitygroupcountryaggregate

public

(default)

btree

 

id

 

indicatorvalueactivitygroupnutsregion_id_key

indicatorvalueactivitygroupnutsregion

public

(default)

btree

 

id

 

 

indicatorvalueactivitygroupnutsregion_pkey

indicatorvalueactivitygroupnutsregion

public

(default)

btree

 

id

 

indicatorvaluebetweencountryaggregates_id_key

indicatorvaluebetweencountryaggregates

public

(default)

btree

 

id

 

 

indicatorvaluebetweencountryaggregates_pkey

indicatorvaluebetweencountryaggregates

public

(default)

btree

 

id

 

indicatorvaluecountry_id_key

indicatorvaluecountry

public

(default)

btree

 

id

 

 

indicatorvaluecountry_pkey

indicatorvaluecountry

public

(default)

btree

 

id

 

indicatorvaluecountryaggregate_id_key

indicatorvaluecountryaggregate

public

(default)

btree

 

id

 

 

indicatorvaluecountryaggregate_pkey

indicatorvaluecountryaggregate

public

(default)

btree

 

id

 

indicatorvaluecrop_id_key

indicatorvaluecrop

public

(default)

btree

 

id

 

 

indicatorvaluecrop_pkey

indicatorvaluecrop

public

(default)

btree

 

id

 

indicatorvaluefarm_id_key

indicatorvaluefarm

public

(default)

btree

 

id

 

 

indicatorvaluefarm_pkey

indicatorvaluefarm

public

(default)

btree

 

id

 

indicatorvaluefarmagrienvironmentalzone_id_key

indicatorvaluefarmagrienvironmentalzone

public

(default)

btree

 

id

 

 

indicatorvaluefarmagrienvironmentalzone_pkey

indicatorvaluefarmagrienvironmentalzone

public

(default)

btree

 

id

 

indicatorvalueinputgroupcountry_id_key

indicatorvalueinputgroupcountry

public

(default)

btree

 

id

 

 

indicatorvalueinputgroupcountry_pkey

indicatorvalueinputgroupcountry

public

(default)

btree

 

id

 

indicatorvalueinputgroupcountryaggregate_id_key

indicatorvalueinputgroupcountryaggregate

public

(default)

btree

 

id

 

 

indicatorvalueinputgroupcountryaggregate_pkey

indicatorvalueinputgroupcountryaggregate

public

(default)

btree

 

id

 

indicatorvalueinputgroupnutsregion_id_key

indicatorvalueinputgroupnutsregion

public

(default)

btree

 

id

 

 

indicatorvalueinputgroupnutsregion_pkey

indicatorvalueinputgroupnutsregion

public

(default)

btree

 

id

 

indicatorvaluenutsregion_id_key

indicatorvaluenutsregion

public

(default)

btree

 

id

 

 

indicatorvaluenutsregion_pkey

indicatorvaluenutsregion

public

(default)

btree

 

id

 

indicatorvalueproductgroupcountry_id_key

indicatorvalueproductgroupcountry

public

(default)

btree

 

id

 

 

indicatorvalueproductgroupcountry_pkey

indicatorvalueproductgroupcountry

public

(default)

btree

 

id

 

indicatorvalueproductgroupcountryaggregate_id_key

indicatorvalueproductgroupcountryaggregate

public

(default)

btree

 

id

 

 

indicatorvalueproductgroupcountryaggregate_pkey

indicatorvalueproductgroupcountryaggregate

public

(default)

btree

 

id

 

indicatorvalueproductgroupnutsregion_id_key

indicatorvalueproductgroupnutsregion

public

(default)

btree

 

id

 

 

indicatorvalueproductgroupnutsregion_pkey

indicatorvalueproductgroupnutsregion

public

(default)

btree

 

id

 

indicatorvaluesimple_id_key

indicatorvaluesimple

public

(default)

btree

 

id

 

 

indicatorvaluesimple_pkey

indicatorvaluesimple

public

(default)

btree

 

id

 

indicatorvaluetable_id_key

indicatorvaluetable

public

(default)

btree

 

id

 

 

indicatorvaluetable_pkey

indicatorvaluetable

public

(default)

btree

 

id

 

inflationrate_id_key

inflationrate

public

(default)

btree

 

id

 

 

inflationrate_pkey

inflationrate

public

(default)

btree

 

id

 

inorganicfertiliser_id_key

inorganicfertiliser

public

(default)

btree

 

id

 

 

inorganicfertiliser_pkey

inorganicfertiliser

public

(default)

btree

 

id

 

input__id_key

input_

public

(default)

btree

 

id

 

 

input__pkey

input_

public

(default)

btree

 

id

 

inputgroup_id_key

inputgroup

public

(default)

btree

 

id

 

 

inputgroup_pkey

inputgroup

public

(default)

btree

 

id

 

inputonsoilinmanagementprocedure_id_key

inputonsoilinmanagementprocedure

public

(default)

btree

 

id

 

 

inputonsoilinmanagementprocedure_pkey

inputonsoilinmanagementprocedure

public

(default)

btree

 

id

 

institutionalcompatibility_id_key

institutionalcompatibility

public

(default)

btree

 

id

 

 

institutionalcompatibility_pkey

institutionalcompatibility

public

(default)

btree

 

id

 

institutionalcompatibilitypicaspatiallevels_pkey

institutionalcompatibilitypicaspatiallevels

public

(default)

btree

 

institutionalcompatibility_id, picaspatiallevel_id

 

intercropping_id_key

intercropping

public

(default)

btree

 

id

 

 

intercropping_pkey

intercropping

public

(default)

btree

 

id

 

irrigationmethod_id_key

irrigationmethod

public

(default)

btree

 

id

 

 

irrigationmethod_pkey

irrigationmethod

public

(default)

btree

 

id

 

irrigationoperation_id_key

irrigationoperation

public

(default)

btree

 

id

 

 

irrigationoperation_pkey

irrigationoperation

public

(default)

btree

 

id

 

irrigationsimple_id_key

irrigationsimple

public

(default)

btree

 

id

 

 

irrigationsimple_pkey

irrigationsimple

public

(default)

btree

 

id

 

irrigationwater_id_key

irrigationwater

public

(default)

btree

 

id

 

 

irrigationwater_pkey

irrigationwater

public

(default)

btree

 

id

 

irrigationwindow_id_key

irrigationwindow

public

(default)

btree

 

id

 

 

irrigationwindow_pkey

irrigationwindow

public

(default)

btree

 

id

 

lamb_id_key

lamb

public

(default)

btree

 

id

 

 

lamb_pkey

lamb

public

(default)

btree

 

id

 

leafareaindexthreshold_id_key

leafareaindexthreshold

public

(default)

btree

 

id

 

 

leafareaindexthreshold_pkey

leafareaindexthreshold

public

(default)

btree

 

id

 

livestockinformation_id_key

livestockinformation

public

(default)

btree

 

id

 

 

livestockinformation_pkey

livestockinformation

public

(default)

btree

 

id

 

managementprocedure_id_key

managementprocedure

public

(default)

btree

 

id

 

 

managementprocedure_pkey

managementprocedure

public

(default)

btree

 

id

 

managementprocedureandtiming_id_key

managementprocedureandtiming

public

(default)

btree

 

id

 

 

managementprocedureandtiming_pkey

managementprocedureandtiming

public

(default)

btree

 

id

 

managementprocedureandtimingtimedecade_pkey

managementprocedureandtimingtimedecade

public

(default)

btree

 

managementprocedureandtiming_id, timedecade_id

 

managementprocedureinputsandimplements_pkey

managementprocedureinputsandimplements

public

(default)

btree

 

managementprocedure_id, inputsandimplements_id

 

manuresimple_id_key

manuresimple

public

(default)

btree

 

id

 

 

manuresimple_pkey

manuresimple

public

(default)

btree

 

id

 

model_id_key

model

public

(default)

btree

 

id

 

 

model_pkey

model

public

(default)

btree

 

id

 

modelchain_id_key

modelchain

public

(default)

btree

 

id

 

 

modelchain_pkey

modelchain

public

(default)

btree

 

id

 

modelchainmodels_pkey

modelchainmodels

public

(default)

btree

 

modelchain_id, model_id

 

modelspatialscales_pkey

modelspatialscales

public

(default)

btree

 

model_id, spatialscale_id

 

modelvariable_id_key

modelvariable

public

(default)

btree

 

id

 

 

modelvariable_pkey

modelvariable

public

(default)

btree

 

id

 

modulation_id_key

modulation

public

(default)

btree

 

id

 

 

modulation_pkey

modulation

public

(default)

btree

 

id

 

multiplerepetitionthreshold_id_key

multiplerepetitionthreshold

public

(default)

btree

 

id

 

 

multiplerepetitionthreshold_pkey

multiplerepetitionthreshold

public

(default)

btree

 

id

 

narrative_id_key

narrative

public

(default)

btree

 

id

 

 

narrative_pkey

narrative

public

(default)

btree

 

id

 

narrativenarrativeoptions_pkey

narrativenarrativeoptions

public

(default)

btree

 

narrative_id, narrativeoption_id

 

narrativeoption_id_key

narrativeoption

public

(default)

btree

 

id

 

 

narrativeoption_pkey

narrativeoption

public

(default)

btree

 

id

 

naturalresourcefocus_id_key

naturalresourcefocus

public

(default)

btree

 

id

 

 

naturalresourcefocus_pkey

naturalresourcefocus

public

(default)

btree

 

id

 

nutrientmanagement_id_key

nutrientmanagement

public

(default)

btree

 

id

 

 

nutrientmanagement_pkey

nutrientmanagement

public

(default)

btree

 

id

 

nutrientmanagementcrops_pkey

nutrientmanagementcrops

public

(default)

btree

 

nutrientmanagement_id, crop_id

 

nutrientoperation_id_key

nutrientoperation

public

(default)

btree

 

id

 

 

nutrientoperation_pkey

nutrientoperation

public

(default)

btree

 

id

 

nutsregion_id_key

nutsregion

public

(default)

btree

 

id

 

 

nutsregion_pkey

nutsregion

public

(default)

btree

 

id

 

observedanimallevels_id_key

observedanimallevels

public

(default)

btree

 

id

 

 

observedanimallevels_pkey

observedanimallevels

public

(default)

btree

 

id

 

optimalfarmbehaviour_id_key

optimalfarmbehaviour

public

(default)

btree

 

id

 

 

optimalfarmbehaviour_pkey

optimalfarmbehaviour

public

(default)

btree

 

id

 

optimalfarmbehaviourcalibrationterms_pkey

optimalfarmbehaviourcalibrationterms

public

(default)

btree

 

optimalfarmbehaviour_id, calibrationterm_id

 

optimalfarmbehaviouroptimalcroppingpattern_pkey

optimalfarmbehaviouroptimalcroppingpattern

public

(default)

btree

 

optimalfarmbehaviour_id, optimalproductioncoefficient_id

 

optimalfarmbehaviouroptimallivestockactivity_pkey

optimalfarmbehaviouroptimallivestockactivity

public

(default)

btree

 

optimalfarmbehaviour_id, optimallivestockactivity_id

 

optimalfarmbehavioursupplyresponses_pkey

optimalfarmbehavioursupplyresponses

public

(default)

btree

 

optimalfarmbehaviour_id, supplyresponse_id

 

optimallivestockactivity_id_key

optimallivestockactivity

public

(default)

btree

 

id

 

 

optimallivestockactivity_pkey

optimallivestockactivity

public

(default)

btree

 

id

 

optimalproductioncoefficient_id_key

optimalproductioncoefficient

public

(default)

btree

 

id

 

 

optimalproductioncoefficient_pkey

optimalproductioncoefficient

public

(default)

btree

 

id

 

organicfertiliser_id_key

organicfertiliser

public

(default)

btree

 

id

 

 

organicfertiliser_pkey

organicfertiliser

public

(default)

btree

 

id

 

outlook_id_key

outlook

public

(default)

btree

 

id

 

 

outlook_pkey

outlook

public

(default)

btree

 

id

 

outlookbiofueldemands_pkey

outlookbiofueldemands

public

(default)

btree

 

outlook_id, biofueldemand_id

 

outlookdemandshifts_pkey

outlookdemandshifts

public

(default)

btree

 

outlook_id, demandshift_id

 

outlookenergyprice_pkey

outlookenergyprice

public

(default)

btree

 

outlook_id, energyprice_id

 

outlookexchangerates_pkey

outlookexchangerates

public

(default)

btree

 

outlook_id, exchangerates_id

 

outlookinflationrates_pkey

outlookinflationrates

public

(default)

btree

 

outlook_id, inflationrate_id

 

outlookmodulations_pkey

outlookmodulations

public

(default)

btree

 

outlook_id, modulation_id

 

outlookyieldgrowth_pkey

outlookyieldgrowth

public

(default)

btree

 

outlook_id, yieldgrowth_id

 

penalty_id_key

penalty

public

(default)

btree

 

id

 

 

penalty_pkey

penalty

public

(default)

btree

 

id

 

perennialrotations_id_key

perennialrotations

public

(default)

btree

 

id

 

 

perennialrotations_pkey

perennialrotations

public

(default)

btree

 

id

 

permisiongroup_id_key

permisiongroup

public

(default)

btree

 

id

 

 

permisiongroup_pkey

permisiongroup

public

(default)

btree

 

id

 

permisiongrouppermissions_pkey

permisiongrouppermissions

public

(default)

btree

 

permisiongroup_id, permission_id

 

permission_id_key

permission

public

(default)

btree

 

id

 

 

permission_pkey

permission

public

(default)

btree

 

id

 

pesticide_id_key

pesticide

public

(default)

btree

 

id

 

 

pesticide_pkey

pesticide

public

(default)

btree

 

id

 

pesticideapplicationmethod_id_key

pesticideapplicationmethod

public

(default)

btree

 

id

 

 

pesticideapplicationmethod_pkey

pesticideapplicationmethod

public

(default)

btree

 

id

 

pesticideoperation_id_key

pesticideoperation

public

(default)

btree

 

id

 

 

pesticideoperation_pkey

pesticideoperation

public

(default)

btree

 

id

 

pesticidesmixtures_id_key

pesticidesmixtures

public

(default)

btree

 

id

 

 

pesticidesmixtures_pkey

pesticidesmixtures

public

(default)

btree

 

id

 

pesticidesmixturespesticideoperations_pkey

pesticidesmixturespesticideoperations

public

(default)

btree

 

pesticidesmixtures_id, pesticideoperation_id

 

picaassessment_id_key

picaassessment

public

(default)

btree

 

id

 

 

picaassessment_pkey

picaassessment

public

(default)

btree

 

id

 

picaindicator_id_key

picaindicator

public

(default)

btree

 

id

 

 

picaindicator_pkey

picaindicator

public

(default)

btree

 

id

 

picaindicatorgeneral_id_key

picaindicatorgeneral

public

(default)

btree

 

id

 

 

picaindicatorgeneral_pkey

picaindicatorgeneral

public

(default)

btree

 

id

 

picaindicatorgeneralcrucialinstitutionalaspectlinkagecruci_pkey

picaindicatorgeneralcrucialinstitutionalaspectlinkagecrucialins

public

(default)

btree

 

picaindicatorgeneral_id, crucialinstitutionalaspect_id

 

picaindicatorvalue_id_key

picaindicatorvalue

public

(default)

btree

 

id

 

 

picaindicatorvalue_pkey

picaindicatorvalue

public

(default)

btree

 

id

 

picaspatiallevel_id_key

picaspatiallevel

public

(default)

btree

 

id

 

 

picaspatiallevel_pkey

picaspatiallevel

public

(default)

btree

 

id

 

policyassessment_id_key

policyassessment

public

(default)

btree

 

id

 

 

policyassessment_pkey

policyassessment

public

(default)

btree

 

id

 

policyassessmentcutfactorsubsidies_pkey

policyassessmentcutfactorsubsidies

public

(default)

btree

 

policyassessment_id, cutfactorsubsidies_id

 

policyassessmentequilibriumprices_pkey

policyassessmentequilibriumprices

public

(default)

btree

 

policyassessment_id, equilibriumprice_id

 

policyassessmentfssimfarmindicators_pkey

policyassessmentfssimfarmindicators

public

(default)

btree

 

policyassessment_id, optimalfarmbehaviour_id

 

policyassessmentpriceelasticities_pkey

policyassessmentpriceelasticities

public

(default)

btree

 

policyassessment_id, priceelasticity_id

 

policyoption_id_key

policyoption

public

(default)

btree

 

id

 

 

policyoption_pkey

policyoption

public

(default)

btree

 

id

 

policyoptionbasicpremiums_pkey

policyoptionbasicpremiums

public

(default)

btree

 

policyoption_id, basicpremium_id

 

policyoptionbilateraltariffs_pkey

policyoptionbilateraltariffs

public

(default)

btree

 

policyoption_id, bilateraltariff_id

 

policyoptioncouplingdegrees_pkey

policyoptioncouplingdegrees

public

(default)

btree

 

policyoption_id, couplingdegree_id

 

policyoptionfarmconstraints_pkey

policyoptionfarmconstraints

public

(default)

btree

 

policyoption_id, farmconstraint_id

 

policyoptionfarmquotas_pkey

policyoptionfarmquotas

public

(default)

btree

 

policyoption_id, farmquota_id

 

policyoptionglobaltariffs_pkey

policyoptionglobaltariffs

public

(default)

btree

 

policyoption_id, globaltariff_id

 

policyoptioninstitutionalcompatibility_pkey

policyoptioninstitutionalcompatibility

public

(default)

btree

 

policyoption_id, institutionalcompatibility_id

 

policyoptionpolicymeasures_pkey

policyoptionpolicymeasures

public

(default)

btree

 

policyoption_id, policymeasure_id

 

policyoptionpricechange_pkey

policyoptionpricechange

public

(default)

btree

 

policyoption_id, price_id

 

policyoptionquotacountries_pkey

policyoptionquotacountries

public

(default)

btree

 

policyoption_id, quotacountry_id

 

policyoptionsetasideregulations_pkey

policyoptionsetasideregulations

public

(default)

btree

 

policyoption_id, setasideregulation_id

 

policyoptionsubsidies_pkey

policyoptionsubsidies

public

(default)

btree

 

policyoption_id, subsidy_id

 

policyoptionsubsidisedexports_pkey

policyoptionsubsidisedexports

public

(default)

btree

 

policyoption_id, subsidisedexport_id

 

policyoptiontradereformproposals_pkey

policyoptiontradereformproposals

public

(default)

btree

 

policyoption_id, tradereformproposal_id

 

policyoptionyieldtrend_pkey

policyoptionyieldtrend

public

(default)

btree

 

policyoption_id, yieldtrend_id

 

policytype_id_key

policytype

public

(default)

btree

 

id

 

 

policytype_pkey

policytype

public

(default)

btree

 

id

 

premiumgroup_id_key

premiumgroup

public

(default)

btree

 

id

 

 

premiumgroup_pkey

premiumgroup

public

(default)

btree

 

id

 

price_id_key

price

public

(default)

btree

 

id

 

 

price_pkey

price

public

(default)

btree

 

id

 

priceelasticity_id_key

priceelasticity

public

(default)

btree

 

id

 

 

priceelasticity_pkey

priceelasticity

public

(default)

btree

 

id

 

problem_id_key

problem

public

(default)

btree

 

id

 

 

problem_pkey

problem

public

(default)

btree

 

id

 

problemexperimentplans_pkey

problemexperimentplans

public

(default)

btree

 

problem_id, experimentplan_id

 

problemindicators_pkey

problemindicators

public

(default)

btree

 

problem_id, indicator__id

 

problemmodels_pkey

problemmodels

public

(default)

btree

 

problem_id, model_id

 

productgroup_id_key

productgroup

public

(default)

btree

 

id

 

 

productgroup_pkey

productgroup

public

(default)

btree

 

id

 

productgroupproductsetofproducts_pkey

productgroupproductsetofproducts

public

(default)

btree

 

productgroup_id, product_id

 

productionactivity_id_key

productionactivity

public

(default)

btree

 

id

 

 

productionactivity_pkey

productionactivity

public

(default)

btree

 

id

 

productionactivitycropproductyearmanagements_pkey

productionactivitycropproductyearmanagements

public

(default)

btree

 

productionactivity_id, productioncoefficient_id

 

productionactivityperfssimfarm_id_key

productionactivityperfssimfarm

public

(default)

btree

 

id

 

 

productionactivityperfssimfarm_pkey

productionactivityperfssimfarm

public

(default)

btree

 

id

 

productionactivityperfssimfarmagriculturalactivities_pkey

productionactivityperfssimfarmagriculturalactivities

public

(default)

btree

 

productionactivityperfssimfarm_id, agriculturalactivity_id

 

productioncoefficient_id_key

productioncoefficient

public

(default)

btree

 

id

 

 

productioncoefficient_pkey

productioncoefficient

public

(default)

btree

 

id

 

productioncoefficientyieldofcropproducts_pkey

productioncoefficientyieldofcropproducts

public

(default)

btree

 

productioncoefficient_id, yieldofcropproduct_id

 

productionorientation_id_key

productionorientation

public

(default)

btree

 

id

 

 

productionorientation_pkey

productionorientation

public

(default)

btree

 

id

 

productionorientationbeefmanagements_pkey

productionorientationbeefmanagements

public

(default)

btree

 

productionorientation_id, beefmanagement_id

 

productionorientationdairymanagements_pkey

productionorientationdairymanagements

public

(default)

btree

 

productionorientation_id, dairymanagement_id

 

productionorientationgrassmanagementalternatives_pkey

productionorientationgrassmanagementalternatives

public

(default)

btree

 

productionorientation_id, grassmanagementalternative_id

 

productionorientationsmallbeefruminantmanagements_pkey

productionorientationsmallbeefruminantmanagements

public

(default)

btree

 

productionorientation_id, beefmanagement_id

 

productionorientationsmalldairyruminantmanagements_pkey

productionorientationsmalldairyruminantmanagements

public

(default)

btree

 

productionorientation_id, dairymanagement_id

 

productiontechnique_id_key

productiontechnique

public

(default)

btree

 

id

 

 

productiontechnique_pkey

productiontechnique

public

(default)

btree

 

id

 

productonsoil_id_key

productonsoil

public

(default)

btree

 

id

 

 

productonsoil_pkey

productonsoil

public

(default)

btree

 

id

 

productsforregion_id_key

productsforregion

public

(default)

btree

 

id

 

 

productsforregion_pkey

productsforregion

public

(default)

btree

 

id

 

producttype_id_key

producttype

public

(default)

btree

 

id

 

 

producttype_pkey

producttype

public

(default)

btree

 

id

 

project_id_key

project

public

(default)

btree

 

id

 

 

project_pkey

project

public

(default)

btree

 

id

 

projectrole_id_key

projectrole

public

(default)

btree

 

id

 

 

projectrole_pkey

projectrole

public

(default)

btree

 

id

 

propertyrightschanges_id_key

propertyrightschanges

public

(default)

btree

 

id

 

 

propertyrightschanges_pkey

propertyrightschanges

public

(default)

btree

 

id

 

quotacountry_id_key

quotacountry

public

(default)

btree

 

id

 

 

quotacountry_pkey

quotacountry

public

(default)

btree

 

id

 

reducebiomassclippingoperation_id_key

reducebiomassclippingoperation

public

(default)

btree

 

id

 

 

reducebiomassclippingoperation_pkey

reducebiomassclippingoperation

public

(default)

btree

 

id

 

reducedtillage_id_key

reducedtillage

public

(default)

btree

 

id

 

 

reducedtillage_pkey

reducedtillage

public

(default)

btree

 

id

 

reducedtillageevents_pkey

reducedtillageevents

public

(default)

btree

 

reducedtillage_id, event_id

 

reduceleafareaindexclippingoperation_id_key

reduceleafareaindexclippingoperation

public

(default)

btree

 

id

 

 

reduceleafareaindexclippingoperation_pkey

reduceleafareaindexclippingoperation

public

(default)

btree

 

id

 

regionalagromanagementzone_id_key

regionalagromanagementzone

public

(default)

btree

 

id

 

 

regionalagromanagementzone_pkey

regionalagromanagementzone

public

(default)

btree

 

id

 

regionalagromanagementzoneagrienvironmentalzones_pkey

regionalagromanagementzoneagrienvironmentalzones

public

(default)

btree

 

regionalagromanagementzone_id, agrienvironmentalzone_id

 

regionaltypology_id_key

regionaltypology

public

(default)

btree

 

id

 

 

regionaltypology_pkey

regionaltypology

public

(default)

btree

 

id

 

regionaltypologyclass_id_key

regionaltypologyclass

public

(default)

btree

 

id

 

 

regionaltypologyclass_pkey

regionaltypologyclass

public

(default)

btree

 

id

 

regionaltypologyvalue_id_key

regionaltypologyvalue

public

(default)

btree

 

id

 

 

regionaltypologyvalue_pkey

regionaltypologyvalue

public

(default)

btree

 

id

 

regionalwage_id_key

regionalwage

public

(default)

btree

 

id

 

 

regionalwage_pkey

regionalwage

public

(default)

btree

 

id

 

relativeday_id_key

relativeday

public

(default)

btree

 

id

 

 

relativeday_pkey

relativeday

public

(default)

btree

 

id

 

repetitionthreshold_id_key

repetitionthreshold

public

(default)

btree

 

id

 

 

repetitionthreshold_pkey

repetitionthreshold

public

(default)

btree

 

id

 

representativefarm_id_key

representativefarm

public

(default)

btree

 

id

 

 

representativefarm_pkey

representativefarm

public

(default)

btree

 

id

 

representativefarmgroup_id_key

representativefarmgroup

public

(default)

btree

 

id

 

 

representativefarmgroup_pkey

representativefarmgroup

public

(default)

btree

 

id

 

representativefarminagrienvregion_id_key

representativefarminagrienvregion

public

(default)

btree

 

id

 

 

representativefarminagrienvregion_pkey

representativefarminagrienvregion

public

(default)

btree

 

id

 

role_permissions_pkey

role_permissions

public

(default)

btree

 

role__id, permission_id

 

rotation_id_key

rotation

public

(default)

btree

 

id

 

 

rotation_pkey

rotation

public

(default)

btree

 

id

 

rotationcropperyear_pkey

rotationcropperyear

public

(default)

btree

 

rotation_id, cropperyear_id

 

rotationwithproductionorientation_id_key

rotationwithproductionorientation

public

(default)

btree

 

id

 

 

rotationwithproductionorientation_pkey

rotationwithproductionorientation

public

(default)

btree

 

id

 

rotationwithproductionorientationforfarm_id_key

rotationwithproductionorientationforfarm

public

(default)

btree

 

id

 

 

rotationwithproductionorientationforfarm_pkey

rotationwithproductionorientationforfarm

public

(default)

btree

 

id

 

rotationwithproductionorientationforfarmrotationwithproduc_pkey

rotationwithproductionorientationforfarmrotationwithproductiono

public

(default)

btree

 

rotationwithproductionorientationforfarm_id, rotationwithproductionorientation_id

 

rotationyear_id_key

rotationyear

public

(default)

btree

 

id

 

 

rotationyear_pkey

rotationyear

public

(default)

btree

 

id

 

roughagefeeds_id_key

roughagefeeds

public

(default)

btree

 

id

 

 

roughagefeeds_pkey

roughagefeeds

public

(default)

btree

 

id

 

seed_id_key

seed

public

(default)

btree

 

id

 

 

seed_pkey

seed

public

(default)

btree

 

id

 

setasideregulation_id_key

setasideregulation

public

(default)

btree

 

id

 

 

setasideregulation_pkey

setasideregulation

public

(default)

btree

 

id

 

simplecropgroup_id_key

simplecropgroup

public

(default)

btree

 

id

 

 

simplecropgroup_pkey

simplecropgroup

public

(default)

btree

 

id

 

simplecropmanagement_id_key

simplecropmanagement

public

(default)

btree

 

id

 

 

simplecropmanagement_pkey

simplecropmanagement

public

(default)

btree

 

id

 

simplecropmanagementinzone_id_key

simplecropmanagementinzone

public

(default)

btree

 

id

 

 

simplecropmanagementinzone_pkey

simplecropmanagementinzone

public

(default)

btree

 

id

 

simplecropmanagementinzonesimplecropmanagement_pkey

simplecropmanagementinzonesimplecropmanagement

public

(default)

btree

 

simplecropmanagementinzone_id, simplecropmanagement_id

 

simplecurrentbeefactivity_id_key

simplecurrentbeefactivity

public

(default)

btree

 

id

 

 

simplecurrentbeefactivity_pkey

simplecurrentbeefactivity

public

(default)

btree

 

id

 

simplecurrentdairyactivity_id_key

simplecurrentdairyactivity

public

(default)

btree

 

id

 

 

simplecurrentdairyactivity_pkey

simplecurrentdairyactivity

public

(default)

btree

 

id

 

simplecurrentsmallbeefruminants_id_key

simplecurrentsmallbeefruminants

public

(default)

btree

 

id

 

 

simplecurrentsmallbeefruminants_pkey

simplecurrentsmallbeefruminants

public

(default)

btree

 

id

 

simplecurrentsmalldairyruminantactivity_id_key

simplecurrentsmalldairyruminantactivity

public

(default)

btree

 

id

 

 

simplecurrentsmalldairyruminantactivity_pkey

simplecurrentsmalldairyruminantactivity

public

(default)

btree

 

id

 

simplesurveyrotationelement_id_key

simplesurveyrotationelement

public

(default)

btree

 

id

 

 

simplesurveyrotationelement_pkey

simplesurveyrotationelement

public

(default)

btree

 

id

 

simplesurveyrotationelementsimplecropmanagementinzone_pkey

simplesurveyrotationelementsimplecropmanagementinzone

public

(default)

btree

 

simplesurveyrotationelement_id, simplecropmanagementinzone_id

 

soilcharacteristics_id_key

soilcharacteristics

public

(default)

btree

 

id

 

 

soilcharacteristics_pkey

soilcharacteristics

public

(default)

btree

 

id

 

soiltemperaturethreshold_id_key

soiltemperaturethreshold

public

(default)

btree

 

id

 

 

soiltemperaturethreshold_pkey

soiltemperaturethreshold

public

(default)

btree

 

id

 

soiltype_id_key

soiltype

public

(default)

btree

 

id

 

 

soiltype_pkey

soiltype

public

(default)

btree

 

id

 

soilwaterlevelthreshold_id_key

soilwaterlevelthreshold

public

(default)

btree

 

id

 

 

soilwaterlevelthreshold_pkey

soilwaterlevelthreshold

public

(default)

btree

 

id

 

soilwaterrepetitionthreshold_id_key

soilwaterrepetitionthreshold

public

(default)

btree

 

id

 

 

soilwaterrepetitionthreshold_pkey

soilwaterrepetitionthreshold

public

(default)

btree

 

id

 

soilwaterrootingdepththreshold_id_key

soilwaterrootingdepththreshold

public

(default)

btree

 

id

 

 

soilwaterrootingdepththreshold_pkey

soilwaterrootingdepththreshold

public

(default)

btree

 

id

 

sowingimplement_id_key

sowingimplement

public

(default)

btree

 

id

 

 

sowingimplement_pkey

sowingimplement

public

(default)

btree

 

id

 

sowingoperation_id_key

sowingoperation

public

(default)

btree

 

id

 

 

sowingoperation_pkey

sowingoperation

public

(default)

btree

 

id

 

sowingoperationregional_id_key

sowingoperationregional

public

(default)

btree

 

id

 

 

sowingoperationregional_pkey

sowingoperationregional

public

(default)

btree

 

id

 

spatialscale_id_key

spatialscale

public

(default)

btree

 

id

 

 

spatialscale_pkey

spatialscale

public

(default)

btree

 

id

 

subsidisedexport_id_key

subsidisedexport

public

(default)

btree

 

id

 

 

subsidisedexport_pkey

subsidisedexport

public

(default)

btree

 

id

 

subsidy_id_key

subsidy

public

(default)

btree

 

id

 

 

subsidy_pkey

subsidy

public

(default)

btree

 

id

 

subsidycrosscompliance_id_key

subsidycrosscompliance

public

(default)

btree

 

id

 

 

subsidycrosscompliance_pkey

subsidycrosscompliance

public

(default)

btree

 

id

 

subtheme_id_key

subtheme

public

(default)

btree

 

id

 

 

subtheme_pkey

subtheme

public

(default)

btree

 

id

 

sucklercow_id_key

sucklercow

public

(default)

btree

 

id

 

 

sucklercow_pkey

sucklercow

public

(default)

btree

 

id

 

sugarcontentnorainthreshold_id_key

sugarcontentnorainthreshold

public

(default)

btree

 

id

 

 

sugarcontentnorainthreshold_pkey

sugarcontentnorainthreshold

public

(default)

btree

 

id

 

supplyresponse_id_key

supplyresponse

public

(default)

btree

 

id

 

 

supplyresponse_pkey

supplyresponse

public

(default)

btree

 

id

 

supplyresponsecropproduction_pkey

supplyresponsecropproduction

public

(default)

btree

 

supplyresponse_id, cropproduction_id

 

surveycroprotationelement_id_key

surveycroprotationelement

public

(default)

btree

 

id

 

 

surveycroprotationelement_pkey

surveycroprotationelement

public

(default)

btree

 

id

 

surveycroprotationelementcostsandlabour_pkey

surveycroprotationelementcostsandlabour

public

(default)

btree

 

surveycroprotationelement_id, costandlabourperregionalzone_id

 

surveycroprotationelementinputonsoilinmanagementprocedure_pkey

surveycroprotationelementinputonsoilinmanagementprocedure

public

(default)

btree

 

surveycroprotationelement_id, inputonsoilinmanagementprocedure_id

 

surveycroprotationelementproductonsoil_pkey

surveycroprotationelementproductonsoil

public

(default)

btree

 

surveycroprotationelement_id, productonsoil_id

 

tax_id_key

tax

public

(default)

btree

 

id

 

 

tax_pkey

tax

public

(default)

btree

 

id

 

temporalscale_id_key

temporalscale

public

(default)

btree

 

id

 

 

temporalscale_pkey

temporalscale

public

(default)

btree

 

id

 

texturalclasssoil_id_key

texturalclasssoil

public

(default)

btree

 

id

 

 

texturalclasssoil_pkey

texturalclasssoil

public

(default)

btree

 

id

 

theme_id_key

theme

public

(default)

btree

 

id

 

 

theme_pkey

theme

public

(default)

btree

 

id

 

tillageimplement_id_key

tillageimplement

public

(default)

btree

 

id

 

 

tillageimplement_pkey

tillageimplement

public

(default)

btree

 

id

 

tillagemachinebased_id_key

tillagemachinebased

public

(default)

btree

 

id

 

 

tillagemachinebased_pkey

tillagemachinebased

public

(default)

btree

 

id

 

tillageoperation_id_key

tillageoperation

public

(default)

btree

 

id

 

 

tillageoperation_pkey

tillageoperation

public

(default)

btree

 

id

 

tillagesimple_id_key

tillagesimple

public

(default)

btree

 

id

 

 

tillagesimple_pkey

tillagesimple

public

(default)

btree

 

id

 

timedecade_id_key

timedecade

public

(default)

btree

 

id

 

 

timedecade_pkey

timedecade

public

(default)

btree

 

id

 

timeperiod_id_key

timeperiod

public

(default)

btree

 

id

 

 

timeperiod_pkey

timeperiod

public

(default)

btree

 

id

 

tradereformproposal_id_key

tradereformproposal

public

(default)

btree

 

id

 

 

tradereformproposal_pkey

tradereformproposal

public

(default)

btree

 

id

 

tradereformproposalcut_id_key

tradereformproposalcut

public

(default)

btree

 

id

 

 

tradereformproposalcut_pkey

tradereformproposalcut

public

(default)

btree

 

id

 

tradereformproposaltradereformproposalcuts_pkey

tradereformproposaltradereformproposalcuts

public

(default)

btree

 

tradereformproposal_id, tradereformproposalcut_id

 

transitionprobability_id_key

transitionprobability

public

(default)

btree

 

id

 

 

transitionprobability_pkey

transitionprobability

public

(default)

btree

 

id

 

treestart_id_key

treestart

public

(default)

btree

 

id

 

 

treestart_pkey

treestart

public

(default)

btree

 

id

 

upscalingprocedure_id_key

upscalingprocedure

public

(default)

btree

 

id

 

 

upscalingprocedure_pkey

upscalingprocedure

public

(default)

btree

 

id

 

user__id_key

user_

public

(default)

btree

 

id

 

 

user__pkey

user_

public

(default)

btree

 

id

 

user_roles_pkey

user_roles

public

(default)

btree

 

user__id, role__id

 

vineyardharvest_id_key

vineyardharvest

public

(default)

btree

 

id

 

 

vineyardharvest_pkey

vineyardharvest

public

(default)

btree

 

id

 

volumestones_id_key

volumestones

public

(default)

btree

 

id

 

 

volumestones_pkey

volumestones

public

(default)

btree

 

id

 

watermanagement_id_key

watermanagement

public

(default)

btree

 

id

 

 

watermanagement_pkey

watermanagement

public

(default)

btree

 

id

 

watermanagementcrops_pkey

watermanagementcrops

public

(default)

btree

 

watermanagement_id, crop_id

 

yieldenergyproteinoffeedproduct_id_key

yieldenergyproteinoffeedproduct

public

(default)

btree

 

id

 

 

yieldenergyproteinoffeedproduct_pkey

yieldenergyproteinoffeedproduct

public

(default)

btree

 

id

 

yieldenergyproteinofgrass_id_key

yieldenergyproteinofgrass

public

(default)

btree

 

id

 

 

yieldenergyproteinofgrass_pkey

yieldenergyproteinofgrass

public

(default)

btree

 

id

 

yieldgrowth_id_key

yieldgrowth

public

(default)

btree

 

id

 

 

yieldgrowth_pkey

yieldgrowth

public

(default)

btree

 

id

 

yieldofcropproduct_id_key

yieldofcropproduct

public

(default)

btree

 

id

 

 

yieldofcropproduct_pkey

yieldofcropproduct

public

(default)

btree

 

id

 

yieldtrend_id_key

yieldtrend

public

(default)

btree

 

id

 

 

yieldtrend_pkey

yieldtrend

public

(default)

btree

 

id

 

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