tbl_dating_material

0 rows


Description

Contains information about materials used for dating processes. Materials can be linked to a specific taxon, pseudotaxon, or described in the ‘material_dated’ field. Specific components of abundance, such as seeds or elytrons, can also be indicated. A single dating instance may involve multiple materials.

Columns

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

Primary key (automatically incremented).
geochron_id int4 10
tbl_geochronology.geochron_id fk_dating_material_geochronology_geochron_id R

Specifies the geochronological context of the dating material.
taxon_id int4 10 √
tbl_taxa_tree_master.taxon_id fk_dating_material_taxa_tree_master_taxon_id R

Specifies the taxonomic unit related to this record.
material_dated varchar 2147483647 √

Text field describing the specific material that was dated.
description text 2147483647 √

Detailed description of the dating material.
abundance_element_id int4 10 √
tbl_abundance_elements.abundance_element_id fk_dating_material_abundance_elements_id R

Specifies the abundance element related to the material.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_dating_material_pkey Primary key Asc dating_material_id

Relationships

Close relationships within degrees of separation