tbl_sample_groups

6528 rows


Description

Contains collections of related samples, typically grouped by structures (e.g., House 1), stratigraphic sequences (e.g., profile 3), or lake cores. Groups can be defined flexibly based on research needs.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_group_id int4 10 √
tbl_lithology.sample_group_id fk_lithology_sample_group_id R
tbl_physical_samples.sample_group_id fk_samples_sample_group_id R
tbl_sample_group_coordinates.sample_group_id fk_sample_group_positions_sample_group_id R
tbl_sample_group_descriptions.sample_group_id fk_sample_groups_sample_group_descriptions_id R
tbl_sample_group_dimensions.sample_group_id fk_sample_group_dimensions_sample_group_id R
tbl_sample_group_images.sample_group_id fk_sample_group_images_sample_group_id R
tbl_sample_group_notes.sample_group_id fk_tbl_sample_group_notes_sample_groups R
tbl_sample_group_references.sample_group_id fk_sample_group_references_sample_group_id R

Primary key (automatically incremented).
site_id int4 10 √
tbl_sites.site_id fk_sample_groups_site_id R

Specifies the site where the samples were collected, linking to additional site-specific information.
sampling_context_id int4 10 √
tbl_sample_group_sampling_contexts.sampling_context_id fk_sample_group_sampling_context_id R

Specifies the sampling context, providing contextual details about the sampling environment.
method_id int4 10
tbl_methods.method_id fk_sample_groups_method_id R

Specifies the method of sample retrieval, such as ‘Russian auger core’ or ‘pitfall traps’. Distinct from sampling context, this specifies the method used rather than the investigation type.
sample_group_name varchar(100) 100 √

A unique identifier name for the sample group. For ceramics, this should be the vessel number.
sample_group_description text 2147483647 √

Detailed description of the sample group, providing context and additional information.
date_updated timestamptz 35,6 √
sample_group_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_groups_pkey Primary key Asc sample_group_id
pk_tbl_sample_groups Must be unique Asc sample_group_uuid

Relationships

Close relationships within degrees of separation