pggeodb.nancy.inra.fr/db_cefs - db_cefs on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Indices

 

Schema

Table

Index

Tablespace

Type

Function

Fields

Primary Key

Unique

Description

analyse

centroid

centroid_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

datasp

datasp_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

datav

datav_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

essaimcp

essaimcp_geom_idx

(default)

gist

 

geom

 

 

 

analyse

essaimcp

essaimcp_pkey

(default)

btree

 

gid

 

analyse

t_30

t_30_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

t_30b

t_30b_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

t_30c

t_30c_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

t_attributs_all

attributs_all_pkey

(default)

btree

 

pos_id

 

analyse

t_attributs_all

t_attributs_all_geom_gist

(default)

gist

 

the_geom

 

 

 

analyse

t_rd1

t_rd1_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

analyse

t_rd2

t_rd2_pts_geom_idx

(default)

gist

 

pts_geom

 

 

 

cmpt

t_capture_cpt

cpt_id_pkey

(default)

btree

 

cpt_id

 

cmpt

t_capture_cpt

t_animal_ani_ani_name_key

(default)

btree

 

cpt_ani_etiq, cpt_date

 

 

para_phy

t_parasitology_para

t_parasitology_para_pkey

(default)

btree

 

para_id

 

para_phy

t_parasitology_para

t_parasitology_para_unique

(default)

btree

 

para_ani_id, para_laboriginid, para_daysampling, para_pat_id, para_var_id, para_eli_id, para_pcr_id, para_cnt_id

 

 

para_phy

t_physiology_phy

t_physiology_phy_pkey

(default)

btree

 

phy_id

 

para_phy

t_physiology_phy

t_physiology_phy_unique

(default)

btree

 

phy_ani_id, phy_daysampling, phy_var_id, phy_laboriginid

 

 

para_phy

tr_analysis_counting_cnt

tr_analysis_counting_cnt_cnt_analysis_type_key

(default)

btree

 

cnt_analysis_type

 

 

para_phy

tr_analysis_counting_cnt

tr_analysis_counting_cnt_pkey

(default)

btree

 

cnt_id

 

para_phy

tr_analysis_elisa_eli

tr_analysis_elisa_eli_pkey

(default)

btree

 

eli_id

 

para_phy

tr_analysis_pcr_pcr

tr_analysis_pcr_pcr_pcr_analysis_type_key

(default)

btree

 

pcr_analysis_type

 

 

para_phy

tr_analysis_pcr_pcr

tr_analysis_pcr_pcr_pkey

(default)

btree

 

pcr_id

 

para_phy

tr_experimenter_exp

tr_experimenter_exp_pkey

(default)

btree

 

exp_id

 

para_phy

tr_laboratory_lab

tr_laboratory_lab_lab_team_key

(default)

btree

 

lab_team

 

 

para_phy

tr_laboratory_lab

tr_laboratory_lab_pkey

(default)

btree

 

lab_id

 

para_phy

tr_pathogen_pat

tr_pathogen_pat_pat_name_key

(default)

btree

 

pat_name

 

 

para_phy

tr_pathogen_pat

tr_pathogen_pat_pkey

(default)

btree

 

pat_id

 

para_phy

tr_synonym_syn

tr_synonym_syn_pkey

(default)

btree

 

syn_id

 

para_phy

tr_variable_measured_var

tr_variable_measured_var_pkey

(default)

btree

 

var_id

 

para_phy

tr_variable_measured_var

tr_variable_measured_var_unique

(default)

btree

 

var_name_long

 

 

public

pgmfavorites

pgmfavorites_pkey

(default)

btree

 

id

 

public

t_activ_anomalie_ano

activ_anomalie_ano_pkey

(default)

btree

 

ano_id

 

public

t_activite_act

activite_act_pkey

(default)

btree

 

act_id

 

public

t_activite_act

x_btr_ani_id_act

(default)

btree

 

act_ani_id

 

 

 

public

t_activite_act

x_btr_anneesuivi_act

(default)

btree

 

act_annee_suivi

 

 

 

public

t_animal_ani

animal_ani_pkey

(default)

btree

 

ani_id

 

public

t_animal_ani

c_uni_ani_etiq

(default)

btree

 

ani_etiq

 

 

public

t_campagne_pos_cpos

c_uni_date_heure_ani_cpos

(default)

btree

 

cpos_ani_id, cpos_date, cpos_heure

 

Unicité de l'ensemble Animal, date, heure de la campagne.

public

t_campagne_pos_cpos

campagne_gps_cpos_pkey

(default)

btree

 

cpos_id

 

public

t_campagne_pos_cpos

x_btr_ani_id

(default)

btree

 

cpos_ani_id

 

 

 

public

t_campagne_pos_cpos

x_btr_anneesuivi_cpos

(default)

btree

 

cpos_annee_suivi

 

 

 

public

t_capture_cap

c_uni_date_ani_cap

(default)

btree

 

cap_ani_id, cap_date

 

Unicité de l'ensemble Animal, date.

public

t_capture_cap

capture_cap_pkey

(default)

btree

 

cap_id

 

public

t_correspondance_animal_cor

