Indices

c_uni_obj_fil_acq

(default)

btree

acq_obj_id, acq_fil_id

The couple acq_obj_id and acq_fil_id is unique

t_acquisition_acq_pkey

(default)

btree

acq_id

x_btr_fkey_adm_acq

(default)

btree

acq_adm_id

Foreign key index to speed up updates / deletion

x_btr_fkey_fil_acq

(default)

btree

acq_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_obj_acq

(default)

btree

acq_obj_id

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_acq

(default)

btree

acq_prot_id

Foreign key index to speed up updates / deletion

t_detection_singularity_det_pkey

(default)

btree

det_id

x_btr_fkey_acq_det

(default)

btree

det_acq_id

Foreign key index to speed up updates / deletion

x_btr_fkey_adm_det

(default)

btree

det_adm_id

Foreign key index to speed up updates / deletion

x_btr_fkey_fil_det

(default)

btree

det_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tsin_det

(default)

btree

det_tsin_id

Foreign key index to speed up updates / deletion

c_uni_acq_var_datemeasure_macq

(default)

btree

macq_acq_id, macq_var_id, macq_date_measure

The set identifier of the acquisition / identifier of the variable / date of the measure is unique

c_uni_acq_var_macq

(default)

btree

macq_acq_id, macq_var_id

The variable / acquisition pair is unique if the measure date is not entered.

t_measure_macq_pkey

(default)

btree

macq_id

x_btr_fkey_acq_macq

(default)

btree

macq_acq_id

Foreign key index to speed up updates / deletion

x_btr_fkey_fil_macq

(default)

btree

macq_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_macq

(default)

btree

macq_prot_id

Foreign key index to speed up updates / deletion

x_btr_fkey_std_macq

(default)

btree

macq_std_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_macq

(default)

btree

macq_tym_id

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_macq

(default)

btree

macq_uni_id

Foreign key index to speed up updates / deletion

x_btr_fkey_var_macq

(default)

btree

macq_var_id

Foreign key index to speed up updates / deletion

c_uni_det_var_datemeasure_mdet

(default)

btree

mdet_det_id, mdet_var_id, mdet_date_measure

The set identifier of the singularity detection / identifier of the variable / date of the measure is unique

c_uni_det_var_mdet

(default)

btree

mdet_det_id, mdet_var_id

The variable / singularity detection pair is unique if the measure date is not entered.

t_measure_mdet_pkey

(default)

btree

mdet_id

x_btr_fkey_det_mdet

(default)

btree

mdet_det_id

Foreign key index to speed up updates / deletion

x_btr_fkey_fil_mdet

(default)

btree

mdet_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_mdet

(default)

btree

mdet_prot_id

Foreign key index to speed up updates / deletion

x_btr_fkey_std_mdet

(default)

btree

mdet_std_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_mdet

(default)

btree

mdet_tym_id

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_mdet

(default)

btree

mdet_uni_id

Foreign key index to speed up updates / deletion

x_btr_fkey_var_mdet

(default)

btree

mdet_var_id

Foreign key index to speed up updates / deletion

c_uni_obj_var_datemeasure_mobj

(default)

btree

mobj_obj_id, mobj_var_id, mobj_date_measure

The set identifier of the object / identifier of the variable / date of the measure is unique

c_uni_obj_var_mobj

(default)

btree

mobj_obj_id, mobj_var_id

The variable / object pair is unique if the measure date is not entered.

t_measure_mobj_pkey

(default)

btree

mobj_id

x_btr_fkey_fil_mobj

(default)

btree

mobj_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_obj_mobj

(default)

btree

mobj_obj_id

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_mobj

(default)

btree

mobj_prot_id

Foreign key index to speed up updates / deletion

x_btr_fkey_std_mobj

(default)

btree

mobj_std_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_mobj

(default)

btree

mobj_tym_id

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_mobj

(default)

btree

mobj_uni_id

Foreign key index to speed up updates / deletion

x_btr_fkey_var_mobj

(default)

btree

mobj_var_id

Foreign key index to speed up updates / deletion

c_uni_zon_var_datemeasure_mzon

(default)

btree

mzon_zon_id, mzon_var_id, mzon_date_measurement

c_uni_zon_var_mzon

(default)

btree

mzon_zon_id, mzon_var_id

the variable / zone pair is unique if the measurement date field is not filled in.

t_measure_mzon_pkey

(default)

btree

mzon_id

x_btr_fkey_fil_mzon

(default)

btree

mzon_fil_id

Foreign key index to speed up updates / deletion

x_btr_fkey_prot_mzon

(default)

btree

mzon_prot_id

Foreign key index to speed up updates / deletion

x_btr_fkey_std_mzon

(default)

