tbl_dating_uncertainty

8 rows


Description

Defines various types of dating uncertainties, such as ‘from’, ‘to’, ‘circa (Ca.)’, and ‘?’. These uncertainties help specify date ranges or approximate periods, such as ‘from Mesolithic to Neolithic’ or ‘from AD 100 to AD 300’.

Columns

Column Type Size Nulls Auto Children Parents Comments
dating_uncertainty_id int4 10 √
tbl_analysis_dating_ranges.dating_uncertainty_id tbl_analysis_dating_ranges_dating_uncertainty_id_fkey R
tbl_geochronology.dating_uncertainty_id fk_geochronology_dating_uncertainty_id R
tbl_relative_dates.dating_uncertainty_id fk_relative_dates_dating_uncertainty_id R
tbl_tephra_dates.dating_uncertainty_id fk_tephra_dates_dating_uncertainty_id R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
description text 2147483647 √

A description of the type of dating uncertainty.
uncertainty varchar 2147483647 √

A brief code or label showing the type of dating uncertainty, such as ‘from’, ‘to’, or ‘Ca.’.

Indexes

Constraint Name Type Sort Column(s)
tbl_dating_uncertainty_pkey Primary key Asc dating_uncertainty_id
tbl_dating_uncertainty_uncertainty_key Must be unique Asc uncertainty
tbl_dating_uncertainty_uncertainty_unique Must be unique Asc uncertainty

Relationships

Close relationships within degrees of separation