tbl_sample_dimensions

7763 rows


Description

Contains measurable dimension data for samples, excluding coordinates. This includes attributes such as volume, weight, and depth within stratigraphy or cores. Related names and descriptions of dimensions are maintained in the ‘tbl_dimension’ table.

Columns

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

Primary key (automatically incremented).
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_dimensions_physical_sample_id R

Identifies the specific physical sample.
dimension_id int4 10
tbl_dimensions.dimension_id fk_sample_dimensions_dimension_id R

Specifies the specific dimension being measured (e.g., length, width, height)..
method_id int4 10
tbl_methods.method_id fk_sample_dimensions_measurement_method_id R

Specifies the measurement method used, including associated units.
dimension_value numeric(20,10) 20,10

The quantified value of the measured dimension.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_dimensions_pkey Primary key Asc sample_dimension_id

Relationships

Close relationships within degrees of separation