tbl_sample_group_coordinates

1026 rows


Description

Stores coordinates related to sample groups, such as the top of a core, the top of a profile, or specific locations on dendrochronological or ceramic objects.

Columns

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

Primary key (automatically incremented).
coordinate_method_dimension_id int4 10
tbl_coordinate_method_dimensions.coordinate_method_dimension_id fk_sample_group_positions_coordinate_method_dimension_id R

Specifies the method and dimension used for determining coordinates.
sample_group_position numeric(20,10) 20,10 √

Describes the specific position within the sample group.
position_accuracy varchar(128) 128 √

Specifies the accuracy level of the recorded position.
sample_group_id int4 10
tbl_sample_groups.sample_group_id fk_sample_group_positions_sample_group_id R

Identifies the specific sample group.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_coordinates_pkey Primary key Asc sample_group_position_id

Relationships

Close relationships within degrees of separation