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

Table: representativefarm

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

The representative farm holds the data on a collection of farms found in a Nuts-2, with a specialisation, intensity-class and size-class, for example an arable-specialised crops farm in the Flevoland region with medium intensity and large size-class.http://ontologies.seamless-ip.org/farm.owl#RepresentativeFarm

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

annualworkingunits

real

 

 

 

 

 

 

 

annualworkingunitsaverage

real

 

 

 

 

 

 

 

annualworkingunitsaveragemax

real

 

 

 

 

 

 

 

annualworkingunitsaveragemin

real

 

 

 

 

 

 

 

annualworkingunitsaveragesd

real

 

 

 

 

 

 

 

areaenvironmentalrestrictions

real

 

 

 

 

 

 

 

areawoodland

real

 

 

 

 

 

 

 

assetstotal

real

 

 

 

 

 

 

 

assetstotalaverage

real

 

 

 

 

 

 

 

assetstotalaveragemax

real

 

 

 

 

 

 

 

assetstotalaveragemin

real

 

 

 

 

 

 

 

assetstotalaveragesd

real

 

 

 

 

 

 

 

assetstotalcurrent

real

 

 

 

 

 

 

 

assetstotalfixed

real

 

 

 

 

 

 

 

awucasualpaidlabour

real

 

 

 

 

 

 

 

awucasualunpaidlabour

real

 

 

 

 

 

 

 

awuholder1

real

 

 

 

 

 

 

 

awuholder2

real

 

 

 

 

 

 

 

awuholder3

real

 

 

 

 

 

 

 

awuholdernotmanager

real

 

 

 

 

 

 

 

awumanagernotholder

real

 

 

 

 

 

 

 

awumanagerpaid

real

 

 

 

 

 

 

 

awuotherspaid

real

 

 

 

 

 

 

 

awuothersunpaid

real

 

 

 

 

 

 

 

awupaidlabour

real

 

 

 

 

 

 

 

awuspouse

real

 

 

 

 

 

 

 

awuunpaidlabour

real

 

 

 

 

 

 

 

balancesubsidiestaxes

real

 

 

 

 

 

 

 

balancesubsidiestaxesoninvestment

real

 

 

 

 

 

 

 

breedinglivestock

real

 

 

 

 

 

 

 

buildings

real

 

 

 

 

 

 

 

capitalfixedclosingvalue

real

 

 

 

 

 

 

 

cashflow1

real

 

 

 

 

 

 

 

cashflow2

real

 

 

 

 

 

 

 

closingagriculturalland

real

 

 

 

 

 

 

 

closinglandandbuilding

real

 

 

 

 

 

 

 

closinglandimprovements

real

 

 

 

 

 

 

 

closinglongmediumloans

real

 

 

 

 

 

 

 

closingmachineryandequipment

real

 

 

 

 

 

 

 

closingshortloans

real

 

 

 

 

 

 

 

closingtotaldebts

real

 

 

 

 

 

 

 

closingvaluecapital

real

 

 

 

 

 

 

 

compensatorypayments

real

 

 

 

 

 

 

 

contractwork

real

 

 

 

 

 

 

cropinformation

bigint

 

 

 

 

 

 

 

depreciation

real

 

 

 

 

 

 

 

description

varchar(255)

 

 

 

 

 

 

 

economicsizeclass

real

 

 

 

 

 

 

 

electricitycosts

real

 

 

 

 

 

 

 

energycosts

real

 

 

 

 

 

 

 

esu

real

 

 

 

 

 

 

 

esuaverage

real

 

 

 

 

 

 

 

esuaveragemax

real

 

 

 

 

 

 

 

esuaveragemin

real

 

 

 

 

 

 

 

esuaveragesd

real

 

 

 

 

 

 

 

externalfactors

real

 

 

 

 

 

 

fadnregion

bigint

 

 

 

 

 

 

 

farmcapitalaverage

real

 

 

 

 

 

 

 

farmfamilyincome

real

 

 

 

 

 

 

 

farmfamilyincomeaverage

real

 

 

 

 

 

 

 

farmfamilyincomeaveragemax

real

 

 

 

 

 

 

 

farmfamilyincomeaveragemin

real

 

 

 

 

 

 

 

farmfamilyincomeaveragesd

real

 

 

 

 

 

 

 

farmincomefamilyperfamilyworkingunit

real

 

 

 

 

 

 

 

