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

Table: surveycroprotationelementinputonsoilinmanagementprocedure

 

 

Schema

public

 

Owner

seamless

 

Tablespace

(default)

 

Descriptions

There is no description for table surveycroprotationelementinputonsoilinmanagementprocedure

 

Fields

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

surveycroprotationelement_id

bigint

 

 

 

 

inputonsoilinmanagementprocedure_id

bigint

 

 

 

 

 

Foreign Keys

Name

Fields

FK Table

FK Fields

Delete Action

Update Action

Deferrable

Check Time

Description

fkd13cc5172cb4569e

surveycroprotationelement_id

public.surveycroprotationelement

id

No Action

No Action

 

Immediate

 

fkd13cc5178b013f6

inputonsoilinmanagementprocedure_id

public.inputonsoilinmanagementprocedure

id

No Action

No Action

 

Immediate

 

 

Checks

There are no check constraints for table surveycroprotationelementinputonsoilinmanagementprocedure

 

Indices

Name

Type

Function

Fields

Primary Key

Unique

Description

surveycroprotationelementinputonsoilinmanagementprocedure_pkey

btree

 

surveycroprotationelement_id, inputonsoilinmanagementprocedure_id

 

 

Triggers

There are no triggers for table surveycroprotationelementinputonsoilinmanagementprocedure

 

Rules

There are no rules for table surveycroprotationelementinputonsoilinmanagementprocedure

 

Referenced

There are no tables referenced by table surveycroprotationelementinputonsoilinmanagementprocedure

 

Options

Option

Value

Inherited From

 

Rows

0

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE "public"."surveycroprotationelementinputonsoilinmanagementprocedure" (
 "surveycroprotationelement_id" BIGINT NOT NULL,
 "inputonsoilinmanagementprocedure_id" BIGINT NOT NULL,
 CONSTRAINT "surveycroprotationelementinputonsoilinmanagementprocedure_pkey" PRIMARY KEY("surveycroprotationelement_id", "inputonsoilinmanagementprocedure_id"),
 CONSTRAINT "fkd13cc5172cb4569e" FOREIGN KEY ("surveycroprotationelement_id")
   REFERENCES "public"."surveycroprotationelement"("id")
   MATCH FULL
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE,
 CONSTRAINT "fkd13cc5178b013f6" FOREIGN KEY ("inputonsoilinmanagementprocedure_id")
   REFERENCES "public"."inputonsoilinmanagementprocedure"("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