tbl_relative_ages

1164 rows


Description

Contains definitions of ages based on historical periods or calendar events, including age ranges and geographical relevance (e.g., Mesolithic in Sweden).

Columns

Column Type Size Nulls Auto Children Parents Comments
relative_age_id int4 10 √
tbl_relative_age_refs.relative_age_id fk_relative_age_refs_relative_age_id R
tbl_relative_dates.relative_age_id fk_relative_dates_relative_age_id R

Primary key (automatically incremented).
relative_age_type_id int4 10 √
tbl_relative_age_types.relative_age_type_id fk_relative_ages_relative_age_type_id R

Specifies the type of relative age.
relative_age_name varchar(50) 50 √

Name of the dating period, e.g., ‘Bronze Age’. Calendar ages should be named appropriately, such as ‘AD 1492’ or ‘74 BC’.
description text 2147483647 √

A detailed description of the period, typically outlining its characteristics.
c14_age_older numeric(20,5) 20,5 √

C14 age of the older boundary of the period, if applicable.
c14_age_younger numeric(20,5) 20,5 √

C14 age of the younger boundary of the period, if applicable. Leave blank for calendar ages.
cal_age_older numeric(20,5) 20,5 √

Approximate age before present (1950) of the earliest boundary of the period, or the calendar age converted to BP if applicable.
cal_age_younger numeric(20,5) 20,5 √

Approximate age before present (1950) of the latest boundary of the period, or the calendar age converted to BP if applicable.
notes text 2147483647 √

Additional notes on the period, such as definitions’ reliability or boundary uncertainties.
date_updated timestamptz 35,6 √
location_id int4 10 √
tbl_locations.location_id fk_relative_ages_location_id R

Specifies the location related to the period.
abbreviation varchar 2147483647 √

Standard abbreviated form of the period name, if available.
relative_age_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_relative_ages_pkey Primary key Asc relative_age_id
pk_tbl_relative_ages Must be unique Asc relative_age_uuid

Relationships

Close relationships within degrees of separation