farmincomegross

real

 

 

 

 

 

 

 

farmingoverhead

real

 

 

 

 

 

 

 

farmsaltitude300to600

real

 

 

 

 

 

 

 

farmsaltitudeabove600

real

 

 

 

 

 

 

 

farmsaltitudeless300

real

 

 

 

 

 

 

 

farmsaltitudenodata

real

 

 

 

 

 

 

 

farmsconventional

real

 

 

 

 

 

 

 

farmsconversion

real

 

 

 

 

 

 

 

farmslfamountain

real

 

 

 

 

 

 

 

farmslfanotmountain

real

 

 

 

 

 

 

 

farmslfanotrelevant

real

 

 

 

 

 

 

 

farmsnotlfa

real

 

 

 

 

 

 

 

farmsorganic

real

 

 

 

 

 

 

 

farmtourism

real

 

 

 

 

 

 

 

forestryspecificcosts

real

 

 

 

 

 

 

 

grossinvestments

real

 

 

 

 

 

 

 

grossinvestmentsaverage

real

 

 

 

 

 

 

 

grossinvestmentsaveragemax

real

 

 

 

 

 

 

 

grossinvestmentsaveragemin

real

 

 

 

 

 

 

 

grossinvestmentsaveragesd

real

 

 

 

 

 

 

 

heatingfuelscosts

real

 

 

 

 

 

 

 

hourscasualpaidlabour

real

 

 

 

 

 

 

 

hourscasualunpaidlabour

real

 

 

 

 

 

 

 

hoursholder1

real

 

 

 

 

 

 

 

hoursholder2

real

 

 

 

 

 

 

 

hoursholder3

real

 

 

 

 

 

 

 

hoursholdernotmanager

real

 

 

 

 

 

 

 

hoursmanagernotholder

real

 

 

 

 

 

 

 

hoursmanagerpaid

real

 

 

 

 

 

 

 

hoursotherspaid

real

 

 

 

 

 

 

 

hoursothersunpaid

real

 

 

 

 

 

 

 

hoursspouse

real

 

 

 

 

 

 

intensity

bigint

 

 

 

 

 

 

 

interestpaid

real

 

 

 

 

 

 

 

investmentsaftersubsidies

real

 

 

 

 

 

 

 

investmentsbeforesubsidies

real

 

 

 

 

 

 

 

investmentslandimprovementaftersubsidies

real

 

 

 

 

 

 

 

investmentslandimprovementbeforesubsidies

real

 

 

 

 

 

 

 

labourinputs

real

 

 

 

 

 

 

 

labourinputspaid

real

 

 

 

 

 

 

 

labourinputsunpaid

real

 

 

 

 

 

 

 

landpermanentcropquotas

real

 

 

 

 

 

 

 

liabilitiestotal

real

 

 

 

 

 

 

 

liabilitiestotalaverage

real

 

 

 

 

 

 

 

liabilitiestotalaveragemax

real

 

 

 

 

 

 

 

liabilitiestotalaveragemin

real

 

 

 

 

 

 

 

liabilitiestotalaveragesd

real

 

 

 

 

 

 

 

loansmediumlong

real

 

 

 

 

 

 

 

loansshort

real

 

 

 

 

 

 

 

machinery

real

 

 

 

 

 

 

 

machineryandbuildings

real

 

 

 

 

 

 

memberof

bigint

 

 

 

 

 

 

 

netinvestments

real

 

 

 

 

 

 

 

netvalueadded

real

 

 

 

 

 

 

 

netvalueaddedaverage

real

 

 

 

 

 

 

 

netvalueaddedaveragemax

real

 

 

 

 

 

 

 

netvalueaddedaveragemin

real

 

 

 

 

 

 

 

netvalueaddedaveragesd

real

 

 

 

 

 

 

 

netvalueaddedawu

real

 

 

 

 

 

 

 

networth

real

 

 

 

 

 

 

 

networthchange

real

 

 

 

 

 

 

 

nonbreedinglivestock

real

 

 

 

 

 

 

 

othercirculatingcapital

real

 

 

 

 

 

 

 

otherdirectinputs

real

 

 

 

 

 

 

 

otheroutput

real

 

 

 

 

 

 

 

outputfarmconsumption

real

 

 

 

 

 

 

 

outputfarmuse

real

 

 

 

 

 

 

 

paymentsdairyoutgoers

