application

t_demande_rgpd

c_pk_t_demande_rgpd

(default)

btree

rgpd_id

application

t_demande_rgpd

x_btr_rgpd_typrgpd_id

(default)

btree

rgpd_typrgpd_id

Index sur la rattachement d'un droit conféré par les RGPD à la demande.

application

t_demande_rgpd

x_btr_rgpd_usr_id

(default)

btree

rgpd_usr_id

Index sur la rattachement d'un utilisateur à une demande relative au RGPD.

application

t_formulaire_access_configuration_faconf

t_formulaire_access_configuration_faconf_pkey

(default)

btree

faconf_id

application

t_organisation_org

c_pk_t_organisation_org

(default)

btree

org_id

application

t_organisation_org

c_uni_code_org

(default)

btree

org_code

Contrainte d'unicité sur le code de l'organisation.

application

t_service_serv

c_pk_t_service_serv

(default)

btree

serv_id

application

t_service_serv

c_uni_code_serv

(default)

btree

serv_code

Contrainte d'unicité sur le code du service.

application

t_utilisateur_usr

c_pk_t_utilisateur_usr

(default)

btree

usr_id

application

t_utilisateur_usr

c_uni_login_ldap_mail_usr

(default)

btree

usr_login, usr_ldap_nom, usr_mail

Unicité sur le login, le nom du ldap et le mail de l'utilisateur, unicité necessaire pour identifier un compte de façon unique lors de connexion via un ldap.

application

t_utilisateur_usr

c_uni_login_mail_usr

(default)

btree

usr_login, usr_mail

Unicité sur le login et le mail de l'utilisateur unicité necessaire pour les comptes sauvegardés en base de données.

application

t_utilisateur_usr

c_uni_login_provider_mail_usr

(default)

btree

usr_login, usr_oauth2_provider, usr_mail

Unicité sur le login, le nom du fournisseur d'identité et le mail de l'utilisateur, unicité necessaire pour identifier un compte de façon unique lors de connexion via le protocole OAuth2.

application

t_utilisateur_usr

c_uni_mail_usr

(default)

btree

usr_mail

Unicité sur l'email de l'utilisateur.

application

t_utilisateur_usr

x_btr_usr_org_id

(default)

btree

usr_org_id

Index sur la rattachement d'une organisation à un utilisateur.

application

t_utilisateur_usr

x_btr_usr_serv_id

(default)

btree

usr_serv_id

Index sur la rattachement d'un service à un utilisateur.

application

tj_apermission_rol_perm_aperm

c_pk_tj_apermission_rol_perm_aperm

(default)

btree

aperm_rol_id, aperm_perm_id

application

tj_apermission_rol_perm_aperm

x_btr_perm_id_aperm

(default)

btree

aperm_perm_id

Index sur le rattachement à une permission afin d'optimiser le temps des requètes.

application

tj_apermission_rol_perm_aperm

x_btr_rol_id_aperm

(default)

btree

aperm_rol_id

Index sur le rattachement à un rôle afin d'optimiser le temps des requètes.

application

tj_arole_usr_rol_arol

c_pk_tj_arol_usr_rol_arol

(default)

btree

arol_usr_id, arol_rol_id

application

tj_arole_usr_rol_arol

x_btr_rol_id_arol

(default)

btree

arol_rol_id

Index sur le rattachement à un rôle afin d'optimiser le temps des requètes.

application

tj_arole_usr_rol_arol

x_btr_usr_id_arol

(default)

btree

arol_usr_id

Index sur le rattachement à un compte utilisateur afin d'optimiser le temps des requètes.

application

tj_role_parent_rol_rol_rolp

c_pk_tj_role_parent_rol_rol_rolp

(default)

btree

rolp_role_parent_id, rolp_role_enfant_id

application

tj_role_parent_rol_rol_rolp

x_btr_role_enfant_id_rolp

(default)

btree

rolp_role_enfant_id

Index sur le rattachement à un rôle enfant afin d'optimiser le temps des requètes.

application

tj_role_parent_rol_rol_rolp

x_btr_role_parent_id_rolp

(default)

btree

rolp_role_parent_id

Index sur le rattachement à un rôle parent afin d'optimiser le temps des requètes.

application

tr_permission_perm

c_pk_tr_permission_perm

(default)

btree

perm_id

application

tr_permission_perm

c_uni_libelle_perm

(default)

btree

perm_libelle

Unicité sur le libellé de la permission.

