Table itk

pggeodb-preprod.nancy.inra.fr/db_diams

Table: itk

Schema

public

Owner

postgres

Tablespace

(default)

Descriptions

There is no description for table itk

Columns

Name	Data type	Default
id_itk	serial	nextval('itk_id_itk_seq'::regclass)
culture	varchar
surface	varchar
intervention	varchar
campagne	varchar
variete	varchar
implantation	varchar
surface_totale	varchar
fumier	varchar
lisier	varchar
precedent	varchar
rendement	varchar
recolte	varchar
sol	varchar
parcelle	integer
code	varchar
rdt_real	varchar
analyse_sol	varchar
ilot	varchar

Foreign Keys

Name	Columns	FK Table	FK Columns	Delete Action	Update Action	Deferrable	Check Time	Description
stk_parcel	parcelle	public.parcelle_diams	id_parcelle	No Action	No Action		Immediate

Check Constraints

There are no check constraints for table itk

Indices

Name	Type	Function	Columns	Primary Key	Unique	Description
fki_stk_parcel	btree		parcelle
itk_pkey	btree		id_itk

Triggers

There are no triggers for table itk

Rules

There are no rules for table itk

Policies

There are no policies for table itk

Referenced

Table	Schema	Foreign Key	Columns	FK Table	FK Columns	Delete Action	Update Action	Check Time
itk_autre	public	st_itk_autre	stk_itk_autre	public.itk	id_itk	No Action	No Action	Immediate
itk_fertilisation	public	st_itk_ferti	stk_itk_ferti	public.itk	id_itk	No Action	No Action	Immediate
itk_protection	public	sk_itk_protect	stk_itk_protect	public.itk	id_itk	No Action	No Action	Immediate
itk_recolte	public	st_itk_recolte	stk_itk_recolte	public.itk	id_itk	No Action	No Action	Immediate
itk_semis	public	stk_itk_sem	stk_itk_sem	public.itk	id_itk	No Action	No Action	Immediate
itk_trav_sol	public	st_itk_trav	stk_itk_trav	public.itk	id_itk	No Action	No Action	Immediate

Properties

Property	Value
Inherited From
Rows	2
Pages	1
System
Temporary
With OID

Definition

CREATE TABLE public.itk ( id_itk SERIAL, culture VARCHAR, surface VARCHAR, intervention VARCHAR, campagne VARCHAR, variete VARCHAR, implantation VARCHAR, surface_totale VARCHAR, fumier VARCHAR, lisier VARCHAR, precedent VARCHAR, rendement VARCHAR, recolte VARCHAR, sol VARCHAR, parcelle INTEGER, code VARCHAR, rdt_real VARCHAR, analyse_sol VARCHAR, ilot VARCHAR, CONSTRAINT itk_pkey PRIMARY KEY(id_itk), CONSTRAINT stk_parcel FOREIGN KEY (parcelle) REFERENCES public.parcelle_diams(id_parcelle) ON DELETE NO ACTION ON UPDATE NO ACTION NOT DEFERRABLE ) ; CREATE INDEX fki_stk_parcel ON public.itk USING btree (parcelle);

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