real

 

 

 

 

 

 

 

rentedutilisedagriculturalarea

real

 

 

 

 

 

 

 

rentpaid

real

 

 

 

 

 

 

 

representedfarms

real

 

 

 

 

 

 

 

representedfarms2013

real

 

 

 

 

 

 

 

representedfarms2020

real

 

 

 

 

 

 

 

samplefarms

real

 

 

 

 

 

 

size_

bigint

 

 

 

 

 

 

specialization

bigint

 

 

 

 

 

 

 

specificcosts

real

 

 

 

 

 

 

 

stocksagriculturalproducts

real

 

 

 

 

 

 

 

structuralfundsarea

real

 

 

 

 

 

 

 

subsidiesdisasters

real

 

 

 

 

 

 

 

subsidiesenvironmental

real

 

 

 

 

 

 

 

subsidiesintermediateconsumption

real

 

 

 

 

 

 

 

subsidiesinvestments

real

 

 

 

 

 

 

 

subsidieslfa

real

 

 

 

 

 

 

 

subsidiesother

real

 

 

 

 

 

 

 

taxes

real

 

 

 

 

 

 

 

totalfarminput

real

 

 

 

 

 

 

 

totalfarmoutput

real

 

 

 

 

 

 

 

totalintermediateconsumption

real

 

 

 

 

 

 

 

totaloutput

real

 

 

 

 

 

 

 

totaloutputaverage

real

 

 

 

 

 

 

 

totaloutputaveragemax

real

 

 

 

 

 

 

 

totaloutputaveragemin

real

 

 

 

 

 

 

 

totaloutputaveragesd

real

 

 

 

 

 

 

 

totalsubsidies

real

 

 

 

 

 

 

 

upkeepmachineryequipment

real

 

 

 

 

 

 

 

upkeepofmachineryandequipment

real

 

 

 

 

 

 

 

utilisedagriculturalarea

real

 

 

 

 

 

 

 

utilisedagriculturalareaaverage

real

 

 

 

 

 

 

 

utilisedagriculturalareaaveragemax

real

 

 

 

 

 

 

 

utilisedagriculturalareaaveragemin

real

 

 

 

 

 

 

 

utilisedagriculturalareaaveragesd

real

 

 

 

 

 

 

 

vatinvestments

real

 

 

 

 

 

 

 

wagespaid

real

 

 

 

 

 

 

 

watercosts

real

 

 

 

 

 

 

 

year_

integer

 

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk34b54b93412d2eb5

size_

public.farmsize

id

No Action

No Action

 

Immediate

 

fk34b54b936138dc32

fadnregion

public.fadnregion

id

No Action

No Action

 

Immediate

 

fk34b54b9372f345cc

specialization

public.farmspecialization

id

No Action

No Action

 

Immediate

 

fk34b54b93bac773f0

intensity

public.farmintensity

id

No Action

No Action

 

Immediate

 

fk34b54b93bf3f37dd

memberof

public.representativefarmgroup

id

No Action

No Action

 

Immediate

 

fk34b54b93f9858038

cropinformation

public.cropinformation

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table representativefarm

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

representativefarm_id_key

btree

 

id

 

 

representativefarm_pkey

btree

 

id

 

 

Triggers

There are no triggers for table representativefarm

 

Rules

There are no rules for table representativefarm

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

agriculturalactivityperfarm

public

fkf575b6e55359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

contextrepresentativefarm

public

fka558736271c715da

representativefarm_id

public.representativefarm

id

No Action

No Action

 

Immediate

 

farmconstraint

public

fk603f4ad35359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

farmquota

public

fk343b47c25359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

fssimarablefarm

public

fke04d40205359ffa68364404b

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

fssimlivestockfarm

public

fke04d40205359ffa6dd3e4056

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

indicatorvalueactivity

public

fk924295f18c89bc89

farm

public.representativefarm

id

No Action

No Action

 

Immediate

 

indicatorvaluecrop

public

fk851e1e728c89bc89

farm

public.representativefarm

id

No Action

No Action

 

Immediate

 

indicatorvaluefarm

public

fk851f3c188c89bc89

farm

public.representativefarm

id

No Action

No Action

 

Immediate

 

indicatorvaluefarmagrienvironmentalzone

public

fkcc618db58c89bc89

farm

public.representativefarm

id

No Action

No Action

 

Immediate

 

livestockinformation

