tbl_relative_age_types

14 rows


Description

Contains various types of relative ages used in different contexts such as archaeological, Blytt-Sernander, and Geological. These age types can vary in specificity, ranging from well-defined systems like Blytt-Sernander to broader categories like geological periods.

Columns

Column Type Size Nulls Auto Children Parents Comments
relative_age_type_id int4 10 √
tbl_relative_ages.relative_age_type_id fk_relative_ages_relative_age_type_id R

Primary key (automatically incremented).
age_type varchar 2147483647 √

The name of the chronological age type, which can include archaeological periods, specific calendar dates, calendar age ranges, or periods defined by the Blytt-Sernander classification.
description text 2147483647 √

A detailed explanation of the chronological age type, such as a period marked by archaeological or geological evidence indicating cultural activities or climate changes as inferred from paleo-vegetation records.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_relative_age_types_pkey Primary key Asc relative_age_type_id
tbl_relative_age_types_age_type_key Must be unique Asc age_type
tbl_relative_age_types_age_type_unique Must be unique Asc age_type

Relationships

Close relationships within degrees of separation