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

Indices

 

Schema

Table

Index

Tablespace

Type

Function

Columns

Primary Key

Unique

Description

public

auto_mpl

pmk_mpl

(default)

btree

 

id_mpl

 

public

BDE

BDE_pkey

(default)

btree

 

id_0

 

public

bloc_diams

pmk_bloc

(default)

btree

 

id_bloc

 

public

CapteursGaz

CapteursGaz_pkey

(default)

btree

 

id

 

public

Chambres_tirage

Chambres_tirage_pkey

(default)

btree

 

id_tirage

 

public

Chambres_tirage

sidx_Chambres_tirage_geom

(default)

gist

 

geom

 

 

 

public

chn

fki_stk_echant

(default)

btree

 

sk_echant

 

 

 

public

chn

pmk_chn

(default)

btree

 

id_chn

 

public

chn_frac

fki_stk_echant_frac

(default)

btree

 

sk_echant_frac

 

 

 

public

chn_frac

pmk_id_chn_frac

(default)

btree

 

id_chn_frac

 

public

chn_phyto

pmk_chn_phyto

(default)

btree

 

id_chn_phyto

 

public

climatik_melgueil

pmk_climatik_melg

(default)

btree

 

id_climatik_melg

 

public

diams_bde

diams_bde_pkey

(default)

btree

 

id

 

public

espece_nematrait

espece_nematrait_pkey

(default)

btree

 

id_espece

 

public

Fosses

Fosses_permanentes_pkey

(default)

btree

 

id_fosse_perma

 

public

Fosses

sidx_Fosses_permanentes_geom

(default)

gist

 

geom

 

 

 

public

Gaines_rouges

Gaines_rouges_pkey

(default)

btree

 

id_grouges

 

public

Gaines_rouges

sidx_Gaines_rouges_geom

(default)

gist

 

geom

 

 

 

public

Gaines_vertes

Gaines_vertes_pkey

(default)

btree

 

id_gvertes

 

public

Gaines_vertes

sidx_Gaines_vertes_geom

(default)

gist

 

geom

 

 

 

public

histo_echant

pmk_histo

(default)

btree

 

id_histo

 

public

histo_phyto

pmk_histo_phyto

(default)

btree

 

id_histo_phyto

 

public

Irrigation

Irrigation_pkey

(default)

btree

 

id

 

public

itk

fki_stk_parcel

(default)

btree

 

parcelle

 

 

 

public

itk

itk_pkey

(default)

btree

 

id_itk

 

public

itk_autre

fki_st_itk_autre

(default)

btree

 

stk_itk_autre

 

 

 

public

itk_autre

pmk_itk_autre

(default)

btree

 

id_itk_autre

 

public

itk_fertilisation

fki_st_itk_ferti

(default)

btree

 

stk_itk_ferti

 

 

 

public

itk_fertilisation

stk_itk_fertilisation

(default)

btree

 

id_itk_fertlisation

 

public

itk_protection

fki_sk_itk_protect

(default)

btree

 

stk_itk_protect

 

 

 

public

itk_protection

pmk_itk_protection

(default)

btree

 

id_itk_protection

 

public

itk_recolte

fki_st_itk_recolte

(default)

btree

 

stk_itk_recolte

 

 

 

public

itk_recolte

pmk_itk_recolte

(default)

btree

 

id_itk_recolte

 

public

itk_semis

fki_stk_itk_sem

(default)

btree

 

stk_itk_sem

 

 

 

public

itk_semis

pmk_itk_semis

(default)

btree

 

id_itk_semis

 

public

itk_trav_sol

fki_st_itk

(default)

btree

 

stk_itk_trav

 

 

 

public

itk_trav_sol

pmk_trav_sol

(default)

btree

 

id_trav_sol

 

public

MA31

MA31_pkey

(default)

btree

 

id_ma31

 

public

ma31_shp

ma31_shp_geom_idx

(default)

gist

 

geom

 

 

 

public

ma31_shp

ma31_shp_pkey

(default)

btree

 

gid

 

public

MA3A Agroforest 4

MA3A Agroforest 4_pkey

(default)

btree

 

id_ma3a_agro

 

public

ma5a_shp

ma5a_shp_geom_idx

(default)

gist

 

