application

t_access_configuration_form_acf

t_access_configuration_form_acf_pkey

(default)

btree

acf_id

application

t_permission_perm

c_pk_t_permission_perm

(default)

btree

perm_id

application

t_permission_perm

c_uni_label_perm

(default)

btree

perm_label

Uniqueness on the label of the permission.

application

t_role_rol

c_pk_t_role_rol

(default)

btree

rol_id

application

t_role_rol

c_uni_label_rol

(default)

btree

rol_label

Uniqueness on the role label.

application

t_user_usr

c_pk_t_user_usr

(default)

btree

usr_id

application

t_user_usr

c_uni_login_usr

(default)

btree

usr_login

Uniqueness on the user's login.

application

t_user_usr

c_uni_mail_usr

(default)

btree

usr_mail

Uniqueness on the user's mail.

application

tj_parent_role_rol_rol_prol

c_pk_tj_parent_role_rol_rol_prol

(default)

btree

prol_parent_role_id, prol_child_role_id

application

tj_parent_role_rol_rol_prol

x_btr_child_role_id_prol

(default)

btree

prol_child_role_id

Index on the attachment to a child role in order to optimize the time of requests

application

tj_parent_role_rol_rol_prol

x_btr_parent_role_id_prol

(default)

btree

prol_parent_role_id

Index on the attachment to a parent role in order to optimize the time of requests

application

tj_rolepermission_rol_perm_rperm

c_pk_tj_rolepermission_rol_perm_rperm

(default)

btree

rperm_rol_id, rperm_perm_id

application

tj_rolepermission_rol_perm_rperm

x_btr_perm_id_rperm

(default)

btree

rperm_perm_id

Index on the attachment to a permission in order to optimize the time of requests

application

tj_rolepermission_rol_perm_rperm

x_btr_rol_id_rperm

(default)

btree

rperm_rol_id

Index on the attachment to a role in order to optimize the time of requests

application

tj_userrole_usr_rol_urol

c_pk_tj_urol_usr_rol_arol

(default)

btree

urol_usr_id, urol_rol_id

application

tj_userrole_usr_rol_urol

x_btr_rol_id_urol

(default)

btree

urol_rol_id

Index on the attachment to a role in order to optimize the time of requests

application

tj_userrole_usr_rol_urol

x_btr_usr_id_urol

(default)

btree

urol_usr_id

Index on the attachment to a user account in order to optimize the time of requests

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_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

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_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_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_role_ope_grp_rog

tj_role_ope_grp_rog_pkey

(default)

btree

rog_grp_id, rog_ope_id, rog_rol_id

public

tj_role_ope_grp_rog

x_btr_grp_rog

(default)

btree

rog_grp_id

Foreign key index to speed up updates / deletion

public

tj_role_ope_grp_rog

x_btr_ope_rog

(default)

btree

rog_ope_id

Foreign key index to speed up updates / deletion

public

tj_role_ope_grp_rog

x_btr_rol_rog

(default)

btree

rog_rol_id

Foreign key index to speed up updates / deletion

public

tj_role_ope_mzon_roz

tj_role_ope_mzon_roz_pkey

(default)

btree

roz_mzon_id, roz_ope_id, roz_rol_id

public

tj_role_ope_mzon_roz

x_btr_mzon_roz

(default)

btree

roz_mzon_id

Foreign key index to speed up updates / deletion

public

tj_role_ope_mzon_roz

x_btr_ope_roz

(default)

btree

roz_ope_id

Foreign key index to speed up updates / deletion

public

tj_role_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