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

Table: productionactivityperfssimfarmagriculturalactivities

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

There is no description for table productionactivityperfssimfarmagriculturalactivities

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

productionactivityperfssimfarm_id

bigint

 

 

 

 

 

agriculturalactivity_id

bigint

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fk5d9d5dd7a37d3e83

productionactivityperfssimfarm_id

public.productionactivityperfssimfarm

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table productionactivityperfssimfarmagriculturalactivities

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

productionactivityperfssimfarmagriculturalactivities_pkey

btree

 

productionactivityperfssimfarm_id, agriculturalactivity_id

 

 

Triggers

There are no triggers for table productionactivityperfssimfarmagriculturalactivities

 

Rules

There are no rules for table productionactivityperfssimfarmagriculturalactivities

 

Referenced

There are no tables referenced by table productionactivityperfssimfarmagriculturalactivities

 

Options

Option

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."productionactivityperfssimfarmagriculturalactivities" (
 "productionactivityperfssimfarm_id" BIGINT NOT NULL,
 "agriculturalactivity_id" BIGINT NOT NULL,
 CONSTRAINT "productionactivityperfssimfarmagriculturalactivities_pkey" PRIMARY KEY("productionactivityperfssimfarm_id", "agriculturalactivity_id"),
 CONSTRAINT "fk5d9d5dd7a37d3e83" FOREIGN KEY ("productionactivityperfssimfarm_id")
   REFERENCES "public"."productionactivityperfssimfarm"("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