tbl_sample_horizons

7857 rows


Description

Represents the specific soil layer from which a sample is collected.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_horizon_id int4 10 √

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
horizon_id int4 10
tbl_horizons.horizon_id fk_sample_horizons_horizon_id R

Specifies the horizon details.
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_horizons_physical_sample_id R

Identifies the specific physical sample.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_horizons_pkey Primary key Asc sample_horizon_id
idx_sample_horizons_horizon_id Performance Asc horizon_id
idx_sample_horizons_physical_sample_id Performance Asc physical_sample_id

Relationships

Close relationships within degrees of separation