environment

1909 rows


Description

Depositional environment details - primarily concerned with water depth, also records whether or not sediments are turbidites

Columns

Column Type Size Nulls Auto Default Children Parents Comments
env_id serial 10 √ nextval('environment_env_id_seq'::regclass)
geol_context.env_id environment_geol_context_fk R

PK. Unique identifier for reported environment. Generated by database
env_notes varchar 4000 √ null

Notes about the depositional environment.
timestamp_created timestamptz 35,6 now()
timestamp_modified timestamptz 35,6 √ now()
is_turbiditic bool 1 √ null

Whether the environment was turbiditic.
temp_deg_c numeric 5,2 √ null

Temperature in celcius, applies to modern environments where water temperature was directly measured.
verbatim_env varchar 250 √ null

Verbatim depositional environment.
env_bin varchar 2147483647 √ null

Environmental bin: inner shelf (marine), outer shelf (marine), basinal (marine) (See Sperling et al. 2015 for description), fluvial, lacustrine, estuarine
env_detail_id int4 10 √ null
dic_env_detail.env_detail_id env_detail_environment_fk R

FK. ID for detailed environmental description. Link to dic_env_detail.

Indexes

Constraint Name Type Sort Column(s)
env_id Primary key Asc env_id
environment_env_bin_idx Performance Asc env_bin
verbatim_env_idx Performance

Check Constraints

Constraint Name Constraint
envchk (((env_bin)::text = ANY (ARRAY['inner shelf (marine)'::text, 'outer shelf (marine)'::text, 'basinal (marine)'::text, 'lacustrine'::text, 'fluvial'::text, 'estuarine'::text, 'igneous (sill)'::text])))

Relationships

Close relationships within degrees of separation