pggeodb.nancy.inra.fr/db_woodseer - db_woodseer on pggeodb.nancy.inra.fr
Previous topic Chapter index Next topic

Tables

 

Schema

Table

Owner

Tablespace

Foreign Table

Cols

Rows

Pages

Inherited From

With OID

Description

public

t_acquisition_acq

woodseer

(default)

 

7

0

0

 

Table of acquisitions (images, cloud of plots, ...)

public

t_detection_singularity_det

woodseer

(default)

 

11

0

0

 

Table of singularities detections

public

t_measure_macq

woodseer

(default)

 

15

0

0

 

Table of measurements of acquisitions

public

t_measure_mdet

woodseer

(default)

 

15

0

0

 

Table of measurements of singularities detections

public

t_measure_mobj

woodseer

(default)

 

15

0

0

 

Table of measurements for objects

public

t_measure_mzon

woodseer

(default)

 

15

0

0

 

Table of metadata measures for study zones

public

t_object_obj

woodseer

(default)

 

7

120

2

 

Table of objects (objetcs of differents natures merged in this table)

public

t_project_proj

woodseer

(default)

 

7

1

1

 

Table of projects

public

tj_classification_var_cvar

woodseer

(default)

 

2

0

0

 

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

public

tj_detection_singularity_pairing_dsp

woodseer

(default)

 

3

0

0

 

Table of singularities detections pairing

public

tj_rol_ope_macq_romacq

woodseer

(default)

 

3

0

0

 

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

public

tj_rol_ope_mdet_romdet

woodseer

(default)

 

3

0

0

 

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

public

tj_rol_ope_mobj_romobj

woodseer

(default)

 

3

0

0

 

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

public

tj_rol_ope_mzon_romzon

woodseer

(default)

 

3

0

0

 

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

public

tj_transformation_matrix_tra

woodseer

(default)

 

4

0

0

 

Table of transformation matrices from an acquiqition to another

public

tr_acquisition_detection_mean_adm

woodseer

(default)

 

4

4

1

 

Table of acquisition or singularities detections means

public

tr_classification_cla

woodseer

(default)

 

4

0

0

 

Table of variables classifications where a variable can belong to several classifications.

public

tr_file_fil

woodseer

(default)

 

5

81

2

 

Table of files of data and information

public

tr_nature_object_nobj

woodseer

(default)

 

4

6

1

 

Table of object nautres

public

tr_operator_ope

woodseer

(default)

 

5

0

0

 

Operator table

public

tr_protocol_prot

woodseer

(default)

 

6

0

0

 

Table of protocols referenced in the database

public

tr_role_rol

woodseer

(default)

 

3

0

0

 

Table of roles that people can play

public

tr_standard_std

woodseer

(default)

 

5

0

0

 

Table containing the standards referenced in the database

public

tr_study_zone_zon

woodseer

(default)

 

5

10

1

 

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

public

tr_taxon_tax

woodseer

(default)

 

4

84600

904

 

Table of plant taxa (species) referenced in the database

public

tr_taxonomic_referential_ref

woodseer

(default)

 

5

1

1

 

Table of taxonomic referentials

public

tr_type_file_typf

woodseer

(default)

 

4

3

1

 

Table of file types

public

tr_type_measure_tym

woodseer

(default)

 

3

5

1

 

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

public

tr_type_singularity_tsin

woodseer

(default)

 

5

0

0

 

Table of singularity types

public

tr_type_study_zone_typz

woodseer

(default)

 

4

6

1

 

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

public

tr_unit_uni

woodseer

(default)

 

5

23

1

 

Table of measurement units

public

tr_variable_var

woodseer

(default)

 

6

220

4

 

Table of measured, observed or calculated variables

topology

layer

postgres

(default)

 

8

0

0

 

 

topology

topology

postgres

(default)

 

5

0

0

 

 

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 07/12/2018 13:23
Previous topic Chapter index Next topic