application

tr_role_rol

c_pk_tr_role_rol

(default)

btree

rol_id

application

tr_role_rol

c_uni_libelle_rol

(default)

btree

rol_libelle

Unicité sur le libellé du rôle.

application

tr_type_rgpd_typrgpd

c_pk_tr_type_rgpd_typrgpd

(default)

btree

typrgpd_id

public

t_grouping_grp

c_uni_code_grp

(default)

btree

grp_code

The code of a group must be unique

public

t_grouping_grp

t_grouping_grp_pkey

(default)

btree

grp_id

public

t_grouping_grp

x_btr_fkey_fil_grp

(default)

btree

grp_fil_id

Foreign key index to speed up updates / deletion

public

t_grouping_grp

x_btr_fkey_prot_grp

(default)

btree

grp_prot_id

Foreign key index to speed up updates / deletion

public

t_grouping_grp

x_btr_fkey_std_grp

(default)

btree

grp_std_id

Foreign key index to speed up updates / deletion

public

t_grouping_grp

x_btr_fkey_tym_grp

(default)

btree

grp_tym_id

Foreign key index to speed up updates / deletion

public

t_grouping_grp

x_btr_fkey_uni_grp

(default)

btree

grp_uni_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

c_uni_sam_var_datemeasure_msam

(default)

btree

msam_sam_id, msam_var_id, msam_date_measure

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

public

t_measure_msam

c_uni_sam_var_msam

(default)

btree

msam_sam_id, msam_var_id

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

public

t_measure_msam

t_measure_msam_pkey

(default)

btree

msam_id

public

t_measure_msam

x_btr_fkey_fil_msam

(default)

btree

msam_fil_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_prot_msam

(default)

btree

msam_prot_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_sam_msam

(default)

btree

msam_sam_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_std_msam

(default)

btree

msam_std_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_tym_msam

(default)

btree

msam_tym_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_uni_msam

(default)

btree

msam_uni_id

Foreign key index to speed up updates / deletion

public

t_measure_msam

x_btr_fkey_var_msam

(default)

btree

msam_var_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

c_uni_tre_var_datemeasure_mtre

(default)

btree

mtre_tre_id, mtre_var_id, mtre_date_measure

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

public

t_measure_mtre

c_uni_tre_var_mtre

(default)

btree

mtre_tre_id, mtre_var_id

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

public

t_measure_mtre

t_measure_mtre_pkey

(default)

btree

mtre_id

public

t_measure_mtre

x_btr_fkey_fil_mtre

(default)

btree

mtre_fil_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_prot_mtre

(default)

btree

mtre_prot_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_std_mtre

(default)

btree

mtre_std_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_tre_mtre

(default)

btree

mtre_tre_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_tym_mtre

(default)

btree

mtre_tym_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_uni_mtre

(default)

btree

mtre_uni_id

Foreign key index to speed up updates / deletion

public

t_measure_mtre

x_btr_fkey_var_mtre

(default)

btree

mtre_var_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

c_uni_zon_var_datemeasure_mzon

(default)

btree

mzon_zon_id, mzon_var_id, mzon_date_measurement

public

t_measure_mzon

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.

public

t_measure_mzon

t_measure_mzon_pkey

(default)

btree

mzon_id

public

t_measure_mzon

x_btr_fkey_fil_mzon

(default)

btree

mzon_fil_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_prot_mzon

(default)

btree

mzon_prot_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_std_mzon

(default)

btree

mzon_std_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_tym_mzon

(default)

btree

mzon_tym_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_uni_mzon

(default)

btree

mzon_uni_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_var_mzon

(default)

btree

mzon_var_id

Foreign key index to speed up updates / deletion

public

t_measure_mzon

x_btr_fkey_zon_mzon

(default)

btree

mzon_zon_id

Foreign key index to speed up updates / deletion

public

t_sample_sam

c_uni_tre_code_ech

(default)

btree

sam_tre_id, sam_code

The tree identifier / sample code pair is unique

public

t_sample_sam

t_sample_sam_pkey

(default)

btree

sam_id

public

t_tree_tre

c_uni_zon_code_tre

(default)

btree

tre_zon_id, tre_code

The study area / tree code pair is unique

public

t_tree_tre

t_tree_tre_pkey

(default)

btree

tre_id

public

t_tree_tre

x_btr_fkey_tax_tre

(default)

btree

tre_tax_id

Foreign key index to speed up updates / deletion

