tbl_dimensions

0 rows


Description

Contains definitions of various measurement types, such as sample weight and core length, categorized by method group.

Columns

Column Type Size Nulls Auto Children Parents Comments
dimension_id int4 10 √
tbl_analysis_entity_dimensions.dimension_id fk_analysis_entity_dimensions_dimension_id R
tbl_analysis_value_dimensions.dimension_id tbl_analysis_value_dimensions_dimension_id_fkey R
tbl_coordinate_method_dimensions.dimension_id fk_coordinate_method_dimensions_dimensions_id R
tbl_measured_value_dimensions.dimension_id fk_measured_value_dimensions_dimension_id R
tbl_sample_dimensions.dimension_id fk_sample_dimensions_dimension_id R
tbl_sample_group_dimensions.dimension_id fk_sample_group_dimensions_dimension_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
dimension_abbrev varchar(40) 40 √

Abbreviation for the dimension type.
dimension_description text 2147483647 √

Detailed description of the dimension.
dimension_name varchar(50) 50

Name of the dimension type.
unit_id int4 10 √
tbl_units.unit_id fk_dimensions_unit_id R

Specifies the unit of measurement used for the dimension.
method_group_id int4 10 √
tbl_method_groups.method_group_id fk_dimensions_method_group_id R

Specifies the method group, limiting dimension application by group (e.g., size measurements, coordinate systems).

Indexes

Constraint Name Type Sort Column(s)
tbl_dimensions_pkey Primary key Asc dimension_id

Relationships

Close relationships within degrees of separation