public

fkd4f989425b19c896

islivestockinformationof

public.representativefarm

id

No Action

No Action

 

Immediate

 

representativefarminagrienvregion

public

fkcf0070ac5359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

rotationwithproductionorientationforfarm

public

fk68be14ec5359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

subsidy

public

fkf3e7138b5359ffa6

representativefarm

public.representativefarm

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

97216

Pages

7592

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."representativefarm" (
 "id" BIGINT NOT NULL,
 "annualworkingunits" REAL,
 "annualworkingunitsaverage" REAL,
 "annualworkingunitsaveragemax" REAL,
 "annualworkingunitsaveragemin" REAL,
 "annualworkingunitsaveragesd" REAL,
 "areaenvironmentalrestrictions" REAL,
 "areawoodland" REAL,
 "assetstotal" REAL,
 "assetstotalaverage" REAL,
 "assetstotalaveragemax" REAL,
 "assetstotalaveragemin" REAL,
 "assetstotalaveragesd" REAL,
 "assetstotalcurrent" REAL,
 "assetstotalfixed" REAL,
 "awucasualpaidlabour" REAL,
 "awucasualunpaidlabour" REAL,
 "awuholder1" REAL,
 "awuholder2" REAL,
 "awuholder3" REAL,
 "awuholdernotmanager" REAL,
 "awumanagernotholder" REAL,
 "awumanagerpaid" REAL,
 "awuotherspaid" REAL,
 "awuothersunpaid" REAL,
 "awupaidlabour" REAL,
 "awuspouse" REAL,
 "awuunpaidlabour" REAL,
 "balancesubsidiestaxes" REAL,
 "balancesubsidiestaxesoninvestment" REAL,
 "breedinglivestock" REAL,
 "buildings" REAL,
 "capitalfixedclosingvalue" REAL,
 "cashflow1" REAL,
 "cashflow2" REAL,
 "closingagriculturalland" REAL,
 "closinglandandbuilding" REAL,
 "closinglandimprovements" REAL,
 "closinglongmediumloans" REAL,
 "closingmachineryandequipment" REAL,
 "closingshortloans" REAL,
 "closingtotaldebts" REAL,
 "closingvaluecapital" REAL,
 "compensatorypayments" REAL,
 "contractwork" REAL,
 "cropinformation" BIGINT,
 "depreciation" REAL,
 "description" VARCHAR(255),
 "economicsizeclass" REAL,
 "electricitycosts" REAL,
 "energycosts" REAL,
 "esu" REAL,
 "esuaverage" REAL,
 "esuaveragemax" REAL,
 "esuaveragemin" REAL,
 "esuaveragesd" REAL,
 "externalfactors" REAL,
 "fadnregion" BIGINT,
 "farmcapitalaverage" REAL,
 "farmfamilyincome" REAL,
 "farmfamilyincomeaverage" REAL,
 "farmfamilyincomeaveragemax" REAL,
 "farmfamilyincomeaveragemin" REAL,
 "farmfamilyincomeaveragesd" REAL,
 "farmincomefamilyperfamilyworkingunit" REAL,
 "farmincomegross" REAL,
 "farmingoverhead" REAL,
 "farmsaltitude300to600" REAL,
 "farmsaltitudeabove600" REAL,
 "farmsaltitudeless300" REAL,
 "farmsaltitudenodata" REAL,
 "farmsconventional" REAL,
 "farmsconversion" REAL,
 "farmslfamountain" REAL,
 "farmslfanotmountain" REAL,
 "farmslfanotrelevant" REAL,
 "farmsnotlfa" REAL,
 "farmsorganic" REAL,
 "farmtourism" REAL,
 "forestryspecificcosts" REAL,
 "grossinvestments" REAL,
 "grossinvestmentsaverage" REAL,
 "grossinvestmentsaveragemax" REAL,
 "grossinvestmentsaveragemin" REAL,
 "grossinvestmentsaveragesd" REAL,
 "heatingfuelscosts" REAL,
 "hourscasualpaidlabour" REAL,
 "hourscasualunpaidlabour" REAL,
 "hoursholder1" REAL,
 "hoursholder2" REAL,
 "hoursholder3" REAL,
 "hoursholdernotmanager" REAL,
 "hoursmanagernotholder" REAL,
 "hoursmanagerpaid" REAL,
 "hoursotherspaid" REAL,
 "hoursothersunpaid" REAL,
 "hoursspouse" REAL,
 "intensity" BIGINT,
 "interestpaid" REAL,
 "investmentsaftersubsidies" REAL,
 "investmentsbeforesubsidies" REAL,
 "investmentslandimprovementaftersubsidies" REAL,
 "investmentslandimprovementbeforesubsidies" REAL,
 "labourinputs" REAL,
 "labourinputspaid" REAL,
 "labourinputsunpaid" REAL,
 "landpermanentcropquotas" REAL,
 "liabilitiestotal" REAL,
 "liabilitiestotalaverage" REAL,
 "liabilitiestotalaveragemax" REAL,
 "liabilitiestotalaveragemin" REAL,
 "liabilitiestotalaveragesd" REAL,
 "loansmediumlong" REAL,
 "loansshort" REAL,
 "machinery" REAL,
 "machineryandbuildings" REAL,
 "memberof" BIGINT,
 "netinvestments" REAL,
 "netvalueadded" REAL,
 "netvalueaddedaverage" REAL,
 "netvalueaddedaveragemax" REAL,
 "netvalueaddedaveragemin" REAL,
 "netvalueaddedaveragesd" REAL,
 "netvalueaddedawu" REAL,
 "networth" REAL,
 "networthchange" REAL,
 "nonbreedinglivestock" REAL,
 "othercirculatingcapital" REAL,
 "otherdirectinputs" REAL,
 "otheroutput" REAL,
 "outputfarmconsumption" REAL,
 "outputfarmuse" REAL,
 "paymentsdairyoutgoers" REAL,
 "rentedutilisedagriculturalarea" REAL,
 "rentpaid" REAL,
 "representedfarms" REAL,
 "representedfarms2013" REAL,
 "representedfarms2020" REAL,
 "samplefarms" REAL,
 "size_" BIGINT,
 "specialization" BIGINT,
 "specificcosts" REAL,
 "stocksagriculturalproducts" REAL,
 "structuralfundsarea" REAL,
 "subsidiesdisasters" REAL,
 "subsidiesenvironmental" REAL,
 "subsidiesintermediateconsumption" REAL,
 "subsidiesinvestments" REAL,
 "subsidieslfa" REAL,
 "subsidiesother" REAL,
 "taxes" REAL,
 "totalfarminput" REAL,
 "totalfarmoutput" REAL,
 "totalintermediateconsumption" REAL,
 "totaloutput" REAL,
 "totaloutputaverage" REAL,
 "totaloutputaveragemax" REAL,
 "totaloutputaveragemin" REAL,
 "totaloutputaveragesd" REAL,
 "totalsubsidies" REAL,
 "upkeepmachineryequipment" REAL,
 "upkeepofmachineryandequipment" REAL,
 "utilisedagriculturalarea" REAL,
 "utilisedagriculturalareaaverage" REAL,
 "utilisedagriculturalareaaveragemax" REAL,
 "utilisedagriculturalareaaveragemin" REAL,
 "utilisedagriculturalareaaveragesd" REAL,
 "vatinvestments" REAL,
 "wagespaid" REAL,
 "watercosts" REAL,
 "year_" INTEGER,
 CONSTRAINT "representativefarm_id_key" UNIQUE("id"),
 CONSTRAINT "representativefarm_pkey" PRIMARY KEY("id"),
 CONSTRAINT "fk34b54b93412d2eb5" FOREIGN KEY ("size_")
   REFERENCES "public"."farmsize"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk34b54b936138dc32" FOREIGN KEY ("fadnregion")
   REFERENCES "public"."fadnregion"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk34b54b9372f345cc" FOREIGN KEY ("specialization")
   REFERENCES "public"."farmspecialization"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk34b54b93bac773f0" FOREIGN KEY ("intensity")
   REFERENCES "public"."farmintensity"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk34b54b93bf3f37dd" FOREIGN KEY ("memberof")
   REFERENCES "public"."representativefarmgroup"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk34b54b93f9858038" FOREIGN KEY ("cropinformation")
   REFERENCES "public"."cropinformation"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."representativefarm"
IS 'The representative farm holds the data on a collection of farms found in a Nuts-2, with a specialisation, intensity-class and size-class, for example an arable-specialised crops farm in the Flevoland region with medium intensity and large size-class.http://ontologies.seamless-ip.org/farm.owl#RepresentativeFarm';

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