pggeodb-preprod.nancy.inra.fr/db_diams
Previous topic Chapter index Next topic

Table: itk_fertilisation

 

 

Schema

public

 

Owner

postgres

 

Tablespace

(default)

 

Descriptions

There is no description for table itk_fertilisation

 

Columns

PK

FK

Name

Data type

Not null

Unique

Inherited

Default

Description

 

id_itk_fertlisation

serial

 

nextval('itk_fertilisation_id_itk_fertlisation_seq'::regclass)

 

 

stk_itk_ferti

integer

 

 

 

 

 

 

 

operation_ferti

varchar

 

 

 

 

 

 

 

date_ferti

date

 

 

 

 

 

 

 

surface_ferti

varchar

 

 

 

 

 

 

 

fertilisant

varchar

 

 

 

 

 

 

 

dose_ferti

varchar

 

 

 

 

 

 

 

quantite_ferti

varchar

 

 

 

 

 

 

 

unite_ferti

varchar

 

 

 

 

 

 

 

n_ferti

varchar

 

 

 

 

 

 

 

p2o5

varchar

 

 

 

 

 

 

 

k2o

varchar

 

 

 

 

 

 

 

cao

varchar

 

 

 

 

 

 

 

mgo

varchar

 

 

 

 

 

 

 

so3

varchar

 

 

 

 

 

 

 

detail_ferti

varchar

 

 

 

 

 

 

Foreign Keys

Name

Columns

FK Table

FK Columns

Delete Action

Update Action

Deferrable

Check Time

Description

st_itk_ferti

stk_itk_ferti

public.itk

id_itk

No Action

No Action

 

Immediate

 

 

Check Constraints

There are no check constraints for table itk_fertilisation

 

Indices

Name

Type

Function

Columns

Primary Key

Unique

Description

fki_st_itk_ferti

btree

 

stk_itk_ferti

 

 

 

stk_itk_fertilisation

btree

 

id_itk_fertlisation

 

 

Triggers

There are no triggers for table itk_fertilisation

 

Rules

There are no rules for table itk_fertilisation

 

Policies

There are no policies for table itk_fertilisation

 

Referenced

There are no tables referenced by table itk_fertilisation

 

Properties

Property

Value

Inherited From

 

Rows

-1

Pages

0

System

 

Temporary

 

With OID

 

Definition

CREATE TABLE public.itk_fertilisation (
 id_itk_fertlisation SERIAL,
 stk_itk_ferti INTEGER,
 operation_ferti VARCHAR,
 date_ferti DATE,
 surface_ferti VARCHAR,
 fertilisant VARCHAR,
 dose_ferti VARCHAR,
 quantite_ferti VARCHAR,
 unite_ferti VARCHAR,
 n_ferti VARCHAR,
 p2o5 VARCHAR,
 k2o VARCHAR,
 cao VARCHAR,
 mgo VARCHAR,
 so3 VARCHAR,
 detail_ferti VARCHAR,
 CONSTRAINT stk_itk_fertilisation PRIMARY KEY(id_itk_fertlisation),
 CONSTRAINT st_itk_ferti FOREIGN KEY (stk_itk_ferti)
   REFERENCES public.itk(id_itk)
   ON DELETE NO ACTION
   ON UPDATE NO ACTION
   NOT DEFERRABLE

) ;

CREATE INDEX fki_st_itk_ferti ON public.itk_fertilisation
 USING btree (stk_itk_ferti);

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic