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

Table: livestockinformation

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

Livestock information holds all the variables in FADN related to livestockhttp://ontologies.seamless-ip.org/farm.owl#LivestockInformation

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

averagenumberbees

real

 

 

 

 

 

 

 

averagenumberbreedingheifers

real

 

 

 

 

 

 

 

averagenumberbreedingsows

real

 

 

 

 

 

 

 

averagenumbercalves

real

 

 

 

 

 

 

 

averagenumberdairycows

real

 

 

 

 

 

 

 

averagenumberdairycullcows

real

 

 

 

 

 

 

 

averagenumberequines

real

 

 

 

 

 

 

 

averagenumberewes

real

 

 

 

 

 

 

 

averagenumberfemalecattleonetotwo

real

 

 

 

 

 

 

 

averagenumbergoats

real

 

 

 

 

 

 

 

averagenumberheifersfattening

real

 

 

 

 

 

 

 

averagenumberlayinghens

real

 

 

 

 

 

 

 

averagenumbermalecattlemorethantwo

real

 

 

 

 

 

 

 

averagenumbermalecattleonetotwo

real

 

 

 

 

 

 

 

averagenumberotheranimals

real

 

 

 

 

 

 

 

averagenumberothercattlelessoneyear

real

 

 

 

 

 

 

 

averagenumberothercows

real

 

 

 

 

 

 

 

averagenumberothergoats

real

 

 

 

 

 

 

 

averagenumberotherpigs

real

 

 

 

 

 

 

 

averagenumberotherpoultry

real

 

 

 

 

 

 

 

averagenumberothersheep

real

 

 

 

 

 

 

 

averagenumberpiglets

real

 

 

 

 

 

 

 

averagenumberpigsfattening

real

 

 

 

 

 

 

 

averagenumberrabbits

real

 

 

 

 

 

 

 

averagenumbertablechickens

real

 

 

 

 

 

 

 

closingbees

real

 

 

 

 

 

 

 

closingbreedingheifers

real

 

 

 

 

 

 

 

closingbreedingsows

real

 

 

 

 

 

 

 

closingcalves

real

 

 

 

 

 

 

 

closingdairycows

real

 

 

 

 

 

 

 

closingdairycullcows

real

 

 

 

 

 

 

 

closingequines

real

 

 

 

 

 

 

 

closingewes

real

 

 

 

 

 

 

 

closingfemalecattleonetotwo

real

 

 

 

 

 

 

 

closinggoats

real

 

 

 

 

 

 

 

closingheifersfattening

real

 

 

 

 

 

 

 

closinglayinghens

real

 

 

 

 

 

 

 

closingmalecattlemorethantwo

real

 

 

 

 

 

 

 

closingmalecattleonetotwo

real

 

 

 

 

 

 

 

closingotheranimals

real

 

 

 

 

 

 

 

closingothercattlelessoneyear

real

 

 

 

 

 

 

 

closingothercows

real

 

 

 

 

 

 

 

closingothergoats

real

 

 

 

 

 

 

 

closingotherpigs

real

 

 

 

 

 

 

 

closingotherpoultry

real

 

 

 

 

 

 

 

closingothersheep

real

 

 

 

 

 

 

 

closingpiglets

real

 

 

 

 

 

 

 

closingpigsfattening

real

 

 

 

 

 

 

 

closingrabbits

real

 

 

 

 

 

 

 

closingtablechickens

real

 

 

 

 

 

 

 

closingvaluebees

real

 

 

 

 

 

 

 

closingvaluebreedingheifers

real

 

 

 

 

 

 

 

closingvaluebreedingsows

real

 

 

 

 

 

 

 

closingvaluecalves

real

 

 

 

 

 

 

 

closingvaluedairycows

real

 

 

 

 

 

 

 

closingvaluedairycullcows

real

 

 

 

 

 

 

 

closingvalueequines

real

 

 

 

 

 

 

 

closingvalueewes

real

 

 

 

 

 

 

 