btree

mzon_std_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tym_mzon

(default)

btree

mzon_tym_id

Foreign key index to speed up updates / deletion

x_btr_fkey_uni_mzon

(default)

btree

mzon_uni_id

Foreign key index to speed up updates / deletion

x_btr_fkey_var_mzon

(default)

btree

mzon_var_id

Foreign key index to speed up updates / deletion

x_btr_fkey_zon_mzon

(default)

btree

mzon_zon_id

Foreign key index to speed up updates / deletion

c_uni_tree_proj_obj

(default)

btree

obj_tree, obj_proj_id

The complete tree structure of an object must be unique for the same project

t_object_obj_pkey

(default)

btree

obj_id

x_btr_fkey_nobj_obj

(default)

btree

obj_nobj_id

Foreign key index to speed up updates / deletion

x_btr_fkey_proj_obj

(default)

btree

obj_proj_id

Foreign key index to speed up updates / deletion

x_btr_fkey_tax_obj

(default)

btree

obj_tax_id

Foreign key index to speed up updates / deletion

x_btr_fkey_zon_obj

(default)

btree

obj_zon_id

Foreign key index to speed up updates / deletion

t_project_proj

c_uni_code_proj

(default)

btree

proj_code

The code of a project must be unique

t_project_proj

t_projet_proj_pkey

(default)

btree

proj_id

tj_classification_var_cvar

tj_classification_var_cvar_pkey

(default)

btree

cvar_cla_id, cvar_var_id

tj_classification_var_cvar

x_btr_fkey_cla_cvar

(default)

btree

cvar_cla_id

Foreign key index to speed up updates / deletion

tj_classification_var_cvar

x_btr_fkey_var_cvar

(default)

btree

cvar_var_id

Foreign key index to speed up updates / deletion

tj_detection_singularity_pairing_dsp

tj_detection_singularity_pairing_dsp_pkey

(default)

btree

dsp_det_id_source, dsp_det_id_target

tj_detection_singularity_pairing_dsp

x_btr_fkey_det_source_dsp

(default)

btree

dsp_det_id_source

Foreign key index to speed up updates / deletion

tj_detection_singularity_pairing_dsp

x_btr_fkey_det_target_dsp

(default)

btree

dsp_det_id_target

Foreign key index to speed up updates / deletion

tj_rol_ope_macq_romacq_pkey

(default)

btree

romacq_macq_id, romacq_ope_id, romacq_rol_id

x_btr_macq_romacq

(default)

btree

romacq_macq_id

Foreign key index to speed up updates / deletion

x_btr_ope_romacq

(default)

btree

romacq_ope_id

Foreign key index to speed up updates / deletion

x_btr_rol_romacq

(default)

btree

romacq_rol_id

Foreign key index to speed up updates / deletion

tj_rol_ope_mdet_romdet_pkey

(default)

btree

romdet_mdet_id, romdet_ope_id, romdet_rol_id

x_btr_mdet_romdet

(default)

btree

romdet_mdet_id

Foreign key index to speed up updates / deletion

x_btr_ope_romdet

(default)

btree

romdet_ope_id

Foreign key index to speed up updates / deletion

x_btr_rol_romdet

(default)

btree

romdet_rol_id

Foreign key index to speed up updates / deletion

tj_rol_ope_mobj_romobj_pkey

(default)

btree

romobj_mobj_id, romobj_ope_id, romobj_rol_id

x_btr_mobj_romobj

(default)

btree

romobj_mobj_id

Foreign key index to speed up updates / deletion

x_btr_ope_romobj

(default)

btree

romobj_ope_id

Foreign key index to speed up updates / deletion

x_btr_rol_romobj

(default)

btree

romobj_rol_id

Foreign key index to speed up updates / deletion

tj_rol_ope_mzon_romzon_pkey

(default)

btree

romzon_mzon_id, romzon_ope_id, romzon_rol_id

x_btr_mzon_romzon

(default)

btree

romzon_mzon_id

Foreign key index to speed up updates / deletion

x_btr_ope_romzon

(default)

btree

romzon_ope_id

Foreign key index to speed up updates / deletion

x_btr_rol_romzon

(default)

btree

romzon_rol_id

Foreign key index to speed up updates / deletion

tj_transformation_matrix_tra

tj_transformation_matrix_tra_pkey

(default)

btree

tra_acq_id_source, tra_acq_id_target

tj_transformation_matrix_tra

x_btr_fkey_acq_source_tra

(default)

btree

tra_acq_id_source

Foreign key index to speed up updates / deletion

tj_transformation_matrix_tra

x_btr_fkey_acq_target_tra

(default)

btree

tra_acq_id_target

Foreign key index to speed up updates / deletion

