tbl_sample_locations

20216 rows


Description

Stores information about the locations of samples based on predefined types.

Columns

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

Primary key (automatically incremented).
sample_location_type_id int4 10
tbl_sample_location_types.sample_location_type_id fk_sample_locations_sample_location_type_id R

Specifies the type of the sample location.
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_locations_physical_sample_id R

Identifies the specific physical sample.
location varchar(255) 255 √

The specific location description of the sample.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_locations_pkey Primary key Asc sample_location_id

Relationships

Close relationships within degrees of separation