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

Table: productionorientation

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

Value driven aims and restrictions of the agricultural activity that direct the input and output levels (Van Ittersum et al., 1997), for example integrated, organic, conventional or highly innovative.http://ontologies.seamless-ip.org/prodent.owl#ProductionOrientation

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

label_en

varchar(255)

 

 

 

 

 

 

 

label_gms

varchar(255)

 

 

 

 

 

 

conservationmanagement

bigint

 

 

 

 

 

 

 

maxnumberdifferentcrops

integer

 

 

 

 

 

 

 

maxrotationlength

integer

 

 

 

 

 

 

 

minrotationlength

integer

 

 

 

 

 

 

nutrientmanagement

bigint

 

 

 

 

 

 

watermanagement

bigint

 

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk46eb7f375e2b86f2

conservationmanagement

public.conservationmanagement

id

No Action

No Action

 

Immediate

 

fk46eb7f378aeddd82

watermanagement

public.watermanagement

id

No Action

No Action

 

Immediate

 

fk46eb7f37d1226406

nutrientmanagement

public.nutrientmanagement

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table productionorientation

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

productionorientation_id_key

btree

 

id

 

 

productionorientation_pkey

btree

 

id

 

 

Triggers

There are no triggers for table productionorientation

 

Rules

There are no rules for table productionorientation

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

alternativearableactivity

public

fk67c9182e8201447ce0991e27

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

animalactivity

public

fk67c9182e8201447c20b2f54b

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

arableactivity

public

fk67c9182e8201447ca8a7095a

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

contextproductionorientation

public

fk1811108ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

currentarableactivity

public

fk67c9182e8201447c679a8ef3

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

grasslandactivity

public

fk67c9182e8201447cb08742d0

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionactivity

public

fk67c9182e8201447c88eb3b08

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionorientationbeefmanagements

public

fk502ae995ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionorientationdairymanagements

public

fk84385d14ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionorientationgrassmanagementalternatives

public

fk5dd18de8ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionorientationsmallbeefruminantmanagements

public

fk69027624ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

productionorientationsmalldairyruminantmanagements

public

fk7a904575ce565fe8

productionorientation_id

public.productionorientation

id

No Action

No Action

 

Immediate

 

rotationwithproductionorientation

public

fkf2bc0338201447c

productionorientation

public.productionorientation

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

84

Pages

1

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."productionorientation" (
 "id" BIGINT NOT NULL,
 "label_en" VARCHAR(255),
 "label_gms" VARCHAR(255),
 "conservationmanagement" BIGINT,
 "maxnumberdifferentcrops" INTEGER,
 "maxrotationlength" INTEGER,
 "minrotationlength" INTEGER,
 "nutrientmanagement" BIGINT,
 "watermanagement" BIGINT,
 CONSTRAINT "productionorientation_id_key" UNIQUE("id"),
 CONSTRAINT "productionorientation_pkey" PRIMARY KEY("id"),
 CONSTRAINT "fk46eb7f375e2b86f2" FOREIGN KEY ("conservationmanagement")
   REFERENCES "public"."conservationmanagement"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk46eb7f378aeddd82" FOREIGN KEY ("watermanagement")
   REFERENCES "public"."watermanagement"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk46eb7f37d1226406" FOREIGN KEY ("nutrientmanagement")
   REFERENCES "public"."nutrientmanagement"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."productionorientation"
IS 'Value driven aims and restrictions of the agricultural activity that direct the input and output levels (Van Ittersum et al., 1997), for example integrated, organic, conventional or highly innovative.http://ontologies.seamless-ip.org/prodent.owl#ProductionOrientation';

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