tr_acquisition_detection_mean_adm

c_uni_code_adm

(default)

btree

adm_code

The code for a mean must be unique

tr_acquisition_detection_mean_adm

tr_acquisition_detection_mean_pkey

(default)

btree

adm_id

tr_classification_cla

c_uni_tree_cla

(default)

btree

cla_tree

The ltree hierarchy of a classification is unique

tr_classification_cla_pkey

tr_classification_cla

(default)

btree

cla_id

tr_file_fil

c_uni_name_url_fil

(default)

btree

fil_name, fil_url

The name / url pair of a file must be unique

tr_file_fil

tr_file_fil_pkey

(default)

btree

fil_id

tr_file_fil

x_btr_fkey_typf_file

(default)

btree

fil_typf_id

Foreign key index to speed up updates / deletion

tr_nature_object_nobj

c_uni_code_nobj

(default)

btree

nobj_code

Unique code to identify the object nature

tr_nature_objet_nobj_pkey

tr_nature_object_nobj

(default)

btree

nobj_id

c_uni_name_first_name_ope

tr_operator_ope

(default)

btree

ope_name, ope_first_name

The name / first name pair of an operator must be unique

tr_operator_ope

tr_operator_ope_pkey

(default)

btree

ope_id

tr_protocol_prot

c_uni_code_prot

(default)

btree

prot_code

Protocol code must be unique

tr_protocol_prot

c_uni_name_prot

(default)

btree

prot_name

Protocol name must be unique

tr_protocol_prot

tr_protocole_prot_pkey

(default)

btree

prot_id

tr_role_rol

c_uni_label_rol

(default)

btree

rol_label

The label of a role must be unique

tr_role_rol

tr_role_rol_pkey

(default)

btree

rol_id

tr_standard_std

c_uni_name_version_std

(default)

btree

std_name, std_version

The name / version pair of a standard must be unique

tr_standard_std

tr_standard_std_pkey

(default)

btree

std_id

tr_study_zone_zon

c_uni_tree_zon

(default)

btree

zon_tree

The complete tree structure of a study zone must be unique

tr_study_zone_zon

tr_study_zone_zon_pkey

(default)

btree

zon_id

tr_study_zone_zon

x_btr_fkey_typz_zon

(default)

btree

zon_typz_id

Foreign key index to speed up updates / deletion

c_uni_ref_identifier_ext_tax

(default)

btree

tax_ref_id, tax_identifier_ext

The referential / external identifier pair is unique

c_uni_ref_label_tax

(default)

btree

tax_ref_id, tax_label

The referential / label pair is unique

tr_taxon_tax_pkey

(default)

btree

tax_id

x_btr_fkey_ref_tax

(default)

btree

tax_ref_id

Foreign key index to speed up updates / deletion

tr_taxonomic_referential_ref

c_uni_code_ref

(default)

btree

ref_code

The code of the referential is unique

tr_taxonomic_referential_ref

c_uni_lab_ver_ref

(default)

btree

ref_label, ref_version

The label / version pair of the referential is unique

tr_taxonomic_referential_ref

tr_taxonomic_referential_ref_pkey

(default)

btree

ref_id

tr_type_file_typf

c_uni_code_typf

(default)

btree

typf_code

The code of type file is unique

tr_type_file_typf

tr_type_file_typf_pkey

(default)

btree

typf_id

tr_type_measure_tym

c_uni_code_tym

(default)

btree

tym_code

The measurement type code must be unique

tr_type_measure_tym

tr_type_measure_tym_pkey

(default)

btree

tym_id

tr_type_singularity_tsin

c_uni_code_tsin

(default)

btree

tsin_code

The code of the singularity type must be unique

tr_type_singularite_tsin_pkey

tr_type_singularity_tsin

(default)

btree

tsin_id

tr_type_study_zone_typz

c_uni_code_typz

(default)

btree

typz_code

The code for a study zone type must be unique

tr_type_study_zone_typz_pkey

tr_type_study_zone_typz

(default)

btree

typz_id

tr_unit_uni

c_uni_name_uni

(default)

btree

uni_name

The name of a unit must be unique

tr_unit_uni

c_uni_symbol_uni

(default)

btree

uni_symbol

The symbol of a unit must be unique

tr_unit_uni

tr_unit_uni_pkey

(default)

btree

uni_id

tr_variable_var

c_uni_code_var

(default)

btree

var_code

The code of a variable must be unique

tr_variable_var

tr_variable_var_pkey

(default)

btree

var_id

layer

layer_pkey

(default)

btree

topology_id, layer_id

layer_schema_name_table_name_feature_column_key

layer

(default)

btree

schema_name, table_name, feature_column

topology_name_key

(default)

btree

name