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

Table: dailyclimate

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

this is for each day a set of climate variables, that have been observed for that day.http://ontologies.seamless-ip.org/farm.owl#DailyClimate

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id

bigint

 

 

 

 

 

albedo

real

 

 

 

 

 

 

 

clearskytransmissivity

real

 

 

 

 

 

 

 

day_

integer

 

 

 

 

 

 

 

maximumtemperature

real

 

 

 

 

 

 

 

maximumtemperaturemax

real

 

 

 

 

 

 

 

maximumtemperaturemin

real

 

 

 

 

 

 

 

maximumtemperaturesd

real

 

 

 

 

 

 

 

minimumtemperature

real

 

 

 

 

 

 

 

minimumtemperaturemax

real

 

 

 

 

 

 

 

minimumtemperaturemin

real

 

 

 

 

 

 

 

minimumtemperaturesd

real

 

 

 

 

 

 

 

month_

integer

 

 

 

 

 

 

 

potentialevaporationsoil

real

 

 

 

 

 

 

 

potentialevaporationwater

real

 

 

 

 

 

 

 

potentialtranspirationcanopy

real

 

 

 

 

 

 

 

radiation

real

 

 

 

 

 

 

 

rainfall

real

 

 

 

 

 

 

 

rainfallmax

real

 

 

 

 

 

 

 

rainfallmin

real

 

 

 

 

 

 

 

rainfallsd

real

 

 

 

 

 

 

 

vapourpressure

real

 

 

 

 

 

 

 

windspeed

real

 

 

 

 

 

 

 

windspeedmax

real

 

 

 

 

 

 

 

windspeedmin

real

 

 

 

 

 

 

 

windspeedsd

real

 

 

 

 

 

 

 

year_

integer

 

 

 

 

 

 

Foreign Keys

There are no foreign keys for table dailyclimate

 

Checks

There are no check constraints for table dailyclimate

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

dailyclimate_id_key

btree

 

id

 

 

dailyclimate_pkey

btree

 

id

 

 

Triggers

There are no triggers for table dailyclimate

 

Rules

There are no rules for table dailyclimate

 

Referenced

Table

Schema

Foreign Key

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

climatezonedailyclimate

public

fk17edd3bd8b48eefa

dailyclimate_id

public.dailyclimate

id

No Action

No Action

 

Immediate

 

 

Options

Option

Value

Inherited From

 

Rows

5048350

Pages

59393

System

 

Temporary

 

With OID

 

 

Definition

CREATE TABLE "public"."dailyclimate" (
 "id" BIGINT NOT NULL,
 "albedo" REAL,
 "clearskytransmissivity" REAL,
 "day_" INTEGER,
 "maximumtemperature" REAL,
 "maximumtemperaturemax" REAL,
 "maximumtemperaturemin" REAL,
 "maximumtemperaturesd" REAL,
 "minimumtemperature" REAL,
 "minimumtemperaturemax" REAL,
 "minimumtemperaturemin" REAL,
 "minimumtemperaturesd" REAL,
 "month_" INTEGER,
 "potentialevaporationsoil" REAL,
 "potentialevaporationwater" REAL,
 "potentialtranspirationcanopy" REAL,
 "radiation" REAL,
 "rainfall" REAL,
 "rainfallmax" REAL,
 "rainfallmin" REAL,
 "rainfallsd" REAL,
 "vapourpressure" REAL,
 "windspeed" REAL,
 "windspeedmax" REAL,
 "windspeedmin" REAL,
 "windspeedsd" REAL,
 "year_" INTEGER,
 CONSTRAINT "dailyclimate_id_key" UNIQUE("id"),
 CONSTRAINT "dailyclimate_pkey" PRIMARY KEY("id")
) WITHOUT OIDS;

COMMENT ON TABLE "public"."dailyclimate"
IS 'this is for each day a set of climate variables, that have been observed for that day.http://ontologies.seamless-ip.org/farm.owl#DailyClimate';

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