geom

 

 

 

public

ma5a_shp

ma5a_shp_pkey

(default)

btree

 

gid

 

public

microresp_diams

fki_stk_ech_micro

(default)

btree

 

sk_echant_micro

 

 

 

public

microresp_diams

pmk_microresp

(default)

btree

 

id_microresp

 

public

modalite_diams

fki_stk_placette_mod

(default)

btree

 

id_placette_mod

 

 

 

public

modalite_diams

pmk_modalite

(default)

btree

 

id_modalite

 

public

nematrait

nematrait_pkey

(default)

btree

 

id_nematrait

 

public

parcelle_diams

pmk_parcelle

(default)

btree

 

id_parcelle

 

public

Parcelles_DIASCOPE_DIAMS

Parcelles_DIASCOPE_DIAMS_pkey

(default)

btree

 

id_diascope_diams

 

public

Parcelles_DIASCOPE_DIAMS

sidx_Parcelles_DIASCOPE_DIAMS_geom

(default)

gist

 

geom

 

 

 

public

pedo_diams

pk_echa

(default)

btree

 

id_echant

 

public

pedotheque

idx_geom

(default)

gist

 

geom

 

 

 

public

pedotheque

pmk_echant

(default)

btree

 

id_echant

 

public

pedotheque

sidx_pedotheque_geom

(default)

gist

 

geom

 

 

 

public

pedotheque_sn

pmk_pedo-sn

(default)

btree

 

id_pedo_sn

 

public

phytotheque

pmk_phyto

(default)

btree

 

id_phyto

 

public

placette_diams

fki_st_parcel

(default)

btree

 

id_parcelle_placette

 

 

 

public

placette_diams

fki_stk_bloc_placette

(default)

btree

 

id_bloc_placette

 

 

 

public

placette_diams

pmk_placette

(default)

btree

 

id_placette

 

public

Point_prlvt_T0

pmk_id_echant

(default)

btree

 

id_echant

 

public

releve_elec

releve_elec_pkey

(default)

btree

 

id_relev2020

 

public

releve_elec_2020_24_07_20

releve_elec_2020_24_07_20_pkey

(default)

btree

 

id_relev2020

 

public

robinier

robinier_pkey

(default)

btree

 

id_robin

 

public

robinier

sidx_robinier_geom

(default)

gist

 

geom

 

 

 

public

spectre

fki_st_spe_ech

(default)

btree

 

spect_echant

 

 

 

public

spectre

fki_st_t_spectro

(default)

btree

 

t_spectro

 

 

 

public

spectre

pmk_spectre

(default)

btree

 

id_spectre

 

public

spectre_phyto

fki_st_spe_ech_phyt

(default)

btree

 

spect_echant_phyto

 

 

 

public

spectre_phyto

fki_st_t_spectro_phy

(default)

btree

 

t_spectro_phyto

 

 

 

public

spectre_phyto

stk_id_spectre_phyto

(default)

btree

 

id_spectre_phyto

 

public

test

saz

(default)

btree

 

zssz

 

public

Tranchees

sidx_Tranchees_geom

(default)

gist

 

geom

 

 

 

public

Tranchees

Tranchees_pkey

(default)

btree

 

id_tranch

 

public

type_spectro

pmk_spectro

(default)

btree

 

id_spectro

 

public

type_spectro_phyto

stk_id_spectro_phyto

(default)

btree

 

id_spectro_phyto

 

public

utilisateur

pmk_user

(default)

btree

 

id_user

 

public

utilisateur_projet

fki_stk_user_proj

(default)

btree

 

stk_user

 

 

 

public

utilisateur_projet

pmk_user_proj

(default)

btree

 

id_user_projet

 

public

vers_de_terre

fki_stk_pedo_vers

(default)

btree

 

sk_pedo_vers

 

 

 

public

vers_de_terre

pmk_vers

(default)

btree

 

id_vers

 

topology

layer

layer_pkey

(default)

btree

 

topology_id, layer_id

 

topology

layer

layer_schema_name_table_name_feature_column_key

(default)

btree

 

schema_name, table_name, feature_column

 

 

topology

topology

topology_name_key

(default)

btree

 

name

 

 

topology

topology

topology_pkey

(default)

btree

 

id

 

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