tbl_relative_dates

19822 rows


Description

This table records the relative dating information for samples by associating a relative age definition with a physical sample through an analysis entity. It includes details about dating methods, notes, and indications of uncertainty (e.g., ‘from’, ‘ca’, ‘<’).

Columns

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

Primary key (automatically incremented).
relative_age_id int4 10 √
tbl_relative_ages.relative_age_id fk_relative_dates_relative_age_id R

Specifies the relative age definition.
method_id int4 10 √
tbl_methods.method_id fk_relative_dates_method_id R

Specifies the method used for dating the sample to a period or calendar date.
notes text 2147483647 √

Additional notes regarding the sample’s dating, including any specific details or observations.
date_updated timestamptz 35,6 √
dating_uncertainty_id int4 10 √
tbl_dating_uncertainty.dating_uncertainty_id fk_relative_dates_dating_uncertainty_id R

Specifies the uncertainty category related to the dating method used.
analysis_entity_id int4 10
tbl_analysis_entities.analysis_entity_id fk_tbl_relative_dates_to_tbl_analysis_entities R

Identifies the specific analysis entity associated with this record.

Indexes

Constraint Name Type Sort Column(s)
tbl_relative_dates_pkey Primary key Asc relative_date_id

Relationships

Close relationships within degrees of separation