tbl_coordinate_method_dimensions

0 rows


Description

This table defines the dimensions applicable to each coordinate system method and specifies any legal values for these dimensions. Each entry associates a coordinate system method with its corresponding dimensions and their permissible value ranges.

Columns

Column Type Size Nulls Auto Children Parents Comments
coordinate_method_dimension_id int4 10 √
tbl_sample_coordinates.coordinate_method_dimension_id fk_sample_coordinates_coordinate_method_dimension_id R
tbl_sample_group_coordinates.coordinate_method_dimension_id fk_sample_group_positions_coordinate_method_dimension_id R

Primary key (automatically incremented).
dimension_id int4 10
tbl_dimensions.dimension_id fk_coordinate_method_dimensions_dimensions_id R

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

Specifies the coordinate system method to which the dimension applies.
limit_upper numeric(18,10) 18,10 √

Specifies the upper bound of the legal value range for the dimension, if applicable.
limit_lower numeric(18,10) 18,10 √

Specifies the lower bound of the legal value range for the dimension, if applicable.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_coordinate_method_dimensions_pkey Primary key Asc coordinate_method_dimension_id

Relationships

Close relationships within degrees of separation