tbl_sample_group_sampling_contexts

17 rows


Description

Defines the type of context or situation in which a sample group was collected. It includes the investigation purpose or initial collection intent, such as stratigraphic sequence, invertebrate survey, archaeological excavation, or quantitative vegetation survey. This context aids in filtering and analyzing samples based on specific project types, like climate reconstruction using stratigraphic sequences or habitat analysis using modern survey data.

Columns

Column Type Size Nulls Auto Children Parents Comments
sampling_context_id int4 10 √
tbl_sample_description_sample_group_contexts.sampling_context_id fk_sample_description_sample_group_contexts_sampling_context_id R
tbl_sample_group_description_type_sampling_contexts.sampling_context_id fk_sample_group_sampling_context_id0 R
tbl_sample_groups.sampling_context_id fk_sample_group_sampling_context_id R
tbl_sample_location_type_sampling_contexts.sampling_context_id fk_sample_location_type_sampling_context_id R

Primary key (automatically incremented).
sampling_context varchar(80) 80

Concise and descriptive name for the sampling context, e.g., stratigraphic sequence or archaeological excavation.
description text 2147483647 √

Detailed explanation of the sampling context term.
sort_order int2 5

Defines the order for grouping similar or related contexts, facilitating the organization of modern and paleo investigations.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_sampling_contexts_pkey Primary key Asc sampling_context_id
tbl_sample_group_sampling_contexts_norm_trgm Performance

Relationships

Close relationships within degrees of separation