closingvaluefemalecattleonetotwo

real

 

 

 

 

 

 

 

closingvaluegoats

real

 

 

 

 

 

 

 

closingvalueheifersfattening

real

 

 

 

 

 

 

 

closingvaluelayinghens

real

 

 

 

 

 

 

 

closingvaluemalecattlemorethantwo

real

 

 

 

 

 

 

 

closingvaluemalecattleonetotwo

real

 

 

 

 

 

 

 

closingvalueotheranimals

real

 

 

 

 

 

 

 

closingvalueothercattlelessoneyear

real

 

 

 

 

 

 

 

closingvalueothercows

real

 

 

 

 

 

 

 

closingvalueothergoats

real

 

 

 

 

 

 

 

closingvalueotherpigs

real

 

 

 

 

 

 

 

closingvalueotherpoultry

real

 

 

 

 

 

 

 

closingvalueothersheep

real

 

 

 

 

 

 

 

closingvaluepiglets

real

 

 

 

 

 

 

 

closingvaluepigsfattening

real

 

 

 

 

 

 

 

closingvaluerabbits

real

 

 

 

 

 

 

 

closingvaluetablechickens

real

 

 

 

 

 

 

 

closingvaluetotallivestock

real

 

 

 

 

 

 

 

coarsefodderpurchased

real

 

 

 

 

 

 

 

concentrates

real

 

 

 

 

 

 

 

cowsmilk

real

 

 

 

 

 

 

 

cowsmilkproducts

real

 

 

 

 

 

 

 

daysgrazingmountain

real

 

 

 

 

 

 

 

feedgrazinglivestock

real

 

 

 

 

 

 

 

feedingstuffspigspoultry

real

 

 

 

 

 

 

 

homegrownfeedgrazinglivestock

real

 

 

 

 

 

 

 

homegrownfeedpigspoultry

real

 

 

 

 

 

 

islivestockinformationof

bigint

 

 

 

 

 

 

 

livestockunits

real

 

 

 

 

 

 

 

livestockunitsaverage

real

 

 

 

 

 

 

 

livestockunitsaveragemax

real

 

 

 

 

 

 

 

livestockunitsaveragemin

real

 

 

 

 

 

 

 

livestockunitsaveragesd

real

 

 

 

 

 

 

 

livestockunitsdairycows

real

 

 

 

 

 

 

 

livestockunitsothercattle

real

 

 

 

 

 

 

 

livestockunitspigs

real

 

 

 

 

 

 

 

livestockunitspoultry

real

 

 

 

 

 

 

 

livestockunitssheepgoats

real

 

 

 

 

 

 

 

milkyieldaverage

real

 

 

 

 

 

 

 

milkyieldaveragemax

real

 

 

 

 

 

 

 

milkyieldaveragemin

real

 

 

 

 

 

 

 

milkyieldaveragesd

real

 

 

 

 

 

 

 

openingbees

real

 

 

 

 

 

 

 

openingbreedingheifers

real

 

 

 

 

 

 

 

openingbreedingsows

real

 

 

 

 

 

 

 

openingcalves

real

 

 

 

 

 

 

 

openingdairycows

real

 

 

 

 

 

 

 

openingdairycullcows

real

 

 

 

 

 

 

 

openingequines

real

 

 

 

 

 

 

 

openingewes

real

 

 

 

 

 

 

 

openingfemalecattleonetotwo

real

 

 

 

 

 

 

 

openinggoats

real

 

 

 

 

 

 

 

openingheifersfattening

real

 

 

 

 

 

 

 

openinglayinghens

real

 

 

 

 

 

 

 

openingmalecattlemorethantwo

real

 

 

 

 

 

 

 

openingmalecattleonetotwo

real

 

 

 

 

 

 

 

openingotheranimals

real

 

 

 

 

 

 

 

openingothercattlelessoneyear

real

 

 

 

 

 

 

 

openingothercows

real

 

 

 

 

 

 

 

openingothergoats

