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

Table: policyoption

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

Each policy option is a combination of one ore more policy changes as described in a set of policy parameters, that could potentially occur in the future. Several policy options can be compared in their effect on different indicators.http://ontologies.seamless-ip.org/seamproj.owl#PolicyOption

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

narrative

bigint

 

 

 

 

 

 

 

time_

integer

 

 

 

 

 

 

 

tradereformactivated

boolean

 

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk8fd04067737ec3e9

narrative

public.narrative

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table policyoption

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

policyoption_id_key

btree

 

id

 

 

policyoption_pkey

btree

 

id

 

 

Triggers

There are no triggers for table policyoption

 

Rules

There are no rules for table policyoption

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

policyassessment

public

fkdff7a5b462231f49

policyoption

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionbasicpremiums

public

fk7fad362324f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionbilateraltariffs

public

fk935cf6a624f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptioncouplingdegrees

public

fk2587248324f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionfarmconstraints

public

fkb70214b924f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionfarmquotas

public

fk73b1dc9824f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionglobaltariffs

public

fk75d9818524f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptioninstitutionalcompatibility

public

fk5a24141424f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionpolicymeasures

public

fk4ce68a6e24f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionpricechange

public

fk9364c77224f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionquotacountries

public

fk44440f6324f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionsetasideregulations

public

fk5b683e4c24f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionsubsidies

public

fk767470e224f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionsubsidisedexports

public

fk80dc0ec124f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptiontradereformproposals

public

fk4af08d0d24f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

policyoptionyieldtrend

public

fkda8f69d724f64b55

policyoption_id

public.policyoption

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

89

Pages

1

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."policyoption" (
 "id" BIGINT NOT NULL,
 "narrative" BIGINT,
 "time_" INTEGER,
 "tradereformactivated" BOOLEAN,
 CONSTRAINT "policyoption_id_key" UNIQUE("id"),
 CONSTRAINT "policyoption_pkey" PRIMARY KEY("id"),
 CONSTRAINT "fk8fd04067737ec3e9" FOREIGN KEY ("narrative")
   REFERENCES "public"."narrative"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

COMMENT ON TABLE "public"."policyoption"
IS 'Each policy option is a combination of one ore more policy changes as described in a set of policy parameters, that could potentially occur in the future. Several policy options can be compared in their effect on different indicators.http://ontologies.seamless-ip.org/seamproj.owl#PolicyOption';

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