tbl_sample_group_dimensions

134 rows


Description

Stores the physical dimensions of a sample group (e.g., core length) based on a specified dimension type.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_group_dimension_id int4 10 √

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
dimension_id int4 10
tbl_dimensions.dimension_id fk_sample_group_dimensions_dimension_id R

Specifies the specific dimension being measured (e.g., length, width, height)..
dimension_value numeric(20,5) 20,5

The quantified value of the measured dimension.
sample_group_id int4 10
tbl_sample_groups.sample_group_id fk_sample_group_dimensions_sample_group_id R

Identifies the specific sample group.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_dimensions_pkey Primary key Asc sample_group_dimension_id

Relationships

Close relationships within degrees of separation