real

 

 

 

 

 

 

 

openingotherpigs

real

 

 

 

 

 

 

 

openingotherpoultry

real

 

 

 

 

 

 

 

openingothersheep

real

 

 

 

 

 

 

 

openingpiglets

real

 

 

 

 

 

 

 

openingpigsfattening

real

 

 

 

 

 

 

 

openingrabbits

real

 

 

 

 

 

 

 

openingtablechickens

real

 

 

 

 

 

 

 

openingvaluebees

real

 

 

 

 

 

 

 

openingvaluebreedingheifers

real

 

 

 

 

 

 

 

openingvaluebreedingsows

real

 

 

 

 

 

 

 

openingvaluecalves

real

 

 

 

 

 

 

 

openingvaluedairycows

real

 

 

 

 

 

 

 

openingvaluedairycullcows

real

 

 

 

 

 

 

 

openingvalueequines

real

 

 

 

 

 

 

 

openingvalueewes

real

 

 

 

 

 

 

 

openingvaluefemalecattleonetotwo

real

 

 

 

 

 

 

 

openingvaluegoats

real

 

 

 

 

 

 

 

openingvalueheifersfattening

real

 

 

 

 

 

 

 

openingvaluelayinghens

real

 

 

 

 

 

 

 

openingvaluemalecattlemorethantwo

real

 

 

 

 

 

 

 

openingvaluemalecattleonetotwo

real

 

 

 

 

 

 

 

openingvalueotheranimals

real

 

 

 

 

 

 

 

openingvalueothercattlelessoneyear

real

 

 

 

 

 

 

 

openingvalueothercows

real

 

 

 

 

 

 

 

openingvalueothergoats

real

 

 

 

 

 

 

 

openingvalueotherpigs

real

 

 

 

 

 

 

 

openingvalueotherpoultry

real

 

 

 

 

 

 

 

openingvalueothersheep

real

 

 

 

 

 

 

 

openingvaluepiglets

real

 

 

 

 

 

 

 

openingvaluepigsfattening

real

 

 

 

 

 

 

 

openingvaluerabbits

real

 

 

 

 

 

 

 

openingvaluetablechickens

real

 

 

 

 

 

 

 

openingvaluetotallivestock

real

 

 

 

 

 

 

 

otherlivestockspecificcosts

real

 

 

 

 

 

 

 

outputanimalproducts

real

 

 

 

 

 

 

 

outputbeefveal

real

 

 

 

 

 

 

 

outputchangelivestockvalue

real

 

 

 

 

 

 

 

outputcowsmilk

real

 

 

 

 

 

 

 

outputeggs

real

 

 

 

 

 

 

 

outputewsgoatsmilk

real

 

 

 

 

 

 

 

outputlivestock

real

 

 

 

 

 

 

 

outputotherlivestock

real

 

 

 

 

 

 

 

outputpigmeat

real

 

 

 

 

 

 

 

outputpoultry

real

 

 

 

 

 

 

 

outputsheepgoats

real

 

 

 

 

 

 

 

stockingdensity

real

 

 

 

 

 

 

 

subsideslivestock

real

 

 

 

 

 

 

 

subsidiesdairying

real

 

 

 

 

 

 

 

subsidiesothercattle

real

 

 

 

 

 

 

 

subsidiesotherlivestock

real

 

 

 

 

 

 

 

subsidiessheepgoats

real

 

 

 

 

 

 

 

totalinputs

real

 

 

 

 

 

 

 

yieldmilk

real

 

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fkd4f989425b19c896

islivestockinformationof

public.representativefarm

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table livestockinformation

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

livestockinformation_id_key

btree

 

id

 

 

livestockinformation_pkey

btree

 

id

 

 

Triggers

There are no triggers for table livestockinformation

 

Rules

There are no rules for table livestockinformation

 

Referenced

There are no tables referenced by table livestockinformation

 

Options

Option

Value

Inherited From

 

Rows

90291

Pages