correspondance_animal_cor_pkey

(default)

btree

 

cor_ancien

 

public

t_equipement_eqt

c_uni_eqt_id_usuel

(default)

btree

 

eqt_id_usuel

 

 

public

t_equipement_eqt

equipement_eqt_pkey

(default)

btree

 

eqt_id

 

public

t_positionnement_pos

positionnement_pos_pkey

(default)

btree

 

pos_id

 

public

t_positionnement_pos

t_positionnement_pos_geom_gist

(default)

gist

 

the_geom

 

 

 

public

t_positionnement_pos

x_btr_cpos_id_pos

(default)

btree

 

pos_cpos_id

 

 

 

public

tj_densite_de_population_var_sit_den

tj_densite_de_population_var_sit_den_pkey

(default)

btree

 

den_sit_id, den_var_id

 

public

tj_equipement_animal_eqt_ani_eqa

tj_equipement_animal_eqt_ani_eqa_pkey

(default)

btree

 

eqa_ani_id, eqa_eqt_id, eqa_date_debut

 

public

tj_mesureealpha_campagnegps_aps

tj_mesureealpha_campagnegps_aps_pkey

(default)

btree

 

aps_var_id, aps_cpos_id

 

public

tj_mesureealpha_capture_aca

tj_mesureealpha_capture_aca_pkey

(default)

btree

 

aca_var_id, aca_cap_id

 

public

tj_mesureenum_campagnegps_nps

tj_mesureenum_campagnegps_nps_pkey

(default)

btree

 

nps_var_id, nps_cpos_id

 

public

tj_mesureenum_capture_nca

tj_mesureenum_capture_nca_pkey

(default)

btree

 

nca_var_id, nca_cap_id

 

public

tr_eqtmarque_mar

c_uni_mar_libelle

(default)

btree

 

mar_libelle

 

 

public

tr_eqtmarque_mar

eqtmarque_mar_pkey

(default)

btree

 

mar_id

 

public

tr_eqtmodel_mod

c_uni_mod_libelle

(default)

btree

 

mod_libelle

 

 

public

tr_eqtmodel_mod

eqtmodel_mod_pkey

(default)

btree

 

mod_id

 

public

tr_parcellaire_par

parcellaire_par_pkey

(default)

btree

 

par_id

 

public

tr_parcellaire_par

tr_parcellaire_par_geom_gist

(default)

gist

 

geom

 

 

 

public

tr_parcellaire_par

x_btr_annee_par

(default)

btree

 

par_annee

 

 

 

public

tr_parcellaire_par

x_btr_grd_cat_par

(default)

btree

 

par_grd_cat

 

 

 

public

tr_sig2005

tr_sig2005_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2005

tr_sig2005_geom_idx1

(default)

gist

 

geom

 

 

 

public

tr_sig2005

tr_sig2005_pkey

(default)

btree

 

gid

 

public

tr_sig2006

tr_sig2006_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2006

tr_sig2006_pkey

(default)

btree

 

gid

 

public

tr_sig2007

tr_sig2007_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2007

tr_sig2007_pkey

(default)

btree

 

gid

 

public

tr_sig2008

tr_sig2008_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2008

tr_sig2008_pkey

(default)

btree

 

gid

 

public

tr_sig2009

tr_sig2009_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2009

tr_sig2009_pkey

(default)

btree

 

gid

 

public

tr_sig2010

tr_sig2010_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2010

tr_sig2010_geom_idx1

(default)

gist

 

geom

 

 

 

public

tr_sig2010

tr_sig2010_pkey

(default)

btree

 

gid

 

public

tr_sig2011

tr_sig2011_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2011

tr_sig2011_pkey

(default)

btree

 

gid

 

public

tr_sig2012

tr_sig2012_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2012

tr_sig2012_pkey

(default)

btree

 

gid

 

public

tr_sig2013

tr_sig2013_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2013

tr_sig2013_pkey

(default)

btree

 

gid

 

public

tr_sig2014

tr_sig2014_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2014

tr_sig2014_pkey

(default)

btree

 

gid

 

public

tr_sig2015

tr_sig2015_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2015

tr_sig2015_pkey

(default)

btree

 

gid

 

public

tr_sig2016

tr_sig2016_geom_idx

(default)

gist

 

geom

 

 

 

public

tr_sig2016

tr_sig2016_pkey

(default)

btree

 

gid

 

public

tr_site_capture_sit

c_uni_sit_nom_court

(default)

btree

 

sit_nom_court

 

 

public

tr_site_capture_sit

site_capture_sit_pkey

(default)

btree

 

sit_id

 

public

tr_type_equipement_teq

c_uni_teq_nom_court

(default)

btree

 

teq_nom_court

 

 

public

tr_type_equipement_teq

type_equipement_teq_pkey

(default)

btree

 

teq_id

 

public

tr_variable_mesuree_var

c_uni_var_nom_court

(default)

btree

 

var_nom_court

 

 

public

tr_variable_mesuree_var

variable_mesuree_var_pkey

(default)

btree

 

var_id

 

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 13/03/2014 13:23
Previous topic Chapter index Next topic