tbl_physical_samples

43181 rows


Description

This table records information about physical samples collected from specific sites. Each sample is characterized by its location within the site, its physical properties measured in specific units (e.g., liters, kilograms), and its context within a sample set. Additionally, samples may have descriptive information, notes, and external identifiers linked to other systems.

Columns

Column Type Size Nulls Auto Children Parents Comments
physical_sample_id int4 10 √
tbl_analysis_entities.physical_sample_id fk_analysis_entities_physical_sample_id R
tbl_physical_sample_features.physical_sample_id fk_physical_sample_features_physical_sample_id C
tbl_sample_alt_refs.physical_sample_id fk_sample_alt_refs_physical_sample_id R
tbl_sample_colours.physical_sample_id fk_sample_colours_physical_sample_id R
tbl_sample_coordinates.physical_sample_id fk_sample_coordinates_physical_sample_id R
tbl_sample_descriptions.physical_sample_id fk_sample_descriptions_physical_sample_id R
tbl_sample_dimensions.physical_sample_id fk_sample_dimensions_physical_sample_id R
tbl_sample_horizons.physical_sample_id fk_sample_horizons_physical_sample_id R
tbl_sample_images.physical_sample_id fk_sample_images_physical_sample_id R
tbl_sample_locations.physical_sample_id fk_sample_locations_physical_sample_id R
tbl_sample_notes.physical_sample_id fk_sample_notes_physical_sample_id R

Primary key (automatically incremented).
sample_group_id int4 10
tbl_sample_groups.sample_group_id fk_samples_sample_group_id R

Identifies the specific sample group this sample belongs to.
alt_ref_type_id int4 10 √
tbl_alt_ref_types.alt_ref_type_id fk_physical_samples_sample_name_type_id R

Specifies the type of the primary sample name, such as lab or museum number.
sample_type_id int4 10
tbl_sample_types.sample_type_id fk_physical_samples_sample_type_id R

Specifies the physical form of the sample, such as bulk sample or core subsample.
sample_name varchar(50) 50

Primary reference number or name of the sample. Additional references can be recorded as alternative names.
date_updated timestamptz 35,6 √
date_sampled varchar 2147483647 √

The date when the sample was collected.

Indexes

Constraint Name Type Sort Column(s)
tbl_physical_samples_pkey Primary key Asc physical_sample_id
idx_physical_samples_alt_ref_type_id Performance Asc alt_ref_type_id
idx_physical_samples_sample_group_id Performance Asc sample_group_id
idx_physical_samples_sample_type_id Performance Asc sample_type_id

Relationships

Close relationships within degrees of separation