8210

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."livestockinformation" (
 "id" BIGINT NOT NULL,
 "averagenumberbees" REAL,
 "averagenumberbreedingheifers" REAL,
 "averagenumberbreedingsows" REAL,
 "averagenumbercalves" REAL,
 "averagenumberdairycows" REAL,
 "averagenumberdairycullcows" REAL,
 "averagenumberequines" REAL,
 "averagenumberewes" REAL,
 "averagenumberfemalecattleonetotwo" REAL,
 "averagenumbergoats" REAL,
 "averagenumberheifersfattening" REAL,
 "averagenumberlayinghens" REAL,
 "averagenumbermalecattlemorethantwo" REAL,
 "averagenumbermalecattleonetotwo" REAL,
 "averagenumberotheranimals" REAL,
 "averagenumberothercattlelessoneyear" REAL,
 "averagenumberothercows" REAL,
 "averagenumberothergoats" REAL,
 "averagenumberotherpigs" REAL,
 "averagenumberotherpoultry" REAL,
 "averagenumberothersheep" REAL,
 "averagenumberpiglets" REAL,
 "averagenumberpigsfattening" REAL,
 "averagenumberrabbits" REAL,
 "averagenumbertablechickens" REAL,
 "closingbees" REAL,
 "closingbreedingheifers" REAL,
 "closingbreedingsows" REAL,
 "closingcalves" REAL,
 "closingdairycows" REAL,
 "closingdairycullcows" REAL,
 "closingequines" REAL,
 "closingewes" REAL,
 "closingfemalecattleonetotwo" REAL,
 "closinggoats" REAL,
 "closingheifersfattening" REAL,
 "closinglayinghens" REAL,
 "closingmalecattlemorethantwo" REAL,
 "closingmalecattleonetotwo" REAL,
 "closingotheranimals" REAL,
 "closingothercattlelessoneyear" REAL,
 "closingothercows" REAL,
 "closingothergoats" REAL,
 "closingotherpigs" REAL,
 "closingotherpoultry" REAL,
 "closingothersheep" REAL,
 "closingpiglets" REAL,
 "closingpigsfattening" REAL,
 "closingrabbits" REAL,
 "closingtablechickens" REAL,
 "closingvaluebees" REAL,
 "closingvaluebreedingheifers" REAL,
 "closingvaluebreedingsows" REAL,
 "closingvaluecalves" REAL,
 "closingvaluedairycows" REAL,
 "closingvaluedairycullcows" REAL,
 "closingvalueequines" REAL,
 "closingvalueewes" REAL,
 "closingvaluefemalecattleonetotwo" REAL,
 "closingvaluegoats" REAL,
 "closingvalueheifersfattening" REAL,
 "closingvaluelayinghens" REAL,
 "closingvaluemalecattlemorethantwo" REAL,
 "closingvaluemalecattleonetotwo" REAL,
 "closingvalueotheranimals" REAL,
 "closingvalueothercattlelessoneyear" REAL,
 "closingvalueothercows" REAL,
 "closingvalueothergoats" REAL,
 "closingvalueotherpigs" REAL,
 "closingvalueotherpoultry" REAL,
 "closingvalueothersheep" REAL,
 "closingvaluepiglets" REAL,
 "closingvaluepigsfattening" REAL,
 "closingvaluerabbits" REAL,
 "closingvaluetablechickens" REAL,
 "closingvaluetotallivestock" REAL,
 "coarsefodderpurchased" REAL,
 "concentrates" REAL,
 "cowsmilk" REAL,
 "cowsmilkproducts" REAL,
 "daysgrazingmountain" REAL,
 "feedgrazinglivestock" REAL,
 "feedingstuffspigspoultry" REAL,
 "homegrownfeedgrazinglivestock" REAL,
 "homegrownfeedpigspoultry" REAL,
 "islivestockinformationof" BIGINT,
 "livestockunits" REAL,
 "livestockunitsaverage" REAL,
 "livestockunitsaveragemax" REAL,
 "livestockunitsaveragemin" REAL,
 "livestockunitsaveragesd" REAL,
 "livestockunitsdairycows" REAL,
 "livestockunitsothercattle" REAL,
 "livestockunitspigs" REAL,
 "livestockunitspoultry" REAL,
 "livestockunitssheepgoats" REAL,
 "milkyieldaverage" REAL,
 "milkyieldaveragemax" REAL,
 "milkyieldaveragemin" REAL,
 "milkyieldaveragesd" REAL,
 "openingbees" REAL,
 "openingbreedingheifers" REAL,
 "openingbreedingsows" REAL,
 "openingcalves" REAL,
 "openingdairycows" REAL,
 "openingdairycullcows" REAL,
 "openingequines" REAL,
 "openingewes" REAL,
 "openingfemalecattleonetotwo" REAL,
 "openinggoats" REAL,
 "openingheifersfattening" REAL,
 "openinglayinghens" REAL,
 "openingmalecattlemorethantwo" REAL,
 "openingmalecattleonetotwo" REAL,
 "openingotheranimals" REAL,
 "openingothercattlelessoneyear" REAL,
 "openingothercows" REAL,
 "openingothergoats" REAL,
 "openingotherpigs" REAL,
 "openingotherpoultry" REAL,
 "openingothersheep" REAL,
 "openingpiglets" REAL,
 "openingpigsfattening" REAL,
 "openingrabbits" REAL,
 "openingtablechickens" REAL,
 "openingvaluebees" REAL,
 "openingvaluebreedingheifers" REAL,
 "openingvaluebreedingsows" REAL,
 "openingvaluecalves" REAL,
 "openingvaluedairycows" REAL,
 "openingvaluedairycullcows" REAL,
 "openingvalueequines" REAL,
 "openingvalueewes" REAL,
 "openingvaluefemalecattleonetotwo" REAL,
 "openingvaluegoats" REAL,
 "openingvalueheifersfattening" REAL,
 "openingvaluelayinghens" REAL,
 "openingvaluemalecattlemorethantwo" REAL,
 "openingvaluemalecattleonetotwo" REAL,
 "openingvalueotheranimals" REAL,
 "openingvalueothercattlelessoneyear" REAL,
 "openingvalueothercows" REAL,
 "openingvalueothergoats" REAL,
 "openingvalueotherpigs" REAL,
 "openingvalueotherpoultry" REAL,
 "openingvalueothersheep" REAL,
 "openingvaluepiglets" REAL,
 "openingvaluepigsfattening" REAL,
 "openingvaluerabbits" REAL,
 "openingvaluetablechickens" REAL,
 "openingvaluetotallivestock" REAL,
 "otherlivestockspecificcosts" REAL,
 "outputanimalproducts" REAL,
 "outputbeefveal" REAL,
 "outputchangelivestockvalue" REAL,
 "outputcowsmilk" REAL,
 "outputeggs" REAL,
 "outputewsgoatsmilk" REAL,
 "outputlivestock" REAL,
 "outputotherlivestock" REAL,
 "outputpigmeat" REAL,
 "outputpoultry" REAL,
 "outputsheepgoats" REAL,
 "stockingdensity" REAL,
 "subsideslivestock" REAL,
 "subsidiesdairying" REAL,
 "subsidiesothercattle" REAL,
 "subsidiesotherlivestock" REAL,
 "subsidiessheepgoats" REAL,
 "totalinputs" REAL,
 "yieldmilk" REAL,
 CONSTRAINT "livestockinformation_id_key" UNIQUE("id"),
 CONSTRAINT "livestockinformation_pkey" PRIMARY KEY("id"),
 CONSTRAINT "fkd4f989425b19c896" FOREIGN KEY ("islivestockinformationof")
   REFERENCES "public"."representativefarm"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."livestockinformation"
IS 'Livestock information holds all the variables in FADN related to livestockhttp://ontologies.seamless-ip.org/farm.owl#LivestockInformation';

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