public

t_tree_tre

x_btr_fkey_zon_tre

(default)

btree

tre_zon_id

Foreign key index to speed up updates / deletion

public

tj_classifyvar_cvar

tj_classifyvar_cvar_pkey

(default)

btree

cvar_var_id, cvar_rank_id

public

tj_classifyvar_cvar

x_btr_rank_cvar

(default)

btree

cvar_rank_id

Foreign key index to speed up updates / deletion

public

tj_classifyvar_cvar

x_btr_var_cvar

(default)

btree

cvar_var_id

Foreign key index to speed up updates / deletion

public

tj_grp_msam_gms

tj_grp_msam_gms_pkey

(default)

btree

gms_msam_id, gms_grp_id

public

tj_grp_msam_gms

x_btr_grp_gms

(default)

btree

gms_grp_id

Foreign key index to speed up updates / deletion

public

tj_grp_msam_gms

x_btr_msam_gms

(default)

btree

gms_msam_id

Foreign key index to speed up updates / deletion

public

tj_grp_mtre_gmt

tj_grp_mtre_gmt_pkey

(default)

btree

gmt_mtre_id, gmt_grp_id

public

tj_grp_mtre_gmt

x_btr_grp_gmt

(default)

btree

gmt_grp_id

Foreign key index to speed up updates / deletion

public

tj_grp_mtre_gmt

x_btr_mtre_gmt

(default)

btree

gmt_mtre_id

Foreign key index to speed up updates / deletion

public

tj_grp_mzon_gmz

tj_grp_mzon_gmz_pkey

(default)

btree

gmz_mzon_id, gmz_grp_id

public

tj_grp_mzon_gmz

x_btr_grp_gmz

(default)

btree

gmz_grp_id

Foreign key index to speed up updates / deletion

public

tj_grp_mzon_gmz

x_btr_mzon_gmz

(default)

btree

gmz_mzon_id

Foreign key index to speed up updates / deletion

public

tj_msam_msam_tsam

tj_msam_msam_tsam_pkey

(default)

btree

tsam_ref_msam_id, tsam_meta_msam_id

public

tj_msam_msam_tsam

x_btr_grp_tsam

(default)

btree

tsam_meta_msam_id

Foreign key index to speed up updates / deletion

public

tj_msam_msam_tsam

x_btr_msam_tsam

(default)

btree

tsam_ref_msam_id

Foreign key index to speed up updates / deletion

public

tj_mtre_mtre_ttre

tj_mtre_mtre_ttre_pkey

(default)

btree

ttre_ref_mtre_id, ttre_meta_mtre_id

public

tj_mtre_mtre_ttre

x_btr_grp_ttre

(default)

btree

ttre_meta_mtre_id

Foreign key index to speed up updates / deletion

public

tj_mtre_mtre_ttre

x_btr_mtre_ttre

(default)

btree

ttre_ref_mtre_id

Foreign key index to speed up updates / deletion

public

tj_mzon_mzon_tzon

tj_mzon_mzon_tzon_pkey

(default)

btree

tzon_ref_mzon_id, tzon_meta_mzon_id

public

tj_mzon_mzon_tzon

x_btr_meta_mzon_tzon

(default)

btree

tzon_meta_mzon_id

Foreign key index to speed up updates / deletion

public

tj_mzon_mzon_tzon

x_btr_ref_mzon_tzon

(default)

btree

tzon_ref_mzon_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_grp_rog

tj_rol_ope_grp_rog_pkey

(default)

btree

rog_grp_id, rog_ope_id, rog_rol_id

public

tj_rol_ope_grp_rog

x_btr_grp_rog

(default)

btree

rog_grp_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_grp_rog

x_btr_ope_rog

(default)

btree

rog_ope_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_grp_rog

x_btr_rol_rog

(default)

btree

rog_rol_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_msam_ros

tj_rol_ope_msam_ros_pkey

(default)

btree

ros_msam_id, ros_ope_id, ros_rol_id

public

tj_rol_ope_msam_ros

x_btr_msam_ros

(default)

btree

ros_msam_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_msam_ros

x_btr_ope_ros

(default)

btree

ros_ope_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_msam_ros

x_btr_rol_ros

(default)

btree

ros_rol_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mtre_rot

tj_rol_ope_mtre_rot_pkey

(default)

btree

rot_mtre_id, rot_ope_id, rot_rol_id

public

tj_rol_ope_mtre_rot

x_btr_mtre_rot

(default)

btree

rot_mtre_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mtre_rot

x_btr_ope_rot

(default)

btree

rot_ope_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mtre_rot

x_btr_rol_rot

(default)

btree

rot_rol_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mzon_roz

tj_rol_ope_mzon_roz_pkey

(default)

btree

roz_mzon_id, roz_ope_id, roz_rol_id

public

tj_rol_ope_mzon_roz

x_btr_mzon_roz

(default)

btree

roz_mzon_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mzon_roz

x_btr_ope_roz

(default)

btree

roz_ope_id

Foreign key index to speed up updates / deletion

public

tj_rol_ope_mzon_roz

x_btr_rol_roz

(default)

btree

roz_rol_id

Foreign key index to speed up updates / deletion

public

tr_file_fil

c_uni_name_url_fil

(default)

btree

fil_name, fil_url

The name / url pair of a file must be unique

public

tr_file_fil

tr_file_fil_pkey

(default)

btree

fil_id

public

tr_operator_ope

c_uni_name_first_name_ope

(default)

btree

ope_name, ope_first_name

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

public

tr_operator_ope

tr_operator_ope_pkey

(default)

btree

ope_id

public

tr_protocol_prot

c_uni_name_prot

(default)

btree

prot_name

Protocol name must be unique

public

tr_protocol_prot

tr_protocol_prot_pkey

(default)

btree

prot_id

public

tr_ranking_rank

c_uni_tree_rank

(default)

btree

rank_tree

The ranking ltree is unique

public

tr_ranking_rank

tr_ranking_rank_pkey

(default)

btree

rank_id

public

tr_role_rol

c_uni_label_rol

(default)

btree

rol_label

The label of a role must be unique

public

tr_role_rol

tr_role_rol_pkey

(default)

btree

rol_id

public

tr_standard_std

c_uni_name_version_std

(default)

btree

std_name, std_version

The name / version pair of a standard must be unique

public

tr_standard_std

tr_standard_std_pkey

(default)

btree

std_id

public

tr_study_zone_zon

c_uni_tree_zon

(default)

btree

zon_tree

The entire tree structure of a study zone must be unique

public

tr_study_zone_zon

tr_study_zone_zon_pkey

(default)

btree

zon_id

public

tr_study_zone_zon

x_btr_fkey_typz_zon

(default)

btree

zon_typz_id

Foreign key index to speed up updates / deletion

public

tr_study_zone_zon

x_gist_tree_zon

(default)

gist

zon_tree

Index of optimization of tree traversals on the tree object of type ltree

public

tr_taxon_tax

c_uni_ref_identifier_ext_tax

(default)

btree

tax_ref_id, tax_identifier_ext

The referential / external identifier pair is unique

public

tr_taxon_tax

c_uni_ref_label_tax

(default)

btree

tax_ref_id, tax_label

The referential / label pair is unique

public

tr_taxon_tax

tr_taxon_tax_pkey

(default)

btree

tax_id

public

tr_taxon_tax

x_btr_fkey_ref_tax

(default)

btree

tax_ref_id

Foreign key index to speed up updates / deletion

public

tr_taxonomic_referential_ref

c_uni_code_ref

(default)

btree

ref_code

The code of the referential is unique

public

tr_taxonomic_referential_ref

c_uni_lab_ver_ref

(default)

btree

ref_label, ref_version

The label / version pair of the referential is unique

public

tr_taxonomic_referential_ref

tr_taxonomic_referential_ref_pkey

(default)

btree

ref_id

public

tr_type_measure_tym

c_uni_code_tym

(default)

btree

tym_code

The measurement type code must be unique

public

tr_type_measure_tym

tr_type_measure_tym_pkey

(default)

btree

tym_id

public

tr_type_study_zone_typz

c_uni_code_typz

(default)

btree

typz_code

The code for a study zone type must be unique

public

tr_type_study_zone_typz

type_study_typz_typz_pkey

(default)

btree

typz_id

public

tr_unit_uni

c_uni_name_uni

(default)

btree

uni_name

The name of a unit must be unique

public

tr_unit_uni

c_uni_symbol_uni

(default)

btree

uni_symbol

The symbol of a unit must be unique

public

tr_unit_uni

tr_unit_uni_pkey

(default)

btree

uni_id

public

tr_variable_var

c_uni_code_var

(default)

btree

var_code

The code of a variable must be unique

public

tr_variable_var

tr_variable_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