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

Table: simplesurveyrotationelementsimplecropmanagementinzone

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

There is no description for table simplesurveyrotationelementsimplecropmanagementinzone

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

simplesurveyrotationelement_id

bigint

 

 

 

 

simplecropmanagementinzone_id

bigint

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk15f155c8a4b40116

simplecropmanagementinzone_id

public.simplecropmanagementinzone

id

No Action

No Action

 

Immediate

 

fk15f155c8d07180de

simplesurveyrotationelement_id

public.simplesurveyrotationelement

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table simplesurveyrotationelementsimplecropmanagementinzone

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

simplesurveyrotationelementsimplecropmanagementinzone_pkey

btree

 

simplesurveyrotationelement_id, simplecropmanagementinzone_id

 

 

Triggers

There are no triggers for table simplesurveyrotationelementsimplecropmanagementinzone

 

Rules

There are no rules for table simplesurveyrotationelementsimplecropmanagementinzone

 

Referenced

There are no tables referenced by table simplesurveyrotationelementsimplecropmanagementinzone

 

Options

Option

Value

Inherited From

 

Rows

1981

Pages

12

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."simplesurveyrotationelementsimplecropmanagementinzone" (
 "simplesurveyrotationelement_id" BIGINT NOT NULL,
 "simplecropmanagementinzone_id" BIGINT NOT NULL,
 CONSTRAINT "simplesurveyrotationelementsimplecropmanagementinzone_pkey" PRIMARY KEY("simplesurveyrotationelement_id", "simplecropmanagementinzone_id"),
 CONSTRAINT "fk15f155c8a4b40116" FOREIGN KEY ("simplecropmanagementinzone_id")
   REFERENCES "public"."simplecropmanagementinzone"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fk15f155c8d07180de" FOREIGN KEY ("simplesurveyrotationelement_id")
   REFERENCES "public"."simplesurveyrotationelement"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE
) WITH OIDS;

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