tbl_analysis_entities

163158 rows


Description

The ‘tbl_analysis_entities’ table represents Analysis Entities, which are virtual constructs allowing the association of multiple proxies with a single physical sample. This enables the linking of physical samples to various measurements or counts across different methods. Analysis Entities are organized by datasets, which are constructed based on proxy requirements. Refer to the ‘Dataset’ documentation for more details.

Columns

Column Type Size Nulls Auto Children Parents Comments
analysis_entity_id int8 19 √
tbl_abundances.analysis_entity_id fk_abundances_analysis_entity_id R
tbl_analysis_entity_ages.analysis_entity_id fk_analysis_entity_ages_analysis_entity_id R
tbl_analysis_entity_dimensions.analysis_entity_id fk_analysis_entity_dimensions_analysis_entity_id C
tbl_analysis_entity_prep_methods.analysis_entity_id fk_analysis_entity_prep_methods_analysis_entity_id R
tbl_analysis_values.analysis_entity_id tbl_analysis_values_analysis_entity_id_fkey R
tbl_ceramics.analysis_entity_id fk_ceramics_analysis_entity_id R
tbl_geochronology.analysis_entity_id fk_geochronology_analysis_entity_id R
tbl_measured_values.analysis_entity_id fk_measured_values_analysis_entity_id R
tbl_relative_dates.analysis_entity_id fk_tbl_relative_dates_to_tbl_analysis_entities R
tbl_tephra_dates.analysis_entity_id fk_tephra_dates_analysis_entity_id R

Primary key (automatically incremented).
physical_sample_id int4 10 √
tbl_physical_samples.physical_sample_id fk_analysis_entities_physical_sample_id R

Identifies the specific physical sample.
dataset_id int4 10 √
tbl_datasets.dataset_id fk_analysis_entities_dataset_id R

Specifies the dataset the analysis entity belongs to.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_analysis_entities_pkey Primary key Asc analysis_entity_id
idx_analysis_entities_dataset_id Performance Asc dataset_id
idx_analysis_entities_physical_sample_id Performance Asc physical_sample_id

Relationships

Close relationships within degrees of separation