interpreted_age

118501 rows


Description

The interpreted age of the sample in millions of years, with justification.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
interpreted_age_id serial 10 √ nextval('interpreted_age_interpreted_age_id_seq'::regclass)
interpreted_age_provided_by.interpreted_age_id interpreted_age_interpreted_age_provided_by_fk R
interpreted_age numeric 6,2 null

Interpreted age in Ma
interpreted_age_notes varchar 4000 √ null

Justification for assigned interpreted age
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
sample_id int4 10 √ null
sample.sample_id sample_interpreted_age_fk R

FK. ID for the sample. Links to the sample table.
reference_id int4 10 √ null
reference_work.reference_id reference_work_interpreted_age_fk R

FK. ID for reference where if the age in Ma comes from the published paper. Links to reference_work table.
min_age numeric 6,2 √ null

Minimum (youngest) age in Ma
max_age numeric 6,2 √ null

Maximum (oldest) age in Ma

Indexes

Constraint Name Type Sort Column(s)
interpreted_age_id Primary key Asc interpreted_age_id
sample_id_uniq Must be unique Asc sample_id

Relationships

Close relationships within degrees of separation