db_globoxylo
Previous topic Chapter index Next topic

Tables

 

Schema

Table

Owner

Tablespace

Foreign Table

Cols

Rows

Pages

Inherited From

With OID

Description

application

t_demande_rgpd

globoxylo

(default)

 

9

-1

0

 

Table contenant les demandes relatives au RGPD.

application

t_formulaire_access_configuration_faconf

globoxylo

(default)

 

9

-1

0

 

Table contenant une partie de la configuration de l'application access.

application

t_organisation_org

globoxylo

(default)

 

4

-1

0

 

Table contenant les organisations (Centre INRAe pour le LDAP INRAe).

application

t_service_serv

globoxylo

(default)

 

4

-1

0

 

Table contenant les différents services (Unité pour le LDAP INRAe).

application

t_utilisateur_usr

globoxylo

(default)

 

24

-1

0

 

Table contenant les comptes utilisateurs.

application

tj_apermission_rol_perm_aperm

globoxylo

(default)

 

2

-1

0

 

Table attribuant une permission à un rôle.

application

tj_arole_usr_rol_arol

globoxylo

(default)

 

2

-1

0

 

Table attribuant un rôle à compte un utilisateur.

application

tj_role_parent_rol_rol_rolp

globoxylo

(default)

 

2

-1

0

 

Table associant un rôle parent à un rôle enfant.

application

tr_permission_perm

globoxylo

(default)

 

3

-1

0

 

Table contenant les différentes permissions pouvant être affectées aux rôles.

application

tr_role_rol

globoxylo

(default)

 

3

-1

0

 

Table contenant les différents rôles pouvant être affectés aux utilisateurs.

application

tr_type_rgpd_typrgpd

globoxylo

(default)

 

3

-1

0

 

Table contenant les types de demandes relatives au RGPD.

public

t_grouping_grp

globoxylo

(default)

 

9

-1

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_msam

postgres

(default)

 

15

-1

0

 

Table of variable measures for a specific type of object

public

t_measure_mtre

postgres

(default)

 

15

-1

0

 

Table of variable measures for a specific type of object

public

t_measure_mzon

postgres

(default)

 

15

-1

0

 

Table of metadata measures for study zones

public

t_sample_sam

postgres

(default)

 

5

-1

0

 

Sample table

public

t_tree_tre

postgres

(default)

 

5

-1

0

 

Tree table

public

tj_classifyvar_cvar

globoxylo

(default)

 

2

-1

0

 

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

public

tj_grp_msam_gms

postgres

(default)

 

2

-1

0

 

Join table associating a measure with a grouping.

public

tj_grp_mtre_gmt

postgres

(default)

 

2

-1

0

 

Join table associating a measure with a grouping.

public

tj_grp_mzon_gmz

postgres

(default)

 

2

-1

0

 

Join table associating a measure with a grouping.

public

tj_msam_msam_tsam

postgres

(default)

 

3

-1

0

 

Table associating an object measure to another object measure, the second being complementary (metadata) or necessary for the interpretation of the first

public

tj_mtre_mtre_ttre

postgres

(default)

 

3

-1

0

 

Table associating an object measure to another object measure, the second being complementary (metadata) or necessary for the interpretation of the first

public

tj_mzon_mzon_tzon

postgres

(default)

 

3

-1

0

 

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

public

tj_rol_ope_grp_rog

globoxylo

(default)

 

3

-1

0

 

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

public

tj_rol_ope_msam_ros

postgres

(default)

 

3

-1

0

 

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

public

tj_rol_ope_mtre_rot

postgres

(default)

 

3

-1

0

 

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

public

tj_rol_ope_mzon_roz

postgres

(default)

 

3

-1

0

 

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

public

tr_file_fil

globoxylo

(default)

 

3

-1

0

 

Table of measurement files

public

tr_operator_ope

globoxylo

(default)

 

5

-1

0

 

Operator table

public

tr_protocol_prot

globoxylo

(default)

 

4

-1

0

 

Table of protocols referenced in the database

public

tr_ranking_rank

globoxylo

(default)

 

4

-1

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

globoxylo

(default)

 

3

-1

0

 

Table of roles that people can play

public

tr_standard_std

globoxylo

(default)

 

5

-1

0

 

Table containing the standards referenced in the database

public

tr_study_zone_zon

postgres

(default)

 

5

-1

0

 

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

public

tr_taxon_tax

postgres

(default)

 

4

-1

0

 

Table of plant taxa (species) referenced in the database

public

tr_taxonomic_referential_ref

postgres

(default)

 

5

-1

0

 

Table of references

public

tr_type_measure_tym

globoxylo

(default)

 

3

-1

0

 

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

public

tr_type_study_zone_typz

postgres

(default)

 

3

-1

0

 

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

public

tr_unit_uni

globoxylo

(default)

 

5

-1

0

 

Table of measurement units.

public

tr_variable_var

globoxylo

(default)

 

6

-1

0

 

Table of measured, observed or calculated variables

topology

layer

postgres

(default)

 

8

-1

0

 

 

topology

topology

postgres

(default)

 

5

-1

0

 

 

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)
Previous topic Chapter index Next topic