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

Table: experiment

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

Experiment is a single run of a policy evaluation and a biophysical simulation. Results can be tracked from the linked concepts.http://ontologies.seamless-ip.org/seamproj.owl#Experiment

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

baseline

boolean

 

 

 

 

 

 

 

changed

boolean

 

 

 

 

 

 

 

description

text

 

 

 

 

 

 

baselineexperiment

bigint

 

 

 

 

 

 

baseyearexperiment

bigint

 

 

 

 

 

 

biophysicalsimulation

bigint

 

 

 

 

 

 

modelchain

bigint

 

 

 

 

 

 

policyassessment

bigint

 

 

 

 

 

 

temporalscale

bigint

 

 

 

 

 

 

 

modelzip

varchar(255)

 

 

 

 

 

 

 

modelzipsaved

boolean

 

 

 

 

 

 

ofproblem

bigint

 

 

 

 

 

 

 

published

boolean

 

 

 

 

 

 

 

state_

integer

 

 

 

 

 

 

 

title

varchar(255)

 

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk71bbb81d1a1bb7cc

ofproblem

public.problem

id

No Action

No Action

 

Immediate

 

fk71bbb81d3e6cc735

temporalscale

public.temporalscale

id

No Action

No Action

 

Immediate

 

fk71bbb81d572c91f1

biophysicalsimulation

public.biophysicalsimulation

id

No Action

No Action

 

Immediate

 

fk71bbb81d59614aa3

baseyearexperiment

public.experiment

id

No Action

No Action

 

Immediate

 

fk71bbb81d6f92799a

baselineexperiment

public.experiment

id

No Action

No Action

 

Immediate

 

fk71bbb81daab83463

policyassessment

public.policyassessment

id

No Action

No Action

 

Immediate

 

fk71bbb81db12717eb

modelchain

public.modelchain

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table experiment

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

experiment_id_key

btree

 

id

 

 

experiment_pkey

btree

 

id

 

 

Triggers

There are no triggers for table experiment

 

Rules

There are no rules for table experiment

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

experiment

public

fk71bbb81d59614aa3

baseyearexperiment

public.experiment

id

No Action

No Action

 

Immediate

 

experiment

public

fk71bbb81d6f92799a

baselineexperiment

public.experiment

id

No Action

No Action

 

Immediate

 

experimentplantwoexperiments

public

fkfcc804b0c6f5c235

experiment_id

public.experiment

id

No Action

No Action

 

Immediate

 

experimentrun

public

fk4417b92ead66e595

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueactivity

public

fk676020c2ad66e595924295f1

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueactivitygroupcountry

public

fk676020c2ad66e595397304a8

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueactivitygroupcountryaggregate

public

fk676020c2ad66e595afc6d5f7

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueactivitygroupnutsregion

public

fk676020c2ad66e595aceddaa8

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluebetweencountryaggregates

public

fk676020c2ad66e5952d62ee84

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluecountry

public

fk676020c2ad66e59572fd074

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluecountryaggregate

public

fk676020c2ad66e5957cc48fab

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluecrop

public

fk676020c2ad66e595851e1e72

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluefarm

public

fk676020c2ad66e595851f3c18

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluefarmagrienvironmentalzone

public

fk676020c2ad66e595cc618db5

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueinputgroupcountry

public

fk676020c2ad66e5953058445f

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueinputgroupcountryaggregate

public

fk676020c2ad66e5955dd85420

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueinputgroupnutsregion

public

fk676020c2ad66e5952cdf6b91

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluenutsregion

public

fk676020c2ad66e5959255eb5c

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueproductgroupcountry

public

fk676020c2ad66e595f061ca84

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueproductgroupcountryaggregate

public

fk676020c2ad66e59557c2e79b

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvalueproductgroupnutsregion

public

fk676020c2ad66e595c130f74c

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

indicatorvaluesimple

public

fk676020c2ad66e595d0de2514

experiment

public.experiment

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

90

Pages

3

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."experiment" (
 "id" BIGINT NOT NULL,
 "baseline" BOOLEAN,
 "changed" BOOLEAN,
 "description" TEXT,
 "baselineexperiment" BIGINT,
 "baseyearexperiment" BIGINT,
 "biophysicalsimulation" BIGINT,
 "modelchain" BIGINT,
 "policyassessment" BIGINT,
 "temporalscale" BIGINT,
 "modelzip" VARCHAR(255),
 "modelzipsaved" BOOLEAN,
 "ofproblem" BIGINT,
 "published" BOOLEAN,
 "state_" INTEGER,
 "title" VARCHAR(255),
 CONSTRAINT "experiment_id_key" UNIQUE("id"),
 CONSTRAINT "experiment_pkey" PRIMARY KEY("id"),
 CONSTRAINT "fk71bbb81d1a1bb7cc" FOREIGN KEY ("ofproblem")
   REFERENCES "public"."problem"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81d3e6cc735" FOREIGN KEY ("temporalscale")
   REFERENCES "public"."temporalscale"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81d572c91f1" FOREIGN KEY ("biophysicalsimulation")
   REFERENCES "public"."biophysicalsimulation"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81d59614aa3" FOREIGN KEY ("baseyearexperiment")
   REFERENCES "public"."experiment"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81d6f92799a" FOREIGN KEY ("baselineexperiment")
   REFERENCES "public"."experiment"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81daab83463" FOREIGN KEY ("policyassessment")
   REFERENCES "public"."policyassessment"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk71bbb81db12717eb" FOREIGN KEY ("modelchain")
   REFERENCES "public"."modelchain"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."experiment"
IS 'Experiment is a single run of a policy evaluation and a biophysical simulation. Results can be tracked from the linked concepts.http://ontologies.seamless-ip.org/seamproj.owl#Experiment';

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