tbl_analysis_dating_ranges

0 rows


Description

Storage for analysis values that represents a dating range.

Columns

Column Type Size Nulls Auto Children Parents Comments
analysis_dating_range_id int8 19 √

Primary key (automatically incremented).
analysis_value_id int8 19
tbl_analysis_values.analysis_value_id tbl_analysis_dating_ranges_analysis_value_id_fkey R

Identifies the specific analysis value associated with this data.
low_value int4 10 √

The lower value of the range.
high_value int4 10 √

The higher value of the range.
low_is_uncertain bool 1 √

Indicates if lower value is uncertain (e.g. question mark).
high_is_uncertain bool 1 √

Indicates if higher value is uncertain (e.g. question mark).
low_qualifier text 2147483647 √
tbl_value_qualifier_symbols.symbol tbl_analysis_dating_ranges_low_qualifier_fkey R

Additional information qualifying the lower value.
high_qualifier text 2147483647 √
tbl_value_qualifier_symbols.symbol tbl_analysis_dating_ranges_high_qualifier_fkey R

Additional information qualifying the higher value.
age_type_id int4 10
tbl_age_types.age_type_id tbl_analysis_dating_ranges_age_type_id_fkey R

Specifies the chronological system (e.g., AD, BC, BP).
season_id int4 10 √
tbl_seasons.season_id tbl_analysis_dating_ranges_season_id_fkey R

Limits the dating range to a particular season.
dating_uncertainty_id int4 10 √
tbl_dating_uncertainty.dating_uncertainty_id tbl_analysis_dating_ranges_dating_uncertainty_id_fkey R

Specifies the uncertainty category related to the dating method used.
is_variant bool 1 √

Indicates if value is an alternative interpretation of analysed value.

Indexes

Constraint Name Type Sort Column(s)
tbl_analysis_dating_ranges_pkey Primary key Asc analysis_dating_range_id

Relationships

Close relationships within degrees of separation