tbl_chronologies

0 rows


Description

This table represents a collection of dated samples grouped for specific purposes, such as assigning a unified age range to samples in a master dataset or developing an age-depth model for a lake. These chronologies may also be used to integrate with external services that limit the scope of dating evidence, such as GBIF or SBDI.

Columns

Column Type Size Nulls Auto Children Parents Comments
chronology_id int4 10 √
tbl_analysis_entity_ages.chronology_id fk_analysis_entity_ages_chronology_id R

Primary key (automatically incremented).
age_model text 2147483647 √

The methodology or model applied to determine the ages of samples within this chronology.
relative_age_type_id int4 10 √

This was previously constrained by the obsolete tbl_age_types table. Now, it serves as a non-binding reference to relative_age_types, although not fully implemented. Relevant notes should document year types and construction methods for the chronology.
chronology_name text 2147483647 √

A descriptive title for the chronology, indicating its purpose and extent.
contact_id int4 10 √
tbl_contacts.contact_id fk_chronologies_contact_id R

Identifies the contact person or organization for the chronology.
date_prepared timestamp 22 √

The date the chronology was initially created or most recently updated.
date_updated timestamptz 35,6 √
notes text 2147483647 √

Supplementary information or anlabels related to the chronology, including data sources, assumptions, or constraints.

Indexes

Constraint Name Type Sort Column(s)
tbl_chronologies_pkey Primary key Asc chronology_id
tbl_chronologies_chronology_name_key Must be unique Asc chronology_name
tbl_chronologies_chronology_name_unique Must be unique Asc chronology_name

Relationships

Close relationships within degrees of separation