geol_context

4956 rows


Description

Links lithostratigraphy, biostratigraphy, depositional environment and age data. Multiple samples from related site/project/paper often have the same combination of these four factors, and may use one geol_context_id.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
geol_context_id serial 10 √ nextval('geol_context_geol_context_id_seq'::regclass)
geol_context_provided_by.geol_context_id geol_context_geol_context_provided_by_fkR
sample.geol_context_id geol_context_sample_fkR

PK. Unique identifier. Generated by database
env_id int4 10 √ null
environment.env_id environment_geol_context_fkR

FK. ID for the environment. Links to the environment table.
age_id int4 10 √ null
geol_age.age_id geol_age_geol_context_fkR

FK. ID for the geological age. Links to the geol_age table.
geol_context_notes varchar 4000 √ null
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
lithostrat_id int4 10 √ null
lithostrat.lithostrat_id strat_geol_context_fkR

FK. ID for the lithostratigraphy. Links to the lithostrat table
biostrat_id int4 10 √ null
biostrat.biostrat_id biostrat_geol_context_fkR

FK. ID for the biostratigraphy. Links to the biostrat table.

Indexes

Constraint Name Type Sort Column(s)
geol_context_id Primary key Asc geol_context_id

Relationships

Close relationships within degrees of separation