application

t_access_configuration_form_acf

ecological_db

(default)

9

0

0

Table containing part of the access application configuration.

application

t_permission_perm

ecological_db

(default)

3

0

0

Table containing the different permissions that can be assigned to roles.

application

t_role_rol

ecological_db

(default)

2

0

0

Table containing the different roles that can be assigned to users.

application

t_user_usr

ecological_db

(default)

6

0

0

Table containing the users having the right to connect to the application.

application

tj_parent_role_rol_rol_prol

ecological_db

(default)

2

0

0

Table associating a parent role with a child role.

application

tj_rolepermission_rol_perm_rperm

ecological_db

(default)

2

0

0

Table granting permission to a role.

application

tj_userrole_usr_rol_urol

ecological_db

(default)

2

0

0

Table assigning a role to a user account.

public

t_grouping_grp

ecological_db

(default)

9

0

0

Table of sets regrouping measures in order to factorize the environment of these measures (variable, unit, standard, protocol, file, operator (s)). The satellite information is then associated with the measurement grouping and no longer with each individual measurement.

public

t_measure_mzon

postgres

(default)

15

0

0

Table of metadata measures for study zones

public

tj_classifyvar_cvar

ecological_db

(default)

2

0

0

Join table associating a variable with a classification, a variable which can be multiclassed

public

tj_grp_mzon_gmz

postgres

(default)

2

0

0

Join table associating a measure with a grouping.

public

tj_mzon_mzon_tzon

postgres

(default)

3

0

0

Join table associating a measure with another measure, the second being complementary (metadata) or necessary for the interpretation of the first.

public

tj_role_ope_grp_rog

ecological_db

(default)

3

0

0

Join table associating a grouping with an operator and a role for this operator

public

tj_role_ope_mzon_roz

postgres

(default)

3

0

0

Join table associating a measure with an operator and a role for this operator

public

tr_file_fil

ecological_db

(default)

3

0

0

Table of measurement files

public

tr_operator_ope

ecological_db

(default)

5

0

0

Operator table

public

tr_protocol_prot

ecological_db

(default)

4

0

0

Table of protocols referenced in the database

public

tr_ranking_rank

ecological_db

(default)

4

0

0

Table of classification plans. Information relating to the classification of variables allowing them to be positioned in one or more repositories.

public

tr_role_rol

ecological_db

(default)

3

0

0

Table of roles that people can play

public

tr_standard_std

ecological_db

(default)

5

0

0

Table containing the standards referenced in the database

public

tr_study_zone_zon

postgres

(default)

5

0

0

Table of study zones representing a geographic entity of variable level and that can be nested.

public

tr_taxon_tax

postgres

(default)

4

0

0

Table of plant taxa (species) referenced in the database

public

tr_taxonomic_referential_ref

postgres

(default)

5

0

0

Table of references

public

tr_type_measure_tym

ecological_db

(default)

3

0

0

Table of measurement types (calculated, measured...)

public

tr_type_study_zone_typz

postgres

(default)

3

0

0

Table of study zone types allowing to characterize the typology of study areas (plot, location, forest ...)

public

tr_unit_uni

ecological_db

(default)

5

0

0

Table of measurement units.

public

tr_variable_var

ecological_db

(default)

6

0

0

Table of measured, observed or calculated variables

topology

layer

postgres

(default)

8

0

0

topology

topology

postgres